makasih atas koreksi nya. maaf, memang saya bacanya gak begitu detil, agak terburu2 :D dan saya pikir tadinya, saya buat script backup controlfile otomatis akan backup spfile dan masu ke file tersebut. dan ternyata masuknya ke datafile#1.
makasih banyak pak Yoel, saya coba lg. 2008/3/5 Yoel Susanto <[EMAIL PROTECTED]>: > 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 ? > > > > > > > > > > > > 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> > > > > <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><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] > > > > > > > > [Non-text portions of this message have been removed] > > > -- Cheers, ^_^ Andes ^_^ [Non-text portions of this message have been removed]
