详解Oracle dg 三种模式切换
oracledg三大模式切换
===================================
1 最大性能模式MAXIMUMPERFORMANCE ------默认模式
===================================
一最大性能模式特点
192.168.1.181 SQL>selectdatabase_role,protection_mode,protection_levelfromv$database; DATABASE_ROLEPROTECTION_MODEPROTECTION_LEVEL -------------------------------------------------------- PRIMARYMAXIMUMPERFORMANCEMAXIMUMPERFORMANCE SQL>coldest_namefora25 SQL>selectdest_name,statusfromv$archive_dest_status; DEST_NAMESTATUS ---------------------------------- LOG_ARCHIVE_DEST_1VALID LOG_ARCHIVE_DEST_2VALID SQL>showparameterlog_archive NAMETYPEVALUE ----------------------------------------------------------------------------- log_archive_configstringdg_config=(orcl,db01) log_archive_dest_1stringlocation=/home/oracle/arch_orc lvalid_for=(all_logfiles,all_ roles)db_unique_name=orcl log_archive_dest_2stringservice=db_db01LGWRASYNCval id_for=(online_logfiles,primar y_roles)db_unique_name=db01 SQL>archiveloglist DatabaselogmodeArchiveMode AutomaticarchivalEnabled Archivedestination/home/oracle/arch_orcl Oldestonlinelogsequence31 Nextlogsequencetoarchive33 Currentlogsequence33 192.168.1.183 SQL>selectdatabase_role,protection_mode,protection_levelfromv$database; DATABASE_ROLEPROTECTION_MODEPROTECTION_LEVEL -------------------------------------------------------- PHYSICALSTANDBYMAXIMUMPERFORMANCEMAXIMUMPERFORMANCE SQL>coldest_namefora25 SQL>selectdest_name,statusfromv$archive_dest_status; DEST_NAMESTATUS ---------------------------------- LOG_ARCHIVE_DEST_1VALID LOG_ARCHIVE_DEST_2VALID SQL>showparameterlog_archive NAMETYPEVALUE ----------------------------------------------------------------------------- log_archive_configstringdg_config=(db01,orcl) log_archive_dest_1stringlocation=/home/oracle/arch_db0 1valid_for=(all_logfiles,all_ roles)db_unique_name=db01 log_archive_dest_2stringservice=db_orclLGWRASYNCval id_for=(online_logfiles,primar y_roles)db_unique_name=orcl SQL>archiveloglist DatabaselogmodeArchiveMode AutomaticarchivalEnabled Archivedestination/home/oracle/arch_orcl Oldestonlinelogsequence31 Nextlogsequencetoarchive33 Currentlogsequence33 192.168.1.181 SQL>altersystemswitchlogfile; SQL>archiveloglist DatabaselogmodeArchiveMode AutomaticarchivalEnabled Archivedestination/home/oracle/arch_orcl Oldestonlinelogsequence32 Nextlogsequencetoarchive34 Currentlogsequence34 192.168.1.183 SQL>archiveloglist DatabaselogmodeArchiveMode AutomaticarchivalEnabled Archivedestination/home/oracle/arch_db01 Oldestonlinelogsequence32 Nextlogsequencetoarchive0 Currentlogsequence34
===================================
2最大性能模式--切换到-->最大高可用 (默认是最大性能模式---MAXIMUMPERFORMANCE)
===================================
192.168.1.181 SQL>selectDATABASE_ROLE,PROTECTION_MODE,PROTECTION_LEVELfromv$database; DATABASE_ROLEPROTECTION_MODEPROTECTION_LEVEL -------------------------------------------------------- PRIMARYMAXIMUMPERFORMANCEMAXIMUMPERFORMANCE SQL>showparameterlog_archive_dest_2 NAMETYPEVALUE ----------------------------------------------------------------------------- log_archive_dest_2stringservice=db_db01LGWRASYNCval id_for=(online_logfiles,primar y_roles)db_unique_name=db01 192.168.1.181 SQL>shutdownimmediate 192.168.1.183 SQL>alterdatabaserecovermanagedstandbydatabasecancel; SQL>shutdownimmediate 192.168.1.181 SQL>startupmount; SQL>alterdatabasesetstandbydatabasetomaximizeavailability; SQL>altersystemsetlog_archive_dest_2='service=db_db01LGWRSYNCvalid_for=(online_logfiles,primary_roles)db_unique_name=db01'scope=spfile; 192.168.1.183 SQL>startupnomount SQL>alterdatabasemountstandbydatabase; SQL>altersystemsetlog_archive_dest_2='service=db_orclLGWRSYNCvalid_for=(online_logfiles,primary_roles)db_unique_name=orcl'scope=spfile; SQL>shutdownimmediate SQL>startupnomount SQL>alterdatabasemountstandbydatabase; 192.168.1.181 SQL>startup SQL>coldest_namefora25 SQL>selectdest_name,statusfromv$archive_dest_status; DEST_NAMESTATUS ---------------------------------- LOG_ARCHIVE_DEST_1VALID LOG_ARCHIVE_DEST_2VALID SQL>showparameterlog_archive_dest_2 NAMETYPEVALUE ----------------------------------------------------------------------------- log_archive_dest_2stringservice=db_db01LGWRSYNCvali d_for=(online_logfiles,primary _roles)db_unique_name=db01 SQL>selectdatabase_role,protection_level,protection_modefromv$database; DATABASE_ROLEPROTECTION_LEVELPROTECTION_MODE -------------------------------------------------------- PRIMARYMAXIMUMAVAILABILITYMAXIMUMAVAILABILITY SQL>archiveloglist DatabaselogmodeArchiveMode AutomaticarchivalEnabled Archivedestination/home/oracle/arch_orcl Oldestonlinelogsequence34 Nextlogsequencetoarchive36 Currentlogsequence36 192.168.1.183 SQL>coldest_namefora25 SQL>selectdest_name,statusfromv$archive_dest_status; DEST_NAMESTATUS ---------------------------------- LOG_ARCHIVE_DEST_1VALID LOG_ARCHIVE_DEST_2VALID SQL>showparameterlog_archive_dest_2 NAMETYPEVALUE ----------------------------------------------------------------------------- log_archive_dest_2stringservice=db_orclLGWRSYNCvali d_for=(online_logfiles,primary _roles)db_unique_name=orcl SQL>selectdatabase_role,protection_level,protection_modefromv$database; DATABASE_ROLEPROTECTION_LEVELPROTECTION_MODE -------------------------------------------------------- PHYSICALSTANDBYMAXIMUMAVAILABILITYMAXIMUMAVAILABILITY SQL>archiveloglist DatabaselogmodeArchiveMode AutomaticarchivalEnabled Archivedestination/home/oracle/arch_db01 Oldestonlinelogsequence35 Nextlogsequencetoarchive0 Currentlogsequence36 192.168.1.181 SQL>altersystemswitchlogfile; SQL>archiveloglist DatabaselogmodeArchiveMode AutomaticarchivalEnabled Archivedestination/home/oracle/arch_orcl Oldestonlinelogsequence35 Nextlogsequencetoarchive37 Currentlogsequence37 192.168.1.183 SQL>archiveloglist DatabaselogmodeArchiveMode AutomaticarchivalEnabled Archivedestination/home/oracle/arch_db01 Oldestonlinelogsequence36 Nextlogsequencetoarchive0 Currentlogsequence37
===================================
3最大高可用--切换到-->最保护能模式
===================================
DG最大保护模式Maximumprotection
192.168.1.181 SQL>shutdownimmediate 192.168.1.183 SQL>shutdownimmediate 192.168.1.181 SQL>alterdatabasesetstandbydatabasetomaximizeprotection; SQL>shutdownimmediate 192.168.1.183 SQL>startupnomount SQL>alterdatabasemountstandbydatabase; 192.168.1.181 SQL>startup SQL>coldest_namefora25 SQL>selectdest_name,statusfromv$archive_dest_status; DEST_NAMESTATUS ---------------------------------- LOG_ARCHIVE_DEST_1VALID LOG_ARCHIVE_DEST_2VALID SQL>showparameterlog_archive_dest_2 NAMETYPEVALUE ----------------------------------------------------------------------------- log_archive_dest_2stringservice=db_db01LGWRSYNCvali d_for=(online_logfiles,primary _roles)db_unique_name=db01 SQL>selectdatabase_role,protection_level,protection_modefromv$database; DATABASE_ROLEPROTECTION_LEVELPROTECTION_MODE -------------------------------------------------------- PRIMARYMAXIMUMPROTECTIONMAXIMUMPROTECTION SQL>archiveloglist DatabaselogmodeArchiveMode AutomaticarchivalEnabled Archivedestination/home/oracle/arch_orcl Oldestonlinelogsequence37 Nextlogsequencetoarchive39 Currentlogsequence39 192.168.1.183 SQL>coldest_namefora25 SQL>selectdest_name,statusfromv$archive_dest_status; DEST_NAMESTATUS ---------------------------------- LOG_ARCHIVE_DEST_1VALID LOG_ARCHIVE_DEST_2VALID SQL>showparameterlog_archive_dest_2 NAMETYPEVALUE ----------------------------------------------------------------------------- log_archive_dest_2stringservice=db_db01LGWRSYNCvali d_for=(online_logfiles,primary _roles)db_unique_name=db01 SQL>selectdatabase_role,protection_level,protection_modefromv$database; DATABASE_ROLEPROTECTION_LEVELPROTECTION_MODE -------------------------------------------------------- PRIMARYMAXIMUMPROTECTIONMAXIMUMPROTECTION SQL>archiveloglist DatabaselogmodeArchiveMode AutomaticarchivalEnabled Archivedestination/home/oracle/arch_db01 Oldestonlinelogsequence37 Nextlogsequencetoarchive0 Currentlogsequence39 192.168.1.181 SQL>altersystemswitchlogfile; SQL>archiveloglist DatabaselogmodeArchiveMode AutomaticarchivalEnabled Archivedestination/home/oracle/arch_orcl Oldestonlinelogsequence38 Nextlogsequencetoarchive40 Currentlogsequence40 192.168.1.183 SQL>archiveloglist DatabaselogmodeArchiveMode AutomaticarchivalEnabled Archivedestination/home/oracle/arch_db01 Oldestonlinelogsequence37 Nextlogsequencetoarchive0 Currentlogsequence40
附：OracleDG管理模式和只读模式相互切换
将standby数据库开启至只读模式(用于primary非常忙时，可以在standby跑一些报表)
$sqlplus“/assysdba” SQL>startupmount SQL>alterdatabaseopenreadonly; [@more@]
将只读模式standby数据库切换至管理模式
$sqlplus“/assysdba” SQL>alterdatabaserecovermanagedstandbydatabasedisconnectfromsession;
将管理模式的standby数据库切换至只读模式
$sqlplus“/assysdba” SQL>alterdatabaserecovermanagedstandbydatabasecancel; SQL>alterdatabaseopenreadonly;
以上内容给大家介绍了Oracledg三种模式切换的相关知识，希望大家喜欢。