I will explain RMAN Catalog start with Command tips in Oracle in this post.
RMAN Catalog start with Command
If you want to learn more details about RMAN Backup, you can read the following RMAN Tutorial series.
List Backup and RMAN Backup Reports | Oracle RMAN ( Recovery Manager ) Backup Tutorials -8
Catalog Start with RMAN
When you move the backup files to non-FRA location, or your backup files are not located under default location, you need to Catalog these backups ( datafiles, control files and archivelogs ).
RMAN Catalog command is used to register these files to Controlfile again. Run catalog command to register backups into new controlfile. If you don’t catalog it, it does not identify backups and you will get No backup founds errors.
If you don’t run Catalog command, then you can not use and restore and recover these backup files, So you need to catalog backup pieces to use them.
You can catalog backup pieces using the backup path as follows.
RMAN> catalog start with '/oracle/backup/'; List of Cataloged Files ======================= File Name: /oracle/backup/incremental.rman
If you do not want to get the prompt for files, you can use the noprompt option as follows.
RMAN> catalog start with '/u01/oracle/backup/' noprompt;
When you catalog any path, RMAN will catalog the valid backup pieces, but If some of files are not backup files, RMAN will not catalog them as follows.
RMAN> catalog start with '/backup/ARCHIVE/MSDBA01.06.2020'; using target database control file instead of recovery catalog searching for all files that match the pattern /backup/ARCHIVE/MSDBA01.06.2020 List of Files Unknown to the Database ===================================== File Name: /backup/ARCHIVE/MSDBA01.06.2020/ARCHIVELOG_MSDBA_u2v1mn0e_123842_20200601.bkp File Name: /backup/ARCHIVE/MSDBA01.06.2020/FULL_DB_MSDBA_stv1l785_123805_20200601.bkp File Name: /backup/ARCHIVE/MSDBA01.06.2020/ARCHIVELOG_MSDBA_rnv1k9o2_123767_20200601.bkp File Name: /backup/ARCHIVE/MSDBA01.06.2020/ARCHIVELOG_MSDBA_sav1kaqu_123786_20200601.bkp File Name: /backup/ARCHIVE/MSDBA01.06.2020/FULL_DB_MSDBA_ppv1k5jv_123705_20200531.bkp File Name: /backup/ARCHIVE/MSDBA01.06.2020/ARCHIVELOG_MSDBA_t7v1l88s_123815_20200601.bkp File Name: /backup/ARCHIVE/MSDBA01.06.2020/FULL_DB_MSDBA_t2v1l786_123810_20200601.bkp File Name: /backup/ARCHIVE/MSDBA01.06.2020/ARCHIVELOG_MSDBA_sev1kb28_123790_20200601.bkp Do you really want to catalog the above files (enter YES or NO)? yes cataloging files... cataloging done List of Cataloged Files ======================= File Name: /backup/ARCHIVE/MSDBA01.06.2020/ARCHIVELOG_MSDBA_u2v1mn0e_123842_20200601.bkp File Name: /backup/ARCHIVE/MSDBA01.06.2020/FULL_DB_MSDBA_stv1l785_123805_20200601.bkp File Name: /backup/ARCHIVE/MSDBA01.06.2020/ARCHIVELOG_MSDBA_rnv1k9o2_123767_20200601.bkp File Name: /backup/ARCHIVE/MSDBA01.06.2020/ARCHIVELOG_MSDBA_sav1kaqu_123786_20200601.bkp File Name: /backup/ARCHIVE/MSDBA01.06.2020/FULL_DB_MSDBA_ppv1k5jv_123705_20200531.bkp File Name: /backup/ARCHIVE/MSDBA01.06.2020/ARCHIVELOG_MSDBA_t7v1l88s_123815_20200601.bkp File Name: /backup/ARCHIVE/MSDBA01.06.2020/FULL_DB_MSDBA_t2v1l786_123810_20200601.bkp File Name: /backup/ARCHIVE/MSDBA01.06.2020/ARCHIVELOG_MSDBA_sev1kb28_123790_20200601.bkp List of Files Which Were Not Cataloged ======================================= File Name: /backup/ARCHIVE/MSDBA01.06.2020/FULL_MSDBA_May_30_20_00_00_02.dmp RMAN-07520: Reason: Data pump dump file ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage RMAN-08132: WARNING: cannot update recovery area reclaimable file list RMAN>
You can catalog all files in the currently enabled fast recovery area without prompting as follows.
RMAN> CATALOG RECOVERY AREA; searching for all files in the recovery area no files found to be unknown to the database
You can catalog the backup piece in the new location.
RMAN> CATALOG BACKUPPIECE '/oradata/backup/c-129220542-20201220-01'; using target database control file instead of recovery catalog cataloged backup piece backup piece handle=/oradata/backup/c-129220542-20201220-011 RECID=12 STAMP=314695990
Do you want to learn more details about RMAN, then Click this Link and read the articles.
RMAN Tutorial | Backup, Restore and Recovery Tutorials For Beginner Oracle DBA