Application of online redo logs

[Former Member]

Dear all,

In my organisation recently standby database has been configured. Now my task is to restore a full online+redo backup which is created in primary database in the standby database. Once it is over I have to apply the newly created redo logs generated after the online backup.

I am planning to restore the online+redo backup using the following command

brrestore -b "BRBACKUP log file" -m full. Once it is done I have to apply the online redo logs. I am confused how to apply manually the newly created redo logs. Is there any document regarding it. I searched and found many information in net but nothing seems to be very convincing as this is a critical activity.

Best Regards,

Tapan

[stefan_koehler · Accepted solution]

Hello Tapan,

> brrestore -b "BRBACKUP log file" -m full. Once it is done I have to apply the online redo logs.

Bad idea, you need a standby controlfile and not a backup controlfile on the standby site.

> I am confused how to apply manually the newly created redo logs. Is there any document regarding it.

You can do this manually by your own or by Oracle Dataguard.

I would suggest that you get a training on Oracle Dataguard and then you will understand the concepts and will be able to setup a DR solution. It makes not much sense to explain you all the steps and the functions, because of in a critical moment you should know what to do and why.

If you really want to try it by your own - so start with this:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/toc.htm

http://download.oracle.com/docs/cd/B19306_01/server.102/b14230/toc.htm

Regards

Stefan

[Former Member · Accepted solution]

Dear Stefan,

Thanks for your prompt response. Right now we are using Oracle 9i and Oracle Dataguard is a feature of Oracle 10g. So in this scenerio can we apply redo logs with the "recover standby database" command.

Thanks & Regards,

Tapan

[stefan_koehler · Accepted solution]

Hello Tapan,

> Right now we are using Oracle 9i and Oracle Dataguard is a feature of Oracle 10g.

Oh no, Oracle Dataguard is also available with Oracle 9i:

http://download.oracle.com/docs/cd/B10501_01/server.920/a96653/toc.htm

Regards

Stefan

[Former Member · Accepted solution]

Dear Stefan,

Thanks a lot. I will go through it and get back to you for any issue.

Thanks & Regards,

Tapan