Alert output when alter database open resetlogs, alterresetlogs
SQL> alter database open resetlogs;
Database altered.
Prompt:
ORA-279 signalled during: alter database recover datafile 5...
ALTER DATABASE RECOVER CANCEL
Media Recovery Canceled
Completed: ALTER DATABASE RECOVER CANCEL
Sat Apr 18 18:41:33 2015
Alter database open resetlogs
ORA-1139 signalled during: alter database open resetlogs...
Sat Apr 18 18:42:06 2015
Alter database recover database until cancel
Media Recovery Start
Started logmerger process
Parallel Media Recovery started with 4 slaves
Sat Apr 18 18:42:06 2015
Warning: Datafile 5 (/u01/app/oracle/oradata/test/ten01.dbf) is offline during full database recovery and will not be recovered
Media Recovery Not Required
Completed: alter database recover database until cancel
Sat Apr 18 18:42:23 2015
Alter database open resetlogs
RESETLOGS after complete recovery through change 3580552
Archived Log entry 28 added for thread 1 sequence 155 ID 0x7d875fb4 dest 1:
Resetting resetlogs activationid 2106023860 (0x7d875fb4)
Sat Apr 18 18:42:28 2015
Setting recovery target incarnation to 3
Sat Apr 18 18:42:28 2015
Assigning activation ID 2175494118 (0x81ab67e6)
LGWR: STARTING ARCH PROCESSES
Sat Apr 18 18:42:28 2015
ARC0 started with pid = 20, OS id = 3826
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Sat Apr 18 18:42:29 2015
ARC1 started with pid = 21, OS id = 3828
Sat Apr 18 18:42:29 2015
ARC2 started with pid = 22, OS id = 3830
Sat Apr 18 18:42:29 2015
ARC3 started with pid = 23, OS id = 3832
ARC1: Archival started
ARC2: Archival started
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the 'no fal' ARCH
ARC0: Becoming the 'no srl' ARCH
ARC1: Becoming the heartbeat ARCH
Thread 1 opened at log sequence 1
Current log #1 seq #1 mem #0:/u01/app/oracle/oradata/test/redo01.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Apr 18 18:42:29 2015
SMON: enabling cache recovery
[2, 3781] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial: 0 start: 11031024 end: 11032224 diff: 1200 (12 seconds)
Dictionary check beginning
File #5 is offline, but is part of an online tablespace.
Data file 5: '/u01/app/oracle/oradata/test/ten01.dbf'
File #12 is offline, but is part of an online tablespace.
Data file 12: '/u01/app/oracle/oradata/test. dbf'
Dictionary check complete
Verifying file header compatibility for 11g tablespace encryption ..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is ZHS16GBK
No Resource Manager plan active
Sat Apr 18 18:42:33 2015
Replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Sat Apr 18 18:42:37 2015
QMNC started with pid = 24, OS id = 3834
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete
Sat Apr 18 18:42:50 2015
Completed: alter database open resetlogs
Sat Apr 18 18:42:50 2015
Starting background process CJQ0
Sat Apr 18 18:42:50 2015
CJQ0 started with pid = 27, OS id = 3854
Sat Apr 18 18:42:51 2015
Checker run found 2 new persistent data failures