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

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

****************I am authoring a Book on Oracle Database Cloud Services.......More details to follow.***************

Title : Oracle Database Cloud Revealed
Publisher : Apress
Release Date : Jan-2019

**********************************************************************************


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]


My Cloud Certifications:
Oracle Cloud Infrastructure 2018 Certified Architect Associate.
Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.
Oracle Database Cloud Administrator Certified Professional.
Oracle Database Cloud Service Operations Certified Associate.

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: