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

Thread: Full Backup

  1. #1
    Join Date
    Dec 2002
    Posts
    89

    Full Backup

    Our Backup strategy have change and will do the level 0 backup everyday which will go into 15 days retention period and will do level 0 backup on 15th day that will go into 3 year ret. period.I have enough space to keep 15 days archive log on the server.So my concern is when i do full backup(level 0) do i have to backup all archive log(15 days of archive log everyday):i.e
    run {
    allocate channel d1 type ='sbt_tape';
    allocate channel d2 type ='sbt_tape';
    backup full database
    filesperset = 10
    format 'db_%d_%s_%p_%t';
    sql "ALTER SYSTEM ARCHIVE LOG CURRENT";
    backup archivelog all format 'ar_%d_%s_%p_%t';
    release channel d1;

    }
    or i can take "backup archive all" out from the above script and run seprate script.
    run {
    allocate channel d1 type ='sbt_tape' ;
    sql "ALTER SYSTEM ARCHIVE LOG CURRENT";
    backup archivelog
    from time 'SYSDATE-2'
    until time 'SYSDATE-1'
    format 'ar_%d_%s_%p_%t';
    }

  2. #2
    Join Date
    Oct 2002
    Posts
    807
    It really doesn't matter as long as you backup the archivelogs.

    You could even setup an hourly job to backup archivelogs which backs up only the archivelogs that haven't already been backed up to tape.

    With a "from time" "to time" you're gonna have redundant stuff. Not that there's anything wrong..but since you make it seem like you're running short of tape, you may not want to do that..

  3. #3
    Join Date
    Dec 2002
    Posts
    89
    thanks for the reply,

    how one can setup job through windows sched. to run a job from day 1st to 14 and then 16 through (last day -1)of the month
    and other job runs on 15th and last day of the month.

  4. #4
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    Logic for days which it will run and for which it wont run has to be developed but. You can put that thing as a batch file and put batch file in scheduler. I think this might help you.

    Rgds
    Parag

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