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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

I think you problem is in the parameters file of standby database, may be you have defined something as:

LOG_FILE_NAME_CONVERT='/u03/app/oracle/oradata/TEST1','/u03/app/oracle/oradata/TEST1_SDY'

This parameter change the location on dbfiles for standby version. Here a link of documentation:

https://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams112.htm#REFRN10098

If you remove this line in parameter file of standby database and restart should be work, with the same control file standby version created before.

share|improve this answer

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.