Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am doing dataguard. I have manually done a backup for the standby database. It was working fine. Problem arose when I used the standby controlfile. On the primary, I have created a standby controlfile and transferred it to the standby.

scp test_sdy oracle@db3.oracle.com:/u03/app/oracle/oradata/TEST1/control01.ctl
cp /u03/app/oracle/oradata/TEST1/control01.ctl \
   /u03/app/oracle/flash_recover_area/TEST1/control02.ctl

The standby's init.ora contains:

*.control_files='/u03/app/oracle/oradata/TEST1/control01.ctl','/u03/app/oracle/flash_recovery_area/TEST1/control02.ctl'

When I start up the standby database using pfile, I get this error:

ORA-10458: standby database requires recovery
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/u03/app/oracle/oradata/TEST1_SDY/system01.dbf'

Did I do something wrong with the standby control file? How can I fix this?

share|improve this question
    
Does that file exist on your standby? –  Mat Nov 20 '12 at 9:36
    
@mat:thanks for replying.no the file doesn't exit. –  sneha Nov 21 '12 at 4:37
    
What is the path to system01.dbf on your primary, and is it the same as on the standby? –  kubanczyk Nov 21 '12 at 8:07
    
path is same for both primary and standby /u03/app/oracle/oradata/TEST1/system01.dbf –  sneha Nov 21 '12 at 8:59
1  
Check out oracle-base.com/articles/11g/data-guard-setup-11gr2.php for simple step by step instructions. –  Roy Nov 21 '12 at 16:14

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.