sql> ALTER DATABASE open resetlogs;
Database altered.
When you are prompted:
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 would not be reco Vered
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 added for thread 1 sequence 155 ID 0x7d875fb4 dest 1:
Resetting resetlogs activation ID 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 are not set
Sat APR 18 18:42:29 2015
Smon:enabling Cache Recovery
[3781] successfully onlined Undo tablespace 2.
Undo initialization finished serial:0 start:11031024 end:11032224 diff:1200 (seconds)
Dictionary Check Beginning
File #5 is offline, and is part of the online tablespace.
Data file 5: '/U01/APP/ORACLE/ORADATA/TEST/TEN01.DBF '
File #12 is offline, and is part of the online tablespace.
Data file: '/U01/APP/ORACLE/ORADATA/TEST/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
ALTER DATABASE open Resetlogs when the output of alert