Oracle RMAN Catalog Database configuration process

Configuration of the RMAN catalog database

1, the function of catalog database

1 centralizes the Rman database (the backed-up metadata) and can be synchronized with the target database Controlfile

2 The backup script that holds the Rman

2, the Catalog database configuration

1 the need to establish a separate 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) to establish a tablespace for storing Rman meta data

02:44:12 sql> Create tablespace Cattbs

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

Tablespace created.

3 Create user to administer Rman, and authorize

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) Start listener, link 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, +, 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 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 the This service ...

Service "prod" has 1 instance (s).