rman进行基于数据文件的恢复的一个例子

rman使用COPY的镜像文件进行基于表空间数据文件的恢复

先使用copy备份数据文件的镜像拷贝，然后删除一个数据文件，在恢复

[@more@]RMAN>backup as copy tag "07032001" database;

RMAN> list copy;


List of Datafile Copies
Key File S Completion Time Ckp SCN Ckp Time Name
------- ---- - --------------- ---------- --------------- ----
1197 1 A 20-MAR-07 22116361 20-MAR-07 /home/oracle/ora10g/dbbak/data_D-CAPDB_I-1355578684_TS-SYSTEM_FNO-1_8fid33oj
1204 2 A 20-MAR-07 22116613 20-MAR-07 /home/oracle/ora10g/dbbak/data_D-CAPDB_I-1355578684_TS-UNDOTBS1_FNO-2_8mid33u3
1203 3 A 20-MAR-07 22116591 20-MAR-07 /home/oracle/ora10g/dbbak/data_D-CAPDB_I-1355578684_TS-SYSAUX_FNO-3_8lid33ta
1206 4 A 20-MAR-07 22116621 20-MAR-07 /home/oracle/ora10g/dbbak/data_D-CAPDB_I-1355578684_TS-USERS_FNO-4_8oid33ui
1205 5 A 20-MAR-07 22116617 20-MAR-07 /home/oracle/ora10g/dbbak/data_D-CAPDB_I-1355578684_TS-EXAMPLE_FNO-5_8nid33ub
1198 6 A 20-MAR-07 22116378 20-MAR-07 /home/oracle/ora10g/dbbak/data_D-CAPDB_I-1355578684_TS-NICEBEIJING_FNO-6_8gid33pc
1199 7 A 20-MAR-07 22116391 20-MAR-07 /home/oracle/ora10g/dbbak/data_D-CAPDB_I-1355578684_TS-MBA_FNO-7_8hid33q5
1200 8 A 20-MAR-07 22116530 20-MAR-07 /home/oracle/ora10g/dbbak/data_D-CAPDB_I-1355578684_TS-CALLCENTER_FNO-8_8iid33qv
1201 9 A 20-MAR-07 22116549 20-MAR-07 /home/oracle/ora10g/dbbak/data_D-CAPDB_I-1355578684_TS-CMS_FNO-9_8jid33ro
1202 10 A 20-MAR-07 22116566 20-MAR-07 /home/oracle/ora10g/dbbak/data_D-CAPDB_I-1355578684_TS-NEIL_FNO-10_8kid33sh
1207 11 A 20-MAR-07 22116625 20-MAR-07 /home/oracle/ora10g/dbbak/data_D-CAPDB_I-1355578684_TS-RMAN_TS_FNO-11_8pid33up

List of Control File Copies
Key S Completion Time Ckp SCN Ckp Time Name
------- - --------------- ---------- --------------- ----
1208 A 20-MAR-07 22116625 20-MAR-07 /home/oracle/ora10g/dbbak/cf_D-CAPDB_id-1355578684_8qid33uq

List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
455 1 471 A 20-MAR-07 /home/oracle/ora10g/flash_recovery_area/CAPDB/archivelog/2007_03_20/o1_mf_1_471_2zyp619q_.arc

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.


[oracle@localhost capdb]$rename example01 example01_old example01.dbf

SQL> startup
ORACLE instance started.

Total System Global Area 1258291200 bytes
Fixed Size 1219160 bytes
Variable Size 318768552 bytes
Database Buffers 922746880 bytes
Redo Buffers 15556608 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '/home/oracle/ora10g/oradata/capdb/example01.dbf'


RMAN> run { set newname for datafile 5 to '/home/oracle/ora10g/oradata/example01.dbf';
2> restore datafile 5;
3> switch datafile all;
4> recover datafile 5;
5> }

executing command: SET NEWNAME

Starting restore at 20-MAR-07
using channel ORA_DISK_1

channel ORA_DISK_1: restoring datafile 00005
input datafile copy recid=1205 stamp=617713614 filename=/home/oracle/ora10g/dbbak/data_D-CAPDB_I-1355578684_TS-EXAMPLE_FNO-5_8nid33ub
destination for restore of datafile 00005: /home/oracle/ora10g/oradata/example01.dbf
channel ORA_DISK_1: copied datafile copy of datafile 00005
output filename=/home/oracle/ora10g/oradata/example01.dbf recid=1210 stamp=617716984
Finished restore at 20-MAR-07

datafile 5 switched to datafile copy
input datafile copy recid=1211 stamp=617716988 filename=/home/oracle/ora10g/oradata/example01.dbf

Starting recover at 20-MAR-07
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:02

Finished recover at 20-MAR-07

RMAN> alter database open;

database opened

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/6597/viewspace-905981/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/6597/viewspace-905981/