Mungkin bisa dicoba untuk memaksa primary database melakukan switch logfile beberapa kali, sekitar 4 kali. Perintahnya 'alter system switch logfile'. Setelah itu, seperti disarankan Pak Wendry, copykan semua archive yang terbentuk. Mulai dari satu archive setelah yang terakhir diapply di standby database (bisa dilihat di file alert.log) sampai archive yang terakhir terbentuk di primary database. Kemudian jalankan lagi recover standby datatabase dan alter database open read only.
Regards, Arief Dh -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Ditya OOo Sent: 13 Mei 2005 8:16 To: [email protected] Subject: Re: [indo-oracle] Error di Standby DATABASE Salam Kenal Pak Wendry, Waktu saya Recover Standby Database dan Alter database open read only tetap aja seperti pada error sebelumnya 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: 'D:\ORA9i\ORADATA\ORA9i\SYSTEM01.dbf' Thank's for ur help,Regard's... Dit ----- Original Message ----- From: "Wendry Yang" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, May 12, 2005 4:34 PM Subject: Re: [indo-oracle] Error di Standby DATABASE > Setahu saya itu berarti SYSTEM01.dbf tidak sukses di recover. Mungkin ada > archive log yang kurang diapply (perlu diambilkan dari production > database). > Coba statement Recover Standby Database lalu dilihat file archive log yang > perlu diapply. Kalau sudah coba juga alter database open read only. > > > ----- Original Message ----- > From: "Ditya OOo" <[EMAIL PROTECTED]> > To: <[email protected]> > Cc: "Ditya OOo" <[EMAIL PROTECTED]> > Sent: Thursday, May 12, 2005 1:15 PM > Subject: [indo-oracle] Error di Standby DATABASE > > >> Dear All, >> Saya mendapatkan error seperti ini pada saat mengaktifkan Standby >> database,mungkin dari rekan ada yang tau error tsb >> >> sql > alter database activate standby database >> * >> ERROR at line 1 : >> ORA-01152: file 1 was not restored from a sufficiently old backup >> ORA-01110: data file 1: 'D:\ORA9i\ORADATA\ORA9i\SYSTEM01.dbf' >> >> >> Mohon bantuan dari Rekan - rekan >> >> Tks >> Dit >> >> >> >> -- >> -----------I.N.D.O - O.R.A.C.L.E--------------- >> Keluar: [EMAIL PROTECTED] >> Website: http://indo-oracle.blogspot.com >> ----------------------------------------------- >> >> Bergabung dengan Indonesia Thin Client User Groups, >> Terminal Server, Citrix, New Moon Caneveral, di: >> http://indo-thin.vze.com >> Yahoo! Groups Links >> >> >> >> >> >> >> > > > > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: http://indo-oracle.blogspot.com > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.vze.com > Yahoo! Groups Links > > > > > > -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
