Oracle RMAN CATALOG資料庫配置過程

RMAN CATALOG資料庫的配置

1、catalog database 的功能

1）集中存放rman的資料庫（備份的中繼資料），並且可以和target database 的controlfile同步

2）存放rman的備份指令碼

2、catalog database 的配置

1）需要建立一個單獨的database

02:43:21 SQL> show parameter name

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_file_name_convert                 string

db_name                              string      catdb

db_unique_name                       string      catdb

global_names                         boolean     FALSE

instance_name                        string      catdb

lock_name_space                      string

log_file_name_convert                string

service_names                        string      catdb

02:43:30 SQL>

2）建立存放rman 中繼資料的tablespace

02:44:12 SQL> create tablespace cattbs

02:44:24   2   datafile '/u01/app/oracle/oradata/catdb/cattbs01.dbf' size 100m;

Tablespace created.

3)建立user，用於管理rman，並授權

02:45:10 SQL> create user rman identified by rman default tablespace cattbs;

User created.

02:45:33 SQL> grant connect ,resource ,recovery_catalog_owner to rman;

Grant succeeded.

4）啟動listener ，連結catalog database

[oracle@work admin]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 19-AUG-2011 02:48:01

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=work)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production

Start Date                19-AUG-2011 02:47:31

Uptime                    0 days 0 hr. 0 min. 29 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora

Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=work)(PORT=1521)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "prod" has 1 instance(s).