SQL> alter database open resetlogs;
Database altered.
時的提示:
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 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 is 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 (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/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