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

Thread: complete RMAN backup script

Threaded View

  1. #1
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681

    complete RMAN backup script

    Hi Dearest Friends,

    What is the simplest RMAN command that will backup everything
    that is needed in complete recovery including init.ora,controlfiles,datafiles, redologs,etc,etc ...and output will be located on one folder for ease of transfer to offsite and then clean up all unnecessary old files.

    I tried to backup my test tb and move the backup to other server and
    restore there and everytime I do it i lack somethin or its incomplete and I have to copy something again manually and some files dafaulted to other
    backup dir

    Thanks a lot for your kindness

    Is this correct?

    rman
    run
    {
    allocate channel d1 type disk;
    backup
    format '/u03/RMAN/%d_al_t%t_s%s_p%p'
    database;
    SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
    crosscheck backup;
    delete obsolete;
    delete expired backup;
    crosscheck archivelog all;
    delete expired archivelog all;
    }
    Last edited by yxez; 09-15-2007 at 01:09 AM.
    Behind The Success And Failure Of A Man Is A Woman

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