虚拟专用恢复目录
来源:互联网 发布:中国早期网络漫画 编辑:程序博客网 时间:2024/05/18 01:25
一、创建恢复目录
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;
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;
- 虚拟专用恢复目录
- 高级rman功能之虚拟专用目录
- 配置catalog,创建创建虚拟专用目录
- OpenVPN虚拟专用通道
- 虚拟专用网络
- 虚拟专用网络
- 虚拟专用网络
- VPN(虚拟专用网络)
- VPN-虚拟专用网络
- 组建VPN虚拟专用网络
- 组建VPN虚拟专用网络
- oracle vpd 虚拟专用数据库
- 什么是虚拟专用服务器VPS
- 什么是虚拟专用网络VPN
- 恢复目录
- 浅析基于MPLS的虚拟专用网络
- 巧建设VPN虚拟专用网络解决方案
- [网络安全四]虚拟专用网络基础
- UML类图几种关系的总结
- JAVA实现微信公众账号自定义消息回复
- hibernate的基本知识点和常见错误
- 采购订单检查/保存BADI使用
- cocos2d
- 虚拟专用恢复目录
- BAdI Interface IF_EX_ME_PROCESS_PO_CUST
- 在linux下安装svn
- js创建div
- Android学习笔记
- andoid 改变api版本 value里文件报错
- Oracle学习(9)--Flashback
- 自学jsp的难点心得
- sap增强小总结