new_standby.3012.log

Mon Dec 29 21:48:19 2014
SWITCHOVER VERIFY: Send VERIFY request to switchover target cdb0
SWITCHOVER VERIFY COMPLETE
ALTER DATABASE SWITCHOVER TO 'cdb0'
Mon Dec 29 21:48:21 2014
Starting switchover [Process ID: 6478]
Mon Dec 29 21:48:21 2014
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY [Process Id: 6478] (CDB1)
Waiting for target standby to receive all redo
Mon Dec 29 21:48:21 2014
Waiting for all non-current ORLs to be archived...
Mon Dec 29 21:48:21 2014
All non-current ORLs have been archived.
Mon Dec 29 21:48:21 2014
Waiting for all FAL entries to be archived...
Mon Dec 29 21:48:21 2014
All FAL entries have been archived.
Mon Dec 29 21:48:21 2014
Waiting for dest_id 2 to become synchronized...
Mon Dec 29 21:48:22 2014
Active, synchronized Physical Standby switchover target has been identified
Preventing updates and queries at the Primary
Generating and shipping final logs to target standby
Switchover End-Of-Redo Log thread 1 sequence 17 has been fixed
Switchover: Primary highest seen SCN set to 0x0.0x1e936f
ARCH: Noswitch archival of thread 1, sequence 17
ARCH: End-Of-Redo Branch archival of thread 1 sequence 17
ARCH: LGWR is actively archiving destination LOG_ARCHIVE_DEST_2
ARCH: Standby redo logfile selected for thread 1 sequence 17 for destination LOG_ARCHIVE_DEST_2
ARCH: Archiving is disabled due to current logfile archival
Primary will check for some target standby to have received all redo
Waiting for target standby to apply all redo
Backup controlfile written to trace file /u01/app/oracle/diag/rdbms/cdb1/CDB1/trace/CDB1_rsm0_6478.trc
Converting the primary database to a new standby database
Clearing standby activation ID 890606658 (0x35159442)
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 52428800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl4.f' SIZE 52428800;
Archivelog for thread 1 sequence 17 required for standby recovery
Switchover: Primary controlfile converted to standby controlfile succesfully.
Switchover: Complete - Database shutdown required
Sending request(convert to primary database) to switchover target cdb0
Switchover complete. Database shutdown required
Completed: ALTER DATABASE SWITCHOVER TO 'cdb0'
Target standby cdb0 did not have Active Data Guard enabled at the time of switchover.
To maintain Active Data Guard license compliance Block Change Tracking will be disabled.
Mon Dec 29 21:48:31 2014
Clusterware restarting instance for Data Guard Broker operation; shutting down instance now
DMON (ospid: 5740): terminating the instance
Mon Dec 29 21:48:31 2014
Instance terminated by DMON, pid = 5740
Mon Dec 29 21:48:39 2014
Starting ORACLE instance (normal) (OS id: 6607)
Mon Dec 29 21:48:39 2014
CLI notifier numLatches:3 maxDescs:519
Mon Dec 29 21:48:39 2014
**********************************************************************
Mon Dec 29 21:48:39 2014
Dump of system resources acquired for SHARED GLOBAL AREA (SGA)

Mon Dec 29 21:48:39 2014
 Per process system memlock (soft) limit = UNLIMITED
Mon Dec 29 21:48:39 2014
 Expected per process system memlock (soft) limit to lock
 SHARED GLOBAL AREA (SGA) into memory: 612M
Mon Dec 29 21:48:39 2014
 Available system pagesizes:
  4K, 2048K
Mon Dec 29 21:48:39 2014
 Supported system pagesize(s):
Mon Dec 29 21:48:39 2014
  PAGESIZE  AVAILABLE_PAGES  EXPECTED_PAGES  ALLOCATED_PAGES  ERROR(s)
Mon Dec 29 21:48:39 2014
        4K       Configured          156676          156676        NONE
Mon Dec 29 21:48:39 2014
 Reason for not supporting certain system pagesizes:
Mon Dec 29 21:48:39 2014
  2048K - Dynamic allocate and free memory regions
