RMAN Catalog start with Command Tips in Oracle

Hi,

I will explain RMAN Catalog start with command tips in Oracle in this post.

 

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

 

 

 

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 read the following articles.

RMAN Tutorial | Backup, Restore and Recovery Tutorials For Beginner Oracle DBA

 

 1,702 views last month,  14 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

Do NOT follow this link or you will be banned from the site!