Regarding Poorman's Dataguard

[sivakumarocp]

Hi Tim,

Tomorrow I am going to perform production database migration from one host to another which is running on solaris O/S.

For this activity i need to migrate two databases are running on same host.

My lead said need to use Poorman dataguard concept for once curcial database!

I head of Dataguard, but I haven't heard about Poorman Dataguard!

what it is actually and how do i setup. and what is the purpose of this kind of setup

[Tim...]

Hi.

I can't be sure what he means, so it's probably best to ask him, but he may mean one of the following:

1) Make a backup of the database. Move the backup to the new server and recover it there. Rather than opening it when you're done, keep it in recovery mode and manually ship the archived redo logs across to it and keep recovering.

2) Basically, the same thing, but start by using a database duplication (RMAN DUPLICATE).

Like I say, you best ask him to see what he means by that.

Cheers

Tim...

[sivakumarocp]

Hi Tim,

sorry for the late reply on this topic.
Actually I did host migration successfully on that day itself using poorman dataguard concept.
Poorman dataguard is nothing but, couple of minutes before to start the production down time we will setup standby database on new host using backups + archivelogs on the database which we are going to move and we will apply archivelogs whichever is generating on production.

Once the production down time starts we just copy the remainig archive logs and apply to standby database. after that need to shutdown the standby database and remove standby controlfile. then from production database copy the redologs and controlfiles and transfer it to new host.

now we should be able to start the database on new host with out resetlogs option!

Purpose of using this method is to eliminate production down time when we have databse with has huge size

Please let me know your comments on this.

[Tim...]

Hi.

I have no comments. This is a pretty typical manual migration.

Cheers

Tim...

[sivakumarocp]

[Tim...]