作者:Lunar©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]
当前环境:
A: 当前是Primary ,Oracle 11.2.0.3,本次切换后为Physical Standby
B: 当前是Physical Standby,本次切换后为Cascade Standby(因为这个库是11.2.0.4,版本不一致,因此只能做standby,不能open)
C:当前是Cascade Standby,Oracle 11.2.0.3,本次切换后为Primary
============================================================================================================
1,级联环境下,如果到Cascade的路径是enable,则在做switchover时,主库上查询会报:“RESOLVABLE GAP”
解决方法是将主库到cascade的归档路径设置为defer ;
============================================================================================================
21:17:04 SYS@lunarp>SELECT SWITCHOVER_STATUS FROM V$DATABASE;
SWITCHOVER_STATUS
--------------------
RESOLVABLE GAP
Elapsed: 00:00:00.02
21:17:30 SYS@lunarp>show parameter log
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_syslog_level string
commit_logging string
db_create_online_log_dest_1 string
db_create_online_log_dest_2 string
db_create_online_log_dest_3 string
db_create_online_log_dest_4 string
db_create_online_log_dest_5 string
enable_ddl_logging boolean FALSE
log_archive_config string DG_CONFIG=(lunarp,lunars,lunar
c)
log_archive_dest string
log_archive_dest_1 string LOCATION=USE_DB_RECOVERY_FILE_
DEST VALID_FOR=(ALL_LOGFILES,A
LL_ROLES) DB_UNIQUE_NAME=lunar
p
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
log_archive_dest_2 string SERVICE=lunars LGWR SYNC AFFIR
M VALID_FOR=(ONLINE_LOGFILES,P
RIMARY_ROLE) DB_UNIQUE_NAME=lu
nars
log_archive_dest_20 string
log_archive_dest_21 string
log_archive_dest_22 string
log_archive_dest_23 string
log_archive_dest_24 string
log_archive_dest_25 string
log_archive_dest_26 string
log_archive_dest_27 string
log_archive_dest_28 string
log_archive_dest_29 string
log_archive_dest_3 string SERVICE=lunarc LGWR SYNC AFFIR
M VALID_FOR=(STANDBY_LOGFILES,
STANDBY_ROLE) DB_UNIQUE_NAME=l
unarc
log_archive_dest_30 string
log_archive_dest_31 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string ENABLE
log_archive_dest_state_10 string enable
log_archive_dest_state_11 string enable
log_archive_dest_state_12 string enable
log_archive_dest_state_13 string enable
log_archive_dest_state_14 string enable
log_archive_dest_state_15 string enable
log_archive_dest_state_16 string enable
log_archive_dest_state_17 string enable
log_archive_dest_state_18 string enable
log_archive_dest_state_19 string enable
log_archive_dest_state_2 string ENABLE
log_archive_dest_state_20 string enable
log_archive_dest_state_21 string enable
log_archive_dest_state_22 string enable
log_archive_dest_state_23 string enable
log_archive_dest_state_24 string enable
log_archive_dest_state_25 string enable
log_archive_dest_state_26 string enable
log_archive_dest_state_27 string enable
log_archive_dest_state_28 string enable
log_archive_dest_state_29 string enable
log_archive_dest_state_3 string ENABLE
log_archive_dest_state_30 string enable
log_archive_dest_state_31 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_format string %t_%s_%r.dbf
log_archive_local_first boolean TRUE
log_archive_max_processes integer 4
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0
log_buffer integer 7200768
log_checkpoint_interval integer 0
log_checkpoint_timeout integer 1800
log_checkpoints_to_alert boolean FALSE
log_file_name_convert string +DATA/lunars/, /stage/lunar/
remote_login_passwordfile string EXCLUSIVE
sec_case_sensitive_logon boolean TRUE
sec_max_failed_login_attempts integer 10
21:20:24 SYS@lunarp>alter system set log_archive_dest_state_3=defer;
System altered.
Elapsed: 00:00:00.07
21:20:53 SYS@lunarp>SELECT NAME,DB_UNIQUE_NAME,DATABASE_ROLE,PROTECTION_MODE, SWITCHOVER_STATUS, OPEN_MODE FROM V$DATABASE;
NAME DB_UNIQUE_NAME DATABASE_ROLE PROTECTION_MODE SWITCHOVER_STATUS OPEN_MODE
--------- ------------------------------ ---------------- -------------------- -------------------- --------------------
LUNAR lunarp PRIMARY MAXIMUM PERFORMANCE TO STANDBY READ WRITE
Elapsed: 00:00:00.03
21:21:16 SYS@lunarp>
============================================================================================================
2,如果主库到备库的归档路径(A到B的)是defer,那么switchover时,检查主库状态会是“NOT ALLOWED”:
解决方法是: 将A到B的路径设置为enable
============================================================================================================
21:41:50 SYS@lunarp>SELECT NAME,DB_UNIQUE_NAME,DATABASE_ROLE,PROTECTION_MODE, SWITCHOVER_STATUS, OPEN_MODE FROM V$DATABASE;
NAME DB_UNIQUE_NAME DATABASE_ROLE PROTECTION_MODE SWITCHOVER_STATUS OPEN_MODE
--------- ------------------------------ ---------------- -------------------- -------------------- --------------------
LUNAR lunarp PRIMARY MAXIMUM PERFORMANCE NOT ALLOWED READ WRITE
Elapsed: 00:00:00.02
21:41:52 SYS@lunarp>archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 34
Next log sequence to archive 36
Current log sequence 36
21:42:29 SYS@lunarp>show parameter log
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_syslog_level string
commit_logging string
db_create_online_log_dest_1 string
db_create_online_log_dest_2 string
db_create_online_log_dest_3 string
db_create_online_log_dest_4 string
db_create_online_log_dest_5 string
enable_ddl_logging boolean FALSE
log_archive_config string DG_CONFIG=(lunarp,lunars,lunar
c)
log_archive_dest string
log_archive_dest_1 string LOCATION=USE_DB_RECOVERY_FILE_
DEST VALID_FOR=(ALL_LOGFILES,A
LL_ROLES) DB_UNIQUE_NAME=lunar
p
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
log_archive_dest_2 string SERVICE=lunars LGWR ASYNC AFFI
RM VALID_FOR=(ONLINE_LOGFILES,
PRIMARY_ROLE) DB_UNIQUE_NAME=l
unars
log_archive_dest_20 string
log_archive_dest_21 string
log_archive_dest_22 string
log_archive_dest_23 string
log_archive_dest_24 string
log_archive_dest_25 string
log_archive_dest_26 string
log_archive_dest_27 string
log_archive_dest_28 string
log_archive_dest_29 string
log_archive_dest_3 string SERVICE=lunarc LGWR ASYNC AFFI
RM VALID_FOR=(STANDBY_LOGFILES
,STANDBY_ROLE) DB_UNIQUE_NAME=
lunarc
log_archive_dest_30 string
log_archive_dest_31 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string ENABLE
log_archive_dest_state_10 string enable
log_archive_dest_state_11 string enable
log_archive_dest_state_12 string enable
log_archive_dest_state_13 string enable
log_archive_dest_state_14 string enable
log_archive_dest_state_15 string enable
log_archive_dest_state_16 string enable
log_archive_dest_state_17 string enable
log_archive_dest_state_18 string enable
log_archive_dest_state_19 string enable
log_archive_dest_state_2 string DEFER
log_archive_dest_state_20 string enable
log_archive_dest_state_21 string enable
log_archive_dest_state_22 string enable
log_archive_dest_state_23 string enable
log_archive_dest_state_24 string enable
log_archive_dest_state_25 string enable
log_archive_dest_state_26 string enable
log_archive_dest_state_27 string enable
log_archive_dest_state_28 string enable
log_archive_dest_state_29 string enable
log_archive_dest_state_3 string DEFER
log_archive_dest_state_30 string enable
log_archive_dest_state_31 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_format string %t_%s_%r.dbf
log_archive_local_first boolean TRUE
log_archive_max_processes integer 4
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0
log_buffer integer 7200768
log_checkpoint_interval integer 0
log_checkpoint_timeout integer 1800
log_checkpoints_to_alert boolean FALSE
log_file_name_convert string +DATA/lunars/, /stage/lunar/
remote_login_passwordfile string EXCLUSIVE
sec_case_sensitive_logon boolean TRUE
sec_max_failed_login_attempts integer 10
21:42:34 SYS@lunarp>
21:42:57 SYS@lunarp>alter system set log_archive_dest_state_2=enable;
System altered.
Elapsed: 00:00:00.10
21:43:08 SYS@lunarp>SELECT NAME,DB_UNIQUE_NAME,DATABASE_ROLE,PROTECTION_MODE, SWITCHOVER_STATUS, OPEN_MODE FROM V$DATABASE;
NAME DB_UNIQUE_NAME DATABASE_ROLE PROTECTION_MODE SWITCHOVER_STATUS OPEN_MODE
--------- ------------------------------ ---------------- -------------------- -------------------- --------------------
LUNAR lunarp PRIMARY MAXIMUM PERFORMANCE TO STANDBY READ WRITE
Elapsed: 00:00:00.02
21:43:14 SYS@lunarp>
============================================================================================================
将A库切换为Standby:
============================================================================================================
21:43:14 SYS@lunarp>ALTER SYSTEM SWITCH LOGFILE;
System altered.
Elapsed: 00:00:00.10
21:47:55 SYS@lunarp>select max(sequence#),thread# from v$archived_log group by thread#;
MAX(SEQUENCE#) THREAD#
-------------- ----------
37 1
Elapsed: 00:00:00.07
21:48:07 SYS@lunarp>alter database commit to switchover to physical standby WITH SESSION SHUTDOWN;
Database altered.
Elapsed: 00:00:05.62
21:50:59 SYS@lunarp>shutdown immediate;
ORA-01092: ORACLE instance terminated. Disconnection forced
21:51:43 SYS@lunarp>
21:51:55 SYS@lunarp>exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning and Real Application Testing options
[oracle@lunar ~]$ ss
SQL*Plus: Release 11.2.0.3.0 Production on Sat Aug 2 21:52:09 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Welcome Lunar's oracle world!
Connected to an idle instance.
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss'
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
Elapsed: 00:00:00.01
21:52:10 SYS@lunarp>startup mount
Welcome Lunar's oracle world!
Love you , baby !
ORACLE instance started.
Total System Global Area 626327552 bytes
Fixed Size 2230952 bytes
Variable Size 184550744 bytes
Database Buffers 432013312 bytes
Redo Buffers 7532544 bytes
Database mounted.
Welcome Lunar's oracle world!
Love you , baby !
21:52:27 SYS@lunarp>SELECT SWITCHOVER_STATUS FROM V$DATABASE;
SWITCHOVER_STATUS
--------------------
RECOVERY NEEDED
Elapsed: 00:00:00.11
21:52:31 SYS@lunarp>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
Database altered.
Elapsed: 00:00:06.08
21:52:55 SYS@lunarp>select DATABASE_ROLE,PROTECTION_MODE,PROTECTION_LEVEL from v$database;
DATABASE_ROLE PROTECTION_MODE PROTECTION_LEVEL
---------------- -------------------- --------------------
PHYSICAL STANDBY MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE
Elapsed: 00:00:00.03
21:53:07 SYS@lunarp>
============================================================================================================
3,同理,Cascade不能切换为Primary,也需要enable C库到A库的归档路径:
============================================================================================================
21:50:41 SYS@lunarc>SELECT SWITCHOVER_STATUS FROM V$DATABASE;
SWITCHOVER_STATUS
--------------------
NOT ALLOWED
Elapsed: 00:00:00.07
21:54:21 SYS@lunarc>show parameter log
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_syslog_level string
commit_logging string
db_create_online_log_dest_1 string
db_create_online_log_dest_2 string
db_create_online_log_dest_3 string
db_create_online_log_dest_4 string
db_create_online_log_dest_5 string
enable_ddl_logging boolean FALSE
log_archive_config string DG_CONFIG=(lunarp,lunars,lunar
c)
log_archive_dest string
log_archive_dest_1 string LOCATION=USE_DB_RECOVERY_FILE_
DEST VALID_FOR=(ALL_LOGFILES,A
LL_ROLES) DB_UNIQUE_NAME=lunar
c
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
log_archive_dest_2 string SERVICE=lunarp LGWR ASYNC AFFI
RM VALID_FOR=(ONLINE_LOGFILES,
PRIMARY_ROLE) DB_UNIQUE_NAME=l
unarp
log_archive_dest_20 string
log_archive_dest_21 string
log_archive_dest_22 string
log_archive_dest_23 string
log_archive_dest_24 string
log_archive_dest_25 string
log_archive_dest_26 string
log_archive_dest_27 string
log_archive_dest_28 string
log_archive_dest_29 string
log_archive_dest_3 string SERVICE=lunars LGWR ASYNC AFFI
RM VALID_FOR=(STANDBY_LOGFILES
,STANDBY_ROLE) DB_UNIQUE_NAME=
lunars
log_archive_dest_30 string
log_archive_dest_31 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string ENABLE
log_archive_dest_state_10 string enable
log_archive_dest_state_11 string enable
log_archive_dest_state_12 string enable
log_archive_dest_state_13 string enable
log_archive_dest_state_14 string enable
log_archive_dest_state_15 string enable
log_archive_dest_state_16 string enable
log_archive_dest_state_17 string enable
log_archive_dest_state_18 string enable
log_archive_dest_state_19 string enable
log_archive_dest_state_2 string DEFER
log_archive_dest_state_20 string enable
log_archive_dest_state_21 string enable
log_archive_dest_state_22 string enable
log_archive_dest_state_23 string enable
log_archive_dest_state_24 string enable
log_archive_dest_state_25 string enable
log_archive_dest_state_26 string enable
log_archive_dest_state_27 string enable
log_archive_dest_state_28 string enable
log_archive_dest_state_29 string enable
log_archive_dest_state_3 string DEFER
log_archive_dest_state_30 string enable
log_archive_dest_state_31 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_format string %t_%s_%r.dbf
log_archive_local_first boolean TRUE
log_archive_max_processes integer 4
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0
log_buffer integer 7200768
log_checkpoint_interval integer 0
log_checkpoint_timeout integer 1800
log_checkpoints_to_alert boolean FALSE
log_file_name_convert string /stage/lunar/, /tempdisk/lunar
c/
remote_login_passwordfile string EXCLUSIVE
sec_case_sensitive_logon boolean TRUE
sec_max_failed_login_attempts integer 10
21:58:35 SYS@lunarc>alter system set log_archive_dest_state_2=enable;
System altered.
Elapsed: 00:00:00.01
22:00:00 SYS@lunarc>
============================================================================================================
4,还需要B库到C库的归档路径:
============================================================================================================
22:16:17 SYS@lunarc>archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 34
Next log sequence to archive 0
Current log sequence 35
22:16:34 SYS@lunarc>show parameter log
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_syslog_level string
commit_logging string
db_create_online_log_dest_1 string
db_create_online_log_dest_2 string
db_create_online_log_dest_3 string
db_create_online_log_dest_4 string
db_create_online_log_dest_5 string
enable_ddl_logging boolean FALSE
log_archive_config string DG_CONFIG=(lunarp,lunars,lunar
c)
log_archive_dest string
log_archive_dest_1 string LOCATION=USE_DB_RECOVERY_FILE_
DEST VALID_FOR=(ALL_LOGFILES,A
LL_ROLES) DB_UNIQUE_NAME=lunar
c
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
log_archive_dest_2 string SERVICE=lunarp LGWR ASYNC AFFI
RM VALID_FOR=(ONLINE_LOGFILES,
PRIMARY_ROLE) DB_UNIQUE_NAME=l
unarp
log_archive_dest_20 string
log_archive_dest_21 string
log_archive_dest_22 string
log_archive_dest_23 string
log_archive_dest_24 string
log_archive_dest_25 string
log_archive_dest_26 string
log_archive_dest_27 string
log_archive_dest_28 string
log_archive_dest_29 string
log_archive_dest_3 string SERVICE=lunars LGWR ASYNC AFFI
RM VALID_FOR=(STANDBY_LOGFILES
,STANDBY_ROLE) DB_UNIQUE_NAME=
lunars
log_archive_dest_30 string
log_archive_dest_31 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string ENABLE
log_archive_dest_state_10 string enable
log_archive_dest_state_11 string enable
log_archive_dest_state_12 string enable
log_archive_dest_state_13 string enable
log_archive_dest_state_14 string enable
log_archive_dest_state_15 string enable
log_archive_dest_state_16 string enable
log_archive_dest_state_17 string enable
log_archive_dest_state_18 string enable
log_archive_dest_state_19 string enable
log_archive_dest_state_2 string ENABLE
log_archive_dest_state_20 string enable
log_archive_dest_state_21 string enable
log_archive_dest_state_22 string enable
log_archive_dest_state_23 string enable
log_archive_dest_state_24 string enable
log_archive_dest_state_25 string enable
log_archive_dest_state_26 string enable
log_archive_dest_state_27 string enable
log_archive_dest_state_28 string enable
log_archive_dest_state_29 string enable
log_archive_dest_state_3 string DEFER
log_archive_dest_state_30 string enable
log_archive_dest_state_31 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_format string %t_%s_%r.dbf
log_archive_local_first boolean TRUE
log_archive_max_processes integer 4
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0
log_buffer integer 7200768
log_checkpoint_interval integer 0
log_checkpoint_timeout integer 1800
log_checkpoints_to_alert boolean FALSE
log_file_name_convert string /stage/lunar/, /tempdisk/lunar
c/
remote_login_passwordfile string EXCLUSIVE
sec_case_sensitive_logon boolean TRUE
sec_max_failed_login_attempts integer 10
22:16:39 SYS@lunarc>show parameter fal
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fal_client string lunarc
fal_server string lunars, lunarp
22:17:06 SYS@lunarc>SELECT NAME,DB_UNIQUE_NAME,DATABASE_ROLE,PROTECTION_MODE, SWITCHOVER_STATUS, OPEN_MODE FROM V$DATABASE;
NAME DB_UNIQUE_NAME DATABASE_ROLE PROTECTION_MODE SWITCHOVER_STATUS OPEN_MODE
--------- ------------------------------ ---------------- -------------------- -------------------- --------------------
LUNAR lunarc PHYSICAL STANDBY MAXIMUM PERFORMANCE TO PRIMARY MOUNTED
Elapsed: 00:00:00.01
22:20:57 SYS@lunarc>archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 35
Next log sequence to archive 0
Current log sequence 39
22:21:10 SYS@lunarc>
============================================================================================================
将C切换为primary:
============================================================================================================
检查C库:
22:24:47 SYS@lunarc> SELECT NAME,DB_UNIQUE_NAME,DATABASE_ROLE,PROTECTION_MODE, SWITCHOVER_STATUS, OPEN_MODE FROM V$DATABASE;
NAME DB_UNIQUE_NAME DATABASE_ROLE PROTECTION_MODE SWITCHOVER_STATUS OPEN_MODE
--------- ------------------------------ ---------------- -------------------- -------------------- --------------------
LUNAR lunarc PHYSICAL STANDBY MAXIMUM PERFORMANCE TO PRIMARY MOUNTED
Elapsed: 00:00:00.04
22:26:26 SYS@lunarc>22:26:26 SYS@lunarc>select max(sequence#),thread# from v$archived_log group by thread#;
MAX(SEQUENCE#) THREAD#
-------------- ----------
39 1
Elapsed: 00:00:00.02
22:26:30 SYS@lunarc>
============================================================================================================
检查A库(已经切换为Standby了):
============================================================================================================
21:52:55 SYS@lunarp>select DATABASE_ROLE,PROTECTION_MODE,PROTECTION_LEVEL from v$database;
DATABASE_ROLE PROTECTION_MODE PROTECTION_LEVEL
---------------- -------------------- --------------------
PHYSICAL STANDBY MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE
Elapsed: 00:00:00.03
21:53:07 SYS@lunarp>select max(sequence#),thread# from v$archived_log group by thread#;
MAX(SEQUENCE#) THREAD#
-------------- ----------
39 1
Elapsed: 00:00:00.04
22:15:18 SYS@lunarp>
============================================================================================================
检查B库(即将被切换为Cascade):
============================================================================================================
SQL> select max(sequence#),thread# from v$archived_log group by thread#;
MAX(SEQUENCE#) THREAD#
-------------- ----------
39 1
SQL> SELECT NAME,DB_UNIQUE_NAME,DATABASE_ROLE,PROTECTION_MODE, SWITCHOVER_STATUS, OPEN_MODE FROM V$DATABASE;
NAME DB_UNIQUE_NAME DATABASE_ROLE PROTECTION_MODE
--------- ------------------------------ ---------------- --------------------
SWITCHOVER_STATUS OPEN_MODE
-------------------- --------------------
LUNAR lunars PHYSICAL STANDBY MAXIMUM PERFORMANCE
NOT ALLOWED MOUNTED
SQL> SQL>
============================================================================================================
切换C为primary:
============================================================================================================
22:26:30 SYS@lunarc>alter database recover managed standby database finish;
Database altered.
Elapsed: 00:00:03.19
22:27:58 SYS@lunarc>select max(sequence#),thread# from v$archived_log group by thread#;
MAX(SEQUENCE#) THREAD#
-------------- ----------
39 1
Elapsed: 00:00:00.01
22:28:16 SYS@lunarc>SELECT NAME,DB_UNIQUE_NAME,DATABASE_ROLE,PROTECTION_MODE, SWITCHOVER_STATUS, OPEN_MODE FROM V$DATABASE;
NAME DB_UNIQUE_NAME DATABASE_ROLE PROTECTION_MODE SWITCHOVER_STATUS OPEN_MODE
--------- ------------------------------ ---------------- -------------------- -------------------- --------------------
LUNAR lunarc PHYSICAL STANDBY MAXIMUM PERFORMANCE TO PRIMARY MOUNTED
Elapsed: 00:00:00.01
22:28:34 SYS@lunarc>22:28:34 SYS@lunarc>ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN;
Database altered.
Elapsed: 00:00:02.75
22:28:52 SYS@lunarc>22:28:52 SYS@lunarc>
测试C库的alert:
Sat Aug 02 22:27:55 2014
alter database recover managed standby database finish
Terminal Recovery: Stopping real time apply
Sat Aug 02 22:27:55 2014
MRP0: Background Media Recovery cancelled with status 16037
Errors in file /u01/app/oracle/diag/rdbms/lunarc/lunarc/trace/lunarc_pr00_19297.trc:
ORA-16037: user requested cancel of managed recovery operation
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!
Sat Aug 02 22:27:55 2014
MRP0: Background Media Recovery process shutdown (lunarc)
Terminal Recovery: Stopped real time apply
Attempt to do a Terminal Recovery (lunarc)
Media Recovery Start: Managed Standby Recovery (lunarc)
started logmerger process
Sat Aug 02 22:27:56 2014
Managed Standby Recovery not using Real Time Apply
Parallel Media Recovery started with 2 slaves
Media Recovery Waiting for thread 1 sequence 40
RECOVER FINISH applied through switchover EOR logs and stopped.
Media Recovery Complete: End-Of-REDO (lunarc)
Attempt to set limbo arscn 0:1362521 irscn 0:1362521
Completed: alter database recover managed standby database finish
Sat Aug 02 22:28:49 2014
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN
ALTER DATABASE SWITCHOVER TO PRIMARY (lunarc)
Maximum wait for role transition is 15 minutes.
krsv_proc_kill: Killing 4 processes (all RFS)
Backup controlfile written to trace file /u01/app/oracle/diag/rdbms/lunarc/lunarc/trace/lunarc_ora_18445.trc
SwitchOver after complete recovery through change 1362521
Online log /tempdisk/lunarc/redo01.log: Thread 1 Group 1 was previously cleared
Online log /tempdisk/lunarc/redo02.log: Thread 1 Group 2 was previously cleared
Online log /tempdisk/lunarc/redo03.log: Thread 1 Group 3 was previously cleared
Standby became primary SCN: 1362519
Switchover: Complete - Database mounted as primary
Completed: ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN
Sat Aug 02 22:29:12 2014
RFS[10]: Assigned to RFS process 19349
RFS[10]: Database mount ID mismatch [0x92fd5f55:0x92fca1ab] (2466078549:2466029995)
RFS[10]: Client instance is standby database instead of primary
RFS[10]: Not using real application clusters
Sat Aug 02 22:29:41 2014
ARC0: Becoming the 'no SRL' ARCH
然后,重启C库:
22:28:52 SYS@lunarc>22:28:52 SYS@lunarc>shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
22:30:35 SYS@lunarc>startup
Welcome Lunar's oracle world!
Love you , baby !
ORACLE instance started.
Total System Global Area 626327552 bytes
Fixed Size 2230952 bytes
Variable Size 184550744 bytes
Database Buffers 432013312 bytes
Redo Buffers 7532544 bytes
Database mounted.
Welcome Lunar's oracle world!
Love you , baby !
Database opened.
此时,C库的日志:
Sat Aug 02 22:30:37 2014
Starting ORACLE instance (normal)
****************** Large Pages Information *****************
Total Shared Global Region in Large Pages = 0 KB (0%)
Large Pages used by this instance: 0 (0 KB)
Large Pages unused system wide = 0 (0 KB) (alloc incr 4096 KB)
Large Pages configured system wide = 0 (0 KB)
Large Page size = 2048 KB
RECOMMENDATION:
Total Shared Global Region size is 602 MB. For optimal performance,
prior to the next instance restart increase the number
of unused Large Pages by atleast 301 2048 KB Large Pages (602 MB)
system wide to get 100% of the Shared
Global Region allocated with Large pages
***********************************************************
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning and Real Application Testing options.
ORACLE_HOME = /u01/app/oracle/product/11.2.0.3/dbhome_1
System name: Linux
Node name: lunar
Release: 2.6.32-300.10.1.el5uek
Version: #1 SMP Wed Feb 22 17:37:40 EST 2012
Machine: x86_64
Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0.3/dbhome_1/dbs/spfilelunarc.ora
System parameters with non-default values:
processes = 150
filesystemio_options = "setall"
sga_target = 600M
control_files = "/tempdisk/lunarc/control01.ctl"
control_files = "/tempdisk/lunarc/control02.ctl"
db_file_name_convert = "/stage/lunar/"
db_file_name_convert = "/tempdisk/lunarc/"
log_file_name_convert = "/stage/lunar/"
log_file_name_convert = "/tempdisk/lunarc/"
db_block_size = 8192
compatible = "11.2.0.3.0"
log_archive_dest_1 = "LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=lunarc"
log_archive_dest_2 = "SERVICE=lunarp LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=lunarp"
log_archive_dest_state_1 = "ENABLE"
log_archive_dest_state_2 = "ENABLE"
log_archive_dest_state_3 = "ENABLE"
fal_client = "lunarc"
fal_server = "lunars"
fal_server = "lunarp"
log_archive_config = "DG_CONFIG=(lunarp,lunars,lunarc)"
db_recovery_file_dest = "/stage/fast_recovery_area"
db_recovery_file_dest_size= 1190198K
standby_file_management = "auto"
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
service_names = "lunar"
audit_file_dest = "/u01/app/oracle/admin/lunarc/adump"
audit_trail = "NONE"
db_name = "lunar"
db_unique_name = "lunarc"
open_cursors = 300
pga_aggregate_target = 146M
deferred_segment_creation= FALSE
sec_return_server_release_banner= FALSE
diagnostic_dest = "/u01/app/oracle"
Sat Aug 02 22:30:38 2014
PMON started with pid=2, OS id=19357
Sat Aug 02 22:30:38 2014
PSP0 started with pid=3, OS id=19359
Sat Aug 02 22:30:39 2014
VKTM started with pid=4, OS id=19361 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Sat Aug 02 22:30:40 2014
GEN0 started with pid=5, OS id=19365
Sat Aug 02 22:30:40 2014
DIAG started with pid=6, OS id=19367
Sat Aug 02 22:30:40 2014
DBRM started with pid=7, OS id=19369
Sat Aug 02 22:30:40 2014
DIA0 started with pid=8, OS id=19371
Sat Aug 02 22:30:40 2014
MMAN started with pid=9, OS id=19373
Sat Aug 02 22:30:40 2014
DBW0 started with pid=10, OS id=19375
Sat Aug 02 22:30:40 2014
LGWR started with pid=11, OS id=19377
Sat Aug 02 22:30:40 2014
CKPT started with pid=12, OS id=19379
Sat Aug 02 22:30:40 2014
SMON started with pid=13, OS id=19381
Sat Aug 02 22:30:40 2014
RECO started with pid=14, OS id=19383
Sat Aug 02 22:30:40 2014
MMON started with pid=15, OS id=19385
Sat Aug 02 22:30:40 2014
MMNL started with pid=16, OS id=19387
ORACLE_BASE from environment = /u01/app/oracle
Sat Aug 02 22:30:40 2014
ALTER DATABASE MOUNT
Sat Aug 02 22:30:45 2014
NSS2 started with pid=18, OS id=19394
Successful mount of redo thread 1, with mount id 2466039952
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Sat Aug 02 22:30:45 2014
ALTER DATABASE OPEN
Assigning activation ID 2466039952 (0x92fcc890)
LGWR: STARTING ARCH PROCESSES
Sat Aug 02 22:30:46 2014
ARC0 started with pid=21, OS id=19401
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Destination LOG_ARCHIVE_DEST_2 is UNSYNCHRONIZED
Sat Aug 02 22:30:47 2014
ARC1 started with pid=19, OS id=19403
Sat Aug 02 22:30:47 2014
ARC2 started with pid=20, OS id=19405
Thread 1 advanced to log sequence 41 (thread open)
Sat Aug 02 22:30:47 2014
ARC3 started with pid=22, OS id=19407
ARC1: Archival started
ARC2: Archival started
ARC2: Becoming the 'no FAL' ARCH
ARC2: Becoming the 'no SRL' ARCH
ARC1: Becoming the heartbeat ARCH
Thread 1 opened at log sequence 41
Current log# 2 seq# 41 mem# 0: /tempdisk/lunarc/redo02.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
SMON: enabling cache recovery
Archived Log entry 33 added for thread 1 sequence 40 ID 0x92fcc890 dest 1:
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Sat Aug 02 22:30:50 2014
Destination LOG_ARCHIVE_DEST_2 is SYNCHRONIZED
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
Destination LOG_ARCHIVE_DEST_2 no longer supports SYNCHRONIZATION
Thread 1 advanced to log sequence 42 (LGWR switch)
Current log# 3 seq# 42 mem# 0: /tempdisk/lunarc/redo03.log
Archived Log entry 35 added for thread 1 sequence 41 ID 0x92fcc890 dest 1:
[19395] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:99886074 end:99887784 diff:1710 (17 seconds)
Dictionary check beginning
Sat Aug 02 22:30:52 2014
Errors in file /u01/app/oracle/diag/rdbms/lunarc/lunarc/trace/lunarc_dbw0_19375.trc:
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/tempdisk/lunarc/temp01.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/lunarc/lunarc/trace/lunarc_dbw0_19375.trc:
ORA-01186: file 201 failed verification tests
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/tempdisk/lunarc/temp01.dbf'
File 201 not verified due to error ORA-01157
Dictionary check complete
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
Sat Aug 02 22:30:52 2014
SMON: enabling tx recovery
Re-creating tempfile /tempdisk/lunarc/temp01.dbf ---重建了temp表空间的数据文件
Database Characterset is AL32UTF8
No Resource Manager plan active
Sat Aug 02 22:30:56 2014
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Sat Aug 02 22:30:58 2014
QMNC started with pid=23, OS id=19421
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete
Completed: ALTER DATABASE OPEN
Sat Aug 02 22:31:05 2014
Starting background process CJQ0
Sat Aug 02 22:31:06 2014
CJQ0 started with pid=25, OS id=19435
Sat Aug 02 22:31:07 2014
db_recovery_file_dest_size of 1162 MB is 33.81% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Sat Aug 02 22:31:47 2014
ARC1: STARTING ARCH PROCESSES
Sat Aug 02 22:31:47 2014
ARC4 started with pid=27, OS id=19445
ARC4: Archival started
ARC1: STARTING ARCH PROCESSES COMPLETE
Shutting down archive processes
ARCH shutting down
ARC4: Archival stopped
切换后的C库(已经切换为primary了):
22:33:15 SYS@lunarc>SELECT SWITCHOVER_STATUS FROM V$DATABASE;
SWITCHOVER_STATUS
--------------------
TO STANDBY
Elapsed: 00:00:00.18
22:33:23 SYS@lunarc> ALTER SYSTEM SWITCH LOGFILE;
System altered.
Elapsed: 00:00:00.26
22:33:31 SYS@lunarc>select DATABASE_ROLE,PROTECTION_MODE,PROTECTION_LEVEL from v$database;
DATABASE_ROLE PROTECTION_MODE PROTECTION_LEVEL
---------------- -------------------- --------------------
PRIMARY MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE
Elapsed: 00:00:00.02
22:33:55 SYS@lunarc>select thread#,max(sequence#) from v$archived_log group by thread#;
THREAD# MAX(SEQUENCE#)
---------- --------------
1 42
Elapsed: 00:00:00.11
22:34:02 SYS@lunarc>
此时A库的日志(已经切换为Standby)了:
Sat Aug 02 22:07:24 2014
db_recovery_file_dest_size of 1162 MB is 13.66% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Sat Aug 02 22:30:48 2014
Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST
Sat Aug 02 22:30:49 2014
RFS[1]: Assigned to RFS process 19415
RFS[1]: Opened log for thread 1 sequence 40 dbid -1830388907 branch 853060791
Archived Log entry 72 added for thread 1 sequence 40 rlc 853060791 ID 0x92fcc890 dest 2:
Sat Aug 02 22:30:50 2014
Primary database is in MAXIMUM PERFORMANCE mode
RFS[2]: Assigned to RFS process 19417
RFS[2]: No standby redo logfiles created
RFS[2]: Opened log for thread 1 sequence 42 dbid -1830388907 branch 853060791
Sat Aug 02 22:30:51 2014
Media Recovery Log /stage/fast_recovery_area/LUNARP/archivelog/2014_08_02/o1_mf_1_40_9xvorstf_.arc
Media Recovery Waiting for thread 1 sequence 41 (in transit)
Sat Aug 02 22:30:51 2014
RFS[3]: Assigned to RFS process 19419
RFS[3]: Opened log for thread 1 sequence 41 dbid -1830388907 branch 853060791
Archived Log entry 73 added for thread 1 sequence 41 rlc 853060791 ID 0x92fcc890 dest 2:
Media Recovery Log /stage/fast_recovery_area/LUNARP/archivelog/2014_08_02/o1_mf_1_41_9xvorvo0_.arc
Media Recovery Waiting for thread 1 sequence 42 (in transit)
Sat Aug 02 22:33:30 2014
Archived Log entry 74 added for thread 1 sequence 42 rlc 853060791 ID 0x92fcc890 dest 2:
RFS[2]: No standby redo logfiles created
RFS[2]: Opened log for thread 1 sequence 43 dbid -1830388907 branch 853060791
Sat Aug 02 22:33:32 2014
Media Recovery Log /stage/fast_recovery_area/LUNARP/archivelog/2014_08_02/o1_mf_1_42_9xvorv1t_.arc
Media Recovery Waiting for thread 1 sequence 43 (in transit)
调整一下A库的fal参数:
22:15:18 SYS@lunarp>show parameter fal
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fal_client string lunarp
fal_server string lunars
22:38:18 SYS@lunarp>alter system set fal_server='lunarc';
System altered.
Elapsed: 00:00:00.08
22:38:44 SYS@lunarp>show parameter fal
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fal_client string lunarp
fal_server string lunarc
22:38:58 SYS@lunarp>
============================================================================================================
5,B库,将被切换为Cascade,此时需要先修改归档参数,取消B到A和B到C的归档
============================================================================================================
SQL> SELECT NAME,DB_UNIQUE_NAME,DATABASE_ROLE,PROTECTION_MODE, SWITCHOVER_STATUS, OPEN_MODE FROM V$DATABASE;
NAME DB_UNIQUE_NAME DATABASE_ROLE PROTECTION_MODE
--------- ------------------------------ ---------------- --------------------
SWITCHOVER_STATUS OPEN_MODE
-------------------- --------------------
LUNAR lunars PHYSICAL STANDBY MAXIMUM PERFORMANCE
NOT ALLOWED MOUNTED
SQL> show parameter log
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_syslog_level string
commit_logging string
db_create_online_log_dest_1 string +DATA
db_create_online_log_dest_2 string
db_create_online_log_dest_3 string
db_create_online_log_dest_4 string
db_create_online_log_dest_5 string
enable_ddl_logging boolean FALSE
log_archive_config string DG_CONFIG=(lunarp,lunars,lunar
c)
log_archive_dest string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1 string LOCATION=USE_DB_RECOVERY_FILE_
DEST VALID_FOR=(ALL_LOGFILES,A
LL_ROLES) DB_UNIQUE_NAME=lunar
s
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
log_archive_dest_2 string SERVICE=lunarp LGWR SYNC AFFIR
M VALID_FOR=(ONLINE_LOGFILES,P
RIMARY_ROLE) DB_UNIQUE_NAME=lu
narp
log_archive_dest_20 string
log_archive_dest_21 string
log_archive_dest_22 string
log_archive_dest_23 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_24 string
log_archive_dest_25 string
log_archive_dest_26 string
log_archive_dest_27 string
log_archive_dest_28 string
log_archive_dest_29 string
log_archive_dest_3 string SERVICE=lunarc LGWR SYNC AFFIR
M VALID_FOR=(STANDBY_LOGFILES,
STANDBY_ROLE) DB_UNIQUE_NAME=l
unarc
log_archive_dest_30 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_31 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string ENABLE
log_archive_dest_state_10 string enable
log_archive_dest_state_11 string enable
log_archive_dest_state_12 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_13 string enable
log_archive_dest_state_14 string enable
log_archive_dest_state_15 string enable
log_archive_dest_state_16 string enable
log_archive_dest_state_17 string enable
log_archive_dest_state_18 string enable
log_archive_dest_state_19 string enable
log_archive_dest_state_2 string ENABLE
log_archive_dest_state_20 string enable
log_archive_dest_state_21 string enable
log_archive_dest_state_22 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_23 string enable
log_archive_dest_state_24 string enable
log_archive_dest_state_25 string enable
log_archive_dest_state_26 string enable
log_archive_dest_state_27 string enable
log_archive_dest_state_28 string enable
log_archive_dest_state_29 string enable
log_archive_dest_state_3 string ENABLE
log_archive_dest_state_30 string enable
log_archive_dest_state_31 string enable
log_archive_dest_state_4 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_format string %t_%s_%r.dbf
log_archive_local_first boolean TRUE
log_archive_max_processes integer 4
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_trace integer 0
log_buffer integer 7176192
log_checkpoint_interval integer 0
log_checkpoint_timeout integer 1800
log_checkpoints_to_alert boolean FALSE
log_file_name_convert string /stage/lunar/, +DATA/lunars/
remote_login_passwordfile string EXCLUSIVE
sec_case_sensitive_logon boolean TRUE
sec_max_failed_login_attempts integer 10
SQL> alter system set log_archive_dest_3='';
System altered.
SQL> alter system set log_archive_dest_state_3=defer;
System altered.
SQL>
日志没有同步完成,需要检查日志的同步情况:
SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;
SWITCHOVER_STATUS
--------------------
NOT ALLOWED
SQL> select max(sequence#),thread# from v$archived_log group by thread#;
MAX(SEQUENCE#) THREAD#
-------------- ----------
39 1
SQL> show parameter fal
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fal_client string lunars
fal_server string lunarp
SQL> alter system set fal_server='lunarp','lunarc';
System altered.
SQL> show parameter fal
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fal_client string lunars
fal_server string lunarp, lunarc
SQL>
============================================================================================================
修改A库(已经切换为Standby了)参数:
============================================================================================================
alter system set log_archive_dest_2='';
alter system set log_archive_dest_3='';
alter system set log_archive_dest_2='SERVICE=lunarc LGWR ASYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=lunarc';
alter system set log_archive_dest_state_2=enable;
alter system set log_archive_dest_3='SERVICE=lunars LGWR ASYNC AFFIRM VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=lunars';
alter system set log_archive_dest_state_3=enable;
如果还有问题,可以执行下面的(本次没等执行,已经好了):
alter system set log_archive_dest_state_2=defer;
alter system set log_archive_dest_state_3=defer;
alter system set log_archive_dest_state_2=enable;
alter system set log_archive_dest_state_3=enable;
此时原来C库的日志(已经从Cascade Standby切换为primart了):
22:59:48 SYS@lunarc>alter system switch logfile;
System altered.
Elapsed: 00:00:00.19
23:06:22 SYS@lunarc>select thread#,max(sequence#) from v$archived_log group by thread#;
THREAD# MAX(SEQUENCE#)
---------- --------------
1 48
Elapsed: 00:00:00.04
23:06:57 SYS@lunarc>select thread#,applied,max(sequence#) from v$archived_log where applied='YES' group by thread#,applied;
THREAD# APPLIED MAX(SEQUENCE#)
---------- --------- --------------
1 YES 48
Elapsed: 00:00:00.05
23:13:00 SYS@lunarc>
日志如下:
Sat Aug 02 22:59:50 2014
Destination LOG_ARCHIVE_DEST_2 is SYNCHRONIZED
Destination LOG_ARCHIVE_DEST_2 no longer supports SYNCHRONIZATION
Thread 1 advanced to log sequence 48 (LGWR switch)
Current log# 3 seq# 48 mem# 0: /tempdisk/lunarc/redo03.log
Sat Aug 02 22:59:51 2014
Archived Log entry 48 added for thread 1 sequence 47 ID 0x92fcc890 dest 1:
Sat Aug 02 23:06:22 2014
Destination LOG_ARCHIVE_DEST_2 is SYNCHRONIZED
Destination LOG_ARCHIVE_DEST_2 no longer supports SYNCHRONIZATION
Thread 1 advanced to log sequence 49 (LGWR switch)
Current log# 1 seq# 49 mem# 0: /tempdisk/lunarc/redo01.log
Sat Aug 02 23:06:23 2014
Archived Log entry 50 added for thread 1 sequence 48 ID 0x92fcc890 dest 1:
此时的A库(已经从Primary切换为Standby了):
23:04:56 SYS@lunarp>select thread#,max(sequence#) from v$archived_log group by thread#;
THREAD# MAX(SEQUENCE#)
---------- --------------
1 48
Elapsed: 00:00:00.06
23:07:00 SYS@lunarp>select thread#,applied,max(sequence#) from v$archived_log where applied='YES' group by thread#,applied;
THREAD# APPLIED MAX(SEQUENCE#)
---------- --------- --------------
1 YES 48
Elapsed: 00:00:00.04
23:12:57 SYS@lunarp>
Sat Aug 02 23:06:22 2014
Archived Log entry 88 added for thread 1 sequence 48 rlc 853060791 ID 0x92fcc890 dest 2:
RFS[2]: No standby redo logfiles created
RFS[2]: Opened log for thread 1 sequence 49 dbid -1830388907 branch 853060791
Sat Aug 02 23:06:27 2014
Media Recovery Log /stage/fast_recovery_area/LUNARP/archivelog/2014_08_02/o1_mf_1_48_9xvqh6hl_.arc
Media Recovery Waiting for thread 1 sequence 49 (in transit)
此时的B库(已经切换为Standby 切换为Cascade Standby了)
SQL> select thread#,max(sequence#) from v$archived_log group by thread#;
THREAD# MAX(SEQUENCE#)
---------- --------------
1 48
SQL> recover managed standby database cancel;
ORA-16136: Managed Standby Recovery not active
SQL> alter database recover managed standby database using current logfile disconnect from session;
Database altered.
SQL>
SQL> select thread#,applied,max(sequence#) from v$archived_log where applied='YES' group by thread#,applied;
THREAD# APPLIED MAX(SEQUENCE#)
---------- --------- --------------
1 YES 48
SQL>
Sun Aug 03 07:06:34 2014
RFS[8]: Opened log for thread 1 sequence 48 dbid -1830388907 branch 853060791
Archived Log entry 75 added for thread 1 sequence 48 rlc 853060791 ID 0x92fcc890 dest 3:
Sun Aug 03 07:11:34 2014
ALTER DATABASE RECOVER managed standby database cancel
ORA-16136 signalled during: ALTER DATABASE RECOVER managed standby database cancel ...
Sun Aug 03 07:11:45 2014
alter database recover managed standby database using current logfile disconnect from session
Attempt to start background Managed Standby Recovery process (lunars)
Sun Aug 03 07:11:45 2014
MRP0 started with pid=34, OS id=20717
MRP0: Background Managed Standby Recovery process started (lunars)
started logmerger process
Sun Aug 03 07:11:50 2014
Managed Standby Recovery starting Real Time Apply
Parallel Media Recovery started with 2 slaves
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Media Recovery Log /stage/fast_recovery_area/LUNARS/archivelog/2014_08_02/o1_mf_1_31_9xsv85l5_.arc
Completed: alter database recover managed standby database using current logfile disconnect from session
Media Recovery Log /stage/fast_recovery_area/LUNARS/archivelog/2014_08_02/o1_mf_1_32_9xsv879v_.arc
Media Recovery Log /stage/fast_recovery_area/LUNARS/archivelog/2014_08_03/o1_mf_1_33_9xto475l_.arc
Media Recovery Log /stage/fast_recovery_area/LUNARS/archivelog/2014_08_03/o1_mf_1_34_9xto4q5w_.arc
Sun Aug 03 07:12:01 2014
Media Recovery Log /stage/fast_recovery_area/LUNARS/archivelog/2014_08_03/o1_mf_1_35_9xtp69j7_.arc
Media Recovery Log /stage/fast_recovery_area/LUNARS/archivelog/2014_08_03/o1_mf_1_36_9xtpvoj1_.arc
Media Recovery Log /stage/fast_recovery_area/LUNARS/archivelog/2014_08_03/o1_mf_1_37_9xtq4hwb_.arc
Media Recovery Log /stage/fast_recovery_area/LUNARS/archivelog/2014_08_03/o1_mf_1_38_9xtqb2lp_.arc
Media Recovery Log /stage/fast_recovery_area/LUNARS/archivelog/2014_08_03/o1_mf_1_39_9xtqb7l9_.arc
Identified End-Of-Redo (switchover) for thread 1 sequence 39 at SCN 0x0.14ca59
Resetting standby activation ID 2464533536 (0x92e5cc20)
Media Recovery End-Of-Redo indicator encountered
Media Recovery Continuing
Media Recovery Log /stage/fast_recovery_area/LUNARS/archivelog/2014_08_03/o1_mf_1_40_9xtvowds_.arc
Media Recovery Log /stage/fast_recovery_area/LUNARS/archivelog/2014_08_03/o1_mf_1_41_9xtvowk2_.arc
Media Recovery Log /stage/fast_recovery_area/LUNARS/archivelog/2014_08_03/o1_mf_1_42_9xtvow7w_.arc
Media Recovery Log /stage/fast_recovery_area/LUNARS/archivelog/2014_08_03/o1_mf_1_43_9xtvowj5_.arc
Media Recovery Log /stage/fast_recovery_area/LUNARS/archivelog/2014_08_03/o1_mf_1_44_9xtvownm_.arc
Media Recovery Log /stage/fast_recovery_area/LUNARS/archivelog/2014_08_03/o1_mf_1_45_9xtvowop_.arc
Media Recovery Log /stage/fast_recovery_area/LUNARS/archivelog/2014_08_03/o1_mf_1_46_9xtvowqg_.arc
Media Recovery Log /stage/fast_recovery_area/LUNARS/archivelog/2014_08_03/o1_mf_1_47_9xtvowtt_.arc
Media Recovery Log /stage/fast_recovery_area/LUNARS/archivelog/2014_08_03/o1_mf_1_48_9xtvqtdm_.arc
Media Recovery Waiting for thread 1 sequence 49