oracle catalog db
恢复目录数据库：包含了recovery catalog（恢复目录）的数据库，就是恢复目录数据库；
存放了注册到恢复目录的目标数据库的备份的元数据信息；
可选的数据库，如果没有恢复目录数据库，那么元数据信息存放在目标数据库的控制文件；
创建恢复目录数据库的目的：
可以集中管理多个目标数据库的备份元数据信息；
可以更长时间的存放目标数据库的备份的元数据信息；
SYS@orcl11g> show parameter record
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
--用来指定备份的元数据信息，在控制文件中的保留时长
创建一个恢复目录数据库：
1.创建一个新的数据库用来存放恢复目录
a.dbca
b.手动建库
SYS@catdb> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
catdb OPEN
2.创建一个表空间，来存放恢复目录所需要的数据库对象
SYS@catdb> create tablespace rcat_tbs
2datafile '/u01/app/oracle/oradata/catdb/rcat_tbs01.dbf'
3size 300m;
Tablespace created.
3.创建一个用户，来作为恢复目录的所有者
SYS@catdb> create user rcat_user identified by oracle
2default tablespace rcat_tbs
3temporary tablespace temp
4quota unlimited on rcat_tbs;
User created.
4.给这个用户授权
SYS@catdb> grant recovery_catalog_owner to rcat_user;
5.配置一下网络的本地服务名
$ cd $ORACLE_HOME/network/admin
$ vi tnsnames.ora
ORCL11G =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db253.neves.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl11g.neves.com)
)
)
CATDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db253.neves.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = catdb.neves.com)
)
)
6.创建恢复目录
$ rman catalog rcat_user/oracle@catdb
RMAN> create catalog;
recovery catalog created
7.向恢复目录注册目标数据库
$ rman target sys/oracle@orcl11g catalog rcat_user/oracle@catdb
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jun 27 10:24:43 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates.All rights reserved.
connected to target database: ORCL11G (DBID=923506654)
connected to recovery catalog database
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
页:
[1]