设置监听
 查看监听位置 locate  tnsnames.ora
catlog =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
       (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = sztech1)
       )
    )
创建表空间

create tablespace ts_rman datafile '/u01/app/oracle/sztech2/ts_rman01.dbf' size 15m;

create user rman identified by rman
default tablespace ts_rman
 temporary tablespace temp
quota unlimited on ts_rman
;

grant recovery_catalog_owner to rman;
查看拥有权限
 select * from session_privs;

RAM：
链接到恢复目录，创建恢复目录：
 connect catalog rman/rman@catlog
 create catalog tablespace ts_rman;

主数据库 链接到恢复目录
 rman target / catalog rman/rman@catdb
注册数据库
register database；
取消注册
unregister database；

查看备份位置
list backup ；
添加备份
cataloged backuppiece ' file_name';
手工重同步备份文档：
resync catalog;

执行rman脚本
rman target / cmdfile=backupdb.rcv

crosscheck archivelog all;检查备份情况

delete expired archivelog all;删除出现错误的备份

创建脚本：
create script scp_backdb{
allocate channel c1 device type sbt;
backup database;
backup archivelog all delete input;
}

create global script gscp_backarch{
backup archivelog all;
}

create script scp_from_os from file  '路径';创建脚本从操作系统导入

使用脚本
run{
 execute script 脚本名；
}
run{
 execute global script 脚本名；
}

list script names;查看脚本信息

print [global] script scrip_name;查看对应脚本内容
print [global] script scrip_name to file ‘路径’;复制到一个路径下
replace **** 【from file ''file_name】
delete

upgrade catalog;升级恢复目录

drop catalog删除

更换恢复目录
CONNECT CATALOG cat111/oracle@destdb;
IMPORT CATALOG cat102/oracle@srcdb;
IMPORT CATALOG cat92/oracle@catdb DBID=1423241, 1423242;
IMPORT CATALOG cat102/rman@srcdb;
IMPORT CATALOG cat101/rman@srcdb;

IMPORT CATALOG cat92/rman@srcdb NO UNREGISTER;

list db_unique_name all;查看恢复目录链接信息