How to enable flashback in Standby database
Below is the command to start MRP process
SQL> recover managed standby database disconnect;
Media recovery complete.
Below we get error because MRP is still active and applying the changes
SQL> alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
Below is the command to stop the MRP process
SQL> recover managed standby database cancel;
Media recovery complete.
So now we will be able to enable flashback
SQL> alter database flashback on;
Database altered.
Below is the command to start the MRP process
SQL> recover managed standby database disconnect;
Media recovery complete.
Below is the command to start MRP process
SQL> recover managed standby database disconnect;
Media recovery complete.
Below we get error because MRP is still active and applying the changes
SQL> alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
Below is the command to stop the MRP process
SQL> recover managed standby database cancel;
Media recovery complete.
So now we will be able to enable flashback
SQL> alter database flashback on;
Database altered.
Below is the command to start the MRP process
SQL> recover managed standby database disconnect;
Media recovery complete.
No comments:
Post a Comment