Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

create standby database using restore backup

unknown-1052419Nov 6 2013 — edited Nov 11 2013

Hi,

I am creating a standby database 11g using manual process of restoring a backup , but to no avail. I can not even restore the backup successfully.

This is the steps I followed (courtesy of ORACLE-BASE) ORACLE-BASE - Data Guard Physical Standby Setup in Oracle Database 11g Release 2

I am confused about these steps:

Copy the files from the primary to the standby server.

Copy Standby controlfile to all locations.

$ scp oracle@ol5-112-dga1:/tmp/db11g_stby.ctl /u01/app/oracle/oradata/DB11G/control01.ctl

$ cp /u01/app/oracle/oradata/DB11G/control01.ctl /u01/app/oracle/fast_recovery_area/DB11G/control02.ctl

My question is, for the 2nd copy, do I need to shutdown the primary db? since control01.ctl is being updated all the time?

Can I not used the standby ctl (db11g_stbg.ctl) and copy it to /u01/app/oracle/fast_recovery_area/DB11G/control02.ctl instead?

Your assistance is highly appreciated.

This post has been answered by saurabh on Nov 6 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 9 2013

Added on Nov 6 2013

#data-guard, #performance-availability

20 comments

1,847 views