Thinking Out Loud

November 11, 2010

Data Guard Monitor Redo Apply 11.2.0.2

Filed under: oracle — mdinh @ 3:44 am

Oracle just made monitoring standby databases easier with the introduction of a new column GAP_STATUS to V$ARCHIVE_DEST_STATUS.

Here is an example from 10.2.0.4 database

> select * from v$version;

BANNER
—————————————————————-
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bi
PL/SQL Release 10.2.0.4.0 – Production
CORE 10.2.0.4.0 Production
TNS for Solaris: Version 10.2.0.4.0 – Production
NLSRTL Version 10.2.0.4.0 – Production

> @t
old 2: c clob := q’\&1\';
new 2: c clob := q’\select * from v$archive_dest_status where dest_id<=2\';
==============================
DEST_ID : 1
DEST_NAME : LOG_ARCHIVE_DEST_1
STATUS : VALID
TYPE : LOCAL
DATABASE_MODE : OPEN
RECOVERY_MODE : IDLE
PROTECTION_MODE : MAXIMUM PERFORMANCE
DESTINATION :
STANDBY_LOGFILE_COUNT : 0
STANDBY_LOGFILE_ACTIVE : 0
ARCHIVED_THREAD# : 1
ARCHIVED_SEQ# : 70097
APPLIED_THREAD# : 0
APPLIED_SEQ# : 0
ERROR :
SRL : NO
DB_UNIQUE_NAME :
SYNCHRONIZATION_STATUS : CHECK CONFIGURATION
SYNCHRONIZED : NO
==============================
DEST_ID : 2
DEST_NAME : LOG_ARCHIVE_DEST_2
STATUS : VALID
TYPE : PHYSICAL
DATABASE_MODE : MOUNTED-STANDBY
RECOVERY_MODE : MANAGED REAL TIME APPLY
PROTECTION_MODE : MAXIMUM PERFORMANCE
DESTINATION :
STANDBY_LOGFILE_COUNT : 5
STANDBY_LOGFILE_ACTIVE : 4
ARCHIVED_THREAD# : 1
ARCHIVED_SEQ# : 70082
APPLIED_THREAD# : 1
APPLIED_SEQ# : 70082
ERROR :
SRL : NO
DB_UNIQUE_NAME :
SYNCHRONIZATION_STATUS : CHECK CONFIGURATION
SYNCHRONIZED : NO
==============================

PL/SQL procedure successfully completed.

Here is an example from 11.2.0.2 database

> select * from v$version;

BANNER
——————————————————————————–
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – 64bit Production
PL/SQL Release 11.2.0.2.0 – Production
CORE 11.2.0.2.0 Production
TNS for Solaris: Version 11.2.0.2.0 – Production
NLSRTL Version 11.2.0.2.0 – Production

> @t
old 2: c clob := q’\&1\';
new 2: c clob := q’\select * from v$archive_dest_status where dest_id<=2\';
==============================
DEST_ID : 1
DEST_NAME : LOG_ARCHIVE_DEST_1
STATUS : VALID
TYPE : LOCAL
DATABASE_MODE : OPEN
RECOVERY_MODE : IDLE
PROTECTION_MODE : MAXIMUM PERFORMANCE
DESTINATION :
STANDBY_LOGFILE_COUNT : 0
STANDBY_LOGFILE_ACTIVE : 0
ARCHIVED_THREAD# : 1
ARCHIVED_SEQ# : 71345
APPLIED_THREAD# : 0
APPLIED_SEQ# : 0
ERROR :
SRL : NO
DB_UNIQUE_NAME :
SYNCHRONIZATION_STATUS : CHECK CONFIGURATION
SYNCHRONIZED : NO
GAP_STATUS :
==============================
DEST_ID : 2
DEST_NAME : LOG_ARCHIVE_DEST_2
STATUS : VALID
TYPE : PHYSICAL
DATABASE_MODE : MOUNTED-STANDBY
RECOVERY_MODE : MANAGED REAL TIME APPLY
PROTECTION_MODE : MAXIMUM PERFORMANCE
DESTINATION :
STANDBY_LOGFILE_COUNT : 4
STANDBY_LOGFILE_ACTIVE : 1
ARCHIVED_THREAD# : 1
ARCHIVED_SEQ# : 71345
APPLIED_THREAD# : 1
APPLIED_SEQ# : 71344
ERROR :
SRL : YES
DB_UNIQUE_NAME :
SYNCHRONIZATION_STATUS : CHECK CONFIGURATION
SYNCHRONIZED : NO
GAP_STATUS : NO GAP
==============================

PL/SQL procedure successfully completed.

See the GAP_STATUS: NO GAP? Another incentive to upgrade.

Reference:
Monitoring Primary, Physical Standby, and Snapshot Standby Databases
V$ARCHIVE_DEST_STATUS

About these ads

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Rubric Theme. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 300 other followers

%d bloggers like this: