rman恢复

rman恢复

rman转储命令

restoredatabase --mount状态

restoretablespace --open状态

restoredatafile --mount或open状态

restorecontrolfile --nomount状态

restorearchivelog --mount或open状态

restorespfile --nomount状态

指定使用哪一次的备份文件restore, restore database from tag tag名称

rman恢复命令

当执行recover命令时，rman会自动应用自最近备份以来的所有归档日志。

recoverdatabase --mount状态

recovertablespace --open状态

recoverdatafile --mount或open状态

恢复数据库

示例一所有数据文件被误删除

全备数据库。

删除所有数据文件。

使用restoredatabase转储所有数据文件，使用recoverdatabase恢复数据库，最后使用alterdatabase open 打开数据库。

[oracle@localhost ~]$ rman target sys/oracle@oralife nocatalog--全备数据库RMAN> run{2> backup database format='/oracle/10g/oracle/rman/%d_%s.dbf'3> tag='whole_bak';4> sql 'alter system archive log current';5> }--添加记录并切换日志SQL> select count(*) from t;  COUNT(*)----------         0SQL> desc t; Name                                      Null?    Type ----------------------------------------- -------- ---------------------------- TEXT                                               VARCHAR2(1000)SQL> insert into t select 'oracle' from dual;1 row created.SQL> commit;Commit complete.SQL> alter system switch logfile;System altered.SQL> alter system checkpoint;System altered.--删除所有数据文件，并启动数据库SQL> host rm  $ORACLE_BASE/product/10.2.0/oradata/oralife/*.dbfSQL> shutdown immediateORA-01116: error in opening database file 2ORA-01110: data file 2: '/oracle/10g/oracle/product/10.2.0/oradata/oralife/undotbs01.dbf'ORA-27041: unable to open fileLinux Error: 2: No such file or directoryAdditional information: 3SQL> shutdown abortORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area  528482304 bytesFixed Size                  1220360 bytesVariable Size             163578104 bytesDatabase Buffers          356515840 bytesRedo Buffers                7168000 bytesDatabase mounted.ORA-01157: cannot identify/lock data file 1 - see DBWR trace fileORA-01110: data file 1:'/oracle/10g/oracle/product/10.2.0/oradata/oralife/system01.dbf'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--使用rman连接数据库，进入mount状态进行恢复[oracle@localhost ~]$ rman target sys/oracle@oralife nocatalogRMAN> startup mountdatabase is already startedRMAN> run{2> restore database;3> recover database;4> sql 'alter database open';5> }--验证恢复情况SQL> select * from t;TEXT--------------------------------------------------------------------------------oracle

示例二数据文件所在磁盘出现硬件故障

在restoredatabase之前，执行setnewname为数据文件指定新的位置。

在restoredatabase之后，执行switchdatafile改变控制文件中数据文件位置和名称。

之后通过执行recoverdatabase应用归档日志。

最后执行alterdatabase open打开数据库。

--删除所有数据文件来模拟磁盘故障，并打开数据库SQL> host rm  $ORACLE_BASE/product/10.2.0/oradata/oralife/*.dbfSQL> shutdown abortORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area  528482304 bytesFixed Size                  1220360 bytesVariable Size             163578104 bytesDatabase Buffers          356515840 bytesRedo Buffers                7168000 bytesDatabase mounted.ORA-01157: cannot identify/lock data file 1 - see DBWR trace fileORA-01110: data file 1:'/oracle/10g/oracle/product/10.2.0/oradata/oralife/system01.dbf'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 FOUNDSQL> column  name for a100SQL> set linesize 150SQL> select file#,name from v$datafile;     FILE# NAME---------- ----------------------------------------------------------------------------------------------------         1 /oracle/10g/oracle/product/10.2.0/oradata/oralife/system01.dbf         2 /oracle/10g/oracle/product/10.2.0/oradata/oralife/undotbs01.dbf         3 /oracle/10g/oracle/product/10.2.0/oradata/oralife/sysaux01.dbf         4 /oracle/10g/oracle/product/10.2.0/oradata/oralife/users01.dbf         5 /oracle/10g/oracle/product/10.2.0/oradata/oralife/example01.dbf--使用rman连接数据库，转储数据文件到oradatabak目录（其它磁盘）[oracle@localhost ~]$ rman target sys/oracle@oralife nocatalogRMAN> run{2> startup mount;3> set newname for datafile 1 to '/oracle/10g/oracle/product/10.2.0/oradatabak/system01.dbf';4> set newname for datafile 2 to '/oracle/10g/oracle/product/10.2.0/oradatabak/undotbs01.dbf';5> set newname for datafile 3 to '/oracle/10g/oracle/product/10.2.0/oradatabak/sysaux01.dbf';6> set newname for datafile 4 to '/oracle/10g/oracle/product/10.2.0/oradatabak/users01.dbf';7> set newname for datafile 5 to '/oracle/10g/oracle/product/10.2.0/oradatabak/example01.dbf';8> restore database;9> switch datafile all;10> recover database;11> sql 'alter database open';12> }--验证恢复情况SQL> select file#,name,status from v$datafile;     FILE# NAME                                                                                                 STATUS---------- ---------------------------------------------------------------------------------------------------- -------         1 /oracle/10g/oracle/product/10.2.0/oradatabak/system01.dbf                                            SYSTEM         2 /oracle/10g/oracle/product/10.2.0/oradatabak/undotbs01.dbf                                           ONLINE         3 /oracle/10g/oracle/product/10.2.0/oradatabak/sysaux01.dbf                                            ONLINE         4 /oracle/10g/oracle/product/10.2.0/oradatabak/users01.dbf                                             ONLINE         5 /oracle/10g/oracle/product/10.2.0/oradatabak/example01.dbf                                           ONLINESQL> select * from t;TEXT---------------------------oracle