b14193Backup and Recovery Quick Start Guide.pdf

总结：rman repository记录在control file中或者catalog中

1、几个概念：backup>backupset>backuppiece

2、report need backup;

3、list backup summary

list backup by backup

list backup by file

4、

crosscheck backup;

crosscheck copy;

delete obsolete;

delete expired backup;

delete backup;

5、configure EXCLUDE FOR TABLESPACE oratab; (不备份oratab表空间)

6、CONFIGURE RETENTION POLICY TO REDUNDANCY 2;（设置冗余策略）

7、脚本

RMAN> @/home/oracle/oracle/product/10.2.0/rman_back.txt

[oracle@oracle 10.2.0]$ more rman_back.txt
list backup;
delete noprompt backup;
backup database;
[oracle@oracle 10.2.0]$

8、backup datafile 1,3;

backup tablespace oratab,system;

9、恢复datafile

RMAN> SQL 'ALTER DATABASE DATAFILE 7 OFFLINE';
RMAN> RESTORE DATAFILE 7;
RMAN> RECOVER DATAFILE 7;
RMAN> SQL 'ALTER DATABASE DATAFILE 7 ONLINE';

10、恢复tablespace

RMAN> SQL 'ALTER TABLESPACE users OFFLINE';
RMAN> RESTORE TABLESPACE users;
RMAN> RECOVER TABLESPACE users;
RMAN> SQL 'ALTER TABLESPACE users ONLINE';

11、恢复database

RMAN> STARTUP FORCE MOUNT;
RMAN> RESTORE DATABASE;
RMAN> RECOVER DATABASE;
RMAN> ALTER DATABASE OPEN;

总结：

下载oracle 官方文档，边看文档边做练习，概念和实际相结合，记得牢固。

[@more@]n

ITPub博客

rman b14193Backup and Recovery Quick Start Guide笔记

最新文章