Amazon books

Tuesday, August 31, 2010

RMAN catalog and uncatalog examples

--RMAN catalog and uncatalog examples
--Catalog
RMAN>CATALOG ARCHIVELOG '/oracle/oradata/dbname/a_1_1883.arc', '/oracle/oradata/dbname/a_1_1885.arc';

RMAN>CATALOG DATAFILECOPY '/oradata/backup/data01.dbf' LEVEL 0;

RMAN>CATALOG CONTROLFILECOPY '/oradata/backup/ctl01.ctl';

RMAN>CATALOG START WITH '/backups/bkp_db' NOPROMPT;

RMAN>CATALOG RECOVERY AREA NOPROMPT;
or
RMAN>CATALOG DB_RECOVERY_FILE_DEST;


RMAN>CATALOG BACKUPPIECE '/u02/oradata/dbname/bkp_piece_name';


--Uncatalog
RMAN>CHANGE ARCHIVELOG ALL UNCATALOG;

RMAN>CHANGE BACKUP OF TABLESPACE TBS_DATA01 UNCATALOG;

RMAN>CHANGE BACKUPPIECE '+DG_DATA/bakup/offr423' UNCATALOG;

No comments:

Post a Comment