ITPub博客

首页 > Linux操作系统 > Linux操作系统 > dataguard switchover 过程及示例

dataguard switchover 过程及示例

原创 Linux操作系统 作者:xpj0515 时间:2011-04-09 15:15:36 0 删除 编辑
参考文章   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



来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24890594/viewspace-692018/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-11-08

  • 博文量
    32
  • 访问量
    55173