Sign up ×
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
cp /u03/app/oracle/oradata/TEST1/control01.ctl \

The standby's init.ora contains:


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 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
Check out for simple step by step instructions. –  Roy Nov 21 '12 at 16:14

Your Answer


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

Browse other questions tagged or ask your own question.