Data-Guard灾难恢复.pptVIP

* * * * * * * * * * * SELECT name, open_mode, database_role, db_unique_name from v$database; * SELECT dest_name, status, destination, target, archiver, schedule, reopen_secs, delay_mins, max_connections, valid_type, valid_role, db_unique_name FROM v$archive_dest WHERE status != INACTIVE‘’ * col First_Time format a15 col Last_time format a15 col FIRST_CHANGE# format 999999999999999999 col NEXT_CHANGE# format 999999999999999999 SELECT thread#, group#, sequence#, status,archived, first_change#, to_char(first_time,dd-mon hh24:mm:ss) first_time, next_change#, to_char(last_time,dd-mon hh24:m