Master AH, Terimakasih banyak atas bantuannya. n'tar malam akan sy jalankan. pertanyaan di bawah itu karena kurang PD u/ running. karena ngga' ada server u/ test :( salam/Aly
--- On Thu, 30/7/09, Awaluddin Hamid <[email protected]> wrote: From: Awaluddin Hamid <[email protected]> Subject: Re: [indo-oracle] Log Archive + ada pertanyaan lg To: [email protected] Date: Thursday, 30 July, 2009, 3:45 PM 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 Get your new Email address! Grab the Email name you've always wanted before someone else does! http://mail.promotions.yahoo.com/newdomains/aa/ [Non-text portions of this message have been removed]
