Oracle RMAN配置与备份信息默认是存放在target数据库的控制文件中,我们可以配置一个recovery catalog服务器来存储这些信息,另外还可以用其来存储一些全局的脚本。
下面我将演示恢复目录的配置过程,其中172.30.10.40为catalog数据库所在的主机,172.30.10.37为target数据库所在的主机。
环境:IBM AIX 5300-08
catalog数据库Oracle 10g 10.2.0.4 ASM
target数据库Oracle 10g 10.2.0.1 文件系统
172.30.10.40(catalog数据库)
1. 创建表空间
sys@ORCL> create tablespace cata datafile '+DATA/orcl/datafile/catalog_01.dbf' size 1024m segment space management auto extent management local uniform;
Tablespace created.
172.30.10.40(catalog数据库)
2. 创建用户
sys@ORCL> create user cata identified by cata default tablespace cata quota unlimited on cata;
User created.
172.30.10.40(catalog数据库)
3. 对用户授权
sys@ORCL> grant connect,resource to cata;
Grant succeeded.
sys@ORCL> grant recovery_catalog_owner to cata;
Grant succeeded.
此时查看user_objects对象
# su - oracle
$ sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Sun Apr 10 03:46:47 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
idle> conn cata/cata
Connected.
cata@ORCL> select count (*) from user_objects;
COUNT(*)
----------
0
172.30.10.37(target数据库)
4. 创建恢复目录
$ rman catalog cata/cata@cata
Recovery Manager: Release 10.2.0.1.0 - Production on Sun Apr 10 16:51:59 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to recovery catalog database
RMAN> create catalog tablespace cata
recovery catalog created
回到172.30.10.40(catalog数据库)
再次查看user_objects对象
cata@ORCL> select count (*) from user_objects;
COUNT(*)
----------
195
172.30.10.37(target数据库)
5. 连接,注册目标数据库
$ rman target sys/oracle@enovia catalog cata/cata@cata
Recovery Manager: Release 10.2.0.1.0 - Production on Sun Apr 10 16:55:26 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ENOVIA (DBID=3150239988)
connected to recovery catalog database
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
到此,一个简单的恢复目录创建完成,接下来你可以进行后续的同步恢复目录、编写脚本完成相应的备份操作。