RMAN "restore... Validate [header]" Lists Full Or L0 Backups Only
(Doc ID 1481151.1)
Last updated on JUNE 07, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Goal
Two RMAN commands were run:
1. restore database until time 'sysdate' preview
2. restore database until time 'sysdate' validate header
According to Oracle doc, they both should produce the same output, but VALIDATE HEADER shows full or level 0 backups only.
Validate header does Reports and validates—but does not restore—the backups that RMAN could use to restore to the specified time.
According to Oracle Documentation:
---
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmcomre.htm#CFADHADH
Oracle® Database Backup and Recovery User's Guide
11g Release 2 (11.2)
Part Number E10642-05
.
17 Performing Complete Database Recovery
..
Preparing for Complete Database Recovery
...
Previewing Backups Used in Restore Operations
..
As an alternative to RESTORE ... PREVIEW, you can use the RESTORE ... VALIDATE HEADER command.
In addition to listing the files needed for restore and recovery, the RESTORE ... VALIDATE HEADER command
validates the backup file headers to determine whether the files on disk
or in the media management catalog correspond to the metadata in the RMAN repository.
..
---
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
Option 1 :- |
Option 2 :- |
References |