how to confirm Real Time Apply working on 10.2.0.4
edited Jun 25, 2012 8:06PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 3 commentsAnswered
Hi. I just configured/fired up standby database for 10.2.0.4. I am very experienced DBA, but totally new to Data Guard. Yes, I have RTFM. But I very tired, and hope someone can just confirm for me that my assumption Real Time Apply working is correct:
SQL> ALTER DATABASE recover managed standby database using current logfile disconnect;
Database altered.
SQL> SELECT DEST_ID, RECOVERY_MODE FROM V$ARCHIVE_DEST_STATUS;
DEST_ID RECOVERY_MODE
---------- -----------------------
1 MANAGED REAL TIME APPLY
2 MANAGED REAL TIME APPLY
3 MANAGED REAL TIME APPLY
4 MANAGED REAL TIME APPLY
5 MANAGED REAL TIME APPLY
6 MANAGED REAL TIME APPLY
7 MANAGED REAL TIME APPLY
0