Oracle RMAN

RMAN is a recovery management utility of oracle database. RMAN is recommended by oracle for backup and recovery. It makes the job easier for a DBA and gives flexibility to work on the database. RMAN optimizes the performance and space occupied while backup with file multiplexing and backup set compression.

Syntax for RMAN Command-line

RMAN 
[ TARGET connectStringSpec 
| { CATALOG connectStringSpec } 
| LOG ['] filename ['] [ APPEND ]
.
. 
]..

1.First create a tablespace for RMAN

CREATE TABLESPACE "RMAN" DATAFILE 'E:\app\solomon\oradata\revolt\rman.dbf' SIZE 100M REUSE AUTOEXTEND ON NEXT 2M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO;

2.Create a user for rman CREATE USER rman IDENTIFIED BY rmanDEFAULT TABLESPACE rman QUOTA UNLIMITED ON rman;3. Grant privileges for the user GRANT connect, resource, recovery_catalog_owner TO rman;

4. Assign catalog

C:\>rman catalog=rman/rman

RMAN> create catalog tablespace "RMAN";

RMAN> register database;