rman恢复

<style type="text/css"> <!-- p {margin-bottom:0.21cm} --> </style>

rman恢复

rman转储命令

restoredatabase --mount状态

restoretablespace --open状态

restoredatafile --mount或open状态

restorecontrolfile --nomount状态

restorearchivelog --mount或open状态

restorespfile --nomount状态

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(*)

----------

         0



SQL> 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/*.dbf



SQL> shutdown immediate

ORA-01116: error in opening database file 2

ORA-01110: data file 2: '/oracle/10g/oracle/product/10.2.0/oradata/oralife/undotbs01.dbf'

ORA-27041: unable to open file

Linux Error: 2: No such file or directory

Additional information: 3

SQL> shutdown abort

ORACLE instance shut down.

SQL> startup

ORACLE instance started.



Total System Global Area  528482304 bytes

Fixed Size                  1220360 bytes

Variable Size             163578104 bytes

Database Buffers          356515840 bytes

Redo Buffers                7168000 bytes

Database mounted.

ORA-01157: cannot identify/lock data file 1 - see DBWR trace file

ORA-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 nocatalog

RMAN> startup mount



database is already started



RMAN> run{

2> restore database;

3> recover database;

4> sql 'alter database open';

5> }


--验证恢复情况
SQL> select * from t;



TEXT

--------------------------------------------------------------------------------

oracle

<style type="text/css"> <!-- p {margin-bottom:0.21cm} --> </style>

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

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

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

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

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

--删除所有数据文件来模拟磁盘故障，并打开数据库
SQL> host rm  $ORACLE_BASE/product/10.2.0/oradata/oralife/*.dbf



SQL> shutdown abort

ORACLE instance shut down.

SQL> startup

ORACLE instance started.



Total System Global Area  528482304 bytes

Fixed Size                  1220360 bytes

Variable Size             163578104 bytes

Database Buffers          356515840 bytes

Redo Buffers                7168000 bytes

Database mounted.

ORA-01157: cannot identify/lock data file 1 - see DBWR trace file

ORA-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



SQL> column  name for a100

SQL> set linesize 150

SQL> 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 nocatalog

RMAN> 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                                           ONLINE

SQL> select * from t;



TEXT

---------------------------
oracle