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.