RMAN: Installation of the DB and configuration

Here is a howto I found on how to install RMAN on a new DB:

Create a new database for RMAN – Recovery catalog database

Note: You can create a small database with minimal sizes of tablespaces and others,
and you can name the database as CATDB for naming convention and to avoid the
confusion between your production and rman databases.

Create a new tablespace in the new database (CATDB)

$ sqlplus /nolog

CONNECT SYS/passwd@catdb AS SYSDBA;
SQL> CREATE TABLESPACE rman DATAFILE ‘/u02/app/oradata/rman/rman01.dbf’ size 100m;

Create the Recovery Catalog Owner in the new database (CATDB)
SQL> CREATE USER rman IDENTIFIED BY rman DEFAULT TABLESPACE rman QUOTA UNLIMITED ON rman;

Grant the necessary privileges to the schema owner
SQL> GRANT connect, resource, recovery_catalog_owner TO rman;

Here the role “RECOVERY_CATALOG_OWNER” provides the user with all privileges required to maintain and query the recovery catalog

Creating the Recovery Catalog
Connect to the database which will contain the catalog as the catalog owner. For
example:
$ rman catalog rman/passwd@catdb
Recovery Manager: Release 10.2.0.3.0 – Production on Sun Apr 1 14:22:13 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to recovery catalog database
RMAN>

Run the CREATE CATALOG command to create the catalog
RMAN> CREATE CATALOG;
recovery catalog created

Registering a Database in the Recovery Catalog. Connect to the target database and recovery catalog database.
$ ORACLE_SID=prod; export ORACLE_SID
$ rman target / catalog rman/passwd@catdb
Recovery Manager: Release 10.2.0.3.0 – Production on Sun Apr 1 14:25:30 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: PROD (DBID=3677528376)
connected to recovery catalog database
RMAN> REGISTER DATABASE;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
Make sure that the registration was successful by running REPORT SCHEMA:
RMAN> REPORT SCHEMA;
Report of database schema
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
—- ——– ——————– ——- ————————
1 500 SYSTEM YES /u02/app/oradata/prod/system01.dbf
2 200 UNDOTBS1 YES /u02/app/oradata/prod/undotbs01.dbf
3 325 SYSAUX NO /u02/app/oradata/prod/sysaux01.dbf
4 100 EXAMPLE NO /u02/app/oradata/prod/example01.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
—- ——– ——————– ———– ——————–
1 200 TEMP 200 /u02/app/oradata/prod/temp01.dbf

Reference: Please go through the Oracle Documents for RMAN concepts.
http://download-uk.oracle.com/docs/cd/B19306_01/backup.102/b14191/toc.htm

Advertisements
This entry was posted in RMAN and tagged . Bookmark the permalink.

One Response to RMAN: Installation of the DB and configuration

  1. Pingback: RMAN: Issues connecting to Target DB @ Unix Experiences

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s