oracle 10g rman备份与恢复之五(四)
g(s) in backup set
input archive log thread=1 sequence=24 recid=13 stamp=813403039
channel ORA_DISK_1: starting piece 1 at 22-4月 -13
channel ORA_DISK_1: finished piece 1 at 22-4月 -13
piece handle=/opt/app/oracle/flash_recovery_area/WOLF/backupset/2013_04_22/o1_mf_annnn_TAG20130422T091723_8qbg351l_.bkp tag=TAG20130422T091723 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/opt/app/oracle/archive/arch_1_24_788004200.arc recid=13 stamp=813403039
Finished backup at 22-4月 -13
RMAN>
RMAN> report schema;
Report of database schema
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 480 SYSTEM YES /opt/app/oracle/oradata/wolf/system01.dbf
2 90 UNDOTBS1 YES /opt/app/oracle/oradata/wolf/undotbs01.dbf
3 240 SYSAUX NO /opt/app/oracle/oradata/wolf/sysaux01.dbf
4 5 USERS NO /opt/app/oracle/oradata/wolf/users01.dbf
5 100 WOLFBLOCK NO /opt/app/oracle/oradata/wolf/wolfblock01.dbf
6 10 WOLF NO /opt/app/oracle/oradata/wolf/wolf01
7 20 RMAN_WOLF NO /opt/app/oracle/oradata/wolf/rman_wolf.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 20 TEMP 32767 /opt/app/oracle/oradata/wolf/temp01.dbf
RMAN>
模拟数据文件全部丢失
[oracle@test wolf]$ ls
control01.ctl redo02.log redo11.log system01.dbf wolfblock01.dbf
control02.ctl redo03.log redo12.log temp01.dbf
control03.ctl redo04.log redo13.log undotbs01.dbf
redo010.log redo05.log rman_wolf.dbf users01.dbf
redo01.log redo06.log sysaux01.dbf wolf01
[oracle@test wolf]$ rm -rf *.dbf
[oracle@test wolf]$ ls
control01.ctl redo010.log redo03.log redo06.log redo13.log
control02.ctl redo01.log redo04.log redo11.log wolf01
control03.ctl redo02.log redo05.log redo12.log
[oracle@test wolf]$
RMAN> shutdown immediate
database closed
database dismounted
Oracle instance shut down
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 113247824 bytes
Database Buffers 167772160 bytes
Redo Buffers 2973696 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/opt/app/oracle/oradata/wolf/system01.dbf'
SQL> SQL> select file#,error from v$recover_file;
FILE# ERROR
---------- -----------------------------------------------------------------
1 FILE NOT FOUND
2 FILE NOT FOUND
3 FILE NOT FOUND
4 FILE NOT FOUND
5 FILE NOT FOUND
7 FILE NOT FOUND
6 rows selected.
SQL>
[oracle@test ~]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on 星期一 4月 22 10:0