The first time Oracle 11g R2 Active Data guard is configured today, after physical standby database is created with rman,
The following error occurs when you try to open standby in read only mode:
SQL> alter database open read only;
Alter database open read only
*
Error at line 1:
ORA-10458: standby database requires recovery
ORA-01152: File 1 was not restored from a sufficiently old backup
ORA-01110: Data File 1:
'/U01/APP/Oracle/oradata/standby/datafile/o1_mf_system_8v8y9m2x _. dbf'
In Metalink [ID 1312376.1], the compatible parameter of primary database is set incorrectly.
Primary:
SQL> Col host_name for A20
SQL> select instance_name, host_name, version, archiver, log_switch_wait from V $ instance;
Instance_name host_name version archive log_switch_wait
---------------------------------------------------------------------------
Prod prod.oracle.com 11.2.0.3.0 started
Standby:
SQL> select instance_name, host_name, version, archiver, log_switch_wait from V $ instance;
Instance_name host_name version archive log_switch_wait
---------------------------------------------------------------------------
Standby standby.oracle.com 11.2.0.3.0 started
Primary:
SQL> show parameter compatible
Name type value
-----------------------------------------------------------------------------
Compatible string 11.2.0.0.0
Standby:
SQL> show parameter compatible
Name type value
-----------------------------------------------------------------------------
Compatible string 11.2.0.0.0
Modify the compatible parameters of primary and standby to 11.2.0.2.0, and then restart to enable standby in read only mode.
Primary:
SQL> alter system set compatible = '11. 2.0.2.0 'scope = spfile;
SQL> shutdown immediate;
SQL> startup;
Standby:
SQL> startup open read only;
SQL> select open_mode from V $ database;
Open_mode
--------------------
Read Only
For reprinting, please indicate the author's source and original article links; otherwise, you will be held legally responsible:
Author: xiangsir
Link: http://blog.csdn.net/xiangsir/article/details/9077527
QQ: 444367417
MSN: xiangsir@hotmail.com