Well, kalo gitu gampang2 an aja, kopikan ulang system01.dbf dari production database ke standby database, dan coba direcover ulang standby databasenya. Ato last resort recreate aja standby databasenya.
----- Original Message ----- From: "Ditya OOo" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Friday, May 13, 2005 8:16 AM 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/
