to pak yoel, saya dh baca2 artikelnya, bagus bgt, boss.. thx 4 sharing :). saya br tau ada PLSQL script buat balikin spfile n ctlfile, bner2 masi byk bgt yg mesti di explore :D..
klo gk kberatan, saya mo ikutan nanya nech, boss, 1. jujur saya ndiri bln coba script itu, tp klo emank script itu bisa balikin spfile n ctlfile, knp ya kira2 mrk suggest utk hubungin oracle support? 2. soal backup set yg mengandung spfile, selama ini saya kira klo spfile itu masuk ke backup set yg sama dgn ctlfile.. kbtulan saya prnah capture screennya RMAN> restore spfile to '/data/oradata/test/pfile/spfile_test.ora'; Starting restore at 29-JUN-07 using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 using channel ORA_DISK_4 channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: restoring SPFILE output filename=/data/oradata/test/pfile/spfile_test.ora channel ORA_DISK_1: restored backup piece 1 piece handle=/data/rman/rman_ctlfile/controlfile_c-1918447291-20070627-00 tag=null params=NULL channel ORA_DISK_1: restore complete Finished restore at 29-JUN-07 RMAN> restore controlfile; Starting restore at 29-JUN-07 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=11 devtype=DISK allocated channel: ORA_DISK_2 channel ORA_DISK_2: sid=12 devtype=DISK allocated channel: ORA_DISK_3 channel ORA_DISK_3: sid=13 devtype=DISK allocated channel: ORA_DISK_4 channel ORA_DISK_4: sid=14 devtype=DISK channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: restoring controlfile output filename=/data/oradata/test/ctlfile/ctlfile01.ctl channel ORA_DISK_1: restored backup piece 1 piece handle=/data/rman/rman_ctlfile/controlfile_c-1918447291-20070627-00 tag=null params=NULL channel ORA_DISK_1: restore complete replicating controlfile input filename=/data/oradata/test/ctlfile/ctlfile01.ctl output filename=/data/oradata/test/ctlfile/ctlfile02.ctl output filename=/data/oradata/test/ctlfile/ctlfile03.ctl Finished restore at 29-JUN-07 klo dr capture-an itu, spfile n ctlfile di restore dr file yg sama.. ato apa itu mungkin krn kbtulan saya set di rmannya utk autobackup controlfile nya ya? thx bgt bantuannya, boss [L] --- Yoel Susanto <[EMAIL PROTECTED]> wrote: > Saya rasa Anda salah tangkap maksud saya menunjukan > artikel2 tersebut. > Saya sadar sekali Anda bisa restore control file > anda karena ada control > file backup set. > > Yang Anda tidak punya adalah "backup set yang > mengandung SPFILE yang bisa di > restore dengan RMAN command." > > Backup set Anda yang mengandung SPFILE adalah backup > set yang mengandung > datafile #1 (SYSTEM tablespace). > > Kalau Anda baca lebih teliti dari link2 yang saya > kasih. > Selain me-restore Controlfile , PLSQL tersebut juga > akan me-restore SPFILE. > > artikel yang paleng simple, dibaca dulu pak. > > http://coskan.wordpress.com/2007/08/29/when-you-lost-your-controlfile-backups/ > > didukung oleh link2 yang sudah saya kasih. > > > On 05/03/2008, Andes Febrian <[EMAIL PROTECTED]> > wrote: > > > > pak Yoel, controlfile berhasil di restore, tp yg > gak bisa adalah ketika > > saya > > mau restore spfile. > > > > meskipun controlfile sudah bisa di restore, tp > untuk startup mount, > > dibutuhkan spfile atau pfile, nah ini yg gak bisa > di restore. btw, terima > > kasih untuk link2nya, bermanfaat sangat. > > > > 2008/3/5 Yoel Susanto <[EMAIL PROTECTED] > <yoel.susanto%40gmail.com>>: > > > > > Ada beberapa situasi dimana RMAN backup spfile : > > > 1. Anda melakukan Backup Datafile #1 (SYSTEM > tablespace datafile), > > > termasuk > > > full database. > > > 2. AUTOBACKUP di set ON > > > 3. Perintah BACKUP SPFILE di execute > > > > > > Saya rasa Anda di situasi yang #1, caranya > restore Controlfile atau > > SPFILE > > > dalam situasi ini adalah dengan PLSQL > > > Saya temukan link ini, bisa silakan di coba. > > > > > > > > > > > > http://www.orafaq.com/faq/can_one_restore_rman_backups_without_a_controlfile_and_recovery_catalog > > > > > > > > > http://coskan.wordpress.com/2007/08/29/when-you-lost-your-controlfile-backups/ > > > > http://www.cuddletech.com/articles/oracle/node63.html > > > > > > Saya recommend anda untuk set autobackup ON. > > > > > > On 05/03/2008, Andes Febrian > <[EMAIL PROTECTED]<pejantan4u%40gmail.com> > > <pejantan4u%40gmail.com>> > > > > > wrote: > > > > > > > > tp pak Yoel, saya jg sudah coba untuk > memberikan nama filenya tp tetep > > > > eror > > > > message yg keluar adalah "spfile not found in > backup set". apakah > > backup > > > > dgn > > > > rman yg saya terapkan ini salah atau gmn ? > atau ada cara restore dgn > > > > menggunakan file rman seperti yg saya buat ini > ? terima kasih. > > > > > > > > RMAN> restore spfile from > > > > > '/u01/tmp/Backup_DB_Intermas/fullbackup/ITTDB_648327603_21_1.dbf'; > > > > Starting restore at 05-MAR-08 > > > > using channel ORA_DISK_1 > > > > channel ORA_DISK_1: autobackup found: > > > > > /u01/tmp/Backup_DB_Intermas/fullbackup/ITTDB_648327603_21_1.dbf > > > > RMAN-00571: > > > =========================================================== > > > > RMAN-00569: =============== ERROR MESSAGE > STACK FOLLOWS > > =============== > > > > RMAN-00571: > > > =========================================================== > > > > RMAN-03002: failure of restore command at > 03/05/2008 16:21:06 > > > > ORA-19687: SPFILE not found in backup set > > > > > > > > RMAN> restore spfile from > > > > > '/u01/tmp/Backup_DB_Intermas/fullbackup/ITTDB_648327818_22_1.dbf'; > > > > Starting restore at 05-MAR-08 > > > > using channel ORA_DISK_1 > > > > channel ORA_DISK_1: autobackup found: > > > > > /u01/tmp/Backup_DB_Intermas/fullbackup/ITTDB_648327818_22_1.dbf > > > > RMAN-00571: > > > =========================================================== > > > > RMAN-00569: =============== ERROR MESSAGE > STACK FOLLOWS > > =============== > > > > RMAN-00571: > > > =========================================================== > > > > RMAN-03002: failure of restore command at > 03/05/2008 16:21:25 > > > > ORA-19687: SPFILE not found in backup set > > > > > > > > RMAN> restore spfile from > > > > > '/u01/tmp/Backup_DB_Intermas/fullbackup/ITTDB_648328033_23_1.dbf'; > > > > Starting restore at 05-MAR-08 > > > > using channel ORA_DISK_1 > > > > channel ORA_DISK_1: autobackup found: > > > > > /u01/tmp/Backup_DB_Intermas/fullbackup/ITTDB_648328033_23_1.dbf > > > > RMAN-00571: > > > =========================================================== > > > > RMAN-00569: =============== ERROR MESSAGE > STACK FOLLOWS > > =============== > > > > RMAN-00571: > > > =========================================================== > > > > RMAN-03002: failure of restore command at > 03/05/2008 16:22:21 > > > > ORA-19687: SPFILE not found in backup set > > > > > > > > 2008/3/5 Yoel Susanto > <[EMAIL PROTECTED]<yoel.susanto%40gmail.com>< > > yoel.susanto%40gmail.com>< > > > yoel.susanto%40gmail.com>>: > > > > > > > > > Maksud pak Leo adalah > > > > > > > > > > Anda salah memberikan nama backup file ke > RESTORE command anda. > > > > > > > > > > Coba liat : > > > > > > > > > > RMAN> restore spfile from > > > > > > '/u01/tmp/Backup_DB_Intermas/fullbackup/%d_%t_%s_%p.dbf'; > > > > > > > > > > dari hasil backup Anda, adakah file dengan > nama di atas??? > > > > > > > > > > /u01/tmp/backupdb/full_backup/ > > > > > -rwxr-xr-x 1 oracle dba 877305856 Mar 5 > 10:59 > > ITTDB_648327603_21_1.dbf > > > > > -rwxr-xr-x 1 oracle dba 1215291392 Mar 5 > 11:06 > > > ITTDB_648327818_22_1.dbf > > > > > -rwxr-xr-x 1 oracle dba 1159831552 Mar 5 > 11:12 > > > ITTDB_648328033_23_1.dbf > > > > > -rwxr-xr-x 1 oracle dba 8617984 Mar 5 11:12 > ITTDB_648328222_25_1.cf > > > > > > > > > > On 05/03/2008, Andes Febrian > <[EMAIL PROTECTED]<pejantan4u%40gmail.com> > > <pejantan4u%40gmail.com> > > > <pejantan4u%40gmail.com> > > > > <pejantan4u%40gmail.com>> > > > > > wrote: > > > > > > > > > > > > Pak Leo, jadi maksudnya saya gak bisa > restore dari file backup-an > > > RMAN > > > > > > ini ? > > > > > > atau gmn ? > > > > > > > > > > > > trs klo saya mau restore ke server yg baru > saya install software > > > > oracle, > > > > > > gmn > > > > > > pak ? saya gak nemu2 caranya ? > === message truncated === ____________________________________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping
