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]>: > 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>> > 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>>: > > > > > 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>> > > > 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 ? > > > > > > > > bukan berarti saya gak bisa restore kan ? karena saya backup oracle > db > > > dgn > > > > format ini. terima kasih. > > > > > > > > 2008/3/5 Leonard Sukendro <[EMAIL PROTECTED]<leon_190699%40yahoo.com> > <leon_190699%40yahoo.com> > > <leon_190699%40yahoo.com><leon_190699%40yahoo.com> > > > > >: > > > > > > > > > > > > > > to pak andes... > > > > > > > > > > moga2 saya gk salah liat :), tp > > > > > '/u01/tmp/Backup_DB_Intermas/fullbackup/%d_%t_%s_%p.dbf' > > > > > --> ini bukan nama file hasil backup-an RMAN, boss... > > > > > "%d_%t_%s_%p.dbf" ini masi dalam bntuk format > > > > > backup-an RMAN, bkn hasil backup-an RMAN itu ndiri... > > > > > > > > > > coba liat hasil backup-an ctlfile nya: > > > > > '%d_%t_%s_%p.cf'--> ini format backup-an ctlfile RMAN > > > > > 'ITTDB_648328222_25_1.cf' --> ini file OS hasil > > > > > backup-an ctlfile dr RMAN > > > > > > > > > > CMIIW, > > > > > [L] > > > > > > > > > > > > > > > --- Andes Febrian <[EMAIL PROTECTED] > > > > > <pejantan4u%40gmail.com><pejantan4u%40gmail.com><pejantan4u%40gmail.com><pejantan4u%40gmail.com><pejantan4u%40gmail.com>> > > > > wrote: > > > > > > > > > > > Dear gurus, > > > > > > > > > > > > Saya mau restore database dari file backup yg ada. > > > > > > file backup tersebut saya > > > > > > backup online dgn rman. tp ketika saya restore, > > > > > > sepertinya syntax saya > > > > > > salah, ada kah yg bisa beri saya pencerahan. > > > > > > saya jalankan crontab script yg memanggil file > > > > > > backupdb.rman ini. kemudian > > > > > > saya ingin restore ke server baru, sama2 linux RHEL > > > > > > 4, sama2 oracle db 10g > > > > > > R2 tp gak sama versi - yg backup versi 10.2.0.3 > > > > > > 64bit, yg baru saya install > > > > > > 10.2.0.1 32bit - > > > > > > ketika saya restore control file, berjalan lancar, > > > > > > tp ketika saya mau > > > > > > restore spfile, terjadi eror, > > > > > > > > > > > > 1. saya copykan hasil backup server lama ke server > > > > > > baru (beda direktori) > > > > > > 2. connect rman target / (tanpa catalog) > > > > > > 3. rman>startup force nomount > > > > > > 4. rman>restore controlfile from > > > > > > > > > > > '/u01/tmp/backupdb/full_backup/ITTDB_648328222_25_1.cf'; > > > > > > (berjalan lancar) > > > > > > 5. rman>restore spfile from > > > > > > '/u01/tmp/backupdb/full_backup/%d_%t_%s_%p.dbf'; > > > > > > (muncul eror) > > > > > > eror sebagai berikut : > > > > > > RMAN> restore spfile from > > > > > > > > > > > '/u01/tmp/Backup_DB_Intermas/fullbackup/%d_%t_%s_%p.dbf'; > > > > > > Starting restore at 05-MAR-08 > > > > > > allocated channel: ORA_DISK_1 > > > > > > channel ORA_DISK_1: sid=36 devtype=DISK > > > > > > RMAN-00571: > > > > > > > > > > > =========================================================== > > > > > > RMAN-00569: =============== ERROR MESSAGE STACK > > > > > > FOLLOWS =============== > > > > > > RMAN-00571: > > > > > > > > > > > =========================================================== > > > > > > RMAN-03002: failure of restore command at 03/05/2008 > > > > > > 14:26:56 > > > > > > RMAN-06172: no autobackup found or specified handle > > > > > > is not a valid copy or > > > > > > piece > > > > > > > > > > > > > > > > > > berikut contoh script backup saya : > > > > > > > > > > > > > > > > > > # Full backup of datafiles, control files, and > > > > > > archived log > > > > > > > > > > > > # > > > > > > > > > > > > run { > > > > > > > > > > > > allocate channel ch1 type disk; > > > > > > > > > > > > backup > > > > > > > > > > > > database > > > > > > > > > > > > tag = 'full_backup' > > > > > > > > > > > > filesperset 5 > > > > > > > > > > > > format > > > > > > > > > > > '/home/oracle/OraHome01/flash_recovery_area/full/%d_%t_%s_%p.dbf' > > > > > > > > > > > > ; > > > > > > > > > > > > # archives current redo log > > > > > > > > > > > > sql 'ALTER SYSTEM ARCHIVE LOG CURRENT'; > > > > > > > > > > > > # archives all un-archived redo logs > > > > > > > > > > > > #sql 'ALTER SYSTEM ARCHIVE LOG ALL'; > > > > > > > > > > > > backup > > > > > > > > > > > > current controlfile > > > > > > > > > > > > filesperset 5 > > > > > > > > > > > > format > > > > > > > > > > > '/home/oracle/OraHome01/flash_recovery_area/full/%d_%t_%s_%p.cf' > > > > > > > > > > > > ; > > > > > > > > > > > > backup > > > > > > > > > > > > filesperset 10 > > > > > > > > > > > > format > > > > > > > > > > > '/home/oracle/OraHome01/flash_recovery_area/full/%d_%t_%s_%p.arch' > > > > > > > > > > > > archivelog all > > > > > > > > > > > > delete input > > > > > > > > > > > > ; > > > > > > > > > > > > release channel ch1; > > > > > > > > > > > > } > > > > > > dan hasil backup format nya sebagai berikut : > > > > > > /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 > > > > > > mohon pencerahannya, terima kasih. > > > > > > > > > > > > -- > > > > > > Cheers, > > > > > > ^_^ Andes ^_^ > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been > > > > > > removed] > > > > > > > > > > > > > > > > > > > > > > __________________________________________________________ > > > > > Be a better friend, newshound, and > > > > > know-it-all with Yahoo! Mobile. Try it now. > > > > > http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ > > > > > > > > > > > > > > > > > > > > > > > -- > > > > Cheers, > > > > ^_^ Andes ^_^ > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > -- > > Cheers, > > ^_^ Andes ^_^ > > > > [Non-text portions of this message have been removed] > > > > > > > > [Non-text portions of this message have been removed] > > > -- Cheers, ^_^ Andes ^_^ [Non-text portions of this message have been removed]
