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

select DATABASE_ROLE,PROTECTION_MODE,PROTECTION_LEVEL from v$database; DATABASE_ROLE PROTECTION_MODE PROTECTION_LEVEL ---------------- -------------------- -------------------- PRIMARY MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE sql> show parameter log_archive_dest_2 NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest_2 string service=db_db01 LGWR ASYNC val id_for=(online_logfiles,primar y_roles) db_unique_name=db01 192.168.1.181 sql> shutdown immediate 192.168.1.183 sql> alter database recover managed standby database cancel; sql> shutdown immediate 192.168.1.181 sql> startup mount; sql> alter database set standby database to maximize availability; sql> alter system set log_archive_dest_2='service=db_db01 LGWR SYNC valid_for=(online_logfiles,primary_roles) db_unique_name=db01' scope=spfile; 192.168.1.183 sql> startup nomount sql> alter database mount standby database; sql> alter system set log_archive_dest_2='service=db_orcl LGWR SYNC valid_for=(online_logfiles,primary_roles) db_unique_name=orcl' scope=spfile; sql> shutdown immediate 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,status from v$archive_dest_status; DEST_NAME STATUS ------------------------- --------- LOG_ARCHIVE_DEST_1 VALID LOG_ARCHIVE_DEST_2 VALID sql> show parameter log_archive_dest_2 NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest_2 string service=db_db01 LGWR SYNC vali d_for=(online_logfiles,primary _roles) db_unique_name=db01 sql> select database_role,protection_level,protection_mode from v$database; DATABASE_ROLE PROTECTION_LEVEL PROTECTION_MODE ---------------- -------------------- -------------------- PRIMARY MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY sql> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination /home/oracle/arch_orcl Oldest online log sequence 34 Next log sequence to archive 36 Current log sequence 36 192.168.1.183 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_dest_2 NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest_2 string service=db_orcl LGWR SYNC vali d_for=(online_logfiles,primary _roles) db_unique_name=orcl sql> select database_role,protection_mode from v$database; DATABASE_ROLE PROTECTION_LEVEL PROTECTION_MODE ---------------- -------------------- -------------------- PHYSICAL STANDBY MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY sql> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination /home/oracle/arch_db01 Oldest online log sequence 35 Next log sequence to archive 0 Current log sequence 36 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 35 Next log sequence to archive 37 Current log sequence 37 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 36 Next log sequence to archive 0 Current log sequence 37

shutdown 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

startup mount sql>alter database open read only; [@more@]

alter database recover managed standby database disconnect from session;

alter database recover managed standby database cancel; sql>alter database open read only;