To start the real time apply (standby redo logfiles are must for it)
On Physical Standby
---------------------
SQL> select DEST_ID,dest_name,status,type,srl,recovery_mode
from v$archive_dest_status;
DEST_ID DEST_NAME STATUS TYPE SRL RECOVERY_MODE
---------- ----------------------- --------- -------------- --- --------------
1 LOG_ARCHIVE_DEST_2 VALID LOCAL NO MANAGED
SQL>
alter database recover managed standby database disconnect from session;
On Physical Standby
---------------------
SQL> select DEST_ID,dest_name,status,type,srl,recovery_mode
from v$archive_dest_status;
DEST_ID DEST_NAME STATUS TYPE SRL RECOVERY_MODE
-------- -------------------- --------- --------- --- ---------------
1 LOG_ARCHIVE_DEST_2 VALID LOCAL YES MANAGED REAL TIME APPLY
SQL>
alter database recover managed standby database using current logfile
disconnect from session;
No comments:
Post a Comment