参考文章 http://rocolex.blog.163.com/blog/static/684464102009112233537535/
SYS@primary/01-JAN-02>@standby_detail.sql
NAME UNIQUE OPEN_MODE FORCE ROLE LOG_MODE SWITCHOVER_STATUS MODE LEVEL
-------- -------- ---------- ----- -------- ---------- ------------------ ----- -----
ORCL orcl_1 READ WRITE YES PRIMARY ARCHIVELOG TO STANDBY AVAI
1 row selected.
Elapsed: 00:00:00.00
SYS@primary/01-JAN-02>SELECT COUNT(*) FROM V$SESSION WHERE USERNAME IS NOT NULL;
COUNT(*)
----------
1
1 row selected.
Elapsed: 00:00:00.03
SYS@primary/01-JAN-02>alter database commit to switchover to physical standby;
Database altered.
Elapsed: 00:00:35.37
SYS@standby1/2002-01-01 01:00:38>@standby_detail.sql
NAME UNIQUE OPEN_MODE FORCE ROLE LOG_MODE SWITCHOVER_STATUS MODE LEVEL
-------- -------- ---------- ----- -------- ---------- ------------------ ----- -----
ORCL orcl_2 READ ONLY YES PHYSICAL ARCHIVELOG NOT ALLOWED PER PER
WITH APPLY
1 row selected.
Elapsed: 00:00:00.00
SYS@standby1/2002-01-01 01:00:42>@standby_detail.sql
NAME UNIQUE OPEN_MODE FORCE ROLE LOG_MODE SWITCHOVER_STATUS MODE LEVEL
-------- -------- ---------- ----- -------- ---------- ------------------ ----- -----
ORCL orcl_2 READ ONLY YES PHYSICAL ARCHIVELOG TO PRIMARY PER PER
1 row selected.
Elapsed: 00:00:00.01
SYS@standby1/2002-01-01 01:03:44>alter database commit to switchover to primary;
Database altered.
Elapsed: 00:00:08.29
SYS@standby1/2002-01-01 01:04:30>@standby_detail.sql
NAME UNIQUE OPEN_MODE FORCE ROLE LOG_MODE SWITCHOVER_STATUS MODE LEVEL
-------- -------- ---------- ----- -------- ---------- ------------------ ----- -----
ORCL orcl_2 MOUNTED YES PRIMARY ARCHIVELOG NOT ALLOWED PER
1 row selected.
Elapsed: 00:00:00.01
SYS@primary/01-JAN-02>startup force
ORACLE instance started.
Total System Global Area 376635392 bytes
Fixed Size 1336652 bytes
Variable Size 327158452 bytes
Database Buffers 41943040 bytes
Redo Buffers 6197248 bytes
Database mounted.
Database opened.
SYS@primary/01-JAN-02>@standby_detail.sql
NAME UNIQUE OPEN_MODE FORCE ROLE LOG_MODE SWITCHOVER_STATUS MODE LEVEL
-------- -------- ---------- ----- -------- ---------- ------------------ ----- -----
ORCL orcl_1 READ ONLY YES PHYSICAL ARCHIVELOG TO PRIMARY AVAI AVAI
1 row selected.
Elapsed: 00:00:00.04
SYS@standby1/2002-01-01 01:13:24>alter database open;
Database altered.
Elapsed: 00:00:03.77
SYS@standby1/2002-01-01 01:13:36>@standby_detail.sql
NAME UNIQUE OPEN_MODE FORCE ROLE LOG_MODE SWITCHOVER_STATUS MODE LEVEL
-------- -------- ---------- ----- -------- ---------- ------------------ ----- -----
ORCL orcl_2 READ WRITE YES PRIMARY ARCHIVELOG TO STANDBY PER PER
1 row selected.
Elapsed: 00:00:00.01
SYS@standby1/2002-01-01 01:10:58>@log_file.sql
FILE TYPE GROUP SEQ SIZE MEM ARC ST
------------------------------------------------------------ ---------- ----- ---- ------ --- --- ----------
/boot/u03/oradata/ORCL_2/onlinelog/o1_mf_1_6sxqh2c1_.log ONLINE 1 143 512 3 NO CURRENT
/boot/u02/oradata/ORCL_2/onlinelog/o1_mf_1_6sxqh23t_.log ONLINE 1 143 512 3 NO CURRENT
/boot/u04/oradata/ORCL_2/onlinelog/o1_mf_1_6sxqh3nm_.log ONLINE 1 143 512 3 NO CURRENT
/boot/u02/oradata/ORCL_2/onlinelog/o1_mf_2_6sxqh5wx_.log ONLINE 2 0 512 3 YES UNUSED
/boot/u03/oradata/ORCL_2/onlinelog/o1_mf_2_6sxqh6b7_.log ONLINE 2 0 512 3 YES UNUSED
/boot/u04/oradata/ORCL_2/onlinelog/o1_mf_2_6sxqh8mn_.log ONLINE 2 0 512 3 YES UNUSED
/boot/u03/oradata/ORCL_2/onlinelog/o1_mf_3_6sxsc80d_.log ONLINE 3 0 512 3 YES UNUSED
/boot/u02/oradata/ORCL_2/onlinelog/o1_mf_3_6sxsc7m7_.log ONLINE 3 0 512 3 YES UNUSED
/boot/u04/oradata/ORCL_2/onlinelog/o1_mf_3_6sxscb5g_.log ONLINE 3 0 512 3 YES UNUSED
9 rows selected.
Elapsed: 00:00:00.00
SYS@standby1/2002-01-01 01:11:04>@managed_standby.sql
ST PROCE PID CLI_P CLIENT_DBID GROUP RESETLOG_ID THR SEQUENCE BLOCK BLOCKS
--------------- ----- ------ ----- ------------ ----- ----------- ---- -------- ------- -------
CLOSING ARCH 5014 ARCH 1275488545 4 747684876 1 141 1 29
CLOSING ARCH 5016 ARCH 1275488545 4 747684876 1 137 1 1482
CONNECTED ARCH 5018 ARCH 1275488545 N/A 0 0 0 0 0
CLOSING ARCH 5020 ARCH 1275488545 4 747684876 1 140 1 202
4 rows selected.
Elapsed: 00:00:00.01
SYS@standby1/2002-01-01 01:11:35>@archive_dest_status.sql
ID ST ARC_THR ARC_SEQ UNIQUE DESTINATION APP_THR APP_SEQ GAP_STATUS ERROR
---- ----- ------- ------- -------- -------------------- ------- ------- ---------- --------------------
1 VALID 1 141 NONE /boot/u02/oradata/OR 0 0
CL_2/archivelog
2 VALID 1 141 NONE /boot/u03/oradata/OR 0 0
CL_2/archivelog
3 VALID 1 141 NONE /boot/u04/oradata/OR 0 0
CL_2/archivelog
4 VALID 0 0 orcl_1 primary 0 0
4 rows selected.
Elapsed: 00:00:00.01
SYS@standby1/2002-01-01 01:13:38>alter system switch logfile;
System altered.
Elapsed: 00:00:00.55
SYS@standby1/2002-01-01 01:14:38>@log_file.sql
FILE TYPE GROUP SEQ SIZE MEM ARC ST
------------------------------------------------------------ ---------- ----- ---- ------ --- --- ----------
/boot/u02/oradata/ORCL_2/onlinelog/o1_mf_1_6sxqh23t_.log ONLINE 1 143 512 3 NO ACTIVE
/boot/u03/oradata/ORCL_2/onlinelog/o1_mf_1_6sxqh2c1_.log ONLINE 1 143 512 3 NO ACTIVE
/boot/u04/oradata/ORCL_2/onlinelog/o1_mf_1_6sxqh3nm_.log ONLINE 1 143 512 3 NO ACTIVE
/boot/u02/oradata/ORCL_2/onlinelog/o1_mf_2_6sxqh5wx_.log ONLINE 2 144 512 3 NO CURRENT
/boot/u03/oradata/ORCL_2/onlinelog/o1_mf_2_6sxqh6b7_.log ONLINE 2 144 512 3 NO CURRENT
/boot/u04/oradata/ORCL_2/onlinelog/o1_mf_2_6sxqh8mn_.log ONLINE 2 144 512 3 NO CURRENT
/boot/u02/oradata/ORCL_2/onlinelog/o1_mf_3_6sxsc7m7_.log ONLINE 3 0 512 3 YES UNUSED
/boot/u03/oradata/ORCL_2/onlinelog/o1_mf_3_6sxsc80d_.log ONLINE 3 0 512 3 YES UNUSED
/boot/u04/oradata/ORCL_2/onlinelog/o1_mf_3_6sxscb5g_.log ONLINE 3 0 512 3 YES UNUSED
9 rows selected.
Elapsed: 00:00:00.02
SYS@primary/01-JAN-02>@log_file.sql
FILE TYPE GROUP SEQ SIZE MEM ARC ST
------------------------------------------------------------ ---------- ----- ---- ------ --- --- ----------
/boot/u02/oradata/ORCL_1/onlinelog/o1_mf_1_6soypgvj_.log ONLINE 1 143 512 3 YES CLEARING
/boot/u03/oradata/ORCL_1/onlinelog/o1_mf_1_6soyph3t_.log ONLINE 1 143 512 3 YES CLEARING
/boot/u04/oradata/ORCL_1/onlinelog/o1_mf_1_6soypjgh_.log ONLINE 1 143 512 3 YES CLEARING
/boot/u02/oradata/ORCL_1/onlinelog/o1_mf_2_6sovhfc8_.log ONLINE 2 144 512 3 YES CLEARING_C
URRENT
/boot/u03/oradata/ORCL_1/onlinelog/o1_mf_2_6sovhfrz_.log ONLINE 2 144 512 3 YES CLEARING_C
URRENT
/boot/u04/oradata/ORCL_1/onlinelog/o1_mf_2_6sovhhr0_.log ONLINE 2 144 512 3 YES CLEARING_C
URRENT
/boot/u02/oradata/ORCL_1/onlinelog/o1_mf_3_6sxxhvhc_.log ONLINE 3 141 512 3 YES INACTIVE
/boot/u03/oradata/ORCL_1/onlinelog/o1_mf_3_6sxxhvtq_.log ONLINE 3 141 512 3 YES INACTIVE
/boot/u04/oradata/ORCL_1/onlinelog/o1_mf_3_6sxxhxw4_.log ONLINE 3 141 512 3 YES INACTIVE
9 rows selected.
Elapsed: 00:00:00.04
SYS@standby1/2002-01-01 01:17:24>show parameter log_archive_dest_4
NAME TYPE VALUE
------------------------------------ ---------- ------------------------------
log_archive_dest_4 string SERVICE=primary ARCH VALID_FOR
=(ONLINE_LOGFILE,PRIMARY_ROLE)
DB_UNIQUE_NAME=orcl_1
SYS@primary/01-JAN-02>@dataguard_status.sql
FACILITY MESSAGE SEVER TIMESTAMP CALLO
------------------------- ---------------------------------------- ----- -------------------- -----
Log Transport Services ARC0: Archival started infor 01-JAN-02 NO
Log Transport Services ARC1: Archival started infor 01-JAN-02 NO
Log Transport Services ARC2: Archival started infor 01-JAN-02 NO
Log Transport Services ARC1: Becoming the 'no FAL' ARCH infor 01-JAN-02 NO
Log Transport Services ARC1: Becoming the 'no SRL' ARCH infor 01-JAN-02 NO
Log Transport Services ARC2: Becoming the heartbeat ARCH infor 01-JAN-02 NO
Log Transport Services ARC3: Archival started infor 01-JAN-02 NO
Remote File Server RFS[1]: Assigned to RFS process 31672 infor 01-JAN-02 NO
Remote File Server RFS[1]: Identified database type as 'phy infor 01-JAN-02 NO
sical standby': Client is ARCH pid 5018
Remote File Server RFS[2]: Assigned to RFS process 10835 infor 01-JAN-02 NO
Remote File Server RFS[2]: Identified database type as 'phy infor 01-JAN-02 NO
sical standby': Client is ARCH pid 5014
Log Transport Services ARC3: Beginning to archive thread 1 sequ contr 01-JAN-02 YES
ence 143 (862018-862112)
Log Transport Services ARC3: Completed archiving thread 1 seque contr 01-JAN-02 YES
nce 143 (0-0)
Log Apply Services Attempt to start background Managed Stan contr 01-JAN-02 YES
dby Recovery process
Log Apply Services MRP0: Background Managed Standby Recover contr 01-JAN-02 YES
y process started
Log Apply Services Managed Standby Recovery not using Real infor 01-JAN-02 NO
Time Apply
Log Apply Services Clearing online redo logfile 1 /boot/u02 infor 01-JAN-02 NO
/oradata/ORCL_1/onlinelog/o1_mf_1_6soypg
vj_.log
Log Apply Services Clearing online redo logfile 1 complete infor 01-JAN-02 NO
Log Apply Services Clearing online redo logfile 2 /boot/u02 infor 01-JAN-02 NO
/oradata/ORCL_1/onlinelog/o1_mf_2_6sovhf
c8_.log
Log Apply Services Clearing online redo logfile 2 complete infor 01-JAN-02 NO
Log Apply Services Clearing online redo logfile 3 /boot/u02 infor 01-JAN-02 NO
/oradata/ORCL_1/onlinelog/o1_mf_3_6sxxhv
hc_.log
Log Apply Services Clearing online redo logfile 3 complete infor 01-JAN-02 NO
Log Apply Services Media Recovery Log /boot/u04/oradata/1_1 infor 01-JAN-02 NO
43_747684876.dbf
Log Apply Services Media Recovery Waiting for thread 1 sequ Warni 01-JAN-02 NO
ence 144 ng
24 rows selected.
SYS@standby1/2002-01-01 01:17:28>@dataguard_status.sql
FACILITY MESSAGE SEVER TIMESTAMP CALLO
------------------------- ---------------------------------------- ----- -------------------- -----
Log Transport Services ARC0: Archival started infor 2002-01-01 00:32:29 NO
Log Transport Services ARC1: Archival started infor 2002-01-01 00:32:29 NO
Log Transport Services ARC2: Archival started infor 2002-01-01 00:32:29 NO
Log Transport Services ARC1: Becoming the 'no FAL' ARCH infor 2002-01-01 00:32:29 NO
Log Transport Services ARC2: Becoming the heartbeat ARCH infor 2002-01-01 00:32:29 NO
Log Transport Services Error 1034 received logging on to the st Error 2002-01-01 00:32:29 YES
andby
Log Transport Services FAL[client, ARC2]: Error 1034 connecting Error 2002-01-01 00:32:29 YES
to primary for fetching gap sequence
Log Transport Services ARC3: Archival started infor 2002-01-01 00:32:30 NO
Remote File Server RFS[1]: Assigned to RFS process 5282 infor 2002-01-01 00:34:38 NO
Remote File Server RFS[1]: Identified database type as 'phy infor 2002-01-01 00:34:38 NO
sical standby': Client is ARCH pid 5254
Remote File Server RFS[2]: Assigned to RFS process 5284 infor 2002-01-01 00:34:39 NO
Remote File Server RFS[2]: Identified database type as 'phy infor 2002-01-01 00:34:39 NO
sical standby': Client is ARCH pid 5258
Log Transport Services ARC3: Beginning to archive thread 1 sequ contr 2002-01-01 00:34:39 YES
ence 135 (858261-860186)
Log Transport Services ARC3: Completed archiving thread 1 seque contr 2002-01-01 00:34:40 YES
nce 135 (0-0)
Log Transport Services ARC0: Beginning to archive thread 1 sequ contr 2002-01-01 00:34:41 YES
ence 136 (860186-860236)
Log Transport Services ARC0: Completed archiving thread 1 seque contr 2002-01-01 00:34:41 YES
nce 136 (0-0)
Remote File Server RFS[3]: Assigned to RFS process 5647 infor 2002-01-01 00:58:43 NO
Remote File Server RFS[3]: Identified database type as 'phy infor 2002-01-01 00:58:43 NO
sical standby': Client is ARCH pid 5635
Log Transport Services ARC1: Beginning to archive thread 1 sequ contr 2002-01-01 00:58:44 YES
ence 137 (860236-861633)
Log Transport Services ARC1: Completed archiving thread 1 seque contr 2002-01-01 00:58:44 YES
nce 137 (0-0)
Log Transport Services ARC3: Beginning to archive thread 1 sequ contr 2002-01-01 00:58:47 YES
ence 138 (861633-861672)
Log Transport Services ARC3: Completed archiving thread 1 seque contr 2002-01-01 00:58:48 YES
nce 138 (0-0)
Remote File Server RFS[4]: Assigned to RFS process 5708 infor 2002-01-01 00:59:33 NO
Remote File Server RFS[4]: Identified database type as 'phy infor 2002-01-01 00:59:33 NO
sical standby': Client is ARCH pid 5630
Log Transport Services ARC0: Beginning to archive thread 1 sequ contr 2002-01-01 00:59:34 YES
ence 139 (861672-861759)
Log Transport Services ARC0: Completed archiving thread 1 seque contr 2002-01-01 00:59:34 YES
nce 139 (0-0)
Log Apply Services Attempt to start background Managed Stan contr 2002-01-01 01:00:32 YES
dby Recovery process
Log Apply Services MRP0: Background Managed Standby Recover contr 2002-01-01 01:00:32 YES
y process started
Log Apply Services Managed Standby Recovery not using Real infor 2002-01-01 01:00:37 NO
Time Apply
Log Apply Services Media Recovery Log /boot/u04/oradata/ORC infor 2002-01-01 01:00:37 NO
L_2/archivelog/1_135_747684876.dbf
Log Apply Services Media Recovery Log /boot/u04/oradata/ORC infor 2002-01-01 01:00:37 NO
L_2/archivelog/1_136_747684876.dbf
Log Apply Services Media Recovery Log /boot/u04/oradata/ORC infor 2002-01-01 01:00:37 NO
L_2/archivelog/1_137_747684876.dbf
Log Apply Services Media Recovery Log /boot/u04/oradata/ORC infor 2002-01-01 01:00:37 NO
L_2/archivelog/1_138_747684876.dbf
FACILITY MESSAGE SEVER TIMESTAMP CALLO
------------------------- ---------------------------------------- ----- -------------------- -----
Log Apply Services Media Recovery Log /boot/u04/oradata/ORC infor 2002-01-01 01:00:38 NO
L_2/archivelog/1_139_747684876.dbf
Log Apply Services Media Recovery Waiting for thread 1 sequ Warni 2002-01-01 01:00:38 NO
ence 140 ng
Log Transport Services ARC3: Beginning to archive thread 1 sequ contr 2002-01-01 01:02:55 YES
ence 140 (861759-861967)
Log Transport Services ARC3: Completed archiving thread 1 seque contr 2002-01-01 01:02:55 YES
nce 140 (0-0)
Log Apply Services Media Recovery Log /boot/u04/oradata/ORC infor 2002-01-01 01:02:59 NO
L_2/archivelog/1_140_747684876.dbf
Log Apply Services Media Recovery Waiting for thread 1 sequ Warni 2002-01-01 01:02:59 NO
ence 141 ng
Remote File Server RFS[5]: Assigned to RFS process 5801 infor 2002-01-01 01:03:03 NO
Remote File Server RFS[5]: Identified database type as 'phy infor 2002-01-01 01:03:03 NO
sical standby': Client is ARCH pid 5635
Remote File Server RFS[6]: Assigned to RFS process 5822 infor 2002-01-01 01:03:14 NO
Remote File Server RFS[6]: Identified database type as 'phy infor 2002-01-01 01:03:14 NO
sical standby': Client is Foreground pid
5619
Log Transport Services ARC0: Beginning to archive thread 1 sequ contr 2002-01-01 01:03:14 YES
ence 141 (861967-862001)
Log Transport Services ARC0: Completed archiving thread 1 seque contr 2002-01-01 01:03:14 YES
nce 141 (0-0)
Remote File Server RFS[7]: Assigned to RFS process 5839 infor 2002-01-01 01:03:16 NO
Remote File Server RFS[7]: Identified database type as 'phy infor 2002-01-01 01:03:16 NO
sical standby': Client is Foreground pid
5619
Remote File Server RFS[8]: Assigned to RFS process 5841 infor 2002-01-01 01:03:17 NO
Remote File Server RFS[8]: Identified database type as 'phy infor 2002-01-01 01:03:17 NO
sical standby': Client is Foreground pid
5619
Log Apply Services Media Recovery Log /boot/u04/oradata/ORC infor 2002-01-01 01:03:19 NO
L_2/archivelog/1_141_747684876.dbf
Log Apply Services Media Recovery Log /boot/u02/oradata/ORC infor 2002-01-01 01:03:19 NO
L_2/archivelog/1_142_747684876.dbf
Log Apply Services Resetting standby activation ID 12754160 infor 2002-01-01 01:03:19 NO
75 (0x4c054e0b)
Log Apply Services MRP0: Media Recovery Complete: End-Of-RE contr 2002-01-01 01:03:19 YES
DO
Log Apply Services MRP0: Background Media Recovery process contr 2002-01-01 01:03:19 YES
shutdown
Role Management Services ALTER DATABASE SWITCHOVER TO PRIMARY contr 2002-01-01 01:04:22 YES
Log Transport Services ARC1: Becoming the 'no SRL' ARCH infor 2002-01-01 01:04:30 NO
Log Transport Services ARC4: Archival started infor 2002-01-01 01:14:30 NO
Log Transport Services ARC3: Beginning to archive thread 1 sequ contr 2002-01-01 01:14:41 YES
ence 143 (862018-862112)
Log Transport Services ARC3: Completed archiving thread 1 seque contr 2002-01-01 01:14:45 YES
nce 143 (862018-862112)
Log Transport Services ARC0: Standby redo logfile selected for Warni 2002-01-01 01:14:52 NO
thread 1 sequence 143 for destination LO ng
G_ARCHIVE_DEST_4
Log Transport Services ARCH shutting down infor 2002-01-01 01:15:30 NO
Log Transport Services ARC4: Archival stopped infor 2002-01-01 01:15:30 NO
62 rows selected.
Elapsed: 00:00:00.03
SYS@standby2/01-JAN-02>@dataguard_status.sql
FACILITY MESSAGE SEVER TIMESTAMP CALLO
------------------------- ---------------------------------------- ----- -------------------- -----
Log Transport Services ARC0: Archival started infor 01-JAN-02 NO
Log Transport Services ARC1: Archival started infor 01-JAN-02 NO
Log Transport Services ARC2: Archival started infor 01-JAN-02 NO
Log Transport Services ARC1: Becoming the 'no FAL' ARCH infor 01-JAN-02 NO
Log Transport Services ARC2: Becoming the heartbeat ARCH infor 01-JAN-02 NO
Log Transport Services ARC3: Archival started infor 01-JAN-02 NO
6 rows selected.
Elapsed: 00:00:00.00
SYS@standby2/01-JAN-02>@standby_detail.sql
NAME UNIQUE OPEN_MODE FORCE ROLE LOG_MODE SWITCHOVER_STATUS MODE LEVEL
-------- -------- ---------- ----- -------- ---------- ------------------ ----- -----
ORCL orcl_3 READ ONLY YES PHYSICAL ARCHIVELOG TO PRIMARY PER PER
1 row selected.
Elapsed: 00:00:00.00
SYS@standby1/2002-01-01 01:44:37>@standby_detail.sql
NAME UNIQUE OPEN_MODE FORCE ROLE LOG_MODE SWITCHOVER_STATUS MODE LEVEL
-------- -------- ---------- ----- -------- ---------- ------------------ ----- -----
ORCL orcl_2 READ WRITE YES PRIMARY ARCHIVELOG TO STANDBY PER PER
1 row selected.
Elapsed: 00:00:00.02
SYS@standby1/2002-01-01 01:46:10>alter database commit to switchover to physical standby;
Database altered.
Elapsed: 00:00:22.07
SYS@primary/01-JAN-02>@standby_detail.sql
NAME UNIQUE OPEN_MODE FORCE ROLE LOG_MODE SWITCHOVER_STATUS MODE LEVEL
-------- -------- ---------- ----- -------- ---------- ------------------ ----- -----
ORCL orcl_1 READ ONLY YES PHYSICAL ARCHIVELOG NOT ALLOWED AVAI AVAI
WITH APPLY
1 row selected.
Elapsed: 00:00:00.00
SYS@primary/01-JAN-02>@standby_detail.sql
NAME UNIQUE OPEN_MODE FORCE ROLE LOG_MODE SWITCHOVER_STATUS MODE LEVEL
-------- -------- ---------- ----- -------- ---------- ------------------ ----- -----
ORCL orcl_1 READ ONLY YES PHYSICAL ARCHIVELOG TO PRIMARY AVAI AVAI
1 row selected.
Elapsed: 00:00:00.00
SYS@primary/01-JAN-02>alter database commit to switchover to primary;
Database altered.
Elapsed: 00:00:00.10
SYS@primary/01-JAN-02>@standby_detail.sql
NAME UNIQUE OPEN_MODE FORCE ROLE LOG_MODE SWITCHOVER_STATUS MODE LEVEL
-------- -------- ---------- ----- -------- ---------- ------------------ ----- -----
ORCL orcl_1 MOUNTED YES PRIMARY ARCHIVELOG NOT ALLOWED AVAI
1 row selected.
Elapsed: 00:00:00.02
SYS@standby1/2002-01-01 01:48:36>startup force
ORACLE instance started.
Total System Global Area 376635392 bytes
Fixed Size 1336652 bytes
Variable Size 310381236 bytes
Database Buffers 58720256 bytes
Redo Buffers 6197248 bytes
Database mounted.
Database opened.
SYS@standby1/01-JAN-02>@standby_detail.sql
NAME UNIQUE OPEN_MODE FORCE ROLE LOG_MODE SWITCHOVER_STATUS MODE LEVEL
-------- -------- ---------- ----- -------- ---------- ------------------ ----- -----
ORCL orcl_2 READ ONLY YES PHYSICAL ARCHIVELOG TO PRIMARY PER PER
1 row selected.
Elapsed: 00:00:00.26
SYS@primary/01-JAN-02>@standby_detail.sql
NAME UNIQUE OPEN_MODE FORCE ROLE LOG_MODE SWITCHOVER_STATUS MODE LEVEL
-------- -------- ---------- ----- -------- ---------- ------------------ ----- -----
ORCL orcl_1 MOUNTED YES PRIMARY ARCHIVELOG NOT ALLOWED AVAI
1 row selected.
Elapsed: 00:00:00.02
SYS@primary/01-JAN-02>alter database open;
Database altered.
Elapsed: 00:00:13.28
SYS@primary/01-JAN-02>@standby_detail.sql
NAME UNIQUE OPEN_MODE FORCE ROLE LOG_MODE SWITCHOVER_STATUS MODE LEVEL
-------- -------- ---------- ----- -------- ---------- ------------------ ----- -----
ORCL orcl_1 READ WRITE YES PRIMARY ARCHIVELOG TO STANDBY AVAI
1 row selected.
Elapsed: 00:00:00.08
SYS@primary/01-JAN-02>
SYS@standby2/01-JAN-02>recover managed standby database disconnect;
Media recovery complete.
SYS@standby2/01-JAN-02>@dataguard_status.sql
FACILITY MESSAGE SEVER TIMESTAMP CALLO
------------------------- ---------------------------------------- ----- -------------------- -----
Log Transport Services ARC0: Archival started infor 01-JAN-02 NO
Log Transport Services ARC1: Archival started infor 01-JAN-02 NO
Log Transport Services ARC2: Archival started infor 01-JAN-02 NO
Log Transport Services ARC1: Becoming the 'no FAL' ARCH infor 01-JAN-02 NO
Log Transport Services ARC2: Becoming the heartbeat ARCH infor 01-JAN-02 NO
Log Transport Services ARC3: Archival started infor 01-JAN-02 NO
Remote File Server RFS[1]: Assigned to RFS process 18934 infor 01-JAN-02 NO
Remote File Server RFS[1]: Identified database type as 'phy infor 01-JAN-02 NO
sical standby': Client is ARCH pid 6228
Remote File Server RFS[2]: Assigned to RFS process 18952 infor 01-JAN-02 NO
Remote File Server RFS[2]: Identified database type as 'phy infor 01-JAN-02 NO
sical standby': Client is LGWR ASYNC pid
18932
Remote File Server Primary database is in MAXIMUM PERFORMAN infor 01-JAN-02 NO
CE mode
Remote File Server RFS[3]: Assigned to RFS process 18956 infor 01-JAN-02 NO
Remote File Server RFS[3]: Identified database type as 'phy infor 01-JAN-02 NO
sical standby': Client is ARCH pid 6222
Remote File Server RFS[4]: Assigned to RFS process 18969 infor 01-JAN-02 NO
Remote File Server RFS[4]: Identified database type as 'phy infor 01-JAN-02 NO
sical standby': Client is ARCH pid 6228
Log Transport Services ARC3: Beginning to archive thread 1 sequ contr 01-JAN-02 YES
ence 147 (862951-862980)
Log Transport Services ARC0: Beginning to archive thread 1 sequ contr 01-JAN-02 YES
ence 146 (862948-862951)
Remote File Server RFS[5]: Assigned to RFS process 18975 infor 01-JAN-02 NO
Remote File Server RFS[5]: Identified database type as 'phy infor 01-JAN-02 NO
sical standby': Client is ARCH pid 6230
Log Transport Services ARC3: Completed archiving thread 1 seque contr 01-JAN-02 YES
nce 147 (0-0)
Log Transport Services ARC0: Completed archiving thread 1 seque contr 01-JAN-02 YES
nce 146 (0-0)
Log Apply Services Attempt to start background Managed Stan contr 01-JAN-02 YES
dby Recovery process
Log Apply Services MRP0: Background Managed Standby Recover contr 01-JAN-02 YES
y process started
Log Apply Services Managed Standby Recovery not using Real infor 01-JAN-02 NO
Time Apply
Log Apply Services Media Recovery Log /boot/u02/oradata/ORC infor 01-JAN-02 NO
L_3/archivelog/1_143_747684876.dbf
Log Apply Services Media Recovery Log /boot/u02/oradata/ORC infor 01-JAN-02 NO
L_3/archivelog/1_144_747684876.dbf
Log Apply Services Media Recovery Log /boot/u02/oradata/ORC infor 01-JAN-02 NO
L_3/archivelog/1_145_747684876.dbf
Log Apply Services Resetting standby activation ID 97781634 infor 01-JAN-02 NO
5 (0x3a484b19)
Log Apply Services Media Recovery archivelogs detected beyo Warni 01-JAN-02 NO
nd End-Of-REDO ng
Log Apply Services MRP0: Media Recovery Complete: End-Of-RE contr 01-JAN-02 YES
DO
Log Apply Services MRP0: Background Media Recovery process contr 01-JAN-02 YES
shutdown
31 rows selected.
Elapsed: 00:00:00.01
SYS@standby2/01-JAN-02>
SYS@primary/01-JAN-02>@dataguard_status.sql
FACILITY MESSAGE SEVER TIMESTAMP CALLO
------------------------- ---------------------------------------- ----- -------------------- -----
Log Transport Services ARC0: Archival started infor 01-JAN-02 NO
Log Transport Services ARC1: Archival started infor 01-JAN-02 NO
Log Transport Services ARC2: Archival started infor 01-JAN-02 NO
Log Transport Services ARC1: Becoming the 'no FAL' ARCH infor 01-JAN-02 NO
Log Transport Services ARC1: Becoming the 'no SRL' ARCH infor 01-JAN-02 NO
Log Transport Services ARC2: Becoming the heartbeat ARCH infor 01-JAN-02 NO
Log Transport Services ARC3: Archival started infor 01-JAN-02 NO
Remote File Server RFS[1]: Assigned to RFS process 31672 infor 01-JAN-02 NO
Remote File Server RFS[1]: Identified database type as 'phy infor 01-JAN-02 NO
sical standby': Client is ARCH pid 5018
Remote File Server RFS[2]: Assigned to RFS process 10835 infor 01-JAN-02 NO
Remote File Server RFS[2]: Identified database type as 'phy infor 01-JAN-02 NO
sical standby': Client is ARCH pid 5014
Log Transport Services ARC3: Beginning to archive thread 1 sequ contr 01-JAN-02 YES
ence 143 (862018-862112)
Log Transport Services ARC3: Completed archiving thread 1 seque contr 01-JAN-02 YES
nce 143 (0-0)
Log Apply Services Attempt to start background Managed Stan contr 01-JAN-02 YES
dby Recovery process
Log Apply Services MRP0: Background Managed Standby Recover contr 01-JAN-02 YES
y process started
Log Apply Services Managed Standby Recovery not using Real infor 01-JAN-02 NO
Time Apply
Log Apply Services Clearing online redo logfile 1 /boot/u02 infor 01-JAN-02 NO
/oradata/ORCL_1/onlinelog/o1_mf_1_6soypg
vj_.log
Log Apply Services Clearing online redo logfile 1 complete infor 01-JAN-02 NO
Log Apply Services Clearing online redo logfile 2 /boot/u02 infor 01-JAN-02 NO
/oradata/ORCL_1/onlinelog/o1_mf_2_6sovhf
c8_.log
Log Apply Services Clearing online redo logfile 2 complete infor 01-JAN-02 NO
Log Apply Services Clearing online redo logfile 3 /boot/u02 infor 01-JAN-02 NO
/oradata/ORCL_1/onlinelog/o1_mf_3_6sxxhv
hc_.log
Log Apply Services Clearing online redo logfile 3 complete infor 01-JAN-02 NO
Log Apply Services Media Recovery Log /boot/u04/oradata/1_1 infor 01-JAN-02 NO
43_747684876.dbf
Log Apply Services Media Recovery Waiting for thread 1 sequ Warni 01-JAN-02 NO
ence 144 ng
Remote File Server RFS[3]: Assigned to RFS process 18767 infor 01-JAN-02 NO
Remote File Server RFS[3]: Identified database type as 'phy infor 01-JAN-02 NO
sical standby': Client is ARCH pid 5020
Log Transport Services ARC1: Beginning to archive thread 1 sequ contr 01-JAN-02 YES
ence 144 (862112-862937)
Remote File Server RFS[4]: Assigned to RFS process 18769 infor 01-JAN-02 NO
Remote File Server RFS[4]: Identified database type as 'phy infor 01-JAN-02 NO
sical standby': Client is ARCH pid 5018
Log Transport Services ARC1: Completed archiving thread 1 seque contr 01-JAN-02 YES
nce 144 (0-0)
Log Apply Services Media Recovery Log /boot/u04/oradata/1_1 infor 01-JAN-02 NO
44_747684876.dbf
Log Apply Services Media Recovery Waiting for thread 1 sequ Warni 01-JAN-02 NO
ence 145 ng
Remote File Server RFS[5]: Assigned to RFS process 18790 infor 01-JAN-02 NO
Remote File Server RFS[5]: Identified database type as 'phy infor 01-JAN-02 NO
sical standby': Client is Foreground pid
5024
Remote File Server RFS[6]: Assigned to RFS process 18792 infor 01-JAN-02 NO
Remote File Server RFS[6]: Identified database type as 'phy infor 01-JAN-02 NO
FACILITY MESSAGE SEVER TIMESTAMP CALLO
------------------------- ---------------------------------------- ----- -------------------- -----
sical standby': Client is Foreground pid
5024
Log Apply Services Media Recovery Log /boot/u02/oradata/1_1 infor 01-JAN-02 NO
45_747684876.dbf
Log Apply Services Resetting standby activation ID 97781634 infor 01-JAN-02 NO
5 (0x3a484b19)
Log Apply Services MRP0: Media Recovery Complete: End-Of-RE contr 01-JAN-02 YES
DO
Log Apply Services MRP0: Background Media Recovery process contr 01-JAN-02 YES
shutdown
Role Management Services ALTER DATABASE SWITCHOVER TO PRIMARY contr 01-JAN-02 YES
Log Transport Services ARC3: Becoming the 'no SRL' ARCH infor 01-JAN-02 NO
Log Transport Services ARC0: Becoming the 'no SRL' ARCH infor 01-JAN-02 NO
Log Transport Services ARC1: Becoming the 'no SRL' ARCH infor 01-JAN-02 NO
Log Transport Services ARC0: Beginning to archive thread 1 sequ contr 01-JAN-02 YES
ence 146 (862948-862951)
Log Transport Services ARC0: Completed archiving thread 1 seque contr 01-JAN-02 YES
nce 146 (862948-862951)
Log Transport Services ARC0: Beginning to archive thread 1 sequ contr 01-JAN-02 YES
ence 147 (862951-862980)
Log Transport Services ARC0: Completed archiving thread 1 seque contr 01-JAN-02 YES
nce 147 (862951-862980)
Log Transport Services ARC3: Standby redo logfile selected for Warni 01-JAN-02 NO
thread 1 sequence 146 for destination LO ng
G_ARCHIVE_DEST_4
Log Transport Services LNS: Standby redo logfile selected for t Warni 01-JAN-02 NO
hread 1 sequence 147 for destination LOG ng
_ARCHIVE_DEST_5
Log Transport Services LNS: Beginning to archive log 2 thread 1 contr 01-JAN-02 YES
sequence 147
Log Transport Services LNS: Completed archiving log 2 thread 1 contr 01-JAN-02 YES
sequence 147
Log Transport Services ARC0: Standby redo logfile selected for Warni 01-JAN-02 NO
thread 1 sequence 146 for destination LO ng
G_ARCHIVE_DEST_5
Log Transport Services ARC3: Standby redo logfile selected for Warni 01-JAN-02 NO
thread 1 sequence 147 for destination LO ng
G_ARCHIVE_DEST_4
Log Transport Services LNS: Standby redo logfile selected for t Warni 01-JAN-02 NO
hread 1 sequence 148 for destination LOG ng
_ARCHIVE_DEST_5
Log Transport Services LNS: Beginning to archive log 3 thread 1 contr 01-JAN-02 YES
sequence 148
Log Transport Services ARC4: Archival started infor 01-JAN-02 NO
Log Transport Services ARCH shutting down infor 01-JAN-02 NO
Log Transport Services ARC4: Archival stopped infor 01-JAN-02 NO
59 rows selected.
Elapsed: 00:00:00.05
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /boot/u01/app/oracle/product/11.2.0/db_1/dbs/spfileorcl_1.ora
System parameters with non-default values:
processes = 150
nls_language = "AMERICAN"
nls_territory = "CHINA"
memory_target = 360M
control_files = "/boot/u02/oradata/ORCL_1/controlfile/o1_mf_6sot5rdl_.ctl"
control_files = "/boot/u03/oradata/ORCL_1/controlfile/o1_mf_6sot5rlk_.ctl"
control_files = "/boot/u04/oradata/ORCL_1/controlfile/o1_mf_6sot5rrh_.ctl"
control_files = "/boot/u05/oradata/ORCL_1/controlfile/o1_mf_6sot5s15_.ctl"
db_file_name_convert = "/boot/u02/oradata/ORCL_2/datafile"
db_file_name_convert = "/boot/u02/oradata/ORCL_1/datafile"
log_file_name_convert = "/boot/u02/oradata/ORCL_2/onlinelog"
log_file_name_convert = "/boot/u02/oradata/ORCL_1/onlinelog"
log_file_name_convert = "/boot/u03/oradata/ORCL_2/onlinelog"
log_file_name_convert = "/boot/u03/oradata/ORCL_1/onlinelog"
log_file_name_convert = "/boot/u04/oradata/ORCL_2/onlinelog"
log_file_name_convert = "/boot/u04/oradata/ORCL_1/onlinelog"
log_file_name_convert = "/boot/u05/oradata/ORCL_2/onlinelog"
log_file_name_convert = "/boot/u05/oradata/ORCL_1/onlinelog"
db_block_size = 8192
compatible = "11.2.0.0.0"
log_archive_dest_1 = "LOCATION=/boot/u02/oradata"
log_archive_dest_2 = "LOCATION=/boot/u03/oradata"
log_archive_dest_3 = "LOCATION=/boot/u04/oradata"
log_archive_dest_4 = "service=standby1 arch valid_for=(online_logfile,primary_role) db_unique_name=orcl_2"
log_archive_dest_5 = "service=standby2 lgwr async valid_for=(online_logfile,primary_role) db_unique_name=orcl_3"
log_archive_dest_state_4 = "ENABLE"
log_archive_dest_state_5 = "ENABLE"
fal_client = "primary"
fal_server = "standby1"
log_archive_config = "dg_config=(orcl_1,orcl_2,orcl_3)"
log_archive_format = "%t_%s_%r.dbf"
db_create_file_dest = "/boot/u02/oradata"
db_create_online_log_dest_1= "/boot/u02/oradata"
db_create_online_log_dest_2= "/boot/u03/oradata"
db_create_online_log_dest_3= "/boot/u04/oradata"
db_create_online_log_dest_4= "/boot/u05/oradata"
db_recovery_file_dest = "/boot/u03/recovery_area"
db_recovery_file_dest_size= 8G
standby_file_management = "auto"
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
audit_file_dest = "/boot/u01/app/oracle/admin/orcl/adump"
audit_trail = "DB"
db_name = "orcl"
db_unique_name = "orcl_1"
open_cursors = 300
diagnostic_dest = "/boot/u01/app/oracle"
Tue Jan 01 00:55:07 2002
PMON started with pid=2, OS id=5556
Tue Jan 01 00:55:07 2002
VKTM started with pid=3, OS id=5558 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Tue Jan 01 00:55:07 2002
GEN0 started with pid=4, OS id=5562
Tue Jan 01 00:55:07 2002
DIAG started with pid=5, OS id=5564
Tue Jan 01 00:55:07 2002
DBRM started with pid=6, OS id=5566
Tue Jan 01 00:55:07 2002
PSP0 started with pid=7, OS id=5568
Tue Jan 01 00:55:07 2002
DIA0 started with pid=8, OS id=5570
Tue Jan 01 00:55:07 2002
MMAN started with pid=9, OS id=5572
Tue Jan 01 00:55:07 2002
DBW0 started with pid=10, OS id=5574
Tue Jan 01 00:55:07 2002
LGWR started with pid=11, OS id=5576
Tue Jan 01 00:55:07 2002
CKPT started with pid=12, OS id=5578
Tue Jan 01 00:55:07 2002
SMON started with pid=13, OS id=5580
Tue Jan 01 00:55:07 2002
RECO started with pid=14, OS id=5582
Tue Jan 01 00:55:08 2002
MMON started with pid=15, OS id=5584
Tue Jan 01 00:55:08 2002
MMNL started with pid=16, OS id=5586
ORACLE_BASE from environment = /boot/u01/app/oracle
Tue Jan 01 00:55:08 2002
ALTER DATABASE MOUNT
Successful mount of redo thread 1, with mount id 977788268
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Tue Jan 01 00:58:42 2002
alter database open
Tue Jan 01 00:58:42 2002
LGWR: STARTING ARCH PROCESSES
Tue Jan 01 00:58:42 2002
ARC0 started with pid=18, OS id=5630
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
LGWR: Primary database is in MAXIMUM AVAILABILITY mode
LGWR: Destination LOG_ARCHIVE_DEST_5 is using asynchronous network I/O
LGWR: Destination LOG_ARCHIVE_DEST_4 is not serviced by LGWR
LGWR: Destination LOG_ARCHIVE_DEST_3 is not serviced by LGWR
LGWR: Destination LOG_ARCHIVE_DEST_2 is not serviced by LGWR
LGWR: Destination LOG_ARCHIVE_DEST_1 is not serviced by LGWR
Thread 1 advanced to log sequence 138 (thread open)
Tue Jan 01 00:58:43 2002
ARC1 started with pid=19, OS id=5633
Thread 1 opened at log sequence 138
Current log# 3 seq# 138 mem# 0: /boot/u02/oradata/ORCL_1/onlinelog/o1_mf_3_6sxxhvhc_.log
Current log# 3 seq# 138 mem# 1: /boot/u03/oradata/ORCL_1/onlinelog/o1_mf_3_6sxxhvtq_.log
Current log# 3 seq# 138 mem# 2: /boot/u04/oradata/ORCL_1/onlinelog/o1_mf_3_6sxxhxw4_.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Jan 01 00:58:43 2002
SMON: enabling cache recovery
Tue Jan 01 00:58:43 2002
ARC2 started with pid=20, OS id=5635
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
Tue Jan 01 00:58:43 2002
ARC3 started with pid=21, OS id=5637
Tue Jan 01 00:58:43 2002
NSA5 started with pid=22, OS id=5641
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Archived Log entry 555 added for thread 1 sequence 137 ID 0x4c054e0b dest 1:
Archived Log entry 556 added for thread 1 sequence 137 ID 0x4c054e0b dest 2:
Archived Log entry 557 added for thread 1 sequence 137 ID 0x4c054e0b dest 3:
Database Characterset is ZHS16GBK
No Resource Manager plan active
ARC2: Standby redo logfile selected for thread 1 sequence 137 for destination LOG_ARCHIVE_DEST_4
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Tue Jan 01 00:58:44 2002
QMNC started with pid=23, OS id=5649
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_5
******************************************************************
Thread 1 advanced to log sequence 139 (LGWR switch)
Current log# 1 seq# 139 mem# 0: /boot/u02/oradata/ORCL_1/onlinelog/o1_mf_1_6soypgvj_.log
Current log# 1 seq# 139 mem# 1: /boot/u03/oradata/ORCL_1/onlinelog/o1_mf_1_6soyph3t_.log
Current log# 1 seq# 139 mem# 2: /boot/u04/oradata/ORCL_1/onlinelog/o1_mf_1_6soypjgh_.log
ARC0: STARTING ARCH PROCESSES
LNS: Standby redo logfile selected for thread 1 sequence 138 for destination LOG_ARCHIVE_DEST_5
Tue Jan 01 00:58:46 2002
ARC4 started with pid=24, OS id=5668
Completed: alter database open
Archived Log entry 559 added for thread 1 sequence 138 ID 0x4c054e0b dest 1:
Archived Log entry 560 added for thread 1 sequence 138 ID 0x4c054e0b dest 2:
Archived Log entry 561 added for thread 1 sequence 138 ID 0x4c054e0b dest 3:
LNS: Standby redo logfile selected for thread 1 sequence 139 for destination LOG_ARCHIVE_DEST_5
ARC2: Standby redo logfile selected for thread 1 sequence 138 for destination LOG_ARCHIVE_DEST_4
Tue Jan 01 00:58:47 2002
db_recovery_file_dest_size of 8192 MB is 6.87% 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.
ARC4: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC3: Standby redo logfile selected for thread 1 sequence 137 for destination LOG_ARCHIVE_DEST_5
Tue Jan 01 00:59:33 2002
Thread 1 advanced to log sequence 140 (LGWR switch)
Current log# 2 seq# 140 mem# 0: /boot/u02/oradata/ORCL_1/onlinelog/o1_mf_2_6sovhfc8_.log
Current log# 2 seq# 140 mem# 1: /boot/u03/oradata/ORCL_1/onlinelog/o1_mf_2_6sovhfrz_.log
Current log# 2 seq# 140 mem# 2: /boot/u04/oradata/ORCL_1/onlinelog/o1_mf_2_6sovhhr0_.log
Tue Jan 01 00:59:33 2002
Shutting down archive processes
Tue Jan 01 00:59:33 2002
ARCH shutting down
ARC4: Archival stopped
Archived Log entry 566 added for thread 1 sequence 139 ID 0x4c054e0b dest 1:
Archived Log entry 567 added for thread 1 sequence 139 ID 0x4c054e0b dest 2:
Archived Log entry 568 added for thread 1 sequence 139 ID 0x4c054e0b dest 3:
Tue Jan 01 00:59:34 2002
LNS: Standby redo logfile selected for thread 1 sequence 140 for destination LOG_ARCHIVE_DEST_5
Tue Jan 01 00:59:34 2002
ARC0: Standby redo logfile selected for thread 1 sequence 139 for destination LOG_ARCHIVE_DEST_4
Tue Jan 01 01:02:48 2002
alter database commit to switchover to physical standby
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY [Process Id: 5619] (orcl_1)
Tue Jan 01 01:02:49 2002
Thread 1 cannot allocate new log, sequence 141
Checkpoint not complete
Current log# 2 seq# 140 mem# 0: /boot/u02/oradata/ORCL_1/onlinelog/o1_mf_2_6sovhfc8_.log
Current log# 2 seq# 140 mem# 1: /boot/u03/oradata/ORCL_1/onlinelog/o1_mf_2_6sovhfrz_.log
Current log# 2 seq# 140 mem# 2: /boot/u04/oradata/ORCL_1/onlinelog/o1_mf_2_6sovhhr0_.log
Thread 1 advanced to log sequence 141 (LGWR switch)
Current log# 3 seq# 141 mem# 0: /boot/u02/oradata/ORCL_1/onlinelog/o1_mf_3_6sxxhvhc_.log
Current log# 3 seq# 141 mem# 1: /boot/u03/oradata/ORCL_1/onlinelog/o1_mf_3_6sxxhvtq_.log
Current log# 3 seq# 141 mem# 2: /boot/u04/oradata/ORCL_1/onlinelog/o1_mf_3_6sxxhxw4_.log
Waiting for all non-current ORLs to be archived...
Waiting for the ORL for thread 1 sequence 140 to be archived...
Tue Jan 01 01:02:55 2002
ARC0: Standby redo logfile selected for thread 1 sequence 140 for destination LOG_ARCHIVE_DEST_4
Archived Log entry 571 added for thread 1 sequence 140 ID 0x4c054e0b dest 1:
Archived Log entry 572 added for thread 1 sequence 140 ID 0x4c054e0b dest 2:
Archived Log entry 573 added for thread 1 sequence 140 ID 0x4c054e0b dest 3:
Tue Jan 01 01:03:03 2002
ORL for thread 1 sequence 140 has been archived...
All non-current ORLs have been archived.
Waiting for all FAL entries to be archived...
All FAL entries have been archived.
Waiting for potential switchover target to become synchronized...
Tue Jan 01 01:03:13 2002
Active, synchronized Physical Standby switchover target has been identified
Tue Jan 01 01:03:13 2002
Thread 1 cannot allocate new log, sequence 142
Checkpoint not complete
Current log# 3 seq# 141 mem# 0: /boot/u02/oradata/ORCL_1/onlinelog/o1_mf_3_6sxxhvhc_.log
Current log# 3 seq# 141 mem# 1: /boot/u03/oradata/ORCL_1/onlinelog/o1_mf_3_6sxxhvtq_.log
Current log# 3 seq# 141 mem# 2: /boot/u04/oradata/ORCL_1/onlinelog/o1_mf_3_6sxxhxw4_.log
Thread 1 advanced to log sequence 142 (LGWR switch)
Current log# 1 seq# 142 mem# 0: /boot/u02/oradata/ORCL_1/onlinelog/o1_mf_1_6soypgvj_.log
Current log# 1 seq# 142 mem# 1: /boot/u03/oradata/ORCL_1/onlinelog/o1_mf_1_6soyph3t_.log
Current log# 1 seq# 142 mem# 2: /boot/u04/oradata/ORCL_1/onlinelog/o1_mf_1_6soypjgh_.log
ARCH: Standby redo logfile selected for thread 1 sequence 141 for destination LOG_ARCHIVE_DEST_5
ARCH: Standby redo logfile selected for thread 1 sequence 141 for destination LOG_ARCHIVE_DEST_4
Archived Log entry 575 added for thread 1 sequence 141 ID 0x4c054e0b dest 1:
Archived Log entry 576 added for thread 1 sequence 141 ID 0x4c054e0b dest 2:
Archived Log entry 577 added for thread 1 sequence 141 ID 0x4c054e0b dest 3:
Tue Jan 01 01:03:14 2002
SMON: disabling tx recovery
Stopping background process QMNC
CLOSE: killing server sessions.
CLOSE: all sessions shutdown successfully.
SMON: disabling cache recovery
Shutting down archive processes
Archiving is disabled
Tue Jan 01 01:03:15 2002
ARCH shutting down
ARC3: Archival stopped
Tue Jan 01 01:03:15 2002
ARCH shutting down
ARC2: Archival stopped
Tue Jan 01 01:03:15 2002
ARCH shutting down
ARC1: Archival stopped
Tue Jan 01 01:03:15 2002
ARCH shutting down
ARC0: Archival stopped
Thread 1 closed at log sequence 142
Successful close of redo thread 1
ARCH: Noswitch archival of thread 1, sequence 142
ARCH: End-Of-Redo Branch archival of thread 1 sequence 142
Archived Log entry 580 added for thread 1 sequence 142 ID 0x4c054e0b dest 1:
Archived Log entry 581 added for thread 1 sequence 142 ID 0x4c054e0b dest 2:
Archived Log entry 582 added for thread 1 sequence 142 ID 0x4c054e0b dest 3:
ARCH: Archiving is disabled due to current logfile archival
Using STANDBY_ARCHIVE_DEST parameter default value as /boot/u02/oradata
Primary will check for some target standby to have received all redo
Final check for a synchronized target standby. Check will be made once.
LOG_ARCHIVE_DEST_4 is a potential Physical Standby switchover target
LOG_ARCHIVE_DEST_5 is a potential Physical Standby switchover target
Active, synchronized target has been identified
Target has also applied all redo
Backup controlfile written to trace file /boot/u01/app/oracle/diag/rdbms/orcl_1/orcl_1/trace/orcl_1_ora_5619.trc
Clearing standby activation ID 1275416075 (0x4c054e0b)
The primary database controlfile was created using the
'MAXLOGFILES 16' clause.
There is space for up to 13 standby redo logfiles
Use the following SQL commands on the standby database to create
standby redo logfiles that match the primary database:
ALTER DATABASE ADD STANDBY LOGFILE 'srl1.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE 104857600;
ALTER DATABASE ADD STANDBY LOGFILE 'srl4.f' SIZE 104857600;
ALTER DATABASE ADD STANDBY LOGFILE 'srl5.f' SIZE 104857600;
Archivelog for thread 1 sequence 142 required for standby recovery
Switchover: Primary controlfile converted to standby controlfile succesfully.
Tue Jan 01 01:03:17 2002
MRP0 started with pid=18, OS id=5845
MRP0: Background Managed Standby Recovery process started (orcl_1)
Serial Media Recovery started
Managed Standby Recovery not using Real Time Apply
Online logfile pre-clearing operation disabled by switchover
Media Recovery Log /boot/u04/oradata/1_142_747684876.dbf
Identified End-Of-Redo for thread 1 sequence 142
Resetting standby activation ID 0 (0x0)
Media Recovery End-Of-Redo indicator encountered
Media Recovery Applied until change 862018
MRP0: Media Recovery Complete: End-Of-REDO (orcl_1)
MRP0: Background Media Recovery process shutdown (orcl_1)
Tue Jan 01 01:03:23 2002
Switchover: Complete - Database shutdown required (orcl_1)
Completed: alter database commit to switchover to physical standby
Tue Jan 01 01:06:12 2002
alter database mount
Database in limbo -- Shutdown Required.
ORA-1100 signalled during: alter database mount...
alter database open
ORA-1507 signalled during: alter database open...
Tue Jan 01 01:06:30 2002
alter database mount
Database in limbo -- Shutdown Required.
ORA-1100 signalled during: alter database mount...
Shutting down instance (abort)
License high water mark = 2
USER (ospid: 5619): terminating the instance
Instance terminated by USER, pid = 5619
Tue Jan 01 01:06:36 2002
Instance shutdown complete
Tue Jan 01 01:06:36 2002
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
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.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /boot/u01/app/oracle/product/11.2.0/db_1/dbs/spfileorcl_2.ora
System parameters with non-default values:
processes = 150
nls_language = "AMERICAN"
nls_territory = "CHINA"
memory_target = 360M
control_files = "/boot/u02/oradata/ORCL_2/controlfile/standby01.ctl"
control_files = "/boot/u02/oradata/ORCL_2/controlfile/standby02.ctl"
control_files = "/boot/u02/oradata/ORCL_2/controlfile/standby03.ctl"
db_file_name_convert = "/boot/u02/oradata/ORCL_1/datafile"
db_file_name_convert = "/boot/u02/oradata/ORCL_2/datafile"
log_file_name_convert = "/boot/u02/oradata/ORCL_1/onlinelog"
log_file_name_convert = "/boot/u02/oradata/ORCL_2/onlinelog"
log_file_name_convert = "/boot/u03/oradata/ORCL_1/onlinelog"
log_file_name_convert = "/boot/u03/oradata/ORCL_2/onlinelog"
log_file_name_convert = "/boot/u04/oradata/ORCL_1/onlinelog"
log_file_name_convert = "/boot/u04/oradata/ORCL_2/onlinelog"
log_file_name_convert = "/boot/u05/oradata/ORCL_1/onlinelog"
log_file_name_convert = "/boot/u05/oradata/ORCL_2/onlinelog"
db_block_size = 8192
compatible = "11.2.0.0.0"
log_archive_dest_1 = "LOCATION=/boot/u02/oradata/ORCL_2/archivelog"
log_archive_dest_2 = "LOCATION=/boot/u03/oradata/ORCL_2/archivelog"
log_archive_dest_3 = "LOCATION=/boot/u04/oradata/ORCL_2/archivelog"
log_archive_dest_4 = "SERVICE=primary ARCH VALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl_1"
log_archive_dest_state_4 = "ENABLE"
fal_client = "standby1"
fal_server = "primary"
log_archive_config = "dg_config=(orcl_1,orcl_2)"
log_archive_format = "%t_%s_%r.dbf"
db_create_file_dest = "/boot/u02/oradata"
db_create_online_log_dest_1= "/boot/u02/oradata"
db_create_online_log_dest_2= "/boot/u03/oradata"
db_create_online_log_dest_3= "/boot/u04/oradata"
db_create_online_log_dest_4= "/boot/u05/oradata"
db_recovery_file_dest = "/boot/u03/recovery_area"
db_recovery_file_dest_size= 8G
standby_file_management = "auto"
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
audit_file_dest = "/boot/u01/app/oracle/admin/orcl/adump"
audit_trail = "DB"
db_name = "orcl"
db_unique_name = "orcl_2"
open_cursors = 300
diagnostic_dest = "/boot/u01/app/oracle"
Tue Jan 01 00:32:24 2002
PMON started with pid=2, OS id=4946
Tue Jan 01 00:32:24 2002
VKTM started with pid=3, OS id=4948 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Tue Jan 01 00:32:24 2002
GEN0 started with pid=4, OS id=4952
Tue Jan 01 00:32:24 2002
DIAG started with pid=5, OS id=4954
Tue Jan 01 00:32:24 2002
DBRM started with pid=6, OS id=4956
Tue Jan 01 00:32:24 2002
PSP0 started with pid=7, OS id=4958
Tue Jan 01 00:32:24 2002
DIA0 started with pid=8, OS id=4960
Tue Jan 01 00:32:24 2002
MMAN started with pid=9, OS id=4962
Tue Jan 01 00:32:24 2002
DBW0 started with pid=10, OS id=4964
Tue Jan 01 00:32:24 2002
LGWR started with pid=11, OS id=4966
Tue Jan 01 00:32:24 2002
CKPT started with pid=12, OS id=4968
Tue Jan 01 00:32:24 2002
SMON started with pid=13, OS id=4970
Tue Jan 01 00:32:24 2002
RECO started with pid=14, OS id=4972
Tue Jan 01 00:32:24 2002
MMON started with pid=15, OS id=4976
Tue Jan 01 00:32:24 2002
MMNL started with pid=16, OS id=4978
ORACLE_BASE from environment = /boot/u01/app/oracle
Tue Jan 01 00:32:24 2002
ALTER DATABASE MOUNT
ARCH: STARTING ARCH PROCESSES
Tue Jan 01 00:32:29 2002
ARC0 started with pid=18, OS id=5014
ARC0: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Successful mount of redo thread 1, with mount id 977816345
Physical Standby Database mounted.
Lost write protection disabled
Tue Jan 01 00:32:29 2002
ARC1 started with pid=19, OS id=5016
Tue Jan 01 00:32:29 2002
ARC2 started with pid=20, OS id=5018
Tue Jan 01 00:32:29 2002
ARC3 started with pid=21, OS id=5020
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC2: Becoming the heartbeat ARCH
Completed: ALTER DATABASE MOUNT
Tue Jan 01 00:32:29 2002
ALTER DATABASE OPEN
AUDIT_TRAIL initialization parameter is changed to OS, as DB is NOT compatible for database opened with read-only access
SMON: enabling cache recovery
Error 1034 received logging on to the standby
FAL[client, ARC2]: Error 1034 connecting to primary for fetching gap sequence
Errors in file /boot/u01/app/oracle/diag/rdbms/orcl_2/orcl_2/trace/orcl_2_arc2_5018.trc:
ORA-01034: ORACLE not available
Errors in file /boot/u01/app/oracle/diag/rdbms/orcl_2/orcl_2/trace/orcl_2_arc2_5018.trc:
ORA-01034: ORACLE not available
Dictionary check beginning
Dictionary check complete
Database Characterset is ZHS16GBK
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Physical standby database opened for read only access.
Completed: ALTER DATABASE OPEN
Tue Jan 01 00:32:30 2002
db_recovery_file_dest_size of 8192 MB is 0.00% 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.
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Tue Jan 01 00:34:38 2002
Using STANDBY_ARCHIVE_DEST parameter default value as /boot/u02/oradata/ORCL_2/archivelog
RFS[1]: Assigned to RFS process 5282
RFS[1]: Identified database type as 'physical standby': Client is ARCH pid 5254
Tue Jan 01 00:34:39 2002
RFS[2]: Assigned to RFS process 5284
RFS[2]: Identified database type as 'physical standby': Client is ARCH pid 5258
RFS[2]: Selected log 4 for thread 1 sequence 135 dbid 1275488545 branch 747684876
Tue Jan 01 00:34:40 2002
Archived Log entry 39 added for thread 1 sequence 135 ID 0x4c054e0b dest 1:
Archived Log entry 40 added for thread 1 sequence 135 ID 0x4c054e0b dest 2:
Archived Log entry 41 added for thread 1 sequence 135 ID 0x4c054e0b dest 3:
RFS[2]: Selected log 4 for thread 1 sequence 136 dbid 1275488545 branch 747684876
Tue Jan 01 00:34:41 2002
Archived Log entry 42 added for thread 1 sequence 136 ID 0x4c054e0b dest 1:
Archived Log entry 43 added for thread 1 sequence 136 ID 0x4c054e0b dest 2:
Archived Log entry 44 added for thread 1 sequence 136 ID 0x4c054e0b dest 3:
Tue Jan 01 00:58:43 2002
RFS[3]: Assigned to RFS process 5647
RFS[3]: Identified database type as 'physical standby': Client is ARCH pid 5635
RFS[3]: Selected log 4 for thread 1 sequence 137 dbid 1275488545 branch 747684876
Tue Jan 01 00:58:44 2002
Archived Log entry 45 added for thread 1 sequence 137 ID 0x4c054e0b dest 1:
Archived Log entry 46 added for thread 1 sequence 137 ID 0x4c054e0b dest 2:
Archived Log entry 47 added for thread 1 sequence 137 ID 0x4c054e0b dest 3:
RFS[3]: Selected log 4 for thread 1 sequence 138 dbid 1275488545 branch 747684876
Tue Jan 01 00:58:47 2002
Archived Log entry 48 added for thread 1 sequence 138 ID 0x4c054e0b dest 1:
Archived Log entry 49 added for thread 1 sequence 138 ID 0x4c054e0b dest 2:
Archived Log entry 50 added for thread 1 sequence 138 ID 0x4c054e0b dest 3:
Tue Jan 01 00:59:33 2002
RFS[4]: Assigned to RFS process 5708
RFS[4]: Identified database type as 'physical standby': Client is ARCH pid 5630
RFS[4]: Selected log 4 for thread 1 sequence 139 dbid 1275488545 branch 747684876
Tue Jan 01 00:59:34 2002
Archived Log entry 51 added for thread 1 sequence 139 ID 0x4c054e0b dest 1:
Archived Log entry 52 added for thread 1 sequence 139 ID 0x4c054e0b dest 2:
Archived Log entry 53 added for thread 1 sequence 139 ID 0x4c054e0b dest 3:
Tue Jan 01 01:00:32 2002
ALTER DATABASE RECOVER managed standby database disconnect
Attempt to start background Managed Standby Recovery process (orcl_2)
Tue Jan 01 01:00:32 2002
MRP0 started with pid=24, OS id=5743
MRP0: Background Managed Standby Recovery process started (orcl_2)
started logmerger process
Tue Jan 01 01:00:37 2002
Managed Standby Recovery not using 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 /boot/u04/oradata/ORCL_2/archivelog/1_135_747684876.dbf
Media Recovery Log /boot/u04/oradata/ORCL_2/archivelog/1_136_747684876.dbf
Media Recovery Log /boot/u04/oradata/ORCL_2/archivelog/1_137_747684876.dbf
Media Recovery Log /boot/u04/oradata/ORCL_2/archivelog/1_138_747684876.dbf
Media Recovery Log /boot/u04/oradata/ORCL_2/archivelog/1_139_747684876.dbf
Completed: ALTER DATABASE RECOVER managed standby database disconnect
Media Recovery Waiting for thread 1 sequence 140
Tue Jan 01 01:02:55 2002
RFS[4]: Selected log 4 for thread 1 sequence 140 dbid 1275488545 branch 747684876
Tue Jan 01 01:02:55 2002
Archived Log entry 54 added for thread 1 sequence 140 ID 0x4c054e0b dest 1:
Archived Log entry 55 added for thread 1 sequence 140 ID 0x4c054e0b dest 2:
Archived Log entry 56 added for thread 1 sequence 140 ID 0x4c054e0b dest 3:
Tue Jan 01 01:02:59 2002
Media Recovery Log /boot/u04/oradata/ORCL_2/archivelog/1_140_747684876.dbf
Media Recovery Waiting for thread 1 sequence 141
Tue Jan 01 01:03:03 2002
RFS[5]: Assigned to RFS process 5801
RFS[5]: Identified database type as 'physical standby': Client is ARCH pid 5635
Tue Jan 01 01:03:14 2002
RFS[6]: Assigned to RFS process 5822
RFS[6]: Identified database type as 'physical standby': Client is Foreground pid 5619
RFS[6]: Selected log 4 for thread 1 sequence 141 dbid 1275488545 branch 747684876
Tue Jan 01 01:03:14 2002
Archived Log entry 57 added for thread 1 sequence 141 ID 0x4c054e0b dest 1:
Archived Log entry 58 added for thread 1 sequence 141 ID 0x4c054e0b dest 2:
Archived Log entry 59 added for thread 1 sequence 141 ID 0x4c054e0b dest 3:
Tue Jan 01 01:03:16 2002
RFS[7]: Assigned to RFS process 5839
RFS[7]: Identified database type as 'physical standby': Client is Foreground pid 5619
RFS[7]: Opened log for thread 1 sequence 142 dbid 1275488545 branch 747684876
Archived Log entry 60 added for thread 1 sequence 142 rlc 747684876 ID 0x4c054e0b dest 4:
Tue Jan 01 01:03:17 2002
RFS[8]: Assigned to RFS process 5841
RFS[8]: Identified database type as 'physical standby': Client is Foreground pid 5619
Tue Jan 01 01:03:19 2002
Media Recovery Log /boot/u04/oradata/ORCL_2/archivelog/1_141_747684876.dbf
Media Recovery Log /boot/u02/oradata/ORCL_2/archivelog/1_142_747684876.dbf
Identified End-Of-Redo for thread 1 sequence 142
Resetting standby activation ID 1275416075 (0x4c054e0b)
Media Recovery End-Of-Redo indicator encountered
Media Recovery Applied until change 862018
Tue Jan 01 01:03:19 2002
MRP0: Media Recovery Complete: End-Of-REDO (orcl_2)
MRP0: Background Media Recovery process shutdown (orcl_2)
Tue Jan 01 01:04:22 2002
alter database commit to switchover to primary
ALTER DATABASE SWITCHOVER TO PRIMARY (orcl_2)
Maximum wait for role transition is 15 minutes.
CLOSE: killing server sessions.
CLOSE: all sessions shutdown successfully.
Tue Jan 01 01:04:22 2002
SMON: disabling cache recovery
Backup controlfile written to trace file /boot/u01/app/oracle/diag/rdbms/orcl_2/orcl_2/trace/orcl_2_ora_5024.trc
SwitchOver after complete recovery through change 862018
Online log /boot/u02/oradata/ORCL_2/onlinelog/o1_mf_1_6sxqh23t_.log: Thread 1 Group 1 was previously cleared
Online log /boot/u03/oradata/ORCL_2/onlinelog/o1_mf_1_6sxqh2c1_.log: Thread 1 Group 1 was previously cleared
Online log /boot/u04/oradata/ORCL_2/onlinelog/o1_mf_1_6sxqh3nm_.log: Thread 1 Group 1 was previously cleared
Online log /boot/u02/oradata/ORCL_2/onlinelog/o1_mf_2_6sxqh5wx_.log: Thread 1 Group 2 was previously cleared
Online log /boot/u03/oradata/ORCL_2/onlinelog/o1_mf_2_6sxqh6b7_.log: Thread 1 Group 2 was previously cleared
Online log /boot/u04/oradata/ORCL_2/onlinelog/o1_mf_2_6sxqh8mn_.log: Thread 1 Group 2 was previously cleared
Online log /boot/u02/oradata/ORCL_2/onlinelog/o1_mf_3_6sxsc7m7_.log: Thread 1 Group 3 was previously cleared
Online log /boot/u03/oradata/ORCL_2/onlinelog/o1_mf_3_6sxsc80d_.log: Thread 1 Group 3 was previously cleared
Online log /boot/u04/oradata/ORCL_2/onlinelog/o1_mf_3_6sxscb5g_.log: Thread 1 Group 3 was previously cleared
Standby became primary SCN: 862016
Switchover: Complete - Database mounted as primary
Tue Jan 01 01:04:30 2002
ARC1: Becoming the 'no SRL' ARCH
Completed: alter database commit to switchover to primary
Tue Jan 01 01:13:32 2002
alter database open
Tue Jan 01 01:13:32 2002
Assigning activation ID 977816345 (0x3a484b19)
Thread 1 opened at log sequence 143
Current log# 1 seq# 143 mem# 0: /boot/u02/oradata/ORCL_2/onlinelog/o1_mf_1_6sxqh23t_.log
Current log# 1 seq# 143 mem# 1: /boot/u03/oradata/ORCL_2/onlinelog/o1_mf_1_6sxqh2c1_.log
Current log# 1 seq# 143 mem# 2: /boot/u04/oradata/ORCL_2/onlinelog/o1_mf_1_6sxqh3nm_.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Jan 01 01:13:32 2002
SMON: enabling cache recovery
Successfully onlined Undo Tablespace 2.
Dictionary check beginning
Dictionary check complete
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Starting background process SMCO
Database Characterset is ZHS16GBK
Tue Jan 01 01:13:33 2002
SMCO started with pid=22, OS id=31720
No Resource Manager plan active
Starting background process QMNC
Tue Jan 01 01:13:35 2002
QMNC started with pid=23, OS id=31831
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete
Completed: alter database open
Tue Jan 01 01:14:29 2002
ARC2: STARTING ARCH PROCESSES
Tue Jan 01 01:14:29 2002
ARC4 started with pid=27, OS id=9835
ARC4: Archival started
ARC2: STARTING ARCH PROCESSES COMPLETE
Tue Jan 01 01:14:38 2002
Thread 1 advanced to log sequence 144 (LGWR switch)
Current log# 2 seq# 144 mem# 0: /boot/u02/oradata/ORCL_2/onlinelog/o1_mf_2_6sxqh5wx_.log
Current log# 2 seq# 144 mem# 1: /boot/u03/oradata/ORCL_2/onlinelog/o1_mf_2_6sxqh6b7_.log
Current log# 2 seq# 144 mem# 2: /boot/u04/oradata/ORCL_2/onlinelog/o1_mf_2_6sxqh8mn_.log
Tue Jan 01 01:14:44 2002
Archived Log entry 61 added for thread 1 sequence 143 ID 0x3a484b19 dest 1:
Archived Log entry 62 added for thread 1 sequence 143 ID 0x3a484b19 dest 2:
Archived Log entry 63 added for thread 1 sequence 143 ID 0x3a484b19 dest 3:
Tue Jan 01 01:14:52 2002
ARC0: Standby redo logfile selected for thread 1 sequence 143 for destination LOG_ARCHIVE_DEST_4
Tue Jan 01 01:15:30 2002
Shutting down archive processes
Tue Jan 01 01:15:30 2002
ARCH shutting down
ARC4: Archival stopped
Tue Jan 01 01:47:32 2002
alter database commit to switchover to physical standby
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY [Process Id: 5024] (orcl_2)
Tue Jan 01 01:47:34 2002
Thread 1 advanced to log sequence 145 (LGWR switch)
Current log# 3 seq# 145 mem# 0: /boot/u02/oradata/ORCL_2/onlinelog/o1_mf_3_6sxsc7m7_.log
Current log# 3 seq# 145 mem# 1: /boot/u03/oradata/ORCL_2/onlinelog/o1_mf_3_6sxsc80d_.log
Current log# 3 seq# 145 mem# 2: /boot/u04/oradata/ORCL_2/onlinelog/o1_mf_3_6sxscb5g_.log
Tue Jan 01 01:47:34 2002
ARC3: Standby redo logfile selected for thread 1 sequence 144 for destination LOG_ARCHIVE_DEST_4
Archived Log entry 65 added for thread 1 sequence 144 ID 0x3a484b19 dest 1:
Archived Log entry 66 added for thread 1 sequence 144 ID 0x3a484b19 dest 2:
Archived Log entry 67 added for thread 1 sequence 144 ID 0x3a484b19 dest 3:
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Waiting for all FAL entries to be archived...
All FAL entries have been archived.
Waiting for potential switchover target to become synchronized...
Tue Jan 01 01:47:45 2002
Active, synchronized Physical Standby switchover target has been identified
Tue Jan 01 01:47:45 2002
SMON: disabling tx recovery
Stopping background process QMNC
CLOSE: killing server sessions.
CLOSE: all sessions shutdown successfully.
Stopping background process SMCO
SMON: disabling cache recovery
Tue Jan 01 01:47:47 2002
Shutting down archive processes
Archiving is disabled
Tue Jan 01 01:47:47 2002
ARCH shutting down
ARC3: Archival stopped
Tue Jan 01 01:47:47 2002
ARCH shutting down
ARC2: Archival stopped
Tue Jan 01 01:47:47 2002
ARCH shutting down
ARC1: Archival stopped
Tue Jan 01 01:47:47 2002
ARCH shutting down
ARC0: Archival stopped
Thread 1 closed at log sequence 145
Successful close of redo thread 1
ARCH: Noswitch archival of thread 1, sequence 145
ARCH: End-Of-Redo Branch archival of thread 1 sequence 145
Archived Log entry 69 added for thread 1 sequence 145 ID 0x3a484b19 dest 1:
Archived Log entry 70 added for thread 1 sequence 145 ID 0x3a484b19 dest 2:
Archived Log entry 71 added for thread 1 sequence 145 ID 0x3a484b19 dest 3:
ARCH: Archiving is disabled due to current logfile archival
Primary will check for some target standby to have received all redo
Final check for a synchronized target standby. Check will be made once.
LOG_ARCHIVE_DEST_4 is a potential Physical Standby switchover target
Active, synchronized target has been identified
Target has also applied all redo
Backup controlfile written to trace file /boot/u01/app/oracle/diag/rdbms/orcl_2/orcl_2/trace/orcl_2_ora_5024.trc
Clearing standby activation ID 977816345 (0x3a484b19)
The primary database controlfile was created using the
'MAXLOGFILES 16' clause.
There is space for up to 13 standby redo logfiles
Use the following SQL commands on the standby database to create
standby redo logfiles that match the primary database:
ALTER DATABASE ADD STANDBY LOGFILE 'srl1.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE 104857600;
ALTER DATABASE ADD STANDBY LOGFILE 'srl4.f' SIZE 104857600;
ALTER DATABASE ADD STANDBY LOGFILE 'srl5.f' SIZE 104857600;
Archivelog for thread 1 sequence 145 required for standby recovery
Switchover: Primary controlfile converted to standby controlfile succesfully.
Tue Jan 01 01:47:48 2002
MRP0 started with pid=18, OS id=18794
MRP0: Background Managed Standby Recovery process started (orcl_2)
Serial Media Recovery started
Managed Standby Recovery not using Real Time Apply
Online logfile pre-clearing operation disabled by switchover
Media Recovery Log /boot/u04/oradata/ORCL_2/archivelog/1_145_747684876.dbf
Identified End-Of-Redo for thread 1 sequence 145
Resetting standby activation ID 0 (0x0)
Media Recovery End-Of-Redo indicator encountered
Media Recovery Applied until change 862948
MRP0: Media Recovery Complete: End-Of-REDO (orcl_2)
MRP0: Background Media Recovery process shutdown (orcl_2)
Switchover: Complete - Database shutdown required (orcl_2)
Completed: alter database commit to switchover to physical standby
Tue Jan 01 01:48:42 2002
Shutting down instance (abort)
License high water mark = 7
USER (ospid: 5024): terminating the instance
Instance terminated by USER, pid = 5024
Tue Jan 01 01:48:44 2002
Instance shutdown complete
Tue Jan 01 01:48:44 2002
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
SYS@primary/01-JAN-02>@standby_detail.sql
NAME UNIQUE OPEN_MODE FORCE ROLE LOG_MODE SWITCHOVER_STATUS MODE LEVEL
-------- -------- ---------- ----- -------- ---------- ------------------ ----- -----
ORCL orcl_1 READ WRITE YES PRIMARY ARCHIVELOG TO STANDBY AVAI
1 row selected.
Elapsed: 00:00:00.00
SYS@primary/01-JAN-02>SELECT COUNT(*) FROM V$SESSION WHERE USERNAME IS NOT NULL;
COUNT(*)
----------
1
1 row selected.
Elapsed: 00:00:00.03
SYS@primary/01-JAN-02>alter database commit to switchover to physical standby;
Database altered.
Elapsed: 00:00:35.37
SYS@standby1/2002-01-01 01:00:38>@standby_detail.sql
NAME UNIQUE OPEN_MODE FORCE ROLE LOG_MODE SWITCHOVER_STATUS MODE LEVEL
-------- -------- ---------- ----- -------- ---------- ------------------ ----- -----
ORCL orcl_2 READ ONLY YES PHYSICAL ARCHIVELOG NOT ALLOWED PER PER
WITH APPLY
1 row selected.
Elapsed: 00:00:00.00
SYS@standby1/2002-01-01 01:00:42>@standby_detail.sql
NAME UNIQUE OPEN_MODE FORCE ROLE LOG_MODE SWITCHOVER_STATUS MODE LEVEL
-------- -------- ---------- ----- -------- ---------- ------------------ ----- -----
ORCL orcl_2 READ ONLY YES PHYSICAL ARCHIVELOG TO PRIMARY PER PER
1 row selected.
Elapsed: 00:00:00.01
SYS@standby1/2002-01-01 01:03:44>alter database commit to switchover to primary;
Database altered.
Elapsed: 00:00:08.29
SYS@standby1/2002-01-01 01:04:30>@standby_detail.sql
NAME UNIQUE OPEN_MODE FORCE ROLE LOG_MODE SWITCHOVER_STATUS MODE LEVEL
-------- -------- ---------- ----- -------- ---------- ------------------ ----- -----
ORCL orcl_2 MOUNTED YES PRIMARY ARCHIVELOG NOT ALLOWED PER
1 row selected.
Elapsed: 00:00:00.01
SYS@primary/01-JAN-02>startup force
ORACLE instance started.
Total System Global Area 376635392 bytes
Fixed Size 1336652 bytes
Variable Size 327158452 bytes
Database Buffers 41943040 bytes
Redo Buffers 6197248 bytes
Database mounted.
Database opened.
SYS@primary/01-JAN-02>@standby_detail.sql
NAME UNIQUE OPEN_MODE FORCE ROLE LOG_MODE SWITCHOVER_STATUS MODE LEVEL
-------- -------- ---------- ----- -------- ---------- ------------------ ----- -----
ORCL orcl_1 READ ONLY YES PHYSICAL ARCHIVELOG TO PRIMARY AVAI AVAI
1 row selected.
Elapsed: 00:00:00.04
SYS@standby1/2002-01-01 01:13:24>alter database open;
Database altered.
Elapsed: 00:00:03.77
SYS@standby1/2002-01-01 01:13:36>@standby_detail.sql
NAME UNIQUE OPEN_MODE FORCE ROLE LOG_MODE SWITCHOVER_STATUS MODE LEVEL
-------- -------- ---------- ----- -------- ---------- ------------------ ----- -----
ORCL orcl_2 READ WRITE YES PRIMARY ARCHIVELOG TO STANDBY PER PER
1 row selected.
Elapsed: 00:00:00.01
SYS@standby1/2002-01-01 01:10:58>@log_file.sql
FILE TYPE GROUP SEQ SIZE MEM ARC ST
------------------------------------------------------------ ---------- ----- ---- ------ --- --- ----------
/boot/u03/oradata/ORCL_2/onlinelog/o1_mf_1_6sxqh2c1_.log ONLINE 1 143 512 3 NO CURRENT
/boot/u02/oradata/ORCL_2/onlinelog/o1_mf_1_6sxqh23t_.log ONLINE 1 143 512 3 NO CURRENT
/boot/u04/oradata/ORCL_2/onlinelog/o1_mf_1_6sxqh3nm_.log ONLINE 1 143 512 3 NO CURRENT
/boot/u02/oradata/ORCL_2/onlinelog/o1_mf_2_6sxqh5wx_.log ONLINE 2 0 512 3 YES UNUSED
/boot/u03/oradata/ORCL_2/onlinelog/o1_mf_2_6sxqh6b7_.log ONLINE 2 0 512 3 YES UNUSED
/boot/u04/oradata/ORCL_2/onlinelog/o1_mf_2_6sxqh8mn_.log ONLINE 2 0 512 3 YES UNUSED
/boot/u03/oradata/ORCL_2/onlinelog/o1_mf_3_6sxsc80d_.log ONLINE 3 0 512 3 YES UNUSED
/boot/u02/oradata/ORCL_2/onlinelog/o1_mf_3_6sxsc7m7_.log ONLINE 3 0 512 3 YES UNUSED
/boot/u04/oradata/ORCL_2/onlinelog/o1_mf_3_6sxscb5g_.log ONLINE 3 0 512 3 YES UNUSED
9 rows selected.
Elapsed: 00:00:00.00
SYS@standby1/2002-01-01 01:11:04>@managed_standby.sql
ST PROCE PID CLI_P CLIENT_DBID GROUP RESETLOG_ID THR SEQUENCE BLOCK BLOCKS
--------------- ----- ------ ----- ------------ ----- ----------- ---- -------- ------- -------
CLOSING ARCH 5014 ARCH 1275488545 4 747684876 1 141 1 29
CLOSING ARCH 5016 ARCH 1275488545 4 747684876 1 137 1 1482
CONNECTED ARCH 5018 ARCH 1275488545 N/A 0 0 0 0 0
CLOSING ARCH 5020 ARCH 1275488545 4 747684876 1 140 1 202
4 rows selected.
Elapsed: 00:00:00.01
SYS@standby1/2002-01-01 01:11:35>@archive_dest_status.sql
ID ST ARC_THR ARC_SEQ UNIQUE DESTINATION APP_THR APP_SEQ GAP_STATUS ERROR
---- ----- ------- ------- -------- -------------------- ------- ------- ---------- --------------------
1 VALID 1 141 NONE /boot/u02/oradata/OR 0 0
CL_2/archivelog
2 VALID 1 141 NONE /boot/u03/oradata/OR 0 0
CL_2/archivelog
3 VALID 1 141 NONE /boot/u04/oradata/OR 0 0
CL_2/archivelog
4 VALID 0 0 orcl_1 primary 0 0
4 rows selected.
Elapsed: 00:00:00.01
SYS@standby1/2002-01-01 01:13:38>alter system switch logfile;
System altered.
Elapsed: 00:00:00.55
SYS@standby1/2002-01-01 01:14:38>@log_file.sql
FILE TYPE GROUP SEQ SIZE MEM ARC ST
------------------------------------------------------------ ---------- ----- ---- ------ --- --- ----------
/boot/u02/oradata/ORCL_2/onlinelog/o1_mf_1_6sxqh23t_.log ONLINE 1 143 512 3 NO ACTIVE
/boot/u03/oradata/ORCL_2/onlinelog/o1_mf_1_6sxqh2c1_.log ONLINE 1 143 512 3 NO ACTIVE
/boot/u04/oradata/ORCL_2/onlinelog/o1_mf_1_6sxqh3nm_.log ONLINE 1 143 512 3 NO ACTIVE
/boot/u02/oradata/ORCL_2/onlinelog/o1_mf_2_6sxqh5wx_.log ONLINE 2 144 512 3 NO CURRENT
/boot/u03/oradata/ORCL_2/onlinelog/o1_mf_2_6sxqh6b7_.log ONLINE 2 144 512 3 NO CURRENT
/boot/u04/oradata/ORCL_2/onlinelog/o1_mf_2_6sxqh8mn_.log ONLINE 2 144 512 3 NO CURRENT
/boot/u02/oradata/ORCL_2/onlinelog/o1_mf_3_6sxsc7m7_.log ONLINE 3 0 512 3 YES UNUSED
/boot/u03/oradata/ORCL_2/onlinelog/o1_mf_3_6sxsc80d_.log ONLINE 3 0 512 3 YES UNUSED
/boot/u04/oradata/ORCL_2/onlinelog/o1_mf_3_6sxscb5g_.log ONLINE 3 0 512 3 YES UNUSED
9 rows selected.
Elapsed: 00:00:00.02
SYS@primary/01-JAN-02>@log_file.sql
FILE TYPE GROUP SEQ SIZE MEM ARC ST
------------------------------------------------------------ ---------- ----- ---- ------ --- --- ----------
/boot/u02/oradata/ORCL_1/onlinelog/o1_mf_1_6soypgvj_.log ONLINE 1 143 512 3 YES CLEARING
/boot/u03/oradata/ORCL_1/onlinelog/o1_mf_1_6soyph3t_.log ONLINE 1 143 512 3 YES CLEARING
/boot/u04/oradata/ORCL_1/onlinelog/o1_mf_1_6soypjgh_.log ONLINE 1 143 512 3 YES CLEARING
/boot/u02/oradata/ORCL_1/onlinelog/o1_mf_2_6sovhfc8_.log ONLINE 2 144 512 3 YES CLEARING_C
URRENT
/boot/u03/oradata/ORCL_1/onlinelog/o1_mf_2_6sovhfrz_.log ONLINE 2 144 512 3 YES CLEARING_C
URRENT
/boot/u04/oradata/ORCL_1/onlinelog/o1_mf_2_6sovhhr0_.log ONLINE 2 144 512 3 YES CLEARING_C
URRENT
/boot/u02/oradata/ORCL_1/onlinelog/o1_mf_3_6sxxhvhc_.log ONLINE 3 141 512 3 YES INACTIVE
/boot/u03/oradata/ORCL_1/onlinelog/o1_mf_3_6sxxhvtq_.log ONLINE 3 141 512 3 YES INACTIVE
/boot/u04/oradata/ORCL_1/onlinelog/o1_mf_3_6sxxhxw4_.log ONLINE 3 141 512 3 YES INACTIVE
9 rows selected.
Elapsed: 00:00:00.04
SYS@standby1/2002-01-01 01:17:24>show parameter log_archive_dest_4
NAME TYPE VALUE
------------------------------------ ---------- ------------------------------
log_archive_dest_4 string SERVICE=primary ARCH VALID_FOR
=(ONLINE_LOGFILE,PRIMARY_ROLE)
DB_UNIQUE_NAME=orcl_1
SYS@primary/01-JAN-02>@dataguard_status.sql
FACILITY MESSAGE SEVER TIMESTAMP CALLO
------------------------- ---------------------------------------- ----- -------------------- -----
Log Transport Services ARC0: Archival started infor 01-JAN-02 NO
Log Transport Services ARC1: Archival started infor 01-JAN-02 NO
Log Transport Services ARC2: Archival started infor 01-JAN-02 NO
Log Transport Services ARC1: Becoming the 'no FAL' ARCH infor 01-JAN-02 NO
Log Transport Services ARC1: Becoming the 'no SRL' ARCH infor 01-JAN-02 NO
Log Transport Services ARC2: Becoming the heartbeat ARCH infor 01-JAN-02 NO
Log Transport Services ARC3: Archival started infor 01-JAN-02 NO
Remote File Server RFS[1]: Assigned to RFS process 31672 infor 01-JAN-02 NO
Remote File Server RFS[1]: Identified database type as 'phy infor 01-JAN-02 NO
sical standby': Client is ARCH pid 5018
Remote File Server RFS[2]: Assigned to RFS process 10835 infor 01-JAN-02 NO
Remote File Server RFS[2]: Identified database type as 'phy infor 01-JAN-02 NO
sical standby': Client is ARCH pid 5014
Log Transport Services ARC3: Beginning to archive thread 1 sequ contr 01-JAN-02 YES
ence 143 (862018-862112)
Log Transport Services ARC3: Completed archiving thread 1 seque contr 01-JAN-02 YES
nce 143 (0-0)
Log Apply Services Attempt to start background Managed Stan contr 01-JAN-02 YES
dby Recovery process
Log Apply Services MRP0: Background Managed Standby Recover contr 01-JAN-02 YES
y process started
Log Apply Services Managed Standby Recovery not using Real infor 01-JAN-02 NO
Time Apply
Log Apply Services Clearing online redo logfile 1 /boot/u02 infor 01-JAN-02 NO
/oradata/ORCL_1/onlinelog/o1_mf_1_6soypg
vj_.log
Log Apply Services Clearing online redo logfile 1 complete infor 01-JAN-02 NO
Log Apply Services Clearing online redo logfile 2 /boot/u02 infor 01-JAN-02 NO
/oradata/ORCL_1/onlinelog/o1_mf_2_6sovhf
c8_.log
Log Apply Services Clearing online redo logfile 2 complete infor 01-JAN-02 NO
Log Apply Services Clearing online redo logfile 3 /boot/u02 infor 01-JAN-02 NO
/oradata/ORCL_1/onlinelog/o1_mf_3_6sxxhv
hc_.log
Log Apply Services Clearing online redo logfile 3 complete infor 01-JAN-02 NO
Log Apply Services Media Recovery Log /boot/u04/oradata/1_1 infor 01-JAN-02 NO
43_747684876.dbf
Log Apply Services Media Recovery Waiting for thread 1 sequ Warni 01-JAN-02 NO
ence 144 ng
24 rows selected.
SYS@standby1/2002-01-01 01:17:28>@dataguard_status.sql
FACILITY MESSAGE SEVER TIMESTAMP CALLO
------------------------- ---------------------------------------- ----- -------------------- -----
Log Transport Services ARC0: Archival started infor 2002-01-01 00:32:29 NO
Log Transport Services ARC1: Archival started infor 2002-01-01 00:32:29 NO
Log Transport Services ARC2: Archival started infor 2002-01-01 00:32:29 NO
Log Transport Services ARC1: Becoming the 'no FAL' ARCH infor 2002-01-01 00:32:29 NO
Log Transport Services ARC2: Becoming the heartbeat ARCH infor 2002-01-01 00:32:29 NO
Log Transport Services Error 1034 received logging on to the st Error 2002-01-01 00:32:29 YES
andby
Log Transport Services FAL[client, ARC2]: Error 1034 connecting Error 2002-01-01 00:32:29 YES
to primary for fetching gap sequence
Log Transport Services ARC3: Archival started infor 2002-01-01 00:32:30 NO
Remote File Server RFS[1]: Assigned to RFS process 5282 infor 2002-01-01 00:34:38 NO
Remote File Server RFS[1]: Identified database type as 'phy infor 2002-01-01 00:34:38 NO
sical standby': Client is ARCH pid 5254
Remote File Server RFS[2]: Assigned to RFS process 5284 infor 2002-01-01 00:34:39 NO
Remote File Server RFS[2]: Identified database type as 'phy infor 2002-01-01 00:34:39 NO
sical standby': Client is ARCH pid 5258
Log Transport Services ARC3: Beginning to archive thread 1 sequ contr 2002-01-01 00:34:39 YES
ence 135 (858261-860186)
Log Transport Services ARC3: Completed archiving thread 1 seque contr 2002-01-01 00:34:40 YES
nce 135 (0-0)
Log Transport Services ARC0: Beginning to archive thread 1 sequ contr 2002-01-01 00:34:41 YES
ence 136 (860186-860236)
Log Transport Services ARC0: Completed archiving thread 1 seque contr 2002-01-01 00:34:41 YES
nce 136 (0-0)
Remote File Server RFS[3]: Assigned to RFS process 5647 infor 2002-01-01 00:58:43 NO
Remote File Server RFS[3]: Identified database type as 'phy infor 2002-01-01 00:58:43 NO
sical standby': Client is ARCH pid 5635
Log Transport Services ARC1: Beginning to archive thread 1 sequ contr 2002-01-01 00:58:44 YES
ence 137 (860236-861633)
Log Transport Services ARC1: Completed archiving thread 1 seque contr 2002-01-01 00:58:44 YES
nce 137 (0-0)
Log Transport Services ARC3: Beginning to archive thread 1 sequ contr 2002-01-01 00:58:47 YES
ence 138 (861633-861672)
Log Transport Services ARC3: Completed archiving thread 1 seque contr 2002-01-01 00:58:48 YES
nce 138 (0-0)
Remote File Server RFS[4]: Assigned to RFS process 5708 infor 2002-01-01 00:59:33 NO
Remote File Server RFS[4]: Identified database type as 'phy infor 2002-01-01 00:59:33 NO
sical standby': Client is ARCH pid 5630
Log Transport Services ARC0: Beginning to archive thread 1 sequ contr 2002-01-01 00:59:34 YES
ence 139 (861672-861759)
Log Transport Services ARC0: Completed archiving thread 1 seque contr 2002-01-01 00:59:34 YES
nce 139 (0-0)
Log Apply Services Attempt to start background Managed Stan contr 2002-01-01 01:00:32 YES
dby Recovery process
Log Apply Services MRP0: Background Managed Standby Recover contr 2002-01-01 01:00:32 YES
y process started
Log Apply Services Managed Standby Recovery not using Real infor 2002-01-01 01:00:37 NO
Time Apply
Log Apply Services Media Recovery Log /boot/u04/oradata/ORC infor 2002-01-01 01:00:37 NO
L_2/archivelog/1_135_747684876.dbf
Log Apply Services Media Recovery Log /boot/u04/oradata/ORC infor 2002-01-01 01:00:37 NO
L_2/archivelog/1_136_747684876.dbf
Log Apply Services Media Recovery Log /boot/u04/oradata/ORC infor 2002-01-01 01:00:37 NO
L_2/archivelog/1_137_747684876.dbf
Log Apply Services Media Recovery Log /boot/u04/oradata/ORC infor 2002-01-01 01:00:37 NO
L_2/archivelog/1_138_747684876.dbf
FACILITY MESSAGE SEVER TIMESTAMP CALLO
------------------------- ---------------------------------------- ----- -------------------- -----
Log Apply Services Media Recovery Log /boot/u04/oradata/ORC infor 2002-01-01 01:00:38 NO
L_2/archivelog/1_139_747684876.dbf
Log Apply Services Media Recovery Waiting for thread 1 sequ Warni 2002-01-01 01:00:38 NO
ence 140 ng
Log Transport Services ARC3: Beginning to archive thread 1 sequ contr 2002-01-01 01:02:55 YES
ence 140 (861759-861967)
Log Transport Services ARC3: Completed archiving thread 1 seque contr 2002-01-01 01:02:55 YES
nce 140 (0-0)
Log Apply Services Media Recovery Log /boot/u04/oradata/ORC infor 2002-01-01 01:02:59 NO
L_2/archivelog/1_140_747684876.dbf
Log Apply Services Media Recovery Waiting for thread 1 sequ Warni 2002-01-01 01:02:59 NO
ence 141 ng
Remote File Server RFS[5]: Assigned to RFS process 5801 infor 2002-01-01 01:03:03 NO
Remote File Server RFS[5]: Identified database type as 'phy infor 2002-01-01 01:03:03 NO
sical standby': Client is ARCH pid 5635
Remote File Server RFS[6]: Assigned to RFS process 5822 infor 2002-01-01 01:03:14 NO
Remote File Server RFS[6]: Identified database type as 'phy infor 2002-01-01 01:03:14 NO
sical standby': Client is Foreground pid
5619
Log Transport Services ARC0: Beginning to archive thread 1 sequ contr 2002-01-01 01:03:14 YES
ence 141 (861967-862001)
Log Transport Services ARC0: Completed archiving thread 1 seque contr 2002-01-01 01:03:14 YES
nce 141 (0-0)
Remote File Server RFS[7]: Assigned to RFS process 5839 infor 2002-01-01 01:03:16 NO
Remote File Server RFS[7]: Identified database type as 'phy infor 2002-01-01 01:03:16 NO
sical standby': Client is Foreground pid
5619
Remote File Server RFS[8]: Assigned to RFS process 5841 infor 2002-01-01 01:03:17 NO
Remote File Server RFS[8]: Identified database type as 'phy infor 2002-01-01 01:03:17 NO
sical standby': Client is Foreground pid
5619
Log Apply Services Media Recovery Log /boot/u04/oradata/ORC infor 2002-01-01 01:03:19 NO
L_2/archivelog/1_141_747684876.dbf
Log Apply Services Media Recovery Log /boot/u02/oradata/ORC infor 2002-01-01 01:03:19 NO
L_2/archivelog/1_142_747684876.dbf
Log Apply Services Resetting standby activation ID 12754160 infor 2002-01-01 01:03:19 NO
75 (0x4c054e0b)
Log Apply Services MRP0: Media Recovery Complete: End-Of-RE contr 2002-01-01 01:03:19 YES
DO
Log Apply Services MRP0: Background Media Recovery process contr 2002-01-01 01:03:19 YES
shutdown
Role Management Services ALTER DATABASE SWITCHOVER TO PRIMARY contr 2002-01-01 01:04:22 YES
Log Transport Services ARC1: Becoming the 'no SRL' ARCH infor 2002-01-01 01:04:30 NO
Log Transport Services ARC4: Archival started infor 2002-01-01 01:14:30 NO
Log Transport Services ARC3: Beginning to archive thread 1 sequ contr 2002-01-01 01:14:41 YES
ence 143 (862018-862112)
Log Transport Services ARC3: Completed archiving thread 1 seque contr 2002-01-01 01:14:45 YES
nce 143 (862018-862112)
Log Transport Services ARC0: Standby redo logfile selected for Warni 2002-01-01 01:14:52 NO
thread 1 sequence 143 for destination LO ng
G_ARCHIVE_DEST_4
Log Transport Services ARCH shutting down infor 2002-01-01 01:15:30 NO
Log Transport Services ARC4: Archival stopped infor 2002-01-01 01:15:30 NO
62 rows selected.
Elapsed: 00:00:00.03
SYS@standby2/01-JAN-02>@dataguard_status.sql
FACILITY MESSAGE SEVER TIMESTAMP CALLO
------------------------- ---------------------------------------- ----- -------------------- -----
Log Transport Services ARC0: Archival started infor 01-JAN-02 NO
Log Transport Services ARC1: Archival started infor 01-JAN-02 NO
Log Transport Services ARC2: Archival started infor 01-JAN-02 NO
Log Transport Services ARC1: Becoming the 'no FAL' ARCH infor 01-JAN-02 NO
Log Transport Services ARC2: Becoming the heartbeat ARCH infor 01-JAN-02 NO
Log Transport Services ARC3: Archival started infor 01-JAN-02 NO
6 rows selected.
Elapsed: 00:00:00.00
SYS@standby2/01-JAN-02>@standby_detail.sql
NAME UNIQUE OPEN_MODE FORCE ROLE LOG_MODE SWITCHOVER_STATUS MODE LEVEL
-------- -------- ---------- ----- -------- ---------- ------------------ ----- -----
ORCL orcl_3 READ ONLY YES PHYSICAL ARCHIVELOG TO PRIMARY PER PER
1 row selected.
Elapsed: 00:00:00.00
SYS@standby1/2002-01-01 01:44:37>@standby_detail.sql
NAME UNIQUE OPEN_MODE FORCE ROLE LOG_MODE SWITCHOVER_STATUS MODE LEVEL
-------- -------- ---------- ----- -------- ---------- ------------------ ----- -----
ORCL orcl_2 READ WRITE YES PRIMARY ARCHIVELOG TO STANDBY PER PER
1 row selected.
Elapsed: 00:00:00.02
SYS@standby1/2002-01-01 01:46:10>alter database commit to switchover to physical standby;
Database altered.
Elapsed: 00:00:22.07
SYS@primary/01-JAN-02>@standby_detail.sql
NAME UNIQUE OPEN_MODE FORCE ROLE LOG_MODE SWITCHOVER_STATUS MODE LEVEL
-------- -------- ---------- ----- -------- ---------- ------------------ ----- -----
ORCL orcl_1 READ ONLY YES PHYSICAL ARCHIVELOG NOT ALLOWED AVAI AVAI
WITH APPLY
1 row selected.
Elapsed: 00:00:00.00
SYS@primary/01-JAN-02>@standby_detail.sql
NAME UNIQUE OPEN_MODE FORCE ROLE LOG_MODE SWITCHOVER_STATUS MODE LEVEL
-------- -------- ---------- ----- -------- ---------- ------------------ ----- -----
ORCL orcl_1 READ ONLY YES PHYSICAL ARCHIVELOG TO PRIMARY AVAI AVAI
1 row selected.
Elapsed: 00:00:00.00
SYS@primary/01-JAN-02>alter database commit to switchover to primary;
Database altered.
Elapsed: 00:00:00.10
SYS@primary/01-JAN-02>@standby_detail.sql
NAME UNIQUE OPEN_MODE FORCE ROLE LOG_MODE SWITCHOVER_STATUS MODE LEVEL
-------- -------- ---------- ----- -------- ---------- ------------------ ----- -----
ORCL orcl_1 MOUNTED YES PRIMARY ARCHIVELOG NOT ALLOWED AVAI
1 row selected.
Elapsed: 00:00:00.02
SYS@standby1/2002-01-01 01:48:36>startup force
ORACLE instance started.
Total System Global Area 376635392 bytes
Fixed Size 1336652 bytes
Variable Size 310381236 bytes
Database Buffers 58720256 bytes
Redo Buffers 6197248 bytes
Database mounted.
Database opened.
SYS@standby1/01-JAN-02>@standby_detail.sql
NAME UNIQUE OPEN_MODE FORCE ROLE LOG_MODE SWITCHOVER_STATUS MODE LEVEL
-------- -------- ---------- ----- -------- ---------- ------------------ ----- -----
ORCL orcl_2 READ ONLY YES PHYSICAL ARCHIVELOG TO PRIMARY PER PER
1 row selected.
Elapsed: 00:00:00.26
SYS@primary/01-JAN-02>@standby_detail.sql
NAME UNIQUE OPEN_MODE FORCE ROLE LOG_MODE SWITCHOVER_STATUS MODE LEVEL
-------- -------- ---------- ----- -------- ---------- ------------------ ----- -----
ORCL orcl_1 MOUNTED YES PRIMARY ARCHIVELOG NOT ALLOWED AVAI
1 row selected.
Elapsed: 00:00:00.02
SYS@primary/01-JAN-02>alter database open;
Database altered.
Elapsed: 00:00:13.28
SYS@primary/01-JAN-02>@standby_detail.sql
NAME UNIQUE OPEN_MODE FORCE ROLE LOG_MODE SWITCHOVER_STATUS MODE LEVEL
-------- -------- ---------- ----- -------- ---------- ------------------ ----- -----
ORCL orcl_1 READ WRITE YES PRIMARY ARCHIVELOG TO STANDBY AVAI
1 row selected.
Elapsed: 00:00:00.08
SYS@primary/01-JAN-02>
SYS@standby2/01-JAN-02>recover managed standby database disconnect;
Media recovery complete.
SYS@standby2/01-JAN-02>@dataguard_status.sql
FACILITY MESSAGE SEVER TIMESTAMP CALLO
------------------------- ---------------------------------------- ----- -------------------- -----
Log Transport Services ARC0: Archival started infor 01-JAN-02 NO
Log Transport Services ARC1: Archival started infor 01-JAN-02 NO
Log Transport Services ARC2: Archival started infor 01-JAN-02 NO
Log Transport Services ARC1: Becoming the 'no FAL' ARCH infor 01-JAN-02 NO
Log Transport Services ARC2: Becoming the heartbeat ARCH infor 01-JAN-02 NO
Log Transport Services ARC3: Archival started infor 01-JAN-02 NO
Remote File Server RFS[1]: Assigned to RFS process 18934 infor 01-JAN-02 NO
Remote File Server RFS[1]: Identified database type as 'phy infor 01-JAN-02 NO
sical standby': Client is ARCH pid 6228
Remote File Server RFS[2]: Assigned to RFS process 18952 infor 01-JAN-02 NO
Remote File Server RFS[2]: Identified database type as 'phy infor 01-JAN-02 NO
sical standby': Client is LGWR ASYNC pid
18932
Remote File Server Primary database is in MAXIMUM PERFORMAN infor 01-JAN-02 NO
CE mode
Remote File Server RFS[3]: Assigned to RFS process 18956 infor 01-JAN-02 NO
Remote File Server RFS[3]: Identified database type as 'phy infor 01-JAN-02 NO
sical standby': Client is ARCH pid 6222
Remote File Server RFS[4]: Assigned to RFS process 18969 infor 01-JAN-02 NO
Remote File Server RFS[4]: Identified database type as 'phy infor 01-JAN-02 NO
sical standby': Client is ARCH pid 6228
Log Transport Services ARC3: Beginning to archive thread 1 sequ contr 01-JAN-02 YES
ence 147 (862951-862980)
Log Transport Services ARC0: Beginning to archive thread 1 sequ contr 01-JAN-02 YES
ence 146 (862948-862951)
Remote File Server RFS[5]: Assigned to RFS process 18975 infor 01-JAN-02 NO
Remote File Server RFS[5]: Identified database type as 'phy infor 01-JAN-02 NO
sical standby': Client is ARCH pid 6230
Log Transport Services ARC3: Completed archiving thread 1 seque contr 01-JAN-02 YES
nce 147 (0-0)
Log Transport Services ARC0: Completed archiving thread 1 seque contr 01-JAN-02 YES
nce 146 (0-0)
Log Apply Services Attempt to start background Managed Stan contr 01-JAN-02 YES
dby Recovery process
Log Apply Services MRP0: Background Managed Standby Recover contr 01-JAN-02 YES
y process started
Log Apply Services Managed Standby Recovery not using Real infor 01-JAN-02 NO
Time Apply
Log Apply Services Media Recovery Log /boot/u02/oradata/ORC infor 01-JAN-02 NO
L_3/archivelog/1_143_747684876.dbf
Log Apply Services Media Recovery Log /boot/u02/oradata/ORC infor 01-JAN-02 NO
L_3/archivelog/1_144_747684876.dbf
Log Apply Services Media Recovery Log /boot/u02/oradata/ORC infor 01-JAN-02 NO
L_3/archivelog/1_145_747684876.dbf
Log Apply Services Resetting standby activation ID 97781634 infor 01-JAN-02 NO
5 (0x3a484b19)
Log Apply Services Media Recovery archivelogs detected beyo Warni 01-JAN-02 NO
nd End-Of-REDO ng
Log Apply Services MRP0: Media Recovery Complete: End-Of-RE contr 01-JAN-02 YES
DO
Log Apply Services MRP0: Background Media Recovery process contr 01-JAN-02 YES
shutdown
31 rows selected.
Elapsed: 00:00:00.01
SYS@standby2/01-JAN-02>
SYS@primary/01-JAN-02>@dataguard_status.sql
FACILITY MESSAGE SEVER TIMESTAMP CALLO
------------------------- ---------------------------------------- ----- -------------------- -----
Log Transport Services ARC0: Archival started infor 01-JAN-02 NO
Log Transport Services ARC1: Archival started infor 01-JAN-02 NO
Log Transport Services ARC2: Archival started infor 01-JAN-02 NO
Log Transport Services ARC1: Becoming the 'no FAL' ARCH infor 01-JAN-02 NO
Log Transport Services ARC1: Becoming the 'no SRL' ARCH infor 01-JAN-02 NO
Log Transport Services ARC2: Becoming the heartbeat ARCH infor 01-JAN-02 NO
Log Transport Services ARC3: Archival started infor 01-JAN-02 NO
Remote File Server RFS[1]: Assigned to RFS process 31672 infor 01-JAN-02 NO
Remote File Server RFS[1]: Identified database type as 'phy infor 01-JAN-02 NO
sical standby': Client is ARCH pid 5018
Remote File Server RFS[2]: Assigned to RFS process 10835 infor 01-JAN-02 NO
Remote File Server RFS[2]: Identified database type as 'phy infor 01-JAN-02 NO
sical standby': Client is ARCH pid 5014
Log Transport Services ARC3: Beginning to archive thread 1 sequ contr 01-JAN-02 YES
ence 143 (862018-862112)
Log Transport Services ARC3: Completed archiving thread 1 seque contr 01-JAN-02 YES
nce 143 (0-0)
Log Apply Services Attempt to start background Managed Stan contr 01-JAN-02 YES
dby Recovery process
Log Apply Services MRP0: Background Managed Standby Recover contr 01-JAN-02 YES
y process started
Log Apply Services Managed Standby Recovery not using Real infor 01-JAN-02 NO
Time Apply
Log Apply Services Clearing online redo logfile 1 /boot/u02 infor 01-JAN-02 NO
/oradata/ORCL_1/onlinelog/o1_mf_1_6soypg
vj_.log
Log Apply Services Clearing online redo logfile 1 complete infor 01-JAN-02 NO
Log Apply Services Clearing online redo logfile 2 /boot/u02 infor 01-JAN-02 NO
/oradata/ORCL_1/onlinelog/o1_mf_2_6sovhf
c8_.log
Log Apply Services Clearing online redo logfile 2 complete infor 01-JAN-02 NO
Log Apply Services Clearing online redo logfile 3 /boot/u02 infor 01-JAN-02 NO
/oradata/ORCL_1/onlinelog/o1_mf_3_6sxxhv
hc_.log
Log Apply Services Clearing online redo logfile 3 complete infor 01-JAN-02 NO
Log Apply Services Media Recovery Log /boot/u04/oradata/1_1 infor 01-JAN-02 NO
43_747684876.dbf
Log Apply Services Media Recovery Waiting for thread 1 sequ Warni 01-JAN-02 NO
ence 144 ng
Remote File Server RFS[3]: Assigned to RFS process 18767 infor 01-JAN-02 NO
Remote File Server RFS[3]: Identified database type as 'phy infor 01-JAN-02 NO
sical standby': Client is ARCH pid 5020
Log Transport Services ARC1: Beginning to archive thread 1 sequ contr 01-JAN-02 YES
ence 144 (862112-862937)
Remote File Server RFS[4]: Assigned to RFS process 18769 infor 01-JAN-02 NO
Remote File Server RFS[4]: Identified database type as 'phy infor 01-JAN-02 NO
sical standby': Client is ARCH pid 5018
Log Transport Services ARC1: Completed archiving thread 1 seque contr 01-JAN-02 YES
nce 144 (0-0)
Log Apply Services Media Recovery Log /boot/u04/oradata/1_1 infor 01-JAN-02 NO
44_747684876.dbf
Log Apply Services Media Recovery Waiting for thread 1 sequ Warni 01-JAN-02 NO
ence 145 ng
Remote File Server RFS[5]: Assigned to RFS process 18790 infor 01-JAN-02 NO
Remote File Server RFS[5]: Identified database type as 'phy infor 01-JAN-02 NO
sical standby': Client is Foreground pid
5024
Remote File Server RFS[6]: Assigned to RFS process 18792 infor 01-JAN-02 NO
Remote File Server RFS[6]: Identified database type as 'phy infor 01-JAN-02 NO
FACILITY MESSAGE SEVER TIMESTAMP CALLO
------------------------- ---------------------------------------- ----- -------------------- -----
sical standby': Client is Foreground pid
5024
Log Apply Services Media Recovery Log /boot/u02/oradata/1_1 infor 01-JAN-02 NO
45_747684876.dbf
Log Apply Services Resetting standby activation ID 97781634 infor 01-JAN-02 NO
5 (0x3a484b19)
Log Apply Services MRP0: Media Recovery Complete: End-Of-RE contr 01-JAN-02 YES
DO
Log Apply Services MRP0: Background Media Recovery process contr 01-JAN-02 YES
shutdown
Role Management Services ALTER DATABASE SWITCHOVER TO PRIMARY contr 01-JAN-02 YES
Log Transport Services ARC3: Becoming the 'no SRL' ARCH infor 01-JAN-02 NO
Log Transport Services ARC0: Becoming the 'no SRL' ARCH infor 01-JAN-02 NO
Log Transport Services ARC1: Becoming the 'no SRL' ARCH infor 01-JAN-02 NO
Log Transport Services ARC0: Beginning to archive thread 1 sequ contr 01-JAN-02 YES
ence 146 (862948-862951)
Log Transport Services ARC0: Completed archiving thread 1 seque contr 01-JAN-02 YES
nce 146 (862948-862951)
Log Transport Services ARC0: Beginning to archive thread 1 sequ contr 01-JAN-02 YES
ence 147 (862951-862980)
Log Transport Services ARC0: Completed archiving thread 1 seque contr 01-JAN-02 YES
nce 147 (862951-862980)
Log Transport Services ARC3: Standby redo logfile selected for Warni 01-JAN-02 NO
thread 1 sequence 146 for destination LO ng
G_ARCHIVE_DEST_4
Log Transport Services LNS: Standby redo logfile selected for t Warni 01-JAN-02 NO
hread 1 sequence 147 for destination LOG ng
_ARCHIVE_DEST_5
Log Transport Services LNS: Beginning to archive log 2 thread 1 contr 01-JAN-02 YES
sequence 147
Log Transport Services LNS: Completed archiving log 2 thread 1 contr 01-JAN-02 YES
sequence 147
Log Transport Services ARC0: Standby redo logfile selected for Warni 01-JAN-02 NO
thread 1 sequence 146 for destination LO ng
G_ARCHIVE_DEST_5
Log Transport Services ARC3: Standby redo logfile selected for Warni 01-JAN-02 NO
thread 1 sequence 147 for destination LO ng
G_ARCHIVE_DEST_4
Log Transport Services LNS: Standby redo logfile selected for t Warni 01-JAN-02 NO
hread 1 sequence 148 for destination LOG ng
_ARCHIVE_DEST_5
Log Transport Services LNS: Beginning to archive log 3 thread 1 contr 01-JAN-02 YES
sequence 148
Log Transport Services ARC4: Archival started infor 01-JAN-02 NO
Log Transport Services ARCH shutting down infor 01-JAN-02 NO
Log Transport Services ARC4: Archival stopped infor 01-JAN-02 NO
59 rows selected.
Elapsed: 00:00:00.05
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /boot/u01/app/oracle/product/11.2.0/db_1/dbs/spfileorcl_1.ora
System parameters with non-default values:
processes = 150
nls_language = "AMERICAN"
nls_territory = "CHINA"
memory_target = 360M
control_files = "/boot/u02/oradata/ORCL_1/controlfile/o1_mf_6sot5rdl_.ctl"
control_files = "/boot/u03/oradata/ORCL_1/controlfile/o1_mf_6sot5rlk_.ctl"
control_files = "/boot/u04/oradata/ORCL_1/controlfile/o1_mf_6sot5rrh_.ctl"
control_files = "/boot/u05/oradata/ORCL_1/controlfile/o1_mf_6sot5s15_.ctl"
db_file_name_convert = "/boot/u02/oradata/ORCL_2/datafile"
db_file_name_convert = "/boot/u02/oradata/ORCL_1/datafile"
log_file_name_convert = "/boot/u02/oradata/ORCL_2/onlinelog"
log_file_name_convert = "/boot/u02/oradata/ORCL_1/onlinelog"
log_file_name_convert = "/boot/u03/oradata/ORCL_2/onlinelog"
log_file_name_convert = "/boot/u03/oradata/ORCL_1/onlinelog"
log_file_name_convert = "/boot/u04/oradata/ORCL_2/onlinelog"
log_file_name_convert = "/boot/u04/oradata/ORCL_1/onlinelog"
log_file_name_convert = "/boot/u05/oradata/ORCL_2/onlinelog"
log_file_name_convert = "/boot/u05/oradata/ORCL_1/onlinelog"
db_block_size = 8192
compatible = "11.2.0.0.0"
log_archive_dest_1 = "LOCATION=/boot/u02/oradata"
log_archive_dest_2 = "LOCATION=/boot/u03/oradata"
log_archive_dest_3 = "LOCATION=/boot/u04/oradata"
log_archive_dest_4 = "service=standby1 arch valid_for=(online_logfile,primary_role) db_unique_name=orcl_2"
log_archive_dest_5 = "service=standby2 lgwr async valid_for=(online_logfile,primary_role) db_unique_name=orcl_3"
log_archive_dest_state_4 = "ENABLE"
log_archive_dest_state_5 = "ENABLE"
fal_client = "primary"
fal_server = "standby1"
log_archive_config = "dg_config=(orcl_1,orcl_2,orcl_3)"
log_archive_format = "%t_%s_%r.dbf"
db_create_file_dest = "/boot/u02/oradata"
db_create_online_log_dest_1= "/boot/u02/oradata"
db_create_online_log_dest_2= "/boot/u03/oradata"
db_create_online_log_dest_3= "/boot/u04/oradata"
db_create_online_log_dest_4= "/boot/u05/oradata"
db_recovery_file_dest = "/boot/u03/recovery_area"
db_recovery_file_dest_size= 8G
standby_file_management = "auto"
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
audit_file_dest = "/boot/u01/app/oracle/admin/orcl/adump"
audit_trail = "DB"
db_name = "orcl"
db_unique_name = "orcl_1"
open_cursors = 300
diagnostic_dest = "/boot/u01/app/oracle"
Tue Jan 01 00:55:07 2002
PMON started with pid=2, OS id=5556
Tue Jan 01 00:55:07 2002
VKTM started with pid=3, OS id=5558 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Tue Jan 01 00:55:07 2002
GEN0 started with pid=4, OS id=5562
Tue Jan 01 00:55:07 2002
DIAG started with pid=5, OS id=5564
Tue Jan 01 00:55:07 2002
DBRM started with pid=6, OS id=5566
Tue Jan 01 00:55:07 2002
PSP0 started with pid=7, OS id=5568
Tue Jan 01 00:55:07 2002
DIA0 started with pid=8, OS id=5570
Tue Jan 01 00:55:07 2002
MMAN started with pid=9, OS id=5572
Tue Jan 01 00:55:07 2002
DBW0 started with pid=10, OS id=5574
Tue Jan 01 00:55:07 2002
LGWR started with pid=11, OS id=5576
Tue Jan 01 00:55:07 2002
CKPT started with pid=12, OS id=5578
Tue Jan 01 00:55:07 2002
SMON started with pid=13, OS id=5580
Tue Jan 01 00:55:07 2002
RECO started with pid=14, OS id=5582
Tue Jan 01 00:55:08 2002
MMON started with pid=15, OS id=5584
Tue Jan 01 00:55:08 2002
MMNL started with pid=16, OS id=5586
ORACLE_BASE from environment = /boot/u01/app/oracle
Tue Jan 01 00:55:08 2002
ALTER DATABASE MOUNT
Successful mount of redo thread 1, with mount id 977788268
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Tue Jan 01 00:58:42 2002
alter database open
Tue Jan 01 00:58:42 2002
LGWR: STARTING ARCH PROCESSES
Tue Jan 01 00:58:42 2002
ARC0 started with pid=18, OS id=5630
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
LGWR: Primary database is in MAXIMUM AVAILABILITY mode
LGWR: Destination LOG_ARCHIVE_DEST_5 is using asynchronous network I/O
LGWR: Destination LOG_ARCHIVE_DEST_4 is not serviced by LGWR
LGWR: Destination LOG_ARCHIVE_DEST_3 is not serviced by LGWR
LGWR: Destination LOG_ARCHIVE_DEST_2 is not serviced by LGWR
LGWR: Destination LOG_ARCHIVE_DEST_1 is not serviced by LGWR
Thread 1 advanced to log sequence 138 (thread open)
Tue Jan 01 00:58:43 2002
ARC1 started with pid=19, OS id=5633
Thread 1 opened at log sequence 138
Current log# 3 seq# 138 mem# 0: /boot/u02/oradata/ORCL_1/onlinelog/o1_mf_3_6sxxhvhc_.log
Current log# 3 seq# 138 mem# 1: /boot/u03/oradata/ORCL_1/onlinelog/o1_mf_3_6sxxhvtq_.log
Current log# 3 seq# 138 mem# 2: /boot/u04/oradata/ORCL_1/onlinelog/o1_mf_3_6sxxhxw4_.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Jan 01 00:58:43 2002
SMON: enabling cache recovery
Tue Jan 01 00:58:43 2002
ARC2 started with pid=20, OS id=5635
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
Tue Jan 01 00:58:43 2002
ARC3 started with pid=21, OS id=5637
Tue Jan 01 00:58:43 2002
NSA5 started with pid=22, OS id=5641
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Archived Log entry 555 added for thread 1 sequence 137 ID 0x4c054e0b dest 1:
Archived Log entry 556 added for thread 1 sequence 137 ID 0x4c054e0b dest 2:
Archived Log entry 557 added for thread 1 sequence 137 ID 0x4c054e0b dest 3:
Database Characterset is ZHS16GBK
No Resource Manager plan active
ARC2: Standby redo logfile selected for thread 1 sequence 137 for destination LOG_ARCHIVE_DEST_4
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Tue Jan 01 00:58:44 2002
QMNC started with pid=23, OS id=5649
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_5
******************************************************************
Thread 1 advanced to log sequence 139 (LGWR switch)
Current log# 1 seq# 139 mem# 0: /boot/u02/oradata/ORCL_1/onlinelog/o1_mf_1_6soypgvj_.log
Current log# 1 seq# 139 mem# 1: /boot/u03/oradata/ORCL_1/onlinelog/o1_mf_1_6soyph3t_.log
Current log# 1 seq# 139 mem# 2: /boot/u04/oradata/ORCL_1/onlinelog/o1_mf_1_6soypjgh_.log
ARC0: STARTING ARCH PROCESSES
LNS: Standby redo logfile selected for thread 1 sequence 138 for destination LOG_ARCHIVE_DEST_5
Tue Jan 01 00:58:46 2002
ARC4 started with pid=24, OS id=5668
Completed: alter database open
Archived Log entry 559 added for thread 1 sequence 138 ID 0x4c054e0b dest 1:
Archived Log entry 560 added for thread 1 sequence 138 ID 0x4c054e0b dest 2:
Archived Log entry 561 added for thread 1 sequence 138 ID 0x4c054e0b dest 3:
LNS: Standby redo logfile selected for thread 1 sequence 139 for destination LOG_ARCHIVE_DEST_5
ARC2: Standby redo logfile selected for thread 1 sequence 138 for destination LOG_ARCHIVE_DEST_4
Tue Jan 01 00:58:47 2002
db_recovery_file_dest_size of 8192 MB is 6.87% 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.
ARC4: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC3: Standby redo logfile selected for thread 1 sequence 137 for destination LOG_ARCHIVE_DEST_5
Tue Jan 01 00:59:33 2002
Thread 1 advanced to log sequence 140 (LGWR switch)
Current log# 2 seq# 140 mem# 0: /boot/u02/oradata/ORCL_1/onlinelog/o1_mf_2_6sovhfc8_.log
Current log# 2 seq# 140 mem# 1: /boot/u03/oradata/ORCL_1/onlinelog/o1_mf_2_6sovhfrz_.log
Current log# 2 seq# 140 mem# 2: /boot/u04/oradata/ORCL_1/onlinelog/o1_mf_2_6sovhhr0_.log
Tue Jan 01 00:59:33 2002
Shutting down archive processes
Tue Jan 01 00:59:33 2002
ARCH shutting down
ARC4: Archival stopped
Archived Log entry 566 added for thread 1 sequence 139 ID 0x4c054e0b dest 1:
Archived Log entry 567 added for thread 1 sequence 139 ID 0x4c054e0b dest 2:
Archived Log entry 568 added for thread 1 sequence 139 ID 0x4c054e0b dest 3:
Tue Jan 01 00:59:34 2002
LNS: Standby redo logfile selected for thread 1 sequence 140 for destination LOG_ARCHIVE_DEST_5
Tue Jan 01 00:59:34 2002
ARC0: Standby redo logfile selected for thread 1 sequence 139 for destination LOG_ARCHIVE_DEST_4
Tue Jan 01 01:02:48 2002
alter database commit to switchover to physical standby
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY [Process Id: 5619] (orcl_1)
Tue Jan 01 01:02:49 2002
Thread 1 cannot allocate new log, sequence 141
Checkpoint not complete
Current log# 2 seq# 140 mem# 0: /boot/u02/oradata/ORCL_1/onlinelog/o1_mf_2_6sovhfc8_.log
Current log# 2 seq# 140 mem# 1: /boot/u03/oradata/ORCL_1/onlinelog/o1_mf_2_6sovhfrz_.log
Current log# 2 seq# 140 mem# 2: /boot/u04/oradata/ORCL_1/onlinelog/o1_mf_2_6sovhhr0_.log
Thread 1 advanced to log sequence 141 (LGWR switch)
Current log# 3 seq# 141 mem# 0: /boot/u02/oradata/ORCL_1/onlinelog/o1_mf_3_6sxxhvhc_.log
Current log# 3 seq# 141 mem# 1: /boot/u03/oradata/ORCL_1/onlinelog/o1_mf_3_6sxxhvtq_.log
Current log# 3 seq# 141 mem# 2: /boot/u04/oradata/ORCL_1/onlinelog/o1_mf_3_6sxxhxw4_.log
Waiting for all non-current ORLs to be archived...
Waiting for the ORL for thread 1 sequence 140 to be archived...
Tue Jan 01 01:02:55 2002
ARC0: Standby redo logfile selected for thread 1 sequence 140 for destination LOG_ARCHIVE_DEST_4
Archived Log entry 571 added for thread 1 sequence 140 ID 0x4c054e0b dest 1:
Archived Log entry 572 added for thread 1 sequence 140 ID 0x4c054e0b dest 2:
Archived Log entry 573 added for thread 1 sequence 140 ID 0x4c054e0b dest 3:
Tue Jan 01 01:03:03 2002
ORL for thread 1 sequence 140 has been archived...
All non-current ORLs have been archived.
Waiting for all FAL entries to be archived...
All FAL entries have been archived.
Waiting for potential switchover target to become synchronized...
Tue Jan 01 01:03:13 2002
Active, synchronized Physical Standby switchover target has been identified
Tue Jan 01 01:03:13 2002
Thread 1 cannot allocate new log, sequence 142
Checkpoint not complete
Current log# 3 seq# 141 mem# 0: /boot/u02/oradata/ORCL_1/onlinelog/o1_mf_3_6sxxhvhc_.log
Current log# 3 seq# 141 mem# 1: /boot/u03/oradata/ORCL_1/onlinelog/o1_mf_3_6sxxhvtq_.log
Current log# 3 seq# 141 mem# 2: /boot/u04/oradata/ORCL_1/onlinelog/o1_mf_3_6sxxhxw4_.log
Thread 1 advanced to log sequence 142 (LGWR switch)
Current log# 1 seq# 142 mem# 0: /boot/u02/oradata/ORCL_1/onlinelog/o1_mf_1_6soypgvj_.log
Current log# 1 seq# 142 mem# 1: /boot/u03/oradata/ORCL_1/onlinelog/o1_mf_1_6soyph3t_.log
Current log# 1 seq# 142 mem# 2: /boot/u04/oradata/ORCL_1/onlinelog/o1_mf_1_6soypjgh_.log
ARCH: Standby redo logfile selected for thread 1 sequence 141 for destination LOG_ARCHIVE_DEST_5
ARCH: Standby redo logfile selected for thread 1 sequence 141 for destination LOG_ARCHIVE_DEST_4
Archived Log entry 575 added for thread 1 sequence 141 ID 0x4c054e0b dest 1:
Archived Log entry 576 added for thread 1 sequence 141 ID 0x4c054e0b dest 2:
Archived Log entry 577 added for thread 1 sequence 141 ID 0x4c054e0b dest 3:
Tue Jan 01 01:03:14 2002
SMON: disabling tx recovery
Stopping background process QMNC
CLOSE: killing server sessions.
CLOSE: all sessions shutdown successfully.
SMON: disabling cache recovery
Shutting down archive processes
Archiving is disabled
Tue Jan 01 01:03:15 2002
ARCH shutting down
ARC3: Archival stopped
Tue Jan 01 01:03:15 2002
ARCH shutting down
ARC2: Archival stopped
Tue Jan 01 01:03:15 2002
ARCH shutting down
ARC1: Archival stopped
Tue Jan 01 01:03:15 2002
ARCH shutting down
ARC0: Archival stopped
Thread 1 closed at log sequence 142
Successful close of redo thread 1
ARCH: Noswitch archival of thread 1, sequence 142
ARCH: End-Of-Redo Branch archival of thread 1 sequence 142
Archived Log entry 580 added for thread 1 sequence 142 ID 0x4c054e0b dest 1:
Archived Log entry 581 added for thread 1 sequence 142 ID 0x4c054e0b dest 2:
Archived Log entry 582 added for thread 1 sequence 142 ID 0x4c054e0b dest 3:
ARCH: Archiving is disabled due to current logfile archival
Using STANDBY_ARCHIVE_DEST parameter default value as /boot/u02/oradata
Primary will check for some target standby to have received all redo
Final check for a synchronized target standby. Check will be made once.
LOG_ARCHIVE_DEST_4 is a potential Physical Standby switchover target
LOG_ARCHIVE_DEST_5 is a potential Physical Standby switchover target
Active, synchronized target has been identified
Target has also applied all redo
Backup controlfile written to trace file /boot/u01/app/oracle/diag/rdbms/orcl_1/orcl_1/trace/orcl_1_ora_5619.trc
Clearing standby activation ID 1275416075 (0x4c054e0b)
The primary database controlfile was created using the
'MAXLOGFILES 16' clause.
There is space for up to 13 standby redo logfiles
Use the following SQL commands on the standby database to create
standby redo logfiles that match the primary database:
ALTER DATABASE ADD STANDBY LOGFILE 'srl1.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE 104857600;
ALTER DATABASE ADD STANDBY LOGFILE 'srl4.f' SIZE 104857600;
ALTER DATABASE ADD STANDBY LOGFILE 'srl5.f' SIZE 104857600;
Archivelog for thread 1 sequence 142 required for standby recovery
Switchover: Primary controlfile converted to standby controlfile succesfully.
Tue Jan 01 01:03:17 2002
MRP0 started with pid=18, OS id=5845
MRP0: Background Managed Standby Recovery process started (orcl_1)
Serial Media Recovery started
Managed Standby Recovery not using Real Time Apply
Online logfile pre-clearing operation disabled by switchover
Media Recovery Log /boot/u04/oradata/1_142_747684876.dbf
Identified End-Of-Redo for thread 1 sequence 142
Resetting standby activation ID 0 (0x0)
Media Recovery End-Of-Redo indicator encountered
Media Recovery Applied until change 862018
MRP0: Media Recovery Complete: End-Of-REDO (orcl_1)
MRP0: Background Media Recovery process shutdown (orcl_1)
Tue Jan 01 01:03:23 2002
Switchover: Complete - Database shutdown required (orcl_1)
Completed: alter database commit to switchover to physical standby
Tue Jan 01 01:06:12 2002
alter database mount
Database in limbo -- Shutdown Required.
ORA-1100 signalled during: alter database mount...
alter database open
ORA-1507 signalled during: alter database open...
Tue Jan 01 01:06:30 2002
alter database mount
Database in limbo -- Shutdown Required.
ORA-1100 signalled during: alter database mount...
Shutting down instance (abort)
License high water mark = 2
USER (ospid: 5619): terminating the instance
Instance terminated by USER, pid = 5619
Tue Jan 01 01:06:36 2002
Instance shutdown complete
Tue Jan 01 01:06:36 2002
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
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.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /boot/u01/app/oracle/product/11.2.0/db_1/dbs/spfileorcl_2.ora
System parameters with non-default values:
processes = 150
nls_language = "AMERICAN"
nls_territory = "CHINA"
memory_target = 360M
control_files = "/boot/u02/oradata/ORCL_2/controlfile/standby01.ctl"
control_files = "/boot/u02/oradata/ORCL_2/controlfile/standby02.ctl"
control_files = "/boot/u02/oradata/ORCL_2/controlfile/standby03.ctl"
db_file_name_convert = "/boot/u02/oradata/ORCL_1/datafile"
db_file_name_convert = "/boot/u02/oradata/ORCL_2/datafile"
log_file_name_convert = "/boot/u02/oradata/ORCL_1/onlinelog"
log_file_name_convert = "/boot/u02/oradata/ORCL_2/onlinelog"
log_file_name_convert = "/boot/u03/oradata/ORCL_1/onlinelog"
log_file_name_convert = "/boot/u03/oradata/ORCL_2/onlinelog"
log_file_name_convert = "/boot/u04/oradata/ORCL_1/onlinelog"
log_file_name_convert = "/boot/u04/oradata/ORCL_2/onlinelog"
log_file_name_convert = "/boot/u05/oradata/ORCL_1/onlinelog"
log_file_name_convert = "/boot/u05/oradata/ORCL_2/onlinelog"
db_block_size = 8192
compatible = "11.2.0.0.0"
log_archive_dest_1 = "LOCATION=/boot/u02/oradata/ORCL_2/archivelog"
log_archive_dest_2 = "LOCATION=/boot/u03/oradata/ORCL_2/archivelog"
log_archive_dest_3 = "LOCATION=/boot/u04/oradata/ORCL_2/archivelog"
log_archive_dest_4 = "SERVICE=primary ARCH VALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl_1"
log_archive_dest_state_4 = "ENABLE"
fal_client = "standby1"
fal_server = "primary"
log_archive_config = "dg_config=(orcl_1,orcl_2)"
log_archive_format = "%t_%s_%r.dbf"
db_create_file_dest = "/boot/u02/oradata"
db_create_online_log_dest_1= "/boot/u02/oradata"
db_create_online_log_dest_2= "/boot/u03/oradata"
db_create_online_log_dest_3= "/boot/u04/oradata"
db_create_online_log_dest_4= "/boot/u05/oradata"
db_recovery_file_dest = "/boot/u03/recovery_area"
db_recovery_file_dest_size= 8G
standby_file_management = "auto"
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
audit_file_dest = "/boot/u01/app/oracle/admin/orcl/adump"
audit_trail = "DB"
db_name = "orcl"
db_unique_name = "orcl_2"
open_cursors = 300
diagnostic_dest = "/boot/u01/app/oracle"
Tue Jan 01 00:32:24 2002
PMON started with pid=2, OS id=4946
Tue Jan 01 00:32:24 2002
VKTM started with pid=3, OS id=4948 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Tue Jan 01 00:32:24 2002
GEN0 started with pid=4, OS id=4952
Tue Jan 01 00:32:24 2002
DIAG started with pid=5, OS id=4954
Tue Jan 01 00:32:24 2002
DBRM started with pid=6, OS id=4956
Tue Jan 01 00:32:24 2002
PSP0 started with pid=7, OS id=4958
Tue Jan 01 00:32:24 2002
DIA0 started with pid=8, OS id=4960
Tue Jan 01 00:32:24 2002
MMAN started with pid=9, OS id=4962
Tue Jan 01 00:32:24 2002
DBW0 started with pid=10, OS id=4964
Tue Jan 01 00:32:24 2002
LGWR started with pid=11, OS id=4966
Tue Jan 01 00:32:24 2002
CKPT started with pid=12, OS id=4968
Tue Jan 01 00:32:24 2002
SMON started with pid=13, OS id=4970
Tue Jan 01 00:32:24 2002
RECO started with pid=14, OS id=4972
Tue Jan 01 00:32:24 2002
MMON started with pid=15, OS id=4976
Tue Jan 01 00:32:24 2002
MMNL started with pid=16, OS id=4978
ORACLE_BASE from environment = /boot/u01/app/oracle
Tue Jan 01 00:32:24 2002
ALTER DATABASE MOUNT
ARCH: STARTING ARCH PROCESSES
Tue Jan 01 00:32:29 2002
ARC0 started with pid=18, OS id=5014
ARC0: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Successful mount of redo thread 1, with mount id 977816345
Physical Standby Database mounted.
Lost write protection disabled
Tue Jan 01 00:32:29 2002
ARC1 started with pid=19, OS id=5016
Tue Jan 01 00:32:29 2002
ARC2 started with pid=20, OS id=5018
Tue Jan 01 00:32:29 2002
ARC3 started with pid=21, OS id=5020
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC2: Becoming the heartbeat ARCH
Completed: ALTER DATABASE MOUNT
Tue Jan 01 00:32:29 2002
ALTER DATABASE OPEN
AUDIT_TRAIL initialization parameter is changed to OS, as DB is NOT compatible for database opened with read-only access
SMON: enabling cache recovery
Error 1034 received logging on to the standby
FAL[client, ARC2]: Error 1034 connecting to primary for fetching gap sequence
Errors in file /boot/u01/app/oracle/diag/rdbms/orcl_2/orcl_2/trace/orcl_2_arc2_5018.trc:
ORA-01034: ORACLE not available
Errors in file /boot/u01/app/oracle/diag/rdbms/orcl_2/orcl_2/trace/orcl_2_arc2_5018.trc:
ORA-01034: ORACLE not available
Dictionary check beginning
Dictionary check complete
Database Characterset is ZHS16GBK
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Physical standby database opened for read only access.
Completed: ALTER DATABASE OPEN
Tue Jan 01 00:32:30 2002
db_recovery_file_dest_size of 8192 MB is 0.00% 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.
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Tue Jan 01 00:34:38 2002
Using STANDBY_ARCHIVE_DEST parameter default value as /boot/u02/oradata/ORCL_2/archivelog
RFS[1]: Assigned to RFS process 5282
RFS[1]: Identified database type as 'physical standby': Client is ARCH pid 5254
Tue Jan 01 00:34:39 2002
RFS[2]: Assigned to RFS process 5284
RFS[2]: Identified database type as 'physical standby': Client is ARCH pid 5258
RFS[2]: Selected log 4 for thread 1 sequence 135 dbid 1275488545 branch 747684876
Tue Jan 01 00:34:40 2002
Archived Log entry 39 added for thread 1 sequence 135 ID 0x4c054e0b dest 1:
Archived Log entry 40 added for thread 1 sequence 135 ID 0x4c054e0b dest 2:
Archived Log entry 41 added for thread 1 sequence 135 ID 0x4c054e0b dest 3:
RFS[2]: Selected log 4 for thread 1 sequence 136 dbid 1275488545 branch 747684876
Tue Jan 01 00:34:41 2002
Archived Log entry 42 added for thread 1 sequence 136 ID 0x4c054e0b dest 1:
Archived Log entry 43 added for thread 1 sequence 136 ID 0x4c054e0b dest 2:
Archived Log entry 44 added for thread 1 sequence 136 ID 0x4c054e0b dest 3:
Tue Jan 01 00:58:43 2002
RFS[3]: Assigned to RFS process 5647
RFS[3]: Identified database type as 'physical standby': Client is ARCH pid 5635
RFS[3]: Selected log 4 for thread 1 sequence 137 dbid 1275488545 branch 747684876
Tue Jan 01 00:58:44 2002
Archived Log entry 45 added for thread 1 sequence 137 ID 0x4c054e0b dest 1:
Archived Log entry 46 added for thread 1 sequence 137 ID 0x4c054e0b dest 2:
Archived Log entry 47 added for thread 1 sequence 137 ID 0x4c054e0b dest 3:
RFS[3]: Selected log 4 for thread 1 sequence 138 dbid 1275488545 branch 747684876
Tue Jan 01 00:58:47 2002
Archived Log entry 48 added for thread 1 sequence 138 ID 0x4c054e0b dest 1:
Archived Log entry 49 added for thread 1 sequence 138 ID 0x4c054e0b dest 2:
Archived Log entry 50 added for thread 1 sequence 138 ID 0x4c054e0b dest 3:
Tue Jan 01 00:59:33 2002
RFS[4]: Assigned to RFS process 5708
RFS[4]: Identified database type as 'physical standby': Client is ARCH pid 5630
RFS[4]: Selected log 4 for thread 1 sequence 139 dbid 1275488545 branch 747684876
Tue Jan 01 00:59:34 2002
Archived Log entry 51 added for thread 1 sequence 139 ID 0x4c054e0b dest 1:
Archived Log entry 52 added for thread 1 sequence 139 ID 0x4c054e0b dest 2:
Archived Log entry 53 added for thread 1 sequence 139 ID 0x4c054e0b dest 3:
Tue Jan 01 01:00:32 2002
ALTER DATABASE RECOVER managed standby database disconnect
Attempt to start background Managed Standby Recovery process (orcl_2)
Tue Jan 01 01:00:32 2002
MRP0 started with pid=24, OS id=5743
MRP0: Background Managed Standby Recovery process started (orcl_2)
started logmerger process
Tue Jan 01 01:00:37 2002
Managed Standby Recovery not using 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 /boot/u04/oradata/ORCL_2/archivelog/1_135_747684876.dbf
Media Recovery Log /boot/u04/oradata/ORCL_2/archivelog/1_136_747684876.dbf
Media Recovery Log /boot/u04/oradata/ORCL_2/archivelog/1_137_747684876.dbf
Media Recovery Log /boot/u04/oradata/ORCL_2/archivelog/1_138_747684876.dbf
Media Recovery Log /boot/u04/oradata/ORCL_2/archivelog/1_139_747684876.dbf
Completed: ALTER DATABASE RECOVER managed standby database disconnect
Media Recovery Waiting for thread 1 sequence 140
Tue Jan 01 01:02:55 2002
RFS[4]: Selected log 4 for thread 1 sequence 140 dbid 1275488545 branch 747684876
Tue Jan 01 01:02:55 2002
Archived Log entry 54 added for thread 1 sequence 140 ID 0x4c054e0b dest 1:
Archived Log entry 55 added for thread 1 sequence 140 ID 0x4c054e0b dest 2:
Archived Log entry 56 added for thread 1 sequence 140 ID 0x4c054e0b dest 3:
Tue Jan 01 01:02:59 2002
Media Recovery Log /boot/u04/oradata/ORCL_2/archivelog/1_140_747684876.dbf
Media Recovery Waiting for thread 1 sequence 141
Tue Jan 01 01:03:03 2002
RFS[5]: Assigned to RFS process 5801
RFS[5]: Identified database type as 'physical standby': Client is ARCH pid 5635
Tue Jan 01 01:03:14 2002
RFS[6]: Assigned to RFS process 5822
RFS[6]: Identified database type as 'physical standby': Client is Foreground pid 5619
RFS[6]: Selected log 4 for thread 1 sequence 141 dbid 1275488545 branch 747684876
Tue Jan 01 01:03:14 2002
Archived Log entry 57 added for thread 1 sequence 141 ID 0x4c054e0b dest 1:
Archived Log entry 58 added for thread 1 sequence 141 ID 0x4c054e0b dest 2:
Archived Log entry 59 added for thread 1 sequence 141 ID 0x4c054e0b dest 3:
Tue Jan 01 01:03:16 2002
RFS[7]: Assigned to RFS process 5839
RFS[7]: Identified database type as 'physical standby': Client is Foreground pid 5619
RFS[7]: Opened log for thread 1 sequence 142 dbid 1275488545 branch 747684876
Archived Log entry 60 added for thread 1 sequence 142 rlc 747684876 ID 0x4c054e0b dest 4:
Tue Jan 01 01:03:17 2002
RFS[8]: Assigned to RFS process 5841
RFS[8]: Identified database type as 'physical standby': Client is Foreground pid 5619
Tue Jan 01 01:03:19 2002
Media Recovery Log /boot/u04/oradata/ORCL_2/archivelog/1_141_747684876.dbf
Media Recovery Log /boot/u02/oradata/ORCL_2/archivelog/1_142_747684876.dbf
Identified End-Of-Redo for thread 1 sequence 142
Resetting standby activation ID 1275416075 (0x4c054e0b)
Media Recovery End-Of-Redo indicator encountered
Media Recovery Applied until change 862018
Tue Jan 01 01:03:19 2002
MRP0: Media Recovery Complete: End-Of-REDO (orcl_2)
MRP0: Background Media Recovery process shutdown (orcl_2)
Tue Jan 01 01:04:22 2002
alter database commit to switchover to primary
ALTER DATABASE SWITCHOVER TO PRIMARY (orcl_2)
Maximum wait for role transition is 15 minutes.
CLOSE: killing server sessions.
CLOSE: all sessions shutdown successfully.
Tue Jan 01 01:04:22 2002
SMON: disabling cache recovery
Backup controlfile written to trace file /boot/u01/app/oracle/diag/rdbms/orcl_2/orcl_2/trace/orcl_2_ora_5024.trc
SwitchOver after complete recovery through change 862018
Online log /boot/u02/oradata/ORCL_2/onlinelog/o1_mf_1_6sxqh23t_.log: Thread 1 Group 1 was previously cleared
Online log /boot/u03/oradata/ORCL_2/onlinelog/o1_mf_1_6sxqh2c1_.log: Thread 1 Group 1 was previously cleared
Online log /boot/u04/oradata/ORCL_2/onlinelog/o1_mf_1_6sxqh3nm_.log: Thread 1 Group 1 was previously cleared
Online log /boot/u02/oradata/ORCL_2/onlinelog/o1_mf_2_6sxqh5wx_.log: Thread 1 Group 2 was previously cleared
Online log /boot/u03/oradata/ORCL_2/onlinelog/o1_mf_2_6sxqh6b7_.log: Thread 1 Group 2 was previously cleared
Online log /boot/u04/oradata/ORCL_2/onlinelog/o1_mf_2_6sxqh8mn_.log: Thread 1 Group 2 was previously cleared
Online log /boot/u02/oradata/ORCL_2/onlinelog/o1_mf_3_6sxsc7m7_.log: Thread 1 Group 3 was previously cleared
Online log /boot/u03/oradata/ORCL_2/onlinelog/o1_mf_3_6sxsc80d_.log: Thread 1 Group 3 was previously cleared
Online log /boot/u04/oradata/ORCL_2/onlinelog/o1_mf_3_6sxscb5g_.log: Thread 1 Group 3 was previously cleared
Standby became primary SCN: 862016
Switchover: Complete - Database mounted as primary
Tue Jan 01 01:04:30 2002
ARC1: Becoming the 'no SRL' ARCH
Completed: alter database commit to switchover to primary
Tue Jan 01 01:13:32 2002
alter database open
Tue Jan 01 01:13:32 2002
Assigning activation ID 977816345 (0x3a484b19)
Thread 1 opened at log sequence 143
Current log# 1 seq# 143 mem# 0: /boot/u02/oradata/ORCL_2/onlinelog/o1_mf_1_6sxqh23t_.log
Current log# 1 seq# 143 mem# 1: /boot/u03/oradata/ORCL_2/onlinelog/o1_mf_1_6sxqh2c1_.log
Current log# 1 seq# 143 mem# 2: /boot/u04/oradata/ORCL_2/onlinelog/o1_mf_1_6sxqh3nm_.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Jan 01 01:13:32 2002
SMON: enabling cache recovery
Successfully onlined Undo Tablespace 2.
Dictionary check beginning
Dictionary check complete
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Starting background process SMCO
Database Characterset is ZHS16GBK
Tue Jan 01 01:13:33 2002
SMCO started with pid=22, OS id=31720
No Resource Manager plan active
Starting background process QMNC
Tue Jan 01 01:13:35 2002
QMNC started with pid=23, OS id=31831
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete
Completed: alter database open
Tue Jan 01 01:14:29 2002
ARC2: STARTING ARCH PROCESSES
Tue Jan 01 01:14:29 2002
ARC4 started with pid=27, OS id=9835
ARC4: Archival started
ARC2: STARTING ARCH PROCESSES COMPLETE
Tue Jan 01 01:14:38 2002
Thread 1 advanced to log sequence 144 (LGWR switch)
Current log# 2 seq# 144 mem# 0: /boot/u02/oradata/ORCL_2/onlinelog/o1_mf_2_6sxqh5wx_.log
Current log# 2 seq# 144 mem# 1: /boot/u03/oradata/ORCL_2/onlinelog/o1_mf_2_6sxqh6b7_.log
Current log# 2 seq# 144 mem# 2: /boot/u04/oradata/ORCL_2/onlinelog/o1_mf_2_6sxqh8mn_.log
Tue Jan 01 01:14:44 2002
Archived Log entry 61 added for thread 1 sequence 143 ID 0x3a484b19 dest 1:
Archived Log entry 62 added for thread 1 sequence 143 ID 0x3a484b19 dest 2:
Archived Log entry 63 added for thread 1 sequence 143 ID 0x3a484b19 dest 3:
Tue Jan 01 01:14:52 2002
ARC0: Standby redo logfile selected for thread 1 sequence 143 for destination LOG_ARCHIVE_DEST_4
Tue Jan 01 01:15:30 2002
Shutting down archive processes
Tue Jan 01 01:15:30 2002
ARCH shutting down
ARC4: Archival stopped
Tue Jan 01 01:47:32 2002
alter database commit to switchover to physical standby
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY [Process Id: 5024] (orcl_2)
Tue Jan 01 01:47:34 2002
Thread 1 advanced to log sequence 145 (LGWR switch)
Current log# 3 seq# 145 mem# 0: /boot/u02/oradata/ORCL_2/onlinelog/o1_mf_3_6sxsc7m7_.log
Current log# 3 seq# 145 mem# 1: /boot/u03/oradata/ORCL_2/onlinelog/o1_mf_3_6sxsc80d_.log
Current log# 3 seq# 145 mem# 2: /boot/u04/oradata/ORCL_2/onlinelog/o1_mf_3_6sxscb5g_.log
Tue Jan 01 01:47:34 2002
ARC3: Standby redo logfile selected for thread 1 sequence 144 for destination LOG_ARCHIVE_DEST_4
Archived Log entry 65 added for thread 1 sequence 144 ID 0x3a484b19 dest 1:
Archived Log entry 66 added for thread 1 sequence 144 ID 0x3a484b19 dest 2:
Archived Log entry 67 added for thread 1 sequence 144 ID 0x3a484b19 dest 3:
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Waiting for all FAL entries to be archived...
All FAL entries have been archived.
Waiting for potential switchover target to become synchronized...
Tue Jan 01 01:47:45 2002
Active, synchronized Physical Standby switchover target has been identified
Tue Jan 01 01:47:45 2002
SMON: disabling tx recovery
Stopping background process QMNC
CLOSE: killing server sessions.
CLOSE: all sessions shutdown successfully.
Stopping background process SMCO
SMON: disabling cache recovery
Tue Jan 01 01:47:47 2002
Shutting down archive processes
Archiving is disabled
Tue Jan 01 01:47:47 2002
ARCH shutting down
ARC3: Archival stopped
Tue Jan 01 01:47:47 2002
ARCH shutting down
ARC2: Archival stopped
Tue Jan 01 01:47:47 2002
ARCH shutting down
ARC1: Archival stopped
Tue Jan 01 01:47:47 2002
ARCH shutting down
ARC0: Archival stopped
Thread 1 closed at log sequence 145
Successful close of redo thread 1
ARCH: Noswitch archival of thread 1, sequence 145
ARCH: End-Of-Redo Branch archival of thread 1 sequence 145
Archived Log entry 69 added for thread 1 sequence 145 ID 0x3a484b19 dest 1:
Archived Log entry 70 added for thread 1 sequence 145 ID 0x3a484b19 dest 2:
Archived Log entry 71 added for thread 1 sequence 145 ID 0x3a484b19 dest 3:
ARCH: Archiving is disabled due to current logfile archival
Primary will check for some target standby to have received all redo
Final check for a synchronized target standby. Check will be made once.
LOG_ARCHIVE_DEST_4 is a potential Physical Standby switchover target
Active, synchronized target has been identified
Target has also applied all redo
Backup controlfile written to trace file /boot/u01/app/oracle/diag/rdbms/orcl_2/orcl_2/trace/orcl_2_ora_5024.trc
Clearing standby activation ID 977816345 (0x3a484b19)
The primary database controlfile was created using the
'MAXLOGFILES 16' clause.
There is space for up to 13 standby redo logfiles
Use the following SQL commands on the standby database to create
standby redo logfiles that match the primary database:
ALTER DATABASE ADD STANDBY LOGFILE 'srl1.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE 104857600;
ALTER DATABASE ADD STANDBY LOGFILE 'srl4.f' SIZE 104857600;
ALTER DATABASE ADD STANDBY LOGFILE 'srl5.f' SIZE 104857600;
Archivelog for thread 1 sequence 145 required for standby recovery
Switchover: Primary controlfile converted to standby controlfile succesfully.
Tue Jan 01 01:47:48 2002
MRP0 started with pid=18, OS id=18794
MRP0: Background Managed Standby Recovery process started (orcl_2)
Serial Media Recovery started
Managed Standby Recovery not using Real Time Apply
Online logfile pre-clearing operation disabled by switchover
Media Recovery Log /boot/u04/oradata/ORCL_2/archivelog/1_145_747684876.dbf
Identified End-Of-Redo for thread 1 sequence 145
Resetting standby activation ID 0 (0x0)
Media Recovery End-Of-Redo indicator encountered
Media Recovery Applied until change 862948
MRP0: Media Recovery Complete: End-Of-REDO (orcl_2)
MRP0: Background Media Recovery process shutdown (orcl_2)
Switchover: Complete - Database shutdown required (orcl_2)
Completed: alter database commit to switchover to physical standby
Tue Jan 01 01:48:42 2002
Shutting down instance (abort)
License high water mark = 7
USER (ospid: 5024): terminating the instance
Instance terminated by USER, pid = 5024
Tue Jan 01 01:48:44 2002
Instance shutdown complete
Tue Jan 01 01:48:44 2002
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/24890594/viewspace-692018/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
