aly rmb wrote:
>
>
> Master AH,
> Terimakasih atas responnya...
> ada pertanyaan lagi ,
>
> klo sy bikin script spt di bawah, yg maksudnya
> mau backup database, controlfile dan archivelog ke tape, script spt
> ini kira* bener ?
> atau script yg biasa di pake oleh DBA u/ backup database, controlfile
> dan archivelog seperti apa ?
>
> klo tapenya sebelumnya ada isi, apa otomatis di delete, bila script
> ini dijalankan ?
>
Tidak.
>
> RMAN> run {
> 2> # backup the database to dev
> 3> allocate channel t1 type 'type sbt';
> 4> backup
> 5> full
> 6> tag full_db
> 7> format '/dev/st0/archive/ dd_%u_%s'
> 8> (database);
> 9> backup current controlfile format '/dev/st0/archive/ controlf_
> %d_%u%s' ;
> 10> backup archivelog all format '/dev/st0/archive/ arch_%d_% u_%s'
> delete input ;
> 11> release channel t1;
> 12> }
>
> terimakasih ...
>
Sertakan statement crosscheck dan delete obsolete agar file2 yg tidak
dibutuhkan lagi untuk recovery di delete.
RUN {
ALLOCATE CHANNEL t1 TYPE sbt;
# Crosscheck backup
CROSSCHECK BACKUP DEVICE TYPE sbt;
# Delete obsolete
DELETE OBSOLETE DEVICE TYPE sbt;
# Put your backup strategy here ...
# ...............
# ...............
# ...............
RELEASE CHANNEL t1;
}
CMIIW,
AH
