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;

0 comments:

hits count
Database | Oracle PartnerNetwork Blog