Results 1 to 8 of 8

Thread: RMAN question

  1. #1
    Join Date
    Sep 2006
    Posts
    30

    Unanswered: RMAN question

    I am experimenting with RMAN to back up the databases. How can I overwrite the backups on a daily basis? We cop the RMAN files to a different machine for archival purposes so I would like to overwite the RMAN backup every night (same filename).

    Thanks for your help.

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    You cannot overwrite the RMAN backup files using the same name. You need to manually remove the files.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    May 2006
    Posts
    132
    As LKBrwn_DBA indicated, RMAN will not automatically overwrite a file.

    You could establish a RETENTION POLICY of REDUNDANCY = 1 and at the end of each backup perform a DELETE OBSOLETE. This will ensure that you get a good backup before deleting the previous days backup. As far as the filename, you can specify a specific DISK FORMAT parameter.

  4. #4
    Join Date
    Sep 2006
    Posts
    30

    Rman

    Is there a way for RMAN to run a UNIX command to delete the backup files?

  5. #5
    Join Date
    May 2006
    Posts
    132
    Sure...

    RMAN> host "rm /backups/db/file1.bkp";

    But this is not the preferred way of doing it.

  6. #6
    Join Date
    Jul 2003
    Posts
    2,296
    configure retention policy to one [as indicated above] and then after
    your backup issue: delete noprompt obsolete;

    that will delete your day old backup <-- but only if the NEW backup is a good one
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  7. #7
    Join Date
    Sep 2006
    Posts
    30
    Thanks for the help. One more questions:
    What is the best way to get the date that the backup was taken already into the filename?

  8. #8
    Join Date
    May 2006
    Posts
    132
    You can specify the FORMAT with %T.

Posting Permissions

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