这方面的文章很多,不再赘述。记录下几个重要的视图备忘.
physical standby database:
select db_unique_name,database_role ,protection_mode,switchover_status from v$database;
select sequence#,applied from v$archived_log;
select status ,error from v$archive_dest where dest_id in (1,2);
select max(sequence#) from v$log_history
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/1698901/viewspace-590734/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/1698901/viewspace-590734/