Tell me more ×
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.
up vote 2 down vote favorite

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
show 1 more comment

2 Answers

up vote 1 down vote

It is recommended to leave exactly the same path to database on standby (the same directory tree).

I think you've changed it, so you would need to rename everything that is stored in the init.ora and controlfile. In the latter, Oracle records logfile names and datafile names. This is nicely covered here http://www.oracle-base.com/articles/misc/renaming-or-moving-oracle-files.php.

Additionally: You are not supposed to startup your standby. Normally you startup mount it (which is less than full start), and issue some kind of recover managed standby ....

Additionally: You are neither supposed to just alter database open your standby. Open for writing (actually open resetlogs) happens only during failover, that is after the primary database fails.

Additionally: The show parameter db_file_name_convert should be undefined in your configuration for both primary and standby, as their pathnames are the same.

share|improve this answer
@kubanczyk.thanks for replying.the directory tree is exactly same in both primary and standby. – sneha Nov 21 '12 at 4:39
STARTUP NOMOUNT;ALTER DATABASE MOUNT STANDBY DATABASE; ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION; after this i gave ALTER DATABASE OPEN.then i am getting the error.i guess i can't give this command. – sneha Nov 21 '12 at 9:01
@sneha a third update of my answer – kubanczyk Nov 21 '12 at 14:51
thank you all for replying.i will follow the steps – sneha Nov 23 '12 at 13:57
up vote 0 down vote

thank you all for replying.i will follow the steps

share|improve this answer
You can always leave comments on your own posts (questions and answers, and answers given on your questions). So please, delete this one and repost as a comment. Thanks in advance! – dezso Nov 23 '12 at 9:16

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.