oracle dg切换步骤,详解Oracle dg 三种模式切换

oracle dg 三大模式切换

===================================

1  最大性能模式MAXIMUM PERFORMANCE   ------默认模式

===================================

一 最大性能模式特点

192.168.1.181

SQL> 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_mode,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

这就是微学网-程序员之家为你提供的"详解Oracle dg 三种模式切换"希望对你有所帮助.本文来自网络，转载请注明出处：http://www.weixuecn.cn/article/6268.html