Rekans milis yang baik,
Database Oracle saya tidak mau startup, setelah saya mencoba ganti control file
dari ketiga control file oracle (control01.dbf,control02.dbf,control03.dbf)
maka file control03.dbf bisa dipake untuk startup dan mount database.
Tapi ketika saya coba startup database,
SQL> startup
ORACLE instance started.
Total System Global Area 129673244 bytes
Fixed Size 75804 bytes
Variable Size 57856000 bytes
Database Buffers 71663616 bytes
Redo Buffers 77824 bytes
Database mounted.
malah muncul error :
ORA-01113: file 5 needs media recovery
ORA-01110: data file 5: 'D:\SERVER\ORACLE\ORADATA\CAKEP\TOOLS01.DBF'
Saya coba recover file tersebut,
SQL> recover datafile 'D:\SERVER\ORACLE\ORADATA\CAKEP\TOOLS01.DBF';
malah muncul error :
ORA-00283: recovery session canceled due to errors
ORA-00341: log 3 of thread 1, wrong log # 1 in header
ORA-00312: online log 3 thread 1: 'D:\SERVER\ORACLE\ORADATA\CAKEP\REDO01.LOG'
saya coba command dibawah ini :
SQL> alter database noarchivelog;
Database altered.
SQL> recover datafile 'D:\SERVER\ORACLE\ORADATA\CAKEP\TOOLS01.DBF';
Tapi tetap muncul error yang sama :
ORA-00283: recovery session canceled due to errors
ORA-00341: log 3 of thread 1, wrong log # 1 in header
ORA-00312: online log 3 thread 1: 'D:\SERVER\ORACLE\ORADATA\CAKEP\REDO01.LOG'
Oracle yang saya gunakan adalah Oracle 8i
Mohon bantuannya ...
Terima kasih sebelumnya..
Wasalam,
Naldy
__________________________________________________________
Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com
[Non-text portions of this message have been removed]
