RMAN CrossCheck in Oracle

I will explain RMAN CrossCheck in Oracle in this post.


RMAN CrossCheck

Crosscheck command is used to synchronize the physical reality of backups and copies with their logical records in the RMAN repository of Controlfile. RMAN Records like backup and archivelog files are checked their physical status.

For example, if someone removes backups or archived logs from disk with an operating system command like rm, the repository still indicates that the backup and archive logs are on disk, when in fact they are not, they are removed.




When you run the Crosscheck command, If the backup is on disk, then the CROSSCHECK command determines whether the header of the file is valid. If the backup is on tape, then the command simply checks that the backup exists. The possible status values for backups are AVAILABLE, UNAVAILABLE, and EXPIRED.


After Running the Crosscheck command, You can list the status of backups using the RMAN LIST command, or by queryingV$BACKUP_FILES or many of the recovery catalog views such as RC_DATAFILE_COPY or RC_ARCHIVED_LOG.


Running a crosscheck updates the RMAN repository so that all of these methods provide accurate information. For each backup in the RMAN repository, if the backup is no longer available, then RMAN marks it as EXPIRED. If it was EXPIRED and is now available, then RMAN marks it AVAILABLE.


You can perform Crosscheck command for Backups, Copy and Archivelogs as follows.


RMAN> crosscheck backup;
RMAN> crosscheck backuppiece PIECE_PATH_AND_NAME;
RMAN> crosscheck copy;
RMAN> crosscheck backup of database;
RMAN> crosscheck backup of controlfile;
RMAN> crosscheck archivelog all;
RMAN> crosscheck backup of archivelog all;
RMAN> crosscheck copy of controlfile;
RMAN> crosscheck backupset 1453, 1881;
RMAN> crosscheck backuppiece tag = 'msdb_backup';
RMAN> crosscheck controlfilecopy '/tmp/control01.ctl';
RMAN> crosscheck datafilecopy 1453, 571, 63;


You can use the COMPLETED BETWEEN command with Crosscheck command as follows.




If the default channel is SBT, then you can cross-check both disk and SBT backups by running CROSSCHECK with the default channels:




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





Do you want to learn Oracle Database for Beginners, then Click and read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )


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

Your email address will not be published. Required fields are marked *