Asalkan Anda pernah lakukan backup controlfile dan spfile, itu sama saja dengan hasilnya autobackup.
On 19/01/2008, Andes Febrian <[EMAIL PROTECTED]> wrote: > > Terima kasih banyak pak, saya akan coba. tp sepertinya saya tidak punya > file > autobackup spfile dan controlfile. tp akan saya coba liat lg deh. makasih > sekali lg. > > On 1/13/08, Yoel Susanto <[EMAIL PROTECTED] <yoel.ade%40gmail.com>> > wrote: > > > > Ok. First of all lets try to restore your spfile & controlfile. > > > > *1. Copy your autobackup file to /tmp* > > *2. Export ORACLE_SID=orclstby* > > *3. RMAN connect to target* > > > > oracle>rman target / > > Recovery Manager: Release 10.2.0.3.0 - Production on Mon Jan 14 09:36:10 > > 2008 > > > > Copyright (c) 1982, 2005, Oracle. All rights reserved. > > > > connected to target database (not started) > > > > *4. Startup force instance* > > > > RMAN> startup force nomount > > > > startup failed: ORA-01078: failure in processing system parameters > > LRM-00109: could not open parameter file > > '/oratest/oracle/product/10.2.0/dbs/initLASQA.ora' > > > > starting Oracle instance without parameter file for retrival of spfile > > Oracle instance started > > > > Total System Global Area 159383552 bytes > > > > Fixed Size 2071192 bytes > > Variable Size 67110248 bytes > > Database Buffers 83886080 bytes > > Redo Buffers 6316032 bytes > > > > *5. Restore spfile from autobackup file* > > > > RMAN> restore spfile from '/tmp/o1_mf_s_643973405_3rogrxdl_.bkp'; > > > > Starting restore at 14-JAN-08 > > using target database control file instead of recovery catalog > > allocated channel: ORA_DISK_1 > > channel ORA_DISK_1: sid=156 devtype=DISK > > > > channel ORA_DISK_1: autobackup found: > > /tmp/o1_mf_s_643973405_3rogrxdl_.bkp > > channel ORA_DISK_1: SPFILE restore from autobackup complete > > Finished restore at 14-JAN-08 > > > > *6. Restore Controlfile from autobackup file* > > > > RMAN> restore controlfile from '/tmp/o1_mf_s_643973405_3rogrxdl_.bkp'; > > > > Starting restore at 14-JAN-08 > > using channel ORA_DISK_1 > > > > channel ORA_DISK_1: restoring control file > > channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 > > output filename=/oratest/oracle/oradata/LASQA/control01.ctl > > output filename=/oratest/oracle/oradata/LASQA/control02.ctl > > output filename=/oratest/oracle/oradata/LASQA/control03.ctl > > Finished restore at 14-JAN-08 > > > > *7. Restart your instance to use restored SPFILE* > > > > RMAN> shutdown abort > > > > Oracle instance shut down > > > > RMAN> startup nomount > > > > connected to target database (not started) > > Oracle instance started > > > > Total System Global Area 629145600 bytes > > > > Fixed Size 2074792 bytes > > Variable Size 390072152 bytes > > Database Buffers 230686720 bytes > > Redo Buffers 6311936 bytes > > > > *8. Mount the database (If this command succesful, congratulation you > have > > restore your controlfile successfully )* > > > > RMAN> alter database mount > > 2> ; > > > > database mounted > > > > Give it a try!. > > Next step would be to restore datafile and open your DB. > > > > Good luck! > > > > 2008/1/12 Andes Febrian <[EMAIL PROTECTED] > > <pejantan4u%40gmail.com><pejantan4u%40gmail.com>>: > > > > > maaf kurang infonya, keburu ke send. > > > > > > 3. server yg baru ORACLE_HOME=/u01/app/oracle/product/10.2/db_1 > > > sama dgn yg lama > > > 4. server baru ORACLE_SID=orclstby > > > sama dgn yg lama > > > 5. pake di server yg lama, tp udah kehapus, karena ke format ulang :D > > > > > > terima kasih > > > > > > > > > On 1/12/08, Andes Febrian <[EMAIL > > > PROTECTED]<pejantan4u%40gmail.com><pejantan4u%40gmail.com><pejantan4u%40gmail.com>> > > > wrote: > > > > > > > > 1. Oracle version 10.2 > > > > 2. yg saya punya hanya backup rman, autobackup set controlfile dan > > > spfile > > > > apakah sudah termasuk di backup rman, fyi, saya backup dgn rman, > > > menggunakan > > > > full backup db option > > > > > > > > On 1/10/08, Yoel Susanto <[EMAIL PROTECTED] <yoel.ade%40gmail.com>< > yoel.ade%40gmail.com> < > > yoel.ade%40gmail.com>> > > > wrote: > > > > > > > > > > Pak Andes, > > > > > > > > > > Bisa kasih info berikut : > > > > > 1. Oracle version > > > > > 2. Apakah anda punya autobackup set controlfile dan spfilenya? > kalo > > > ada > > > > > backup pfile akan lebih mudah. > > > > > 3. ORACLE_HOME directory > > > > > 4. ORACLE_SID > > > > > 5. Kalo Anda pakai oracle 10g apakah Anda menggunakan > > > > > flash_recovery_area? > > > > > > > > > > Sekian dulu pertanyaan saya. > > > > > > > > > > On Jan 10, 2008 7:54 PM, Andes Febrian <[EMAIL > > > > > PROTECTED]<pejantan4u%40gmail.com> > <pejantan4u%40gmail.com> > > <pejantan4u%40gmail.com> > > > <pejantan4u%40gmail.com>> > > > > > wrote: > > > > > > > > > > > terima kasih atas responnnya pak, > > > > > > > > > > > > 1. skrg di server pc yg baru saya install oracle software aja, > tp > > > > > ketika > > > > > > saya ketik dari prompt "rman target /" keluar tulisan rman : > can't > > > > > open > > > > > > target. jadi gmn cara restorenya ya klo melalui rman ? > > > > > > 2. waktu saya backup di pc lama gak pake catalog pak, hanya > > control > > > > > file. > > > > > > dan saya sudah lupa configuration di pc lama, karena sudah ilang > > > > > semuanya, > > > > > > alias udah ke format :( > > > > > > > > > > > > terima kasih. > > > > > > > > > > > > > > > > > > On 1/9/08, Leonard Sukendro <[EMAIL > > > > > > PROTECTED]<leon_190699%40yahoo.com> > <leon_190699%40yahoo.com> > > <leon_190699%40yahoo.com> > > > <leon_190699%40yahoo.com> > > > > > <leon_190699%40yahoo.com>> > > > > > > wrote: > > > > > > > > > > > > > > > > > > > > > to pak andes, > > > > > > > > > > > > > > saya coba jawab, pak, moga2 bisa membantu.. CMIIW, > > > > > > > 1. gk usah, pak, cukup software oraclenya aja... nanti > > > > > > > khan database nya di restore dr rman, boss.. > > > > > > > 2. klo boleh tau, rman nya pake catalog gk ya, pak? > > > > > > > soalnya bakal jauh lbh gampang klo pake catalog... > > > > > > > well, tmptnya gk perlu sama sech, pokoknya sesuai dgn > > > > > > > settingan "configure device type disk....bla2" di > > > > > > > rmannya aja... ini bkn masalah formatnya, boss, tp > > > > > > > supaya rmannya tau dmana letak file2 hasil backup > > > > > > > nya.. n format2 file rmannya dibuat sama di server yg > > > > > > > baru. klo mo aman, hasil dr perintah "show all" di > > > > > > > rman prompt yg lama, dijalanin lagi aja di rman prompt > > > > > > > server baru... > > > > > > > 4. ini bisa pake perintah "startup force nomount" di > > > > > > > rman prompt.. rman akan otomatis generate dummy > > > > > > > spfile.. perlunya cmn supaya databasenya bisa nomount > > > > > > > aja, boss.. > > > > > > > > > > > > > > moga2 membantu n gk salah :D > > > > > > > > > > > > > > regards, > > > > > > > [L] > > > > > > > > > > > > > > --- Andes Febrian <[EMAIL > > > > > > > PROTECTED]<pejantan4u%40gmail.com><pejantan4u%40gmail.com><pejantan4u%40gmail.com><pejantan4u%40gmail.com><pejantan4u%40gmail.com><pejantan4u%40gmail.com>> > > > > > wrote: > > > > > > > > > > > > > > > Hi all, > > > > > > > > > > > > > > > > saya pernah menanyakan hal dibawah ini pada email > > > > > > > > sebelumnya, > > > > > > > > saya punya backup file full database yg dibackup dgn > > > > > > > > menggunakan rman, lalu > > > > > > > > bila saya mau merestore backup-an itu ke server > > > > > > > > baru, gmn ya ?? > > > > > > > > > > > > > > > > Lalu mendapat jawaban seperti ini, tp ada yg mau > > > > > > > > saya tanya : > > > > > > > > 1. Install Oracle software dimesin linux yg baru >>> > > > > > > > > apakah bagian ini > > > > > > > > termasuk create database jg ? > > > > > > > > 2. Copy seluruh hasil backup ke mesin linux yg baru > > > > > > > > (utk lebih mudahnya, > > > > > > > > lokasinya dibuat sama) >> hasil backup saya berupa > > > > > > > > rman format, apakah perlu > > > > > > > > ditempatkan lokasi yg sama ? > > > > > > > > 3. Set environment variables (spt: ORACLE_HOME, > > > > > > > > ORACLE_SID, dll) - done > > > > > > > > 4. Buat dummy parameter file (atau copy dari origin > > > > > > > > server) >> gmn cara > > > > > > > > buatnya ? > > > > > > > > 5. Jalankan RMAN, startup nomount, lalu restore > > > > > > > > SPFILE dari hasil > > > > > > > > autobackup (kecuali kalau sudah copy dari origin > > > > > > > > server) > > > > > > > > 6. Restore CONTROLFILE dari hasil autobackup > > > > > > > > 7. alter database mount > > > > > > > > 8. restore database > > > > > > > > 9. recover database > > > > > > > > 10. open database > > > > > > > > > > > > > > > > Catt : backup controlfile dan spfile, dibackup dgn > > > > > > > > rman. klo autobackup > > > > > > > > sepertinya gak ada. > > > > > > > > > > > > > > > > terima kasih > > > > > > > > > > > > > > > > -- > > > > > > > > Cheers, > > > > > > > > ^_^ Andes ^_^ > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been > > > > > > > > removed] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > __________________________________________________________ > > > > > > > Looking for last minute shopping deals? > > > > > > > Find them fast with Yahoo! Search. > > > > > > > > > > http://tools.search.yahoo.com/newsearch/category.php?category=shopping > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > Cheers, > > > > > > ^_^ Andes ^_^ > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > Cheers, > > > > ^_^ Andes ^_^ > > > > > > -- > > > 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]
