Enable Real-Time apply on Standby(Standalone,RAC)
September 21, 2012 1 Comment
In this post we will discuss how to enable real-time apply feature on standalone and Real Application Cluster standby databases.
On standalone standby:
1. See what is recovery mode for now:
SQL> select dest_name,status,type,recovery_mode
from v$archive_dest_status
where dest_id=1;DEST_NAME STATUS TYPE RECOVERY_MODE
———————– ——— ————– ————————-
LOG_ARCHIVE_DEST_1 VALID LOCAL MANAGED
2. Enable real-time apply
On physical:
SQL> recover managed standby database cancel;
Media recovery complete.SQL> recover managed standby database using current logfile disconnect from session;
Media recovery complete.
On logical:
SQL> alter database start logical standby apply immediate;
3. Check
SQL> select dest_name,status,type,recovery_mode
from v$archive_dest_status
where dest_id=1;DEST_NAME STATUS TYPE RECOVERY_MODE
———————– ——— ————– ————————-
LOG_ARCHIVE_DEST_1 VALID LOCAL MANAGED REAL TIME APPLY
On RAC standby:
1. See what is recovery mode for now:
SQL> select dest_name,status,type,recovery_mode
from v$archive_dest_status
where dest_id=1;DEST_NAME STATUS TYPE RECOVERY_MODE
———————– ——— ————– ————————-
LOG_ARCHIVE_DEST_1 VALID LOCAL MANAGED
2. Enable real-time apply
On node1:
SQL> recover managed standby database cancel;
Media recovery complete.SQL> recover managed standby database using current logfile disconnect from session;
Media recovery complete.
3. Check
SQL> select dest_name,status,type,recovery_mode
from v$archive_dest_status
where dest_id=1;DEST_NAME STATUS TYPE RECOVERY_MODE
———————– ——— ————– ————————-
LOG_ARCHIVE_DEST_1 VALID LOCAL MANAGED REAL TIME APPLY
DBA Knowledge Base 