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]> 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>>: > > > 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>> > > 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> > > > >: > > > > > > > > > > > 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>> > 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]
