数据库启动时丢失数据文件模拟实验(二)
TATUS
------------
MOUNTED
SYS@ bys001>col error for a20
SYS@ bys001>select * from v$recover_file;
FILE# ONLINE ONLINE_ ERROR CHANGE# TIME
---------- ------- ------- -------------------- ---------- -------------------
1 ONLINE ONLINE FILE NOT FOUND 0
4.重新移回原文件，数据库可以正常打开
[oracle@oel-01 bys001]$ pwd
/u01/app/oracle/oradata/bys001
[oracle@oel-01 bys001]$ ls
bys_flashback.dbf control01.ctl redo01a.log redo02.log sysaux01.dbf temp01.dbf test1_undo.dbf users01.dbf.bak
catalog1.dbf example01.dbf redo01.log redo03.log system01.dbf test1.dbf undotbs01.dbf
[oracle@oel-01 bys001]$ mv users01.dbf.bak users01.dbf
SYS@ bys001>alter database open;
Database altered.
SYS@ bys001>select status from v$instance;
STATUS
------------
OPEN
SYS@ bys001>select * from v$recover_file;
no rows selected
[oracle@oel-01 ~]$ tail -n 100 alert_bys001.log
Tue Jul 16 22:19:30 2013
alter database open
Beginning crash recovery of 1 threads
Started redo scan
Completed redo scan
read 0 KB redo, 0 data blocks need recovery
Started redo application at
Thread 1: logseq 49, block 25811, scn 2241514
Recovery of Online Redo Log: Thread 1 Group 1 Seq 49 Reading mem 0
Mem# 0: /u01/app/oracle/oradata/bys001/redo01.log
Mem# 1: /u01/app/oracle/oradata/bys001/redo01a.log
Completed redo application of 0.00MB
Completed crash recovery at
Thread 1: logseq 49, block 25811, scn 2261515
0 data blocks read, 0 data blocks written, 0 redo k-bytes read
Tue Jul 16 22:19:31 2013
LGWR: STARTING ARCH PROCESSES
Tue Jul 16 22:19:32 2013
ARC0 started with pid=21, OS id=4743
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Tue Jul 16 22:19:33 2013
ARC1 started with pid=22, OS id=4746
Thread 1 advanced to log sequence 50 (thread open)
Tue Jul 16 22:19:33 2013
ARC2 started with pid=23, OS id=4748
ARC1: Archival started
ARC2: Archival started
Tue Jul 16 22:19:33 2013
ARC3 started with pid=24, OS id=4750
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
Thread 1 opened at log sequence 50
Current log# 2 seq# 50 mem# 0: /u01/app/oracle/oradata/bys001/redo02.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Jul 16 22:19:33 2013
SMON: enabling cache recovery
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is AL32UTF8
No Resource Manager plan active
Starting background process FBDA
Tue Jul 16 22:19:40 2013
FBDA started with pid=25, OS id=4752
Tue Jul 16 22:19:40 2013
replication_dependency_tracking turned off (no async multimaster replication found)
Archived Log entry 141 added for thread 1 sequence 49 ID 0x79c75bdb dest 1:
Starting background process QMNC
Tue Jul 16 22:19:44 2013
QMNC started with pid=26, OS id=4754
Completed: alter database open