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 --------------------~-->
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/cd_AJB/QnQLAA/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/