Mon Dec 29 21:48:39 2014
**********************************************************************
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 1
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =51
LICENSE_MAX_USERS = 0
SYS auditing is enabled
NOTE: remote asm mode is local (mode 0x1; from cluster type)
NOTE: Using default ASM root directory ASM
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options.
ORACLE_HOME = /u01/app/12.1.0.2/db
System name:    Linux
Node name:      ol6twsa1
Release:        3.8.13-44.1.4.el6uek.x86_64
Version:        #2 SMP Wed Oct 29 23:58:06 PDT 2014
Machine:        x86_64
Using parameter settings in server-side spfile /u01/app/12.1.0.2/db/dbs/spfileCDB1.ora
System parameters with non-default values:
  processes                = 300
  memory_target            = 612M
  control_files            = "+DATA/CDB1/CONTROLFILE/current.267.867162943"
  control_files            = "+FRA/CDB1/CONTROLFILE/current.258.867162945"
  db_block_size            = 8192
  compatible               = "12.1.0.2"
  log_archive_dest_1       = "location=USE_DB_RECOVERY_FILE_DEST"
  log_archive_dest_1       = "valid_for=(ALL_LOGFILES, ALL_ROLES)"
  log_archive_dest_2       = "service="cdb0""
  log_archive_dest_2       = "ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name="cdb0" net_timeout=30"
  log_archive_dest_2       = "valid_for=(online_logfile,all_roles)"
  log_archive_dest_state_2 = "ENABLE"
  log_archive_min_succeed_dest= 1
  fal_client               = "CDB1"
  fal_server               = "CDB0"
  log_archive_trace        = 0
  log_archive_config       = "dg_config=(CDB0,CDB1)"
  log_archive_format       = "%t_%s_%r.dbf"
  log_archive_max_processes= 4
  archive_lag_target       = 0
  db_create_file_dest      = "+DATA"
  db_recovery_file_dest    = "+FRA"
  db_recovery_file_dest_size= 4560M
  standby_file_management  = "AUTO"
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=CDB0XDB)"
  audit_file_dest          = "/u01/app/oracle/admin/CDB0/adump"
  audit_trail              = "DB"
  db_name                  = "CDB0"
  db_unique_name           = "CDB1"
  open_cursors             = 300
  dg_broker_start          = TRUE
  diagnostic_dest          = "/u01/app/oracle"
NOTE: remote asm mode is local (mode 0x1; from cluster type)
Starting background process PMON
Starting background process PSP0
Mon Dec 29 21:48:43 2014
PMON started with pid=2, OS id=6612
Starting background process VKTM
Mon Dec 29 21:48:43 2014
PSP0 started with pid=3, OS id=6614
Mon Dec 29 21:48:44 2014
VKTM started with pid=4, OS id=6616 at elevated (RT) priority
Mon Dec 29 21:48:44 2014
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Mon Dec 29 21:48:44 2014
Warning: VKTM detected a time drift.
Time drifts can result in an unexpected behavior such as time-outs. Please check trace file for more details.
Starting background process GEN0
Starting background process MMAN
Mon Dec 29 21:48:44 2014
GEN0 started with pid=5, OS id=6620
Mon Dec 29 21:48:44 2014
MMAN started with pid=6, OS id=6622
Starting background process DIAG
Starting background process DBRM
Mon Dec 29 21:48:45 2014
DIAG started with pid=7, OS id=6626
Starting background process VKRM
Mon Dec 29 21:48:45 2014
DBRM started with pid=8, OS id=6628
Starting background process DIA0
Mon Dec 29 21:48:45 2014
VKRM started with pid=9, OS id=6630
Starting background process DBW0
Mon Dec 29 21:48:45 2014
DIA0 started with pid=10, OS id=6632
Starting background process LGWR
Mon Dec 29 21:48:45 2014
DBW0 started with pid=11, OS id=6634
Starting background process CKPT
Mon Dec 29 21:48:45 2014
LGWR started with pid=12, OS id=6636
Starting background process SMON
Mon Dec 29 21:48:45 2014
CKPT started with pid=13, OS id=6638
Starting background process RECO
Mon Dec 29 21:48:45 2014
SMON started with pid=14, OS id=6640
Starting background process LREG
Mon Dec 29 21:48:45 2014
RECO started with pid=15, OS id=6642
Starting background process PXMN
Mon Dec 29 21:48:45 2014
LREG started with pid=16, OS id=6644
Starting background process RBAL
Mon Dec 29 21:48:45 2014
PXMN started with pid=17, OS id=6646
Starting background process ASMB
Mon Dec 29 21:48:45 2014
RBAL started with pid=18, OS id=6648
Starting background process MMON
Mon Dec 29 21:48:45 2014
ASMB started with pid=19, OS id=6650
Starting background process MMNL
Mon Dec 29 21:48:45 2014
MMON started with pid=20, OS id=6652
Mon Dec 29 21:48:45 2014
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Dec 29 21:48:45 2014
MMNL started with pid=21, OS id=6656
starting up 1 shared server(s) ...
Instance started by oraagent
Starting background process DMON
ORACLE_BASE from environment = /u01/app/oracle
Mon Dec 29 21:48:45 2014
DMON started with pid=24, OS id=6662
Mon Dec 29 21:48:45 2014
NOTE: ASMB registering with ASM instance as Standard client 0xffffffffffffffff (reg:2193446493) (new connection)
NOTE: ASMB connected to ASM instance +ASM osid: 6654 (Flex mode; client id 0xffffffffffffffff)
NOTE: initiating MARK startup
Starting background process MARK
Mon Dec 29 21:48:45 2014
MARK started with pid=26, OS id=6666
Mon Dec 29 21:48:45 2014
NOTE: MARK has subscribed
Mon Dec 29 21:48:45 2014
ALTER SYSTEM SET local_listener=' (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.77)(PORT=1521))' SCOPE=MEMORY SID='CDB1';
ALTER DATABASE MOUNT /* db agent *//* {0:0:2875} */
Mon Dec 29 21:48:48 2014
NOTE: ASMB mounting group 1 (DATA)
NOTE: Assigning number (1,0) to disk (/dev/asm-disk1)
SUCCESS: mounted group 1 (DATA)
NOTE: grp 1 disk 0: DATA_0000 path:/dev/asm-disk1
Mon Dec 29 21:48:48 2014
NOTE: dependency between database CDB1 and diskgroup resource ora.DATA.dg is established
Mon Dec 29 21:48:48 2014
NOTE: ASMB mounting group 2 (FRA)
NOTE: Assigning number (2,0) to disk (/dev/asm-disk2)
SUCCESS: mounted group 2 (FRA)
NOTE: grp 2 disk 0: FRA_0000 path:/dev/asm-disk2
Mon Dec 29 21:48:48 2014
Using default pga_aggregate_limit of 2048 MB
Mon Dec 29 21:48:48 2014
NOTE: dependency between database CDB1 and diskgroup resource ora.FRA.dg is established
Starting background process TMON
Mon Dec 29 21:48:54 2014
ARCH: STARTING ARCH PROCESSES
Starting background process ARC0
Mon Dec 29 21:48:54 2014
TMON started with pid=30, OS id=6688
Mon Dec 29 21:48:54 2014
ARC0 started with pid=31, OS id=6690
ARC0: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
Mon Dec 29 21:48:54 2014
ARC0: STARTING ARCH PROCESSES
Starting background process ARC1
Starting background process ARC2
Mon Dec 29 21:48:54 2014
ARC1 started with pid=32, OS id=6692
Starting background process ARC3
Mon Dec 29 21:48:54 2014
ARC2 started with pid=33, OS id=6694
ARC1: Archival started
ARC2: Archival started
Mon Dec 29 21:48:54 2014
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC1: Thread not mounted
Mon Dec 29 21:48:54 2014
ARC2: Becoming the heartbeat ARCH
Mon Dec 29 21:48:54 2014
ARC3 started with pid=34, OS id=6696
Mon Dec 29 21:48:54 2014
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Thread not mounted
Mon Dec 29 21:48:54 2014
ARC3: Thread not mounted
Mon Dec 29 21:48:54 2014
ARC2: Thread not mounted
Mon Dec 29 21:48:54 2014
Network Resource Management enabled for Process LGWR (pid 6636) for Exadata I/O
Successful mount of redo thread 1, with mount id 891055426
Mon Dec 29 21:48:54 2014
Physical Standby Database mounted.
Lost write protection disabled
Mon Dec 29 21:48:55 2014
Archiving previously deferred ORLs (CDB1)
ARCH: End-Of-Redo Branch archival of thread 1 sequence 17
Mon Dec 29 21:48:56 2014
Archived Log entry 15 added for thread 1 sequence 17 ID 0x35159442 dest 1:
Completed: ALTER DATABASE MOUNT /* db agent *//* {0:0:2875} */
Mon Dec 29 21:49:01 2014
Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST
Network Resource Management enabled for Process  (pid 6707) for Exadata I/O
Primary database is in MAXIMUM PERFORMANCE mode
RFS[1]: Assigned to RFS process (PID:6707)
RFS[1]: Selected log 4 for thread 1 sequence 20 dbid 890600873 branch 867160237
Mon Dec 29 21:49:02 2014
RFS[2]: Assigned to RFS process (PID:6709)
RFS[2]: Opened log for thread 1 sequence 19 dbid 890600873 branch 867160237
Mon Dec 29 21:49:03 2014
RFS[3]: Assigned to RFS process (PID:6715)
RFS[3]: Opened log for thread 1 sequence 18 dbid 890600873 branch 867160237
Mon Dec 29 21:49:03 2014
Archived Log entry 16 added for thread 1 sequence 19 rlc 867160237 ID 0x351be1b0 dest 2:
Mon Dec 29 21:49:03 2014
Starting Data Guard Broker (DMON)
Starting background process INSV
Mon Dec 29 21:49:03 2014
INSV started with pid=39, OS id=6717
Mon Dec 29 21:49:03 2014
Archived Log entry 17 added for thread 1 sequence 18 rlc 867160237 ID 0x351be1b0 dest 2:
RFS[1]: Selected log 5 for thread 1 sequence 21 dbid 890600873 branch 867160237
Mon Dec 29 21:49:07 2014
Archived Log entry 18 added for thread 1 sequence 20 ID 0x351be1b0 dest 1:
Starting background process NSV1
Mon Dec 29 21:49:08 2014
NSV1 started with pid=40, OS id=6724
Starting background process RSM0
Mon Dec 29 21:49:12 2014
RSM0 started with pid=41, OS id=6726
Mon Dec 29 21:49:16 2014
Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST
Mon Dec 29 21:49:16 2014
ALTER SYSTEM SET log_archive_dest_2='' SCOPE=BOTH;
Mon Dec 29 21:49:16 2014
ARC2: Becoming the active heartbeat ARCH
Mon Dec 29 21:49:17 2014
ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=BOTH;
Mon Dec 29 21:49:17 2014
ALTER SYSTEM SET log_archive_trace=0 SCOPE=BOTH SID='CDB1';
Mon Dec 29 21:49:17 2014
ALTER SYSTEM SET log_archive_format='%t_%s_%r.dbf' SCOPE=SPFILE SID='CDB1';
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT  NODELAY
Mon Dec 29 21:49:17 2014
Attempt to start background Managed Standby Recovery process (CDB1)
Starting background process MRP0
Mon Dec 29 21:49:17 2014
MRP0 started with pid=42, OS id=6728
Mon Dec 29 21:49:17 2014
MRP0: Background Managed Standby Recovery process started (CDB1)
Mon Dec 29 21:49:22 2014
Serial Media Recovery started
Managed Standby Recovery starting Real Time Apply
Mon Dec 29 21:49:24 2014
Waiting for all non-current ORLs to be archived...
Mon Dec 29 21:49:24 2014
All non-current ORLs have been archived.
Clearing online redo logfile 1 +DATA/CDB1/ONLINELOG/group_1.273.867163065

