rman实验之归档模式有备份，正常关机丢失数据文件的恢复

1 创建备份

RMAN> backup database plus archivelog;

2 搭建环境

hr@ORCL> create table tt (name varchar2(20));Table created.hr@ORCL> insert into tt values('test1');1 row created.hr@ORCL> insert into tt values('test2');1 row created.hr@ORCL> insert into tt values('test3');1 row created.hr@ORCL> commit;Commit complete.hr@ORCL> select * from tt;NAME--------------------test1test2test3

3 模拟数据文件丢失

sys@ORCL> select default_tablespace from dba_users where username='HR';DEFAULT_TABLESPACE-------- userssys@ORCL> select dt.tablespace_name,  2              file_id,  3              file_name  4         from dba_tablespaces dt, dba_data_files dd  5        where dt.tablespace_name=dd.tablespace_name;TABLESPA    FILE_ID FILE_NAME-------- ---------- ----------------------------------USERS             4 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_8050fkdh_.dbfSYSAUX            3 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_8050fk3w_.dbfUNDOTBS1          2 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_8050fkc6_.dbfSYSTEM            1 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_8050fk2z_.dbfEXAMPLE           5 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_8050jhm7_.dbfUNDOTBS2          6 /u01/app/oracle/oradata/ORCL/datafile/undotbsthi.dbfRMANTBS           7 /u01/app/oracle/flash_recovery_area/ORCL/rmantbs01.dbfsys@ORCL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.sys@ORCL> host rm -rf /u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_8050fkdh_.dbf;重新启动数据库：sys@ORCL> startupORACLE instance started.Total System Global Area  419430400 bytesFixed Size                  1219760 bytesVariable Size             121635664 bytesDatabase Buffers          293601280 bytesRedo Buffers                2973696 bytesDatabase mounted.ORA-01157: cannot identify/lock data file 4 - see DBWR trace fileORA-01110: data file 4: '/u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_8050fkdh_.dbf'

4 用rman执行修复和恢复

[oracle@localhost ~]$ rman target /Recovery Manager: Release 10.2.0.1.0 - Production on Mon Aug 6 22:54:36 2012Copyright (c) 1982, 2005, Oracle.  All rights reserved.connected to target database: ORCL (DBID=1316499950, not open)RMAN> restore datafile 4;Starting restore at 06-AUG-12using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=155 devtype=DISKchannel ORA_DISK_1: starting datafile backupset restorechannel ORA_DISK_1: specifying datafile(s) to restore from backup setrestoring datafile 00004 to /u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_8050fkdh_.dbfchannel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_08_06/o1_mf_nnndf_TAG20120806T223510_81zojyz5_.bkpchannel ORA_DISK_1: restored backup piece 1piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_08_06/o1_mf_nnndf_TAG20120806T223510_81zojyz5_.bkp tag=TAG20120806T223510channel ORA_DISK_1: restore complete, elapsed time: 00:00:03Finished restore at 06-AUG-12RMAN> recover datafile 4;Starting recover at 06-AUG-12using channel ORA_DISK_1starting media recoverymedia recovery complete, elapsed time: 00:00:03Finished recover at 06-AUG-12RMAN> alter database open;database opened

5 查询数据

hr@ORCL> select * from tt;NAME--------------------test1test2test3

数据全部回来，恢复成功！