Home > rman > Oracle 11g rman Catalog Setup

Oracle 11g rman Catalog Setup

Here are the steps to create RMAN catalog in 11g database

1)Create tablespace for RMAN repository
2)create RMAN owner user
3)Grant privileges to the RMAN Repository owner
4)create catalog using RMAN catalog command tool
5)Register the database with RMAN repository

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

SQL*Plus: Release 11.2.0.2.0 Production on Thu Jun 2 22:43:20 2011

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

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

SQL> create tablespace rman_tbs
datafile ‘/u01/app/oracle/oradata/rman11g/rman_tbs01.dbf’ size 100M autoextend off
extent management local
segment space management auto;  2    3    4

Tablespace created.

SQL> create user rman identified by rman001
default tablespace rman_tbs
temporary tablespace temp;  2    3

User created.

SQL> grant connect,resource,recovery_catalog_owner to rman;

Grant succeeded.

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

Recovery Manager: Release 11.2.0.2.0 – Production on Thu Jun 2 22:45:47 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to recovery catalog database

RMAN> create catalog;

recovery catalog created

Check to see if any objects were created in rman table space;

Now we will register 10g database with the rman repository.

SQL> connect rman@rman11g
Enter password:
Connected.
SQL> select * from rc_database;

no rows selected

[oracle@rmanl001 bin]$ export ORACLE_HOME=/u01/app/oracle/product/10.2.0.5/db_1
[oracle@rmanl001 bin]$ export ORACLE_SID=rmandv1
[oracle@rmanl001 bin]$ cd /u01/app/oracle/product/10.2.0.5/db_1

[oracle@rmanl001 bin]$ export TNS_ADMIN=/u01/app/oracle/product/11.2.0.2/db_1/network/admin
[oracle@rmanl001 bin]$ ./tnsping rman11g

TNS Ping Utility for Linux: Version 10.2.0.5.0 – Production on 02-JUN-2011 22:56:23

Copyright (c) 1997,  2010, Oracle.  All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rmanl001.ukatru.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = rman11g.ukatru.com)))
OK (10 msec)

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

Recovery Manager: Release 10.2.0.5.0 – Production on Thu Jun 2 22:56:27 2011

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

connected to target database: RMANDV1 (DBID=701459141)
connected to recovery catalog database

RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

SQL> select * from rc_database;

DB_KEY  DBINC_KEY       DBID NAME     RESETLOGS_CHANGE# RESETLOGS
———- ———- ———- ——– —————– ———
1          2  701459141 RMANDV1                  1 02-JUN-11

RMAN> show all
2> ;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘%F’; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM ‘AES128’; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘/u01/app/oracle/product/10.2.0.5/db_1/dbs/snapcf_rmandv1.f’; # default

RMAN> configure channel device type disk format ‘/u01/app/backup/rmandv1_%U’;

new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   ‘/u01/app/backup/rmandv1_%U’;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

[oracle@rmanl001 backup]$ pwd
/u01/app/backup

RMAN> backup database;

Starting backup at 03-JUN-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=144 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u01/app/oracle/oradata/rmandv1/system01.dbf
input datafile fno=00002 name=/u01/app/oracle/oradata/rmandv1/undotbs01.dbf
input datafile fno=00005 name=/u01/app/oracle/oradata/rmandv1/rman_catalog.dbf
input datafile fno=00003 name=/u01/app/oracle/oradata/rmandv1/sysaux01.dbf
input datafile fno=00004 name=/u01/app/oracle/oradata/rmandv1/users01.dbf
channel ORA_DISK_1: starting piece 1 at 03-JUN-11
channel ORA_DISK_1: finished piece 1 at 03-JUN-11
piece handle=/u01/app/backup/rmandv1_03mduskp_1_1 tag=TAG20110603T103608 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 03-JUN-11
channel ORA_DISK_1: finished piece 1 at 03-JUN-11
piece handle=/u01/app/backup/rmandv1_04mdusls_1_1 tag=TAG20110603T103608 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 03-JUN-11

select DB_ID,BACKUP_TYPE,START_TIME,COMPLETION_TIME,STATUS,CONTROLFILE_INCLUDED from rman.rc_backup_set;

DB_ID B START_TIM COMPLETIO S CONTROL
———- – ——— ——— – ——-
701459141 D 03-JUN-11 03-JUN-11 A BACKUP

 

*rmanl001*<oracle:rman11g>:/u01/app/backup=>ls -tlr
total 681072
-rw-r—– 1 oracle oinstall 682434560 Jun  3 10:36 rmandv1_03mduskp_1_1
-rw-r—– 1 oracle oinstall   7143424 Jun  3 10:36 rmandv1_04mdusls_1_1

Advertisements
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: