mysql catalog def_catalog 配置 成功笔记

Rman 在恢复数据的情况下，借助catalog 可以恢复control file ,还有spfile 等，今天特地配置了一下catalog 数据库：

Rman 在恢复数据的情况下，借助catalog 可以恢复control file ,还有spfile 等，今天特地配置了一下catalog 数据库：

1>在catalog数据库上创建一个表空间供catalog使用

create tablespace rman_ts datafile '/u02/ezhou/rman01.dbf' size 50m extent management local uniform size 126k;

2>在catalog数据库上创建用户并赋予权限

create user rman_user identified by rman_user default tablespace rman_ts quota unlimited on rman_ts;

grant recovery_catalog_owner to rman_user;

grant connect,resource to rman_user;

3：连到catalog 数据库，，建tablespace:

rman catalog rman_user/rman_user

RMAN> create catalog tablespace rman_ts;

recovery catalog created

4:在catalog上配置并启动监听程序，在target数据库上配置本地命名服务.

cd /$Oracle_HOME/network/admin

[oracle@aoracle admin]$ vi tnsnames.ora

PRD =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.190.140)(PORT = 1521))

)

(CONNECT_DATA =

(SID = EZHOU)

)

)

好，下面启动监听：lsnrctl start

再lsnrctl status,可以看到status is ready,就可以了。

5>在target数据库的机器上通过本地命名服务连接到catalog数据库

[oracle@aoracle ~]$ rman target / catalog rman_user/rman_user@prd;

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Dec 8 15:14:46 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: EZHOU (DBID=4046377924)

connected to recovery catalog database

好，下面在catalog 数据库上注册target 数据库。

RMAN> register database;

database registered in recovery catalog

starting full resync of recovery catalog

full resync complete

RMAN>

到现在，catalog 的配置就算完成了。

当然下面的文章，也可以参考一下：

1.在目录数据库中创建恢复目录所需的表空间

CREATE TABLESPACE rman_ts DATAFILE '/oradata/RCAT/data/rman.dbf' SIZE 200m;

PS:删除掉该表空间 DROP TABLESPACE rman_ts INCLUDING CONTENTS;

2.在目录数据库中创建RMAN用户

CREATE USER rman IDENTIFIED BY rman DEFAULT TABLESPACE rman_ts TEMPORARY TABLESPACE TEMP QUOTA UNLIMITED ON rman_ts;

PS:删除用户 DROP USER rman CASCADE;

3.给rman用户授权

GRANT recovery_catalog_owner,connect,resource TO rman;

4.新开启一个CMD

rman catalog rman/rman

或者: -C:\>rman

<