Clearing online log 1 of thread 1 sequence number 15
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT  NODELAY
Clearing online redo logfile 1 complete
Clearing online redo logfile 2 +DATA/CDB1/ONLINELOG/group_2.263.867163071

Clearing online log 2 of thread 1 sequence number 16
Mon Dec 29 21:49:36 2014
Clearing online redo logfile 2 complete
Clearing online redo logfile 3 +DATA/CDB1/ONLINELOG/group_3.260.867163077

Clearing online log 3 of thread 1 sequence number 17
Clearing online redo logfile 3 complete
Mon Dec 29 21:49:41 2014
Media Recovery Log +FRA/CDB1/ARCHIVELOG/2014_12_29/thread_1_seq_17.276.867620937
Mon Dec 29 21:49:42 2014
Resetting standby activation ID 0 (0x0)
Mon Dec 29 21:49:43 2014
Media Recovery End-Of-Redo indicator encountered
Mon Dec 29 21:49:43 2014
Media Recovery Continuing
Mon Dec 29 21:49:43 2014
Media Recovery Log +FRA/CDB1/ARCHIVELOG/2014_12_29/thread_1_seq_18.278.867620943
Mon Dec 29 21:49:43 2014
Media Recovery Log +FRA/CDB1/ARCHIVELOG/2014_12_29/thread_1_seq_19.275.867620943
Mon Dec 29 21:49:45 2014
Media Recovery Log +FRA/CDB1/ARCHIVELOG/2014_12_29/thread_1_seq_20.277.867620947
Media Recovery Waiting for thread 1 sequence 21 (in transit)
Mon Dec 29 21:49:46 2014
Recovery of Online Redo Log: Thread 1 Group 5 Seq 21 Reading mem 0
  Mem# 0: +DATA/CDB1/ONLINELOG/group_5.271.867163083
  Mem# 1: +FRA/CDB1/ONLINELOG/group_5.260.867163085
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: