主库、备库细则 - Oracle-fans - 博客园

col dest_name for a20

col status for a8

col database_mode for a15

col recovery_mode for a15

col protection_mode for a30

col destination for a25

col standby_logfile_count for a30

col standby_logfile_active  a30

col archived_seq#  99999

col applied_seq#  a15

col error for a20   

 select   dest_id, dest_name, status,database_mode,recovery_mode ,protection_mode ,destination  ,standby_logfile_count, standby_logfile_active,archived_seq#  ,applied_seq# ,error    ,     synchronization_status,  gap_status   from v$archive_dest_status where rownum <3;