rman configuration in oracle step by step



Target DB Side

  1. Check Archive log enable/Disable if it is disable make sure enable it.
  2. Configure the listener.ora.
  3. Create the password file.
  4. Create Rman Backup location directory structure



Catalog DB Side

  1. Configure the Tnsnames.ora for target Database.
  2. Create the tablespace to store rman catalog database objects.
  3. Create a user and grant one extra privilege called (recovery_catalog_owner).
  4. Assign rman tablespace to rmanusr as a default.
  5. Connect to RMAN prompt. And create the catalog database.
  6. Connect catalog with target DB and register it.
  7. Change RMAN backup policies.
  8. After finishing that just give the commend ' Backup database'.

RMAN Configuration (DEMO)



Target Database Side :


1) check the database in Archive log mode or not.

SQL> archive log list (or) select log_mode from v$database;

2) changing database to archive log mode

SQL>startup mount;
SQL>alter database archivelog;

2)Configure the Listener.ora file in $ORACLE_HOME/network/admin

3) Create the password file in $ORACLE_HOME/dbs

dbs]$ orapwd  file=orapw$ORACLE_SID   password=orcl force=y

4) create the Rman backup directory structure.

~]$ mkdir -p /u01/oradata/orcl/rmanbkp


Catalog Database Side



1) configure the Tnsnames.ora for target DB in ORACLE_HOME/network/admin location

2) create a tablespace to store rman catalog database objects.

SQL> create tablespace rmants datafile '/u01/oradata/catdb/rmants.dbf' size 300m;

3) create a user

SQL> create user rmanusr identified by rmanusr;

4) grant one extra privilege to rman user.

SQL> grant connect,resource , recovery_catalog_owner to rmanusr;

5) assign rman tablespace to rman user as a default.

SQL> alter user rmanusr default tablespace rmants;

6) connect to RMAN prompt.

~]$rman  catalog  rmanusr/rmanusr

RMAN>

7) Create the catalog in RMAN prompt;

RMAN> create catalog

(NOTE: Go and check in rman user all objects are created or not)

8)After finishing the catalog database creation connect with target database and register it.

~]$ rman catalog rmanusr/rmanusr target=sys/orcl@to_lsnralias;

RMAN> register database;

(NOTE : jst go and check target database registered or not in rman user with rc_database command)

9) Change the backup policies in show.all file.

RMAN> show.all

10) After changing the policies just give the command like..

RMAN> backup database;

(Not : go and check in target database Rman backup location files are backed up or not) 
 
HTML Comment Box is loading comments...