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博客

rman配置恢复目录

最新文章