----- ------------- -------------
1 3587033 3580553
2 3587033 3580553
3 3587033 3580553
4 3587033 3580553
5 3585480 3580553-------->这是kscnbas改之前的。
6 3587033 3580553
7 3587033 3580553
8 3587033 3580553
9 3587033 3580553
10 3587033 3580553
11 3587033 3580553
12 3395372 995548
12 rows selected.
SQL> select file#,to_char(checkpoint_change#,'999999999999'),to_char(RESETLOGS_CHANGE#,'999999999999') from v$datafile_header;
FILE# TO_CHAR(CHECK TO_CHAR(RESET
----- ------------- -------------
1 3587033 3580553
2 3587033 3580553
3 3587033 3580553
4 3587033 3580553
5 3587033 3580553
6 3587033 3580553
7 3587033 3580553
8 3587033 3580553
9 3587033 3580553
10 3587033 3580553
11 3587033 3580553
12 3395372 995548
12 rows selected.
SQL> alter database open;
Database altered.
SQL> recover datafile 5;
Media recovery complete.
SQL> alter database datafile 5 online;
Database altered.
SQL>
如下是：从alter database open; 之后的alert日志：
Sun Apr 19 05:09:46 2015 alter database open Sun Apr 19 05:09:47 2015 LGWR: STARTING ARCH PROCESSES Sun Apr 19 05:09:47 2015 ARC0 started with pid=20, OS id=3461 ARC0: Archival started LGWR: STARTING ARCH PROCESSES COMPLETE ARC0: STARTING ARCH PROCESSES Sun Apr 19 05:09:48 2015 ARC1 started with pid=21, OS id=3463 Sun Apr 19 05:09:48 2015 ARC2 started with pid=22, OS id=3465 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 Sun Apr 19 05:09:48 2015 SMON: enabling cache recovery Sun Apr 19 05:09:48 2015 ARC3 started with pid=23, OS id=3467 ARC1: Archival started ARC2: Archival started ARC2: Becoming the 'no FAL' ARCH ARC2: Becoming the 'no SRL' ARCH ARC1: Becoming the heartbeat ARCH ARC3: Archival started ARC0: STARTING ARCH PROCESSES COMPLETE [3382] Successfully onlined Undo Tablespace 2. Undo initialization finished serial:0 start:17282894 end:17283434 diff:540 (5 seconds) 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 replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC Sun Apr 19 05:09:53 2015 QMNC started with pid=24, OS id=3470 Sun Apr 19 05:10:04 2015 Completed: alter database open Sun Apr 19 05:10:04 2015 Starting background process CJQ0 Sun Apr 19 05:10:06 2015 CJQ0 started with pid=30, OS id=3494 ALTER DATABASE RECOVER datafile 5 Media Recovery Start Serial Media Recovery started WARNING! Recovering data file 5 from a fuzzy backup. It might be an online backup taken without entering the begin backup command. Media Recovery Complete (test) Completed: ALTER DATABASE RECOVER datafile 5 Sun Apr 19 05:10:17 2015 alter database datafile 5 online Completed: alter database datafile 5 online
?
?