DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: RMAN - backup files expired

Hybrid View

  1. #1
    Join Date
    Aug 2007
    Posts
    54

    RMAN - backup files expired

    Hi, using Rman I have taken the production database complete backup with archivelogs by connecting to catalog database present on different machine.
    But when I crosschecked the backup using the following command:

    RMAN> crosscheck backup completed before 'sysdate-1';

    It shows all the backup files as "Expired". As I have taken the backup yesterday, the above command should show me the files as "Available". The backup was run successfully, I have checked the backup files present on the disk.


    Kind help is highly appreciated.

    Regards,

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    What's the retention period you configured?

  3. #3
    Join Date
    Apr 2006
    Posts
    377
    What time did you take the backup? The window you specified 'sysdate - 1' may actually fall before the time you took the backup.

    What is the output of the following:

    Code:
    RMAN> list backup;

  4. #4
    Join Date
    Aug 2007
    Posts
    54

    RMAN - backup files expired

    Hi, the configuration for retention policy is as follows:

    RMAN>configure retention policy to recovery window of 30 days.

    and I have crosscheck the backup with

    RMAN>crosscheck backup completed before 'sysdate';
    previously i wrote 'sysdate-1' by mistake.

  5. #5
    Join Date
    Aug 2007
    Posts
    54

    RMAN - backup files expired

    Hi, can anyone help me in knowing the reason for why RMAN is showing the backup files as expired.


    thanks,

  6. #6
    Join Date
    Aug 2007
    Location
    Kerala
    Posts
    2

    Smile Rman backup expired

    Hi
    Crosschecks update outdated RMAN repository information about backups whose repository records do not match their physical status. For example, if a user removes archived logs from disk with an operating system command, the repository still indicates that the logs are on disk, when in fact they are not.
    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.

    you can list the backup details using the commands
    list backup;
    list backup summary;

    or by quering
    V$BACKUP_FILES
    RC_DATAFILE_COPY or RC_ARCHIVED_LOG.

    f the backup is no longer available, then RMAN marks it as EXPIRED.
    gopu

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width