Here in this post we will learn how to set time interval of redo log application to standby.
You can set a delay between the arrival of the archived redo log and it being applied on the standby server using the following commands.
On standby server:
-ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
-ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DELAY 30 DISCONNECT FROM SESSION;
You may also changed the scenario as NODELAY means redo log will immediately applied using the below command:
-ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
-ALTER DATABASE RECOVER MANAGED STANDBY DATABASE NODELAY DISCONNECT FROM SESSION;
enjoy:-)
No comments:
Post a Comment