虚拟专用恢复目录

一、创建恢复目录
1、建表空间
create tablespace rc_data datafile '/u01/app/oracle/oradata/ocp/rc_data.dbf' size 50m;


2、建用户
create user rc_ocp identified by rc_ocp default tablespace rc_data quota unlimited on rc_data;


3、授权
grant connect,resource,recovery_catalog_owner to rc_ocp;


4、创建目录
rman catalog rc_ocp/rc_ocp


create catalog;

5、注册
rman target sys/oracle@ocp catalog rc_ocp/rc_ocp@ocp


register database;


6、查incarnation
list incarnation;


二、虚拟专用目录：
1.先建表空间，用户，授权
sys@OCP>create user v_user1 identified by v_user1 default tablespace tp1 temporary tablespace temp quota unlimited on tp1;

sys@OCP> grant recovery_catalog_owner to v_user1;

2.用基本恢复目录登录给v_user1用户授权
[oracle@ocm ~]$ rman catalog rc_ocp/rc_ocp
grant catalog for database ocp to v_user1;
grant catalog for database ocm to v_user1;


3.用虚拟用户登录，建恢复目录
[oracle@ocm ~]$ rman catalog v_user1/v_user1
create virtual catalog;

list incarnation


4.sqlplus v_user1/v_user1
select * from RC_BACKUP_DATAFILE;


三、备份脚本


create script datafile_5{
backup datafile 5;
}


run{execute script full_db;}


rman target sys/oracle@oca catalog rc_admin/rc_admin@oca script datafile_4


list script names;


print script datafile_4;


replace script datafile_4{
backup format='/backup/rman/full_%U'
database;
}


四、常用操作
delete script full_db;
resync catalog;
unregister database;
upgrade catalog;
drop catalog;