Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Friday, April 2, 2010

RMAN CATALOG BACKUPS

1)Catalog an archive log

RMAN> CATALOG ARCHIVELOG '/LOC/arc01.arc', '/LOC/arc02.arc';

2)Catalog a file

RMAN>CATALOG DATAFILECOPY '/LOC/DATAFILE01.dbf' LEVEL 0;

3)Catalog multiple copies in a directory

RMAN>CATALOG START WITH '/LOC/BACKUPDIR';

4)Catalog files in the flash recovery area:

RMAN>CATALOG RECOVERY AREA ;

5)Catalog backup pieces:
RMAN>CATALOG BACKUPPIECE '/LOC/PEICENAME';
EX:-
RMAN> CATALOG START WITH '+disk'; # catalog all files from an ASM disk group RMAN> CATALOG START WITH '/fs1/datafiles/'; # catalog all files in directory


RMAN> catalog start with '+RESTOREDB_FRA01/RESTOREDBDUP/ARCHIVELOG/2011_12_06';

starting full resync of recovery catalog
full resync complete
searching for all files that match the pattern +RESTOREDB_FRA01/RESTOREDBDUP/ARCHIVELOG/2011_12_06

List of Files Unknown to the Database
=====================================
File Name: +RESTOREDB_fra01/RESTOREDBDUP/ARCHIVELOG/2011_12_06/thread_3_seq_165457.3992.769173241


Do you really want to catalog the above files (enter YES or NO)? YES
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: +RESTOREDB_fra01/RESTOREDBDUP/ARCHIVELOG/2011_12_06/thread_3_seq_165457.3992.769173241
File Name: +RESTOREDB_fra01/RESTOREDBDUP/ARCHIVELOG/2011_12_06/thread_1_seq_145279.1991.769173481


RMAN>


Uncatalog Backup

RMAN>CHANGE ARCHIVELOG ALL UNCATALOG;

RMAN>CHANGE BACKUP OF TABLESPACE DATA01 UNCATALOG;

To uncatalog a backuppiece name,
RMAN>CHANGE BACKUPPIECE '/LOC/PEICENAME' UNCATALOG;

No comments: