RMAN的完全恢复

1.备份数据库

C:\Documents and Settings\una>rman target sys/sysdba@demo1 nocatalog

恢复管理器: Release 10.2.0.1.0 - Production on 星期二 1月 31 21:34:47 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

连接到目标数据库: DEMO1 (DBID=3769378787)
使用目标数据库控制文件替代恢复目录

RMAN> backup database format '/u01/rmanbackup/demo1_%U';

RMAN> sql 'alter system archive log current';

sql 语句: alter system archive log current

 

2.备份0级数据库备份

RMAN> backup incremental level 0 database plus archivelog delete all input format '/u01/rmanbackup/all_%U';

 

3.插入数据

SQL> conn user1/user1
Connected.
SQL> select * from t1;

        ID NAME
---------- --------------------
         0 zhangning

SQL> inserrt^H^H
SP2-0042: unknown command "inser" - rest of line ignored.
SQL>
SQL> insert into t1 values(1,'yjg');

1 row created.

SQL> commit;

 

4.备份1级备份数据库

SQL> alter system checkpoint;

RMAN> backup incremental level 1 database plus archivelog delete all input format '/u01/rmanbackup/all_%U';

 

5.关闭数据库并删除数据文件

SQL> shutdown immediate

[oracle@asm demo1]$ rm -f *.dbf

 

6.启动数据库到mount 状态

SQL> startup mount

 

7.用rman连接到数据库

C:\Documents and Settings\una>rman target sys/sysdba@demo1 nocatalog

 

8.用rman还原数据库

RMAN> restore database;

 

9.用rman恢复数据库

RMAN> recover database;

 

10.用rman打开数据库

RMAN> alter database open;