rman配置恢复目录

1.创建恢复目录数据库
 创建system表空间100M
create tablespace system_space
datafile '/u01/app/oracle/oradata/prod/'
size 100M autoextend on next 20M
maxsize unlimited
extent management local autoallocate
segment space management auto ;

undo表空间20M
create undo tablespace undo_space
datafile '/u01/app/oracle/oradata/prod/'
size 20M autoextend on next 10M
maxsize unlimited
extent management local autoallocate
segment space management auto;

temp表空间20M
create temporary tablespace temp_space
tempfile '/u01/app/oracle/oradata/prod/'
size 20M autoextend no next 10M
maxsize unlimited
extent management local autoallocate
segment space management auto;

recovery catalog表空间,大小50M  
create  tablespace catalog_space   
datafile '/u01/app/oracle/oradata/prod/'
size 50M
extent management local autoallocate
segment space management auto;

日志文件,3个日志文件组,每组两个成员,大小2M
alter database prod
add logfile group rman_log1
('/u01/app/oracle/oradata/prod/rman_log1a.log';
/u01/app/oracle/oradata/prod/rman_log1b.log')
size 2M;


alter database prod
add logfile group rman_log2
('/u01/app/oracle/oradata/prod/rman_log2a.log';
/u01/app/oracle/oradata/prod/rman_log2b.log')
size 2M;


alter database prod
add logfile group rman_log3
('/u01/app/oracle/oradata/prod/rman_log3a.log';
/u01/app/oracle/oradata/prod/rman_log3b.log')
size 2M;

2.创建存储目录用户,默认表空间recovery catlog创建的表空间,临时表空间temp
     create user rman identified by rman
     default tablespace catalog_space
     temporary  tablespace temp_space;


3.为rman授权
   grant connect,resource to rman;
   grant recovery_catalog_owner to rman;


4.创建恢复目录(在恢复目录数据库上)
   $rman  
   RMAN> connect catalog rman/rman
            > create catalog                                  //使用rman默认表空间
       
   > create catalog tablespace other_space    //使用其他表空间
   > drop  catalog                                             //删除恢复目录


5.配置tnsnames.ora($ORACLE_HOME/network/admin)
将恢复目录数据库tnsnames.ora中的内容追加到目标库的tnsnames.ora


6.注册目标数据库(在目标库上)
$rman
>connect target /
>connect catalog rman/rman@host     //host恢复目录数据库中tnsnames.ora中的网络服务名
>register database


7.同步
>resync catalog                  //手工 

自动同步修改参数control_file_record_keep_time,默认7天

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30077753/viewspace-1385332/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30077753/viewspace-1385332/