Oracle OCM考试系列教程_OCM考试实验笔记之六_备份恢复

一、恢复目录的创建
Database Backup and Recovery Advanced User’s Guide –> 10 Managing the
Recovery Catalog（第十章） –> Creating a Recovery Catalog（第一小节）
1、创建所需表空间
create tablespace cata datafile ‘/opt/oracle/oradata/mytwo/cata1.dbf’ size
50m;

2、创建用户并授予权限
create user cata identified by abcde temporary tablespace tempts1 default
tablespace cata quota unlimited on cata;
grant recovery_catalog_owner to cata;

3、在RMAN中创建恢复目录
[oracle@vhv ~]$ rman target /
RMAN> connect catalog cata/abcde@mytwo
RMAN> create catalog;
recovery catalog created

4、向恢复目录中注册数据库
保证同时连接到目标库、目录库，发出如下命令：
RMAN> REGISTER DATABASE;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
此命令在第二小节：
Database Backup and Recovery Advanced User’s Guide –> 10 Managing the
Recovery Catalog（第十章） –> Managing Target Database Records in the
Recovery Catalog（第二小节）

5、恢复目录的常用操作：同步
此命令在第三小节：c
Database Backup and Recovery Advanced User’s Guide –> 10 Managing the
Recovery Catalog（第十章） –> Resynchronizing the Recovery Catalog（第三小
节）

二、压缩备份
1、直接备份：
backup as compressed backupset datafile 1
format=’/opt/oracle/oradata/myone/arc/myone_%U’;
文档Backup and Recovery Reference中，找到backup命令，向下翻四页，或搜索

465