Shulou(Shulou.com)06/01 Report--

Select log_mode,open_mode, database_role from vault database;-- View dataguard master / slave database status select status from vault instance;-- View database status alter database recover managed standby database cancel;-- cancel log application alter database recover managed standby database using current logfile disconnect;-- slave database to enable real-time application select sequence#,applied from v$archived_log order by sequence#;-- if the slave database is all yes, then the standby database has replicated alter database recover managed standby database disconnect from session in real time. -- slave mount application log alter system switch logfile;-- master database switch log-- enable and stop dg master library alter system set log_archive_dest_state_2 = 'defer';lsnrctl stopshutdown immediatestartupalter system set log_archive_dest_state_2 =' enable';-- standby library stop alter database recover managed standby database cancel;shutdown immediate-- standby library enable startup mount-start to mount status alter database recover managed standby database disconnect from session -- start the log application master / slave archive log list to see if it is synchronized, and the slave database can execute select * from vault archivearchivearchiveApp; check whether there is a delay for the alter system switch logfile;-- master library to perform the switching log, and see whether the slave database applies the log synchronization in a timely manner. After the slave database executes ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;-- to cancel the log application alter database open;--, the slave database opens the alter database recover managed standby database using current logfile disconnect. -- enable the real-time application select log_mode,open_mode for the slave database, and database_role from the real-time application to check the status of the slave database.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.