Hi rekans,
 
mohon pencerahan,
 
kemarin saya coba pindahkan lokasi datafile seperti panduan pada thread yg 
sebelumnya,
 
tetapi pada saat startup database memberikan pesan error seperti dibawah ini
 
SQL> startup
ORACLE instance started.
Total System Global Area  219223120 bytes
Fixed Size                   451664 bytes
Variable Size             201326592 bytes
Database Buffers           16777216 bytes
Redo Buffers                 667648 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL>
 
kemudian yang saya coba lakukan 
 
 SQL> Recover database using backup controlfile;
ORA-00279: change 18554358603 generated at 07/29/2005 20:28:42 needed for 
thread 1
ORA-00289: suggestion : /oracle/app/product/9.2.0.4/dbs/arch1_13.dbf
ORA-00280: change 18554358603 for thread 1 is in sequence #13

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
 
CANCEl
Media recovery cancelled.
SQL> alter database open resetlogs
  2  ;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oracle/app/product/oradata/RADGINE/system01.dbf'

SQL>

Gimana ya, cara supaya database bisa di open lagi
 
Best regards
 

 

                
---------------------------------
 Start your day with Yahoo! - make it your home page 

[Non-text portions of this message have been removed]



------------------------ Yahoo! Groups Sponsor --------------------~--> 
<font face=arial size=-1><a 
href="http://us.ard.yahoo.com/SIG=12h63tphm/M=362329.6886308.7839368.1510227/D=groups/S=1705007183:TM/Y=YAHOO/EXP=1122707022/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992
">Fair play? Video games influencing politics. Click and talk back!</a>.</font>
--------------------------------------------------------------------~-> 

--
-----------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/
 


Kirim email ke