1.登陆到恢复目录所在的数据库（注意：这里不是目标数据库），创建表空间tbs_rman_catalog
sys@secooler> create tablespace tbs_rman_catalog datafile '/oracle/oradata/secooler/tbs_rman_catalog01.dbf' size 100m;

Tablespace created.

2.创建用户rman_catalog
sys@secooler> create user rman_catalog identified by hsw default tablespace tbs_rman_catalog temporary tablespace temp quota unlimited on tbs_rman_catalog;

User created.

3.将recovery_catalog_owner权限授予给rman_catalog用户
sys@secooler> grant recovery_catalog_owner to rman_catalog;

Grant succeeded.

4.进入RMAN，创建恢复目录catalog
secooler@testdb /home/oracle$ rman

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Jul 28 15:45:05 2009

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

RMAN> connect catalog rman_catalog@secooler

recovery catalog database Password:
connected to recovery catalog database

RMAN> create catalog tablespace tbs_rman_catalog;

recovery catalog created

RMAN>

5.通过查询rman_catalog用户下是否存在对象的方法确认恢复目录是否创建成功
secooler@testdb /home/oracle$ sqlplus rman_catalog/hsw@secooler

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 28 15:49:36 2009

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

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options

rman_catalog@secooler>
rman_catalog@secooler> select table_name from user_tables;

TABLE_NAME
------------------------------
DB
NODE
CONF
DBINC
CKP
TS
TSATT
DF
DFATT
TF
TFATT
OFFR
RR
RT
ORL
RLH
AL
BS
BP
BCF
CCF
XCF
BSF
BDF
CDF
XDF
BRL
BCB
CCB
SCR
SCRL
CONFIG
XAL
RSR
FB
ROUT
RCVER

37 rows selected.

6.OK，如果您看到了上面的内容，说明恢复目录创建成功了。

secooler
09.07.28

-- The End --

ITPub博客

【RMAN】创建恢复目录--CATALOG

最新文章