Skip to Main Content

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!

ORA-01110: data file 1: '+DATA/cchdr/datafile/system.266 when open standby

626620May 11 2010 — edited May 21 2010
I configured a physical standby with the primary a 3 node RAC. All server are Redhat 2.6, Oracle 11.2.

After duplicated the primary to the standby successively, I tried to open the physical standby, but get error
SQL> alter database open;
ERROR at line 1:
ORA-10458: standby database requires recovery
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '+DATA/cchdr/datafile/system.266.718714217'
Then I tried
 SQL> alter database recover datafile '+DATA/cchdr/datafile/system.266.718714217';
alter database recover datafile '+DATA/cchdr/datafile/system.266.718714217'
*
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

SQL> recover database until cancel using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-01666: control file is for a standby database
WHat is wrong?
Thanks.
This post has been answered by Dr. Paranoid-Oracle on May 14 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 18 2010
Added on May 11 2010
6 comments
6,968 views