RMAN reports latest backup pieces as Expired
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: RMAN reports latest backup pieces as Expired

  1. #1
    Join Date
    Aug 2007
    Posts
    54

    RMAN reports latest backup pieces as Expired



    Hi, RMAN reports latest backup pieces as expired, I have configured the retention policy as follows:

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

    I take weekly full backup of database including archivelogs using rman. On month end I delete the archive logs from rman by giving the command to remove the previous one month old archivelogs from the disk.

    RMAN>delete archivelog until time 'sysdate-30';


    Kind help is highly appreciated,

    thanks,

  2. #2
    Join Date
    Apr 2006
    Posts
    377
    Quote Originally Posted by habeebksa
    On month end I delete the archive logs from rman by giving the command to remove the previous one month old archivelogs from the disk.

    RMAN>delete archivelog until time 'sysdate-30';
    This is only deleting your archivelogs and NOT your backupsets. How are you actually deleting your backupsets?

    I know this may be an obvious question, but have you verified that the backupset exists on disk/tape?

  3. #3
    Join Date
    Aug 2007
    Posts
    54

    RMAN reports latest backup pieces as Expired

    Hi, I take backup on both disk and tape. The backup on disk is deleted by giving solaris operating system command (rm *) in the backup directory. The deletion is done weekly before taking full rman backup.

    Iam maintaining 4 tapes to maintain one month rman backup. I delete the backup sets on disk due to less space. I can keep only 1 week backup set on my disk.


    thanks for response,

  4. #4
    Join Date
    Apr 2006
    Posts
    377
    I wouldn't recommend manually deleting the files from disk with rm. You can allow RMAN to remove the backups from disk while leaving the ones on tape.

  5. #5
    Join Date
    Aug 2007
    Posts
    54

    RMAN reports latest backup pieces as Expired

    Hi,
    But why RMAN is showing the backup files as Expired now. Previously everything was ok. I used to follow the same procedure, like deleting the backup files from the disk using OS command and then taking full Rman backup, everything was ok.

    thanks,

  6. #6
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Did somebody run crosscheck command ?

    If youd elete from OS using Just os commands then rman would think that the backup set is still lying around where it was backed up .

    what does the rc_backup_set view say ?

    what does
    LIST BACKUP OF DATABASE
    COMPLETED BETWEEN SYSDATE and SYSDATE-30

    return does it show your backup that you were searching for ?

    regards
    Hrishy
    Last edited by hrishy; 08-21-2007 at 04:28 AM.

  7. #7
    Join Date
    Aug 2007
    Posts
    54

    RMAN reports latest backup pieces as Expired

    Hi,


    Yes, I have executed the Crosscheck command

    RMAN>CROSSCHECK BACKUP COMPLETED BEFORE 'SYSDATE';

    then only Iam seeing the backup pieces as expired eventhough the latest backup files are physically present on disk.

    RMAN>LIST BACKUP OF DATABASE
    COMPLETED BETWEEN SYSDATE and SYSDATE-30;

    this command displays nothing, but when I give

    RMAN>LIST BACKUP OF DATABASE;

    I get the backup list which shows the backup pieces status as expired.


    thanks,

  8. #8
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    CROSSCHECK command updates the repository status for a backup to EXPIRED when it cannot locate it at the location to which it was backed up.
    This condition could occur if,
    for example, a backup was deleted from disk at the operating system level

    I suggest you either

    Restore the backups from tape to the same loaction where you had backed up the database
    and then run crosscheck command again this would make the backups available and you can verify with

    list backup of database

    Or
    if you dont want these backups then you can run the delete expired backups to delete these entries from rman catalog

    regards
    Hrishy

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