--01. 创建 catalog 所需要的表空间
create tablespace tbs_rman datafile '/oradata/ocm/tbs_rman01.dbf' size 100m; -- 生产系统 5G 到 10G
--02. 创建 rman 用户并授权
- create user rman identified by rman default tablespace tbs_rman quota unlimited on tbs_rman;
- grant connect,resource,recovery_catalog_owner to rman;
--03. 创建恢复目录
- rman catalog rman/rman
- create catalog tablespace tbs_rman;
--04. 配置目标数据库的 tnsnames.ora
- rman =
- (description =
- (address_list =
- (address = (protocol = tcp)(host = 10.53.110.181)(port = 1521))
- )
- (connect_data =
- (sid = ocm)
- )
- )
--05. 注册目标数据库
- $rman target / catalog rman/rman@ocm
- register database;
--06. 检查 catalog 恢复目录
显示目标数据库注册信息
report schema ;
显示备份信息
list backup;
命令解释:
report schema
report shema 是指在数据库中需找 schema
list backup 从 control 读取信息
来源: http://www.bubuko.com/infodetail-2547066.html