Terima kasih pak andrew, Saya baru belajar cara2 backup n restore, error dibawah ini muncul karena saya ganti datafile (a) yg sebenernya dengan backupnya (a'), dimana antara a' dan a ini tidak sinkron, a adalah datafile sesudah ada perubahan (insert) pada datafile a'. saya memakai oracle 10g (10.1.0.3) dan database dalam mode noarchivelog.
dengan kondisi seperti ini apakah ada cara agar database bisa di startup..? Thx b4, Condro --- In [email protected], "Andrew E.K." <[EMAIL PROTECTED]> wrote: > Kebetulan saya blom alami yg seperti ini, tpi ini saya > ambil dari metalink semoga membantu : > > Error: ORA-19901 (ORA-19901) > Text: database needs more recovery to create new > incarnation > -------------------------------------------------------------------- ------- > Cause: Recovery was done to an incarnation after > changing the > destination incarnation using RMAN's RESET DATABASE > command, but > one or more of the recovered datafiles still belongs > to the parent > incarnation. This usually happens when recovery is > ended before > any logs from the desired incarnation have been > applied. > Action: Continue recovery. > > Salam, > > Andrew > > --- cyuniart <[EMAIL PROTECTED]> wrote: > > > Dear all, > > Waktu startup database muncul error > > > > ORA-01190: controlfile or data file 5 is from before > > the last > > RESETLOGS > > ORA-01110: data file 5: > > '/u01/hodwkd/datafile/readonly01.dbf' > > > > SQL> alter database recover until cancel; > > alter database recover until cancel > > * > > ERROR at line 1: > > ORA-00279: change 323683 generated at 09/27/2005 > > 16:19:41 needed for > > thread 1 > > ORA-00289: suggestion : > > > /oracle/flash_recovery_area/HODWKD/archivelog/2005_09_29/ o1_mf_1_187_% > > u_.arc > > ORA-00280: change 323683 for thread 1 is in sequence > > #187 > > > > > > SQL> alter database recover cancel; > > alter database recover cancel > > * > > ERROR at line 1: > > ORA-01547: warning: RECOVER succeeded but OPEN > > RESETLOGS would get > > error below > > ORA-19901: database needs more recovery to create > > new incarnation > > > > > > SQL> alter database open resetlogs; > > alter database open resetlogs > > * > > ERROR at line 1: > > ORA-19901: database needs more recovery to create > > new incarnation > > > > ada yang tau gak solusinya ... ???? > > > > > > thx b4, > > Condro > > > > > > > > > > > __________________________________ > Yahoo! Mail - PC Magazine Editors' Choice 2005 > http://mail.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- 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/
