;
SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
(primary)(修改成MAXIMUM PROTECTION)
alter system set log_archive_dest_2='SERVICE=boston LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=boston NODELAY MAX_CONNECTIONS=2 REOPEN=300 NOMAX_FAILURE';
(standby)
alter system set log_archive_dest_2='SERVICE=chicago LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=chicago NODELAY MAX_CONNECTIONS=2 REOPEN=300 NOMAX_FAILURE';
(primary)
shutdown immediate
startup mount
alter database set standby to maximize protection;
alter database open;
(primary 和 standby都看一下是否是maximun protection)
SQL> select open_mode, database_role, switchover_status, protection_mode, protection_level from v$database;
OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS PROTECTION_MODE PROTECTION_LEVEL
---------- ---------------- -------------------- -------------------- --------------------
READ WRITE PRIMARY TO STANDBY MAXIMUM PROTECTION MAXIMUM PROTECTION
SQL> select open_mode, database_role, switchover_status, protection_mode, protection_level from v$database;
OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS PROTECTION_MODE PROTECTION_LEVEL
---------- ---------------- -------------------- -------------------- --------------------
MOUNTED PHYSICAL STANDBY NOT ALLOWED MAXIMUM PROTECTION MAXIMUM PROTECTION
On maximum protection status, when you switch log file on primary database, then at the same time, the standby logfile also archive the standby logfile to archive log file path. At this mode, you must have standby redo log on standby database,which is directly recevied primary online redo log.
?(primary)(修改成MAXIMUM AVAILABLITY)
alter system set log_archive_dest_2='SERVICE=boston LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=boston NODELAY MAX_CONNECTIONS=2 REOPEN=300 NOMAX_FAILURE';
(standby)
alter system set log_archive_dest_2='SERVICE=chicago LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=chicago NODELAY MAX_CONNECTIONS=2 REOPEN=300 NOMAX_FAILURE';
(primary)
shutdown immediate
startup mount
alter database set standby to maximize availability;
alter database open;
RFS(Remote File Server)
(primary)(修改成MAXIMUM PERFORMANCE)
alter system set log_archive_dest_2='SERVICE=boston LGWR ASYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=boston NODELAY MAX_CONNECTIONS=2 REOPEN=300 NOMAX_FAILURE';
(standby)
alter system set log_archive_dest_2='SERVICE=chicago LGWR ASYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=chicago NODELAY MAX_CONNECTIONS=2 REOPEN=300 NOMAX_FAILURE';
(primary)
shutdown immediate
startup mount
alter database set standby to maximize performance;
alter database open;
RFS(Remote File Server)
SQL> select open_mode, database_role, switchover_status, protection_mode, protection_level from v$database;
OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS PROTECTION_MODE PROTECTION_LEVEL
---------- ---------------- -------------------- -------------------- --------------------
READ WRITE PRIMARY TO STANDBY MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE
SQL> select open_mode, database_role, switchover_status, protection_mode, protection_level from v$database;
OPEN_MODE DATABASE_ROLE SWITCHOVER_STATUS PROTECTION_MODE PROTECTION_LEVEL
-----