oracle12C推SCN,推陈出新：12C 推进 SCN 新方法实践

Completed: ALTER DATABASE   MOUNT

2017-03-18T07:59:40.236101+08:00

ALTER DATABASE RECOVER  database using backup controlfile until cancel

2017-03-18T07:59:40.236186+08:00

Media Recovery Start

2017-03-18T07:59:40.236823+08:00

Serial Media Recovery started

ORA-279 signalled during: ALTER DATABASE RECOVER  database using backup controlfile until cancel  ...

2017-03-18T07:59:42.034160+08:00

ALTER DATABASE RECOVER    CANCEL

2017-03-18T07:59:42.040794+08:00

Media Recovery Canceled

Completed: ALTER DATABASE RECOVER    CANCEL

2017-03-18T07:59:48.188727+08:00

alter database open resetlogs

2017-03-18T07:59:48.189864+08:00

RESETLOGS is being done without consistancy checks. This may result

in a corrupted database. The database should be recreated.

RESETLOGS after incomplete recovery UNTIL CHANGE 4422836 time

Clearing online redo logfile 1 /oracle/app/oracle/oradata/htz/redo01.log

Clearing online log 1 of thread 1 sequence number 1

Clearing online redo logfile 1 complete

Resetting resetlogs activation ID 1993705771 (0x76d5892b)

Online log /oracle/app/oracle/oradata/htz/redo01.log: Thread 1 Group 1 was previously cleared

Online log /oracle/app/oracle/oradata/htz/redo02.log: Thread 1 Group 2 was previously cleared

Online log /oracle/app/oracle/oradata/htz/redo03.log: Thread 1 Group 3 was previously cleared

2017-03-18T07:59:48.690166+08:00

Setting recovery target incarnation to 4

2017-03-18T07:59:48.693973+08:00

Ping without log force is disabled:

instance mounted in exclusive mode.    会在这里 HANG 住，根据 LEVEL 的值不同，这个 HANG 的时候也不同。目前这里 LEVEL 值是多少，在这里消耗的时间就是多少。

2017-03-18T08:02:51.712840+08:00

Endian type of dictionary set to little

2017-03-18T08:02:51.716445+08:00

Assigning activation ID 1993737045 (0x76d60355)

Thread 1 opened at log sequence 1

Current log# 1 seq# 1 mem# 0: /oracle/app/oracle/oradata/htz/redo01.log

Successful open of redo thread 1

2017-03-18T08:02:51.734620+08:00

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

2017-03-18T08:02:51.758900+08:00

TT00: Gap Manager starting (PID:9735)

2017-03-18T08:02:51.846445+08:00

Sleep 5 seconds and then try to clear SRLs in 2 time(s)

2017-03-18T08:02:51.887673+08:00

[9714] Successfully onlined Undo Tablespace 2.

Undo initialization finished serial:0 start:5652874 end:5652906 diff:32 ms (0.0 seconds)

Dictionary check beginning

Dictionary check complete

Verifying minimum file header compatibility for tablespace encryption..

Verifying file header compatibility for tablespace encryption completed for pdb 0

Database Characterset is AL32UTF8

No Resource Manager plan active

replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process AQPC

2017-03-18T08:02:52.207519+08:00

AQPC started with pid=38, OS id=9743

LOGSTDBY: Validating controlfile with logical metadata

LOGSTDBY: Validation complete

Starting background process CJQ0

Completed: alter database open resetlogs

2017-03-18T08:02:52.618086+08:00

CJQ0 started with pid=42, OS id=9751

2017-03-18T08:02:54.893495+08:00

Shared IO Pool defaulting to 64MB. Trying to get it from Buffer Cache for process 9698.

===========================================================

Dumping current patch information

===========================================================

No patches have been applied

===========================================================