complete RMAN backup script
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: complete RMAN backup script

  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 02:09 AM.
    Behind The Success And Failure Of A Man Is A Woman

  2. #2
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Muchas gracias Pando mi querido,usted es muy amable
    (Im practising my spanish now coz i'll be employed in Mexico as DBA soon
    say good luck to me )

    Do you have somthing like this for windows too?
    Puedo yo usar este para la versión 9i. Puede u darme también la versión de no estante


    Gracias mucho otra vez
    Last edited by yxez; 09-15-2007 at 03:56 AM.
    Behind The Success And Failure Of A Man Is A Woman

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I dont do Windows hehe, if you want to use it for Windows use Cygwin or something similar

    For 9i you just have to get rid of compression part and it should work....

  4. #4
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    thanks dear ....do you undertand my spanish message? are they grammatically correct
    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