Full Backup

[kpate]

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';
}

[Axr2]

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..

[kpate]

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.

[paragp1981]

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