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?
[Yoel] Saya rasa karena DBMS_RESTORE tidak di dokumentasi oleh oracle. 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 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? [Yoel] Kalo AUTOBACKUP anda di set ON, pasti Anda bisa restore SPFILE dari backup set yang sama dengan controlfile menggunakan RMAN command. Anda bisa coba lakukan test seperti yang ada di link tersebut. 1. Remove all your backup files. 2. Set AUTOBACKUP OFF 3. Backup full database 4. coba restore spfile Cheers, On 06/03/2008, Leonard Sukendro <[EMAIL PROTECTED]> wrote: > > > 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] <yoel.susanto%40gmail.com>> > 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]<pejantan4u%40gmail.com> > > > > 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> > > <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> > > > <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>< > > > > 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> > > > > > <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 > > > [Non-text portions of this message have been removed]
