This discussion is archived
3 Replies Latest reply: Nov 19, 2012 10:20 PM by vk82 RSS

RMAN Validate backup from a location

Chilakamarthi Newbie
Currently Being Moderated
Hi All,

I need to validate a set of RMAN backup files that I took to a disk say /ora_tmp.

Do I need to catalogue those files to validate or I can validate the files connecting to the target and provide a location to validate the backups.

Please let me know.

Thanks,
Chilakamarthi.
  • 1. Re: RMAN Validate backup from a location
    585179 Expert
    Currently Being Moderated
    Hi,

    RMAN needs to know the backup if it doesn't know then the catalog required

    Cheers
  • 2. Re: RMAN Validate backup from a location
    mseberg Guru
    Currently Being Moderated
    Hello;

    If you know the primary key of the backup ( needs a catalog ) then you can do something like :
    RMAN>validate backupset 73;
    In Oracle 11 you can use the validate command to validate all the backup pieces in FRA :
    RMAN>validate recovery area;
    Given the information you have provided I believe you need to catalog first.


    Best Regards

    mseberg
  • 3. Re: RMAN Validate backup from a location
    vk82 Explorer
    Currently Being Moderated
    You can use the BACKUP VALIDATE command to do the following:

    Check datafiles for physical and logical block corruption

    Confirm that all database files exist and are in the correct locations

    When you run BACKUP VALIDATE, RMAN reads the files to be backed up in their entirety, as it would during a real backup. RMAN does not, however, actually produce any backup sets or image copies.

    To validate files with the BACKUP VALIDATE command:

    Start RMAN and connect to a target database and recovery catalog (if used).

    Run the BACKUP VALIDATE command.

    For example, you can validate that all database files and archived logs can be backed up by running a command as shown in the following example. This command checks for physical corruptions only.

    BACKUP VALIDATE
    DATABASE
    ARCHIVELOG ALL;

    To check for logical corruptions in addition to physical corruptions, run the following variation of the preceding command:

    BACKUP VALIDATE
    CHECK LOGICAL
    DATABASE
    ARCHIVELOG ALL;


    Hope this will help you

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points