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

Thread: rman

Threaded View

  1. #6
    Join Date
    Jan 2001
    Posts
    2,828
    Quote Originally Posted by prodadmin
    btw delete noprompt backup of database completed before 'sysdate-1' is not deleting backups on standby.

    Thanks

    You are running this command while connected to the standby database i assume

    BTW a better comman would be something like

    DELETE ARCHIVELOG ALL BACKED UP 2 TIMES TO SBT COMPLETED BEFORE ‘SYSDATE-7

    You will be deleting those backups of archivelogs that have been already backed up.You are absolutely sure you have backups of archivelogs

    You might also be interested in setting the following config on standby database

    CONFIGURE ARCHIVELOG DELETION POLICY TO NONE
    This will enable automatic deletion of archived logs
    on the standby database
    (where backups are being taken)
    that are outside of the retention period
    or have already been backed up to tape,
    if additional space is needed for new backups or archived logs

    regards
    Hrishy
    Last edited by hrishy; 11-20-2008 at 05:24 AM.

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