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).