oracle catalog 恢复,oracle rman catalog db（恢复目录数据库）的创建

oracle rman catalog db(恢复目录数据库)的创建

(2012-02-07 22:13:16)

标签：

rman

备份恢复

catalog

db

记不清是哪个版本教材上的内容了，今天看了一下，步骤还是很清晰的，做个记录。

How to Set Up a Recovery Catalog

1. Create the database to be used as the recovery catalog.

Alternatively, identify an already

existing database and use that. Because a single recovery catalog

can serve more than

one database, you may choose to create a single recovery catalog

that services all your

databases that are being backed up.

2. In the recovery catalog database, create the user that will own

the recovery catalog data.

For example, assume that catdb is the name of the catalog database,

and rcat_ts is

the name of a tablespace you have created where the catalog data is

to be stored.

$ sqlplus sys/password@catdb as sysdba

SQL> CREATE USER rman IDENTIFIED BY cat

2 TEMPORARY TABLESPACE temp

3 DEFAULT TABLESPACE rcat_ts

4 QUOTA UNLIMITED ON rcat_ts;

SQL> GRANT UNLIMITED ON rcat_ts TO rman;

3. Grant the RECOVERY_CATALOG_OWNER role to the catalog owner. This

role provides

the user with all privileges required to maintain and query the

recovery catalog.

SQL>GRANT RECOVERY_CATALOG_OWNER TO rman;

4. Start RMAN and log in as the catalog owner.

$ rman catalog rman/cat@catdb

RMAN> CREATE CATALOG TABLESPACE rcat_ts;

5. Connect to the target database by using RMAN, and register it in

the newly created

recovery catalog.

$ rman target sys/oracle@orcl catalog rman/cat@catdb

RMAN> register database;

Note: It is important to back up your recovery catalog

database.

分享：

喜欢

0

赠金笔

加载中，请稍候......

评论加载中，请稍候...

发评论

登录名： 密码： 找回密码 注册记住登录状态

昵   称：

评论并转载此博文

发评论

以上网友发言只代表其个人观点，不代表新浪网的观点或立场。