Site icon IT Tutorial

RMAN Catalog start with Command Tips in Oracle

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

 

Exit mobile version