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/
