SQL> alter database open resetlogs;
Database altered.时的提示：
ORA-279 signalled during: ALTER DATABASE RECOVER datafile 5 …ALTER DATABASE RECOVER CANCEL Media Recovery CanceledCompleted: ALTER DATABASE RECOVER CANCEL Sat Apr 18 18:41:33 2015alter database open resetlogsORA-1139 signalled during: alter database open resetlogs…Sat Apr 18 18:42:06 2015ALTER DATABASE RECOVER database until cancel Media Recovery Startstarted logmerger processParallel Media Recovery started with 4 slavesSat Apr 18 18:42:06 2015Warning: Datafile 5 (/u01/app/oracle/oradata/test/ten01.dbf) is offline during full database recovery and will not be recoveredMedia Recovery Not RequiredCompleted: ALTER DATABASE RECOVER database until cancel Sat Apr 18 18:42:23 2015alter database open resetlogsRESETLOGS after complete recovery through change 3580552Archived Log entry 28 added for thread 1 sequence 155 ID 0x7d875fb4 dest 1:Resetting resetlogs activation ID 2106023860 (0x7d875fb4)Sat Apr 18 18:42:28 2015Setting recovery target incarnation to 3Sat Apr 18 18:42:28 2015Assigning activation ID 2175494118 (0x81ab67e6)LGWR: STARTING ARCH PROCESSESSat Apr 18 18:42:28 2015ARC0 started with pid=20, OS id=3826 ARC0: Archival startedLGWR: STARTING ARCH PROCESSES COMPLETEARC0: STARTING ARCH PROCESSESSat Apr 18 18:42:29 2015ARC1 started with pid=21, OS id=3828 Sat Apr 18 18:42:29 2015ARC2 started with pid=22, OS id=3830 Sat Apr 18 18:42:29 2015ARC3 started with pid=23, OS id=3832 ARC1: Archival startedARC2: Archival startedARC3: Archival startedARC0: STARTING ARCH PROCESSES COMPLETEARC0: Becoming the ‘no FAL’ ARCHARC0: Becoming the ‘no SRL’ ARCHARC1: Becoming the heartbeat ARCHThread 1 opened at log sequence 1 Current log# 1 seq# 1 mem# 0: /u01/app/oracle/oradata/test/redo01.logSuccessful open of redo thread 1MTTR advisory is disabled because FAST_START_MTTR_TARGET is not setSat Apr 18 18:42:29 2015SMON: enabling cache recovery[3781] Successfully onlined Undo Tablespace 2.Undo initialization finished serial:0 start:11031024 end:11032224 diff:1200 (12 seconds)Dictionary check beginningFile #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/test.dbf’Dictionary check completeVerifying file header compatibility for 11g tablespace encryption..Verifying 11g file header compatibility for tablespace encryption completedSMON: enabling tx recoveryDatabase Characterset is ZHS16GBKNo Resource Manager plan activeSat Apr 18 18:42:33 2015replication_dependency_tracking turned off (no async multimaster replication found)Starting background process QMNCSat Apr 18 18:42:37 2015QMNC started with pid=24, OS id=3834 LOGSTDBY: Validating controlfile with logical metadataLOGSTDBY: Validation completeSat Apr 18 18:42:50 2015Completed: alter database open resetlogsSat Apr 18 18:42:50 2015Starting background process CJQ0Sat Apr 18 18:42:50 2015CJQ0 started with pid=27, OS id=3854 Sat Apr 18 18:42:51 2015Checker run found 2 new persistent data failures
，选择逃避，选择被动的去面对生活
