How to delete the old unavailable backup from RMAN catalog - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18

Thread: How to delete the old unavailable backup from RMAN catalog

  1. #11
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Yes Axr2., I did see the metalink post. The reason I ignored it was that it states that this problem will occour only when you use the controlfile to backup. In my case I'm using the catalog. The backup piece deletion option does not work, because there is no backuppiece in the disk. So it would require you to run the crosscheck and then do delete expired backup. Which I tried and was not successful. At this juncture I have opened a Tar with oracle and lets see what they have to offer.

    Thanx,
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  2. #12
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,027
    Just a thought, but are you familiar with the reset database; command in rman?

  3. #13
    Join Date
    Oct 2002
    Posts
    807
    > At this juncture I have opened a Tar with oracle and lets see what they have to offer.

    It'll be great if you could post their eventual response / solution.

  4. #14
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Yes I'll do so

    Thanx,
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #15
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Hi All,

    It is true that when your brains are fried, you cannot think clearly in depth. Here is the solution, for my problem.


    1. Since I was lucky, I was able to retrive the disk backups from our usual daily backups on tape. For my luck, we backup the disk backup directory to tape.

    2. Issued the following commands on those disk backup sets with the status unavailable on RMAN.

    change backupset available;

    3. On the OS moved the files to another directory

    4. Ran the cross check, this expired the backups
    crosscheck backup;
    crosscheck backup of archivelog all;

    5. Deleted the expired backups from catalog

    delete expired backups;

    6. Reran the validation. Bingo, its all working.

    The validation completed successfully.

    So, the solution in short is that when you have the backupset marked unavailable, RMAN seem to include those sets also in its validation process, and ademantly looks for those backups for the validation.

    I concern is that its going to be an issue when you go for a longterm backup policy, where you take a full backup once a month and hold them on for a long time. The way Oracle suggest that you can achieve this on 8i is by marking those backupsets unavailable. In this can, it wouldn't work well looks like at this juncture.

    I'm yet to hear from Oracle, why this is happening?

    Anyhow, hope this would help you all.

    Thanx.
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  6. #16
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Here is the test case.

    Sam
    Attached Files Attached Files
    Thanx
    Sam



    Life is a journey, not a destination!


  7. #17
    Join Date
    Oct 2002
    Posts
    807
    I concern is that its going to be an issue when you go for a longterm backup policy, where you take a full backup once a month and hold them on for a long time. The way Oracle suggest that you can achieve this on 8i is by marking those backupsets unavailable.
    Where does Oracle suggest this? Is this actually documented somewhere?

    This is completely bizzare that you had to restore the bs to mark it expired. I'm soon gonna be backing up an 8i target with 9i catalog with retentions of 7 years. Guess some serious testing needs to be done.

    Thanks for the followup. Do post again with Oracle support's official response.

  8. #18
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Here is a the extract from chapter 3 on RMAN user guide:

    The unavailable option provides for cases when a backup or copy cannot be found or has migrated offsite. A file that is marked UNAVAILABLE is not used in a restore or recover command. If the file is later found or returns to the main site, then you can mark it available again by using the available operand. Note that you do not need to allocate a channel of type maintenance for this operation.


    --------------------------------------------------------------------------------
    Note:
    You must use a recovery catalog when executing change ... unavailable and change ... available.

    --------------------------------------------------------------------------------

    Also, in my past discussion with Oracle, I have heard this from a number of support personals of this solution. But the catch is what I have explained on my attachment earlier.

    Thanx,
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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