详解Oracle dg 三种模式切换
发布时间:2020-12-12 17:02:27 所属栏目:百科 来源:网络整理
导读:oracle dg 三大模式切换 =================================== 1 最大性能模式MAXIMUM PERFORMANCE ------默认模式 =================================== 一 最大性能模式特点 select database_role,protection_mode,protection_level from v$database;DATAB
oracle dg 三大模式切换 =================================== 一 最大性能模式特点select database_role,protection_mode,protection_level from v$database; DATABASE_ROLE PROTECTION_MODE PROTECTION_LEVEL ---------------- -------------------- -------------------- PRIMARY MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE SQL> col dest_name for a25 SQL> select dest_name,status from v$archive_dest_status; DEST_NAME STATUS ------------------------- --------- LOG_ARCHIVE_DEST_1 VALID LOG_ARCHIVE_DEST_2 VALID SQL> show parameter log_archive NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_config string dg_config=(orcl,db01) log_archive_dest_1 string location=/home/oracle/arch_orc l valid_for=(all_logfiles,all_ roles) db_unique_name=orcl log_archive_dest_2 string service=db_db01 LGWR ASYNC val id_for=(online_logfiles,primar y_roles) db_unique_name=db01 SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination /home/oracle/arch_orcl Oldest online log sequence 31 Next log sequence to archive 33 Current log sequence 33 192.168.1.183 SQL> select database_role,protection_level from v$database; DATABASE_ROLE PROTECTION_MODE PROTECTION_LEVEL ---------------- -------------------- -------------------- PHYSICAL STANDBY MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE SQL> col dest_name for a25 SQL> select dest_name,status from v$archive_dest_status; DEST_NAME STATUS ------------------------- --------- LOG_ARCHIVE_DEST_1 VALID LOG_ARCHIVE_DEST_2 VALID SQL> show parameter log_archive NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_config string dg_config=(db01,orcl) log_archive_dest_1 string location=/home/oracle/arch_db0 1 valid_for=(all_logfiles,all_ roles) db_unique_name=db01 log_archive_dest_2 string service=db_orcl LGWR ASYNC val id_for=(online_logfiles,primar y_roles) db_unique_name=orcl SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination /home/oracle/arch_orcl Oldest online log sequence 31 Next log sequence to archive 33 Current log sequence 33 192.168.1.181 SQL> alter system switch logfile; SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination /home/oracle/arch_orcl Oldest online log sequence 32 Next log sequence to archive 34 Current log sequence 34 192.168.1.183 SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination /home/oracle/arch_db01 Oldest online log sequence 32 Next log sequence to archive 0 Current log sequence 34=================================== =================================== DG最大保护模式Maximum protectionshutdown immediate 192.168.1.183 SQL> shutdown immediate 192.168.1.181 SQL> alter database set standby database to maximize protection; SQL> shutdown immediate 192.168.1.183 SQL> startup nomount SQL> alter database mount standby database; 192.168.1.181 SQL> startup SQL> col dest_name for a25 SQL> select dest_name,protection_mode from v$database; DATABASE_ROLE PROTECTION_LEVEL PROTECTION_MODE ---------------- -------------------- -------------------- PRIMARY MAXIMUM PROTECTION MAXIMUM PROTECTION SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination /home/oracle/arch_orcl Oldest online log sequence 37 Next log sequence to archive 39 Current log sequence 39 192.168.1.183 SQL> col dest_name for a25 SQL> select dest_name,protection_mode from v$database; DATABASE_ROLE PROTECTION_LEVEL PROTECTION_MODE ---------------- -------------------- -------------------- PRIMARY MAXIMUM PROTECTION MAXIMUM PROTECTION SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination /home/oracle/arch_db01 Oldest online log sequence 37 Next log sequence to archive 0 Current log sequence 39 192.168.1.181 SQL> alter system switch logfile; SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination /home/oracle/arch_orcl Oldest online log sequence 38 Next log sequence to archive 40 Current log sequence 40 192.168.1.183 SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination /home/oracle/arch_db01 Oldest online log sequence 37 Next log sequence to archive 0 Current log sequence 40将standby数据库开启至只读模式(用于primary非常忙时,可以在standby跑一些报表)startup mount SQL>alter database open read only; [@more@]将只读模式standby数据库切换至管理模式alter database recover managed standby database disconnect from session;将管理模式的standby数据库切换至只读模式alter database recover managed standby database cancel; SQL>alter database open read only;以上内容给大家介绍了Oracle dg 三种模式切换的相关知识,希望大家喜欢。 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |