select "DEST_ID","DEST_NAME","STATUS","TYPE","DATABASE_MODE","RECOVERY_MODE","PROTECTION_MODE","DESTINATION","STANDBY_LOGFILE_COUNT","STANDBY_LOGFILE_ACTIVE","ARCHIVED_THREAD#","ARCHIVED_SEQ#","APPLIED_THREAD#","APPLIED_SEQ#","ERROR","SRL","DB_UNIQUE_NAME","SYNCHRONIZATION_STATUS","SYNCHRONIZED","GAP_STATUS","CON_ID" from v$archive_dest_status
SELECT "DEST_ID"
, "DEST_NAME"
, "STATUS"
, "TYPE"
, "DATABASE_MODE"
, "RECOVERY_MODE"
, "PROTECTION_MODE"
, "DESTINATION"
, "STANDBY_LOGFILE_COUNT"
, "STANDBY_LOGFILE_ACTIVE"
, "ARCHIVED_THREAD#"
, "ARCHIVED_SEQ#"
, "APPLIED_THREAD#"
, "APPLIED_SEQ#"
, "ERROR"
, "SRL"
, "DB_UNIQUE_NAME"
, "SYNCHRONIZATION_STATUS"
, "SYNCHRONIZED"
, "GAP_STATUS"
, "CON_ID"
FROM V$ARCHIVE_DEST_STATUS
|
|
|