Cnverting Active DG to Normal Physical standby
edited Jan 4, 2013 4:16AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 5 commentsAnswered
I have a Active DG setup which I want to convert to a normal physical standby..
I do the following steps in the standby database
SQL> startup mount
ORACLE instance started.
Total System Global Area 6413680640 bytes
Fixed Size 2240344 bytes
Variable Size 4378853544 bytes
Database Buffers 2013265920 bytes
Redo Buffers 19320832 bytes
Database mounted.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
What are the right steps to convert? Or Do i need to rebuild? I dont think a rebuild is required.
Please suggest
I do the following steps in the standby database
SQL> startup mount
ORACLE instance started.
Total System Global Area 6413680640 bytes
Fixed Size 2240344 bytes
Variable Size 4378853544 bytes
Database Buffers 2013265920 bytes
Redo Buffers 19320832 bytes
Database mounted.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
What are the right steps to convert? Or Do i need to rebuild? I dont think a rebuild is required.
Please suggest
0