Halo, Kalo dilihat dari kasus ini memang butuh archivelog yah, karena yah itu datafile headernya udah berubah dan controlfile jg gak sinkron lagi. Nah kalo dari kasus yg anda hadapi ini mesti restore dari full backup. Saran saya kalo untuk Production database aktifkan archivelog nya dan dengan anda memakai fitur Flash_recovery_area saran saya gunakan jg sesuai keperluan untuk size nya. Jika untuk latihan ok2 aja sih pake no archivelog. Untuk Jenis2 backup mungkin anda bisa baca berbagai scenario nya di oracle 10g documentation cukup lengkap :)
salam, Andrew --- cyuniart <[EMAIL PROTECTED]> wrote: > 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! 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/
