Standby (alter database open read only;) --> got ORA Errors
edited Apr 22, 2010 2:39AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 4 commentsAnswered ✓
Plattform: 11g R1 Enterprise / Windows 2008 x64 Enterprise
Edition
Did the following on 11g R1 DG Standby system:
SQL> alter database recover managed standby database cancel;
SQL> alter database open read only;
Errors in alert log. (I dont know anything about this errors!):
Thu Apr 22 11:18:57 2010
alter database recover managed standby database cancel
Thu Apr 22 11:18:57 2010
MRP0: Background Media Recovery cancelled with status 16037
Errors in file c:\prg\oracle\diag\rdbms\chids\chids\trace\chids_mrp0_2784.trc:
ORA-16037: user requested cancel of managed recovery operation
Managed Standby Recovery not using Real Time Apply
Shutting down recovery slaves due to error 16037
Recovery interrupted!
Recovered data files to a consistent state at change 85269828
Did the following on 11g R1 DG Standby system:
SQL> alter database recover managed standby database cancel;
SQL> alter database open read only;
Errors in alert log. (I dont know anything about this errors!):
Thu Apr 22 11:18:57 2010
alter database recover managed standby database cancel
Thu Apr 22 11:18:57 2010
MRP0: Background Media Recovery cancelled with status 16037
Errors in file c:\prg\oracle\diag\rdbms\chids\chids\trace\chids_mrp0_2784.trc:
ORA-16037: user requested cancel of managed recovery operation
Managed Standby Recovery not using Real Time Apply
Shutting down recovery slaves due to error 16037
Recovery interrupted!
Recovered data files to a consistent state at change 85269828
0