Dear Pak Henri & Pak Leonard, Terima kasih banyak atas masukkannya.. Standby saya dah oke sekarang.. Saya cuma perhatikan errornya ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/disk1/oradata/PROD/system01.dbf'
Maka langkah saya hanya seperti berikut ini; 1. Saya buat backup lg data file yg corrupt tersebut di production; alter tablespace SYSTEM begin backup; !cp /disk1/oradata/PROD/system01.dbf /disk1/oradata/backup/disk1/ alter tablespace system end backup; 2. Kemudian saya copy kan lagi file tersebut ke standby (saat proses copy, database standby dah di shutdown) 3. Kemudian Saya copy lagi semua archive file terbaru ke standby; 4. Lalu Saya Recover standby database lagi dan berhasil... Terima kasih atas segala perhatian dan masukkannya.. Regards, Wisnu --- On Tue, 6/23/09, Henri Alia Putra <[email protected]> wrote: > From: Henri Alia Putra <[email protected]> > Subject: RE: External Email : --> RE: External Email : --> [indo-oracle] > Error Recover Standby Database; > To: "[email protected]" <[email protected]> > Date: Tuesday, June 23, 2009, 10:17 PM > > > > Dear wisnu > > > > Saat anda melakukan perintah Recover standby database , > muncul error seperti yang di tamilkan oracle, > > Nah, pada saat bersamaan akan muncul juga error log di > alert log. errornya apa ya, biasanya ada informasi tambahan, > bisa jadi file yang lainnya yang corrupt, atau lain > sebagainya. > > Bisa ga di copas ,error lognya di sini, supaya rekan2 yang > lain bisa bantu. > > > > regards > > > > Henri > > ____________ _________ _________ _________ _ > > From: indo-oracle@ > yahoogroups. com [indo-oracle@ > yahoogroups. com] On Behalf Of wisnu dwi hidayat [wisnu...@yahoo. > com] > > Sent: Tuesday, June 23, 2009 5:08 PM > > To: indo-oracle@ > yahoogroups. com > > Subject: External Email : --> RE: External Email : > --> [indo-oracle] Error Recover Standby Database; > > > > Dear Master Heru & Master Leonardo > > > > Saya sudah lihat lognya dan saya juga sudah pakai command > "recover managed standby database disconnect from > session" , saya juga lihat dari metalink tapi blum bisa > membantu juga.. Mohon kalo ada masukan lagi... Terima kasih > banyak masukkan dari master2 skalian... Apakah saya perlu > melakukan backup online lagi (bukan RMAN)..dan recover > lagi..??? > > > > Regards, > > Wisnu > > > > --- On Tue, 6/23/09, Leonard Sukendro <leon_190699@ > yahoo.com<mailto:leon_ 190699%40yahoo. com>> > wrote: > > > > From: Leonard Sukendro <leon_190699@ > yahoo.com<mailto:leon_ 190699%40yahoo. com>> > > Subject: RE: External Email : --> [indo-oracle] Error > Recover Standby Database; > > To: indo-oracle@ > yahoogroups. com<mailto:indo- oracle%40yahoogr > oups.com> > > Date: Tuesday, June 23, 2009, 4:59 PM > > > > to pak wisnu, > > > > klo blh tau, backup ol nya itu pake apa ya, pak? RMAN kah? > klo pake RMAN, error itu blh d ignore aja, pak... saya ndiri > bln prnah bikin pake RMAN, tp mnrt metalink, error itu emank > expected... mungkin ada tmen2 laen yg dh prnah coba... > > > > bisa lanjutin aja lgs ke "recover managed standby > database disconnect from session;"-nya > > > > moga2 membantu ya, pak... > > > > CMIIW, > > > > [L] > > > > --- On Tue, 6/23/09, Henri Alia Putra <henr...@fif. > astra.co. id> wrote: > > > > From: Henri Alia Putra <henr...@fif. astra.co. id> > > > > Subject: RE: External Email : --> [indo-oracle] Error > Recover Standby Database; > > > > To: "indo-oracle@ yahoogroups. com" > <indo-oracle@ yahoogroups. com> > > > > Date: Tuesday, June 23, 2009, 4:07 PM > > > > Mas Wisnu > > > > Coba liat informasi yang ada di alert_SID.log nya terlebih > dahulu, biasanya ada indormasi tambahan di sana > > > > regards > > > > henri > > > > From: indo-oracle@ yahoogroups. com [indo-oracle@ > yahoogroups. com] On Behalf Of wisnu dwi hidayat > [wisnu...@yahoo. com] > > > > Sent: Tuesday, June 23, 2009 3:53 PM > > > > To: indo-oracle@ yahoogroups. com > > > > Subject: External Email : --> [indo-oracle] Error > Recover Standby Database; > > > > Dear all master, > > > > Saya mohon bantuannya untuk masalah saya saat recover > standby database. > > > > Ketika saya recover standby database saya menemukan error > dibawah ini; > > > > ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS > would get error below > > > > ORA-01152: file 1 was not restored from a sufficiently old > backup > > > > ORA-01110: data file 1: '/disk1/oradata/ PROD/system01. > dbf' > > > > padahal saya telah mencopy dari data file backup online di > production dan berikut archive file terbarunya. > > > > Salam, > > > > Wisnu > > > > [Non-text portions of this message have been removed] > > > > This e-mail and any files transmitted with it are > confidential and intended solely for the use of the > individual or entity to whom they are addressed. If you have > received this email by mistake please notify the sender by > return e-mail and delete this message from your system. Any > unauthorized use or dissemination of this e-mail in whole or > in part is strictly prohibited. PT Federal International > Finance, which has its seat at North of Jakarta, Indonesia, > including its affiliated companies, shall not be liable for > the improper or incomplete transmission of the information > contained in this e-mail nor for any delay in its receipt or > damage to your system. PT Federal International Finance (or > its affiliated companies) does not guarantee that the > integrity of this communication has been maintained nor that > this communication is free of viruses, interceptions or > interference. > > > > [Non-text portions of this message have been removed] > > > > [Non-text portions of this message have been removed] > > > > This e-mail and any files transmitted with it are > confidential and intended solely for the use of the > individual or entity to whom they are addressed. If you have > received this email by mistake please notify the sender by > return e-mail and delete this message from your system. Any > unauthorized use or dissemination of this e-mail in whole or > in part is strictly prohibited. PT Federal International > Finance, which has its seat at North of Jakarta, Indonesia, > including its affiliated companies, shall not be liable for > the improper or incomplete transmission of the information > contained in this e-mail nor for any delay in its receipt or > damage to your system. PT Federal International Finance (or > its affiliated companies) does not guarantee that the > integrity of this communication has been maintained nor that > this communication is free of viruses, interceptions or > interference. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
