s1_CDB1_06072016

Wed Jul 06 08:57:05 2016
 Data Guard Broker: A failover will now be attempted
Wed Jul 06 08:57:05 2016
ALTER DATABASE FAILOVER TO CDB1
Wed Jul 06 08:57:05 2016
Terminal Recovery requested in process 3040
Terminal Recovery: Stopping real time apply
Wed Jul 06 08:57:05 2016
MRP0: Background Media Recovery cancelled with status 16037
Wed Jul 06 08:57:05 2016
Errors in file /u01/app/oracle/diag/rdbms/cdb1/CDB1/trace/CDB1_mrp0_3050.trc:
ORA-16037: user requested cancel of managed recovery operation
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!
Recovered data files to a consistent state at change 6023247
Wed Jul 06 08:57:06 2016
Errors in file /u01/app/oracle/diag/rdbms/cdb1/CDB1/trace/CDB1_mrp0_3050.trc:
ORA-16037: user requested cancel of managed recovery operation
Wed Jul 06 08:57:06 2016
MRP0: Background Media Recovery process shutdown (CDB1)
Wed Jul 06 08:57:06 2016
Terminal Recovery: Stopped real time apply
Wed Jul 06 08:57:06 2016
Attempt to do a Terminal Recovery (CDB1)
Wed Jul 06 08:57:06 2016
Media Recovery Start: Managed Standby Recovery (CDB1)
Wed Jul 06 08:57:06 2016
Serial Media Recovery started
Managed Standby Recovery not using Real Time Apply
Media Recovery Waiting for thread 1 sequence 140 (in transit)
Killing 3 processes (PIDS:3042,3044,3052) (all RFS, wait for I/O) in order to disallow current and future RFS connections. Requested by OS process 3040
Begin: Standby Redo Logfile archival
End: Standby Redo Logfile archival
Terminal Recovery timestamp is '07/06/2016 08:57:09'
Terminal Recovery: applying standby redo logs.

Terminal Recovery: thread 1 seq# 140 redo required

Wed Jul 06 08:57:09 2016
Terminal Recovery:

Wed Jul 06 08:57:09 2016
Recovery of Online Redo Log: Thread 1 Group 5 Seq 140 Reading mem 0
  Mem# 0: +DATA/CDB1/ONLINELOG/group_5.271.867163083
  Mem# 1: +FRA/CDB1/ONLINELOG/group_5.260.867163085
Wed Jul 06 08:57:10 2016
Incomplete Recovery applied until change 6023253 time 07/06/2016 08:57:07
Wed Jul 06 08:57:10 2016
Media Recovery Complete (CDB1)
Terminal Recovery: successful completion
Forcing ARSCN to IRSCN for TR 0:6023253
Attempt to set limbo arscn 0:6023253 irscn 0:6023253
Resetting standby activation ID 891183184 (0x351e6050)
Wed Jul 06 08:57:11 2016
ALTER DATABASE SWITCHOVER TO PRIMARY (CDB1)
Maximum wait for role transition is 15 minutes.
Backup controlfile written to trace file /u01/app/oracle/diag/rdbms/cdb1/CDB1/trace/CDB1_rsm0_3040.trc
Standby terminal recovery start SCN: 6023247
RESETLOGS after complete recovery through change 6023253
Online logfile pre-clearing operation disabled by switchover
Online log +DATA/CDB1/ONLINELOG/group_1.273.867163065: Thread 1 Group 1 was previously cleared
Online log +FRA/CDB1/ONLINELOG/group_1.264.867163067: Thread 1 Group 1 was previously cleared
Online log +DATA/CDB1/ONLINELOG/group_2.263.867163071: Thread 1 Group 2 was previously cleared
Online log +FRA/CDB1/ONLINELOG/group_2.263.867163075: Thread 1 Group 2 was previously cleared
Online log +DATA/CDB1/ONLINELOG/group_3.260.867163077: Thread 1 Group 3 was previously cleared
Online log +FRA/CDB1/ONLINELOG/group_3.262.867163079: Thread 1 Group 3 was previously cleared
Standby became primary SCN: 6023246
Wed Jul 06 08:57:12 2016
Setting recovery target incarnation to 4
Wed Jul 06 08:57:12 2016
Switchover: Complete - Database mounted as primary
Completed: ALTER DATABASE FAILOVER TO CDB1
ALTER DATABASE OPEN
Data Guard Broker initializing...
Ping without log force is disabled
.
Wed Jul 06 08:57:13 2016
Assigning activation ID 939943840 (0x380667a0)
Thread 1 opened at log sequence 1
  Current log# 1 seq# 1 mem# 0: +DATA/CDB1/ONLINELOG/group_1.273.867163065
  Current log# 1 seq# 1 mem# 1: +FRA/CDB1/ONLINELOG/group_1.264.867163067
Successful open of redo thread 1
Wed Jul 06 08:57:13 2016
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Jul 06 08:57:13 2016
ARC1: Becoming the 'no SRL' ARCH
Wed Jul 06 08:57:13 2016
SMON: enabling cache recovery
Wed Jul 06 08:57:17 2016
[3040] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:2649384 end:2651334 diff:1950 ms (2.0 seconds)
Dictionary check beginning
Dictionary check complete
Verifying minimum file header compatibility (11g) for tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
Wed Jul 06 08:57:18 2016
SMON: enabling tx recovery
Starting background process SMCO
Wed Jul 06 08:57:18 2016
SMCO started with pid=35, OS id=3654
Wed Jul 06 08:57:18 2016
Database Characterset is AL32UTF8
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process AQPC
Wed Jul 06 08:57:26 2016
AQPC started with pid=42, OS id=3660
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete
Wed Jul 06 08:57:26 2016
ARC2: STARTING ARCH PROCESSES
Starting background process ARC4
Wed Jul 06 08:57:26 2016
ARC4 started with pid=43, OS id=3662
ARC4: Archival started
ARC2: STARTING ARCH PROCESSES COMPLETE
Wed Jul 06 08:57:26 2016
krsk_srl_archive_int: Enabling archival of deferred physical standby SRLs
Wed Jul 06 08:57:27 2016
Archived Log entry 148 added for thread 1 sequence 140 ID 0x351e6050 dest 1:
Starting background process CJQ0
Shutting down archive processes
Wed Jul 06 08:57:45 2016
ARCH shutting down
ARC4: Archival stopped
Completed: ALTER DATABASE OPEN
Wed Jul 06 08:57:46 2016
CJQ0 started with pid=49, OS id=3685
Wed Jul 06 08:57:46 2016
ALTER SYSTEM SET log_archive_trace=0 SCOPE=BOTH SID='CDB1';
Wed Jul 06 08:57:46 2016
ALTER SYSTEM SET log_archive_format='%t_%s_%r.dbf' SCOPE=SPFILE SID='CDB1';
Wed Jul 06 08:57:46 2016
ALTER SYSTEM SET standby_file_management='AUTO' SCOPE=BOTH SID='*';
Wed Jul 06 08:57:46 2016
ALTER SYSTEM SET archive_lag_target=0 SCOPE=BOTH SID='*';
Wed Jul 06 08:57:46 2016
ALTER SYSTEM SET log_archive_max_processes=4 SCOPE=BOTH SID='*';
Wed Jul 06 08:57:47 2016
ALTER SYSTEM SET log_archive_min_succeed_dest=1 SCOPE=BOTH SID='*';
Wed Jul 06 08:57:48 2016
Failover succeeded. Primary database is now CDB1.
Wed Jul 06 08:59:01 2016
Shared IO Pool defaulting to 4MB. Trying to get it from Buffer Cache for process 2973.
===========================================================
Dumping current patch information
===========================================================
Patch Id: 19769480
Patch Description: Database Patch Set Update : 12.1.0.2.2 (19769480)
Patch Apply Time: 2015-11-04 22:16:23 GMT+01:00
Bugs Fixed: 14643995,16359751,16870214,17835294,18250893,18288842,18354830,
18436647,18456643,18610915,18618122,18674024,18674047,18791688,18845653,
18849537,18885870,18921743,18948177,18952989,18964939,18964978,18967382,
18988834,18990693,19001359,19001390,19016730,19018206,19022470,19024808,
19028800,19044962,19048007,19050649,19052488,19054077,19058490,19065556,
19067244,19068610,19068970,19074147,19075256,19076343,19077215,19124589,
19134173,19143550,19149990,19154375,19155797,19157754,19174430,19174521,
19174942,19176223,19176326,19178851,19180770,19185876,19189317,19189525,
19195895,19197175,19248799,19279273,19280225,19289642,19303936,19304354,
19309466,19329654,19371175,19382851,19390567,19409212,19430401,19434529,
19439759,19440586,19468347,19501299,19518079,19520602,19532017,19561643,
19577410,19597439,19676905,19706965,19708632,19723336,19769480,20074391,
20284155

Patch Id: 20299023
Patch Description: Database Patch Set Update : 12.1.0.2.3 (20299023)
Patch Apply Time: 2015-11-04 22:16:45 GMT+01:00
Bugs Fixed: 16619249,17274537,18202441,18306996,18417036,18607546,18681056,
18856999,18909599,18940497,19012119,19018447,19023822,19035573,19065677,
19081128,19183343,19238590,19272708,19291380,19315691,19335438,19358317,
19385656,19393542,19487147,19512341,19524384,19536415,19547370,19597583,
19606174,19619732,19627012,19637186,19644859,19649152,19658708,19670108,
19684504,19687159,19730508,19791377,19805359,19841800,19865345,19873610,
19896336,19915271,19928926,19978542,20235511,20347562,20348653,20425790,
20440930

Patch Id: 20831110
Patch Description: Database Patch Set Update : 12.1.0.2.4 (20831110)
Patch Apply Time: 2015-11-04 22:17:43 GMT+01:00
Bugs Fixed: 19284031,19307662,19399918,19699191,19703301,19989009,20093776,
20165574,20294666,20331945,20387265,20402832,20424899,20474192,20558005,
20657441,20746251,20899461,20919320,21225209

Patch Id: 21359755
Patch Description: Database Patch Set Update : 12.1.0.2.5 (21359755)
Patch Apply Time: 2015-11-04 22:18:33 GMT+01:00
Bugs Fixed: 17365043,18411216,18743542,18966843,19032777,19243521,19468991,
19571367,19587324,19791273,20048359,20122715,20134339,20245930,20281121,
20361671,20397490,20413820,20441797,20471920,20476175,20688221,20925795,
21281532,21421886,21442094,21620471,22062026

Patch Id: 21539301
Patch Description:
Patch Apply Time: 2015-11-09 20:58:05 GMT+01:00
Bugs Fixed: 21539301
===========================================================
Advertisements
%d bloggers like this: