Book Image

Oracle 10g/11g Data and Database Management Utilities

Book Image

Oracle 10g/11g Data and Database Management Utilities

Overview of this book

Does your database look complicated? Are you finding it difficult to interact with it? Database interaction is a part of the daily routine for all database professionals. Using Oracle Utilities the user can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security and in general can do more with the same time and resources.
Table of Contents (18 chapters)
Oracle 10g/11g Data and Database Management Utilities
Credits
About the Author
About the Reviewer
Preface

Crosscheck command


The crosscheck command is used to validate the physical backup is located where rman thinks it is. rman stores the backup information either in the controlfile or in the rman repository. If a restore operation needs to be carried out, rman determines the best suitable backupset and archivelog files required to successfully perform the recover process. If the backup is not where it is supposed to be then there will be problems.

In the following scenario rman validates the backup sets:

There are three backupsets, this can be queried using the LIST BACKUP command (A):

LIST BACKUP OF TABLESPACE USERS SUMMARY;

This is only to find out the backupset tag where a particular tablespace was stored. Afterwards, the CROSSCHECK command is issued against a particular backupset (B). In the first case the validation was successful for all backup pieces involved (all backup pieces were marked as AVAILABLE).

CROSSCHECK BACKUPSET TAG='Tag Name';

On the second execution of the CROSSCHECK command...