Introduction: –
RMAN catalog command tips | To restore the oracle database using rman , first of all we have to Cataloging RMAN backup in RMAN Catalog. There are many rman catalog commands to register old backupset to new location, so that rman read the backup piece and restore them. Below is some RMAN CATALOG command example.
Catalog as Backup piece in RMAN repository: –
If you wiil execute ‘CATALOG BACKUPPIECE‘ backup will cataloged by piece. We have to run the CATALOG BACKUPPIECE command for every Backuppiece from different location so that rman register old backupset. Once all Backup piece will cataloged, start restoration oracle database.
RMAN> CATALOG BACKUPPIECE ‘/DATA01/BACKUP/PROD_2123.BKP’;
Catalog as Whole bakuppiece in RMAN repository:-
Here RMAN CATALOG START WITH command, will catalog all backup piece in single execution. Here no need to run one by one, it will catalog all backup piece, once we will run CATALOG BACKUPPIECE with exact Backup location.
RMAN> CATALOG START WITH ‘/DATA01/BACKUP/’;
using target database control file instead of recovery catalog
searching for all files that match the pattern /DATA01/BACKUP/
List of Files Unknown to the Database
=====================================
File Name: /DATA01/BACKUP/DB_1_20180904_22226.rbkp
File Name: /DATA01/BACKUP/DB_1_20180904_22224.rbkp
File Name: /DATA01/BACKUP/DB_1_20180904_22212.rbkp
File Name: /DATA01/BACKUP/DB_1_20180904_22211.rbkp
File Name: /DATA01/BACKUP/DB_1_20180904_22205.rbkp
File Name: /DATA01/BACKUP/DB_1_20180904_22219.rbkp
File Name: /DATA01/BACKUP/DB_1_20180904_22213.rbkp
File Name: /DATA01/BACKUP/CNT_1_20180904_22238.rbkp
File Name: /DATA01/BACKUP/DB_1_20180904_22229.rbkp
File Name: /DATA01/BACKUP/DB_1_20180904_22225.rbkp
Do you really want to catalog the above files (enter YES or NO)? YES
cataloging files…
cataloging done
Now we have ‘catalog backup piece from disk ‘, Need to do the restoration steps.
Catalog archive log in RMAN repository.
RMAN> CATALOG ARCHIVELOG ‘/oradata/archive/archive_100.dbf’,’/oradata/archive/archive_101.dbf’;
Catalog data filecopy in RMAN repository.
RMAN> CATALOG DATAFILECOPY ‘/oradata/datafile/users01.dbf’ LEVEL 0;
Catalog user managed controlfile copy in RMAN repository.
SQL> alter database backup controlfile as ‘/tmp/control01.ctl’;
RMAN> CATALOG controlfilecopy ‘/tmp/control01.ctl’;
Catalog file in Flash Recovery Area and Recovery file destination in RMAN repository.
RMAN> CATALOG RECOVERY AREA NOPROMPT;
RMAN> CATALOG DB_RECOVERY_FILE_DEST;