ORACLE RMAN CONFIGURATION

Oracle RMAN Configuration Step by Step:

Requirements:

Catalog Database
Target Database

After Oracle Installation Login to the target database.

sqlplus / as sysdba

Check with the database in archive log mode.

archive log list;

To change the No archive log mode to Archive log mode shutdown the database.

shutdown immediate;

Then Start the database with mount mode.

startup mount

To change the log mode

alter database archivelog;

archive log list;

Then open the database. 

Alter database open;

To create a catalog database use the database configuration assistant

dbca

Database creation setp1

Setting the global SID:

Database creation:

Creating the tablespace in the catalog database.
create tablesapce senthil_tbs datafile 'location' size 40m autoextend on next 10m maxsize 100m;

Creating a RMAN user and granting privileges to that user.

Connecting catalog db through the rman.

rman catalog rmanuser/password

Creating the catalog.

Now connecting the target database to the RMAN.

rman catalog rmanuser/password  target sys/password@DB1

create catalog tablespace senthil_tbs;

After that register the target database to the catalog database.

register database;

To list the configuration parameters.

show all;

Output of report schema;

To take a full database backup then you issue this following command.

backup database;

Backup successfully completed.

Output of list backup command;

Few other commands:

backup database
restore database
recover database
show all
list backup
report schema
run
sql


All the best.................................

Senthilkumar Muthusamy