Home > rman > Steps to Create a Recovery Catalog in 10g database

Steps to Create a Recovery Catalog in 10g database

In this article I will describe the process to create recovery catalog in 10.2.0.5 database.

[oracle@rmanl001 bin]$ export ORACLE_SID=rmandv1
[oracle@rmanl001 bin]$ ./sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 – Production on Thu Jun 2 21:19:03 2011

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Step1)Create separate tablespace to store rman catlog tables.

SQL> CREATE  TABLESPACE rmancatlog_tbs DATAFILE ‘/u01/app/oracle/oradata/rmandv1/rman_catalog.dbf’
SIZE 250M AUTOEXTEND OFF
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

Tablespace created.

Step2)Create rman user

SQL> CREATE USER rman IDENTIFIED BY rman001
DEFAULT TABLESPACE rmancatlog_tbs
QUOTA UNLIMITED ON rmancatlog_tbs
TEMPORARY TABLESPACE TEMP;

User created.

Step3)

SQL> GRANT recovery_catalog_owner TO rman;

Grant succeeded.

[oracle@rmanl001 bin]$ ./rman catalog rman/rman001@rmandv1

Recovery Manager: Release 10.2.0.5.0 – Production on Thu Jun 2 21:26:30 2011

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

connected to recovery catalog database

RMAN> create catalog;

recovery catalog created

RMAN>exit

 

 

Categories: rman
  1. No comments yet.
  1. No trackbacks yet.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: