--- In [email protected], "Subekti Pranoto" <[EMAIL PROTECTED]> wrote: > > Platform : Microsoft Windows 2000 Server > Oracle 9i R2 Enterprise Edition > Archived Log Mode > > > 1. CONTROL FILE RUSAK > KEmarin saya diminta bantuan client. saya lihat di alert log bahwa ada masalah di control file. saya coba shutdown database OK. Saya coba start database muncul peringatan bahwa control file 'CONTROL03.CTL' rusak. saya coba copy 'CONTROL02.CTL' menjadi 'CONTROL03.CTL' lalu database saya start, database open. saya pikir masalah control file ini selesai. ada hal yg belum saya lakukan? >
Jika controlfile nya di copy dalam keadaan database nya sedang shutdown ini tidak akan menimbulkan masalah karena controlfilenya dalam keadaan consistent. > 2. TABLESPACE 'USERS' OFFLINE > saya coba cek kondisi tablespace. ternyata tablespace 'USERS' dalam kondisi OFFLINE. > =============================================================================================== > D:\>sqlplus "sys/[EMAIL PROTECTED] as sysdba" > > SQL*Plus: Release 9.2.0.1.0 - Production on Thu Mar 1 19:00:02 2007 > > Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. > > > Connected to: > Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production > With the Partitioning, OLAP and Oracle Data Mining options > JServer Release 9.2.0.1.0 - Production > > SQL> ALTER TABLESPACE USERS ONLINE; > ALTER TABLESPACE USERS ONLINE > * > ERROR at line 1: > ORA-01113: file 9 needs media recovery > ORA-01110: data file 9: 'H:\ORADATA\TEST\USERS01.DBF' > > > SQL> ALTER DATABASE RECOVER TABLESPACE "USERS"; > ALTER DATABASE RECOVER TABLESPACE "USERS" > * > ERROR at line 1: > ORA-00283: recovery session canceled due to errors > ORA-01124: cannot recover data file 9 - file is in use or recovery > ORA-01110: data file 9: 'H:\ORADATA\TEST\USERS01.DBF' > > =============================================================================================== > apa yang harus saya lakukan agar tablespace 'USERS' ONLINE? > bagaimana jika dengan perintah: SQL> ALTER TABLESPACE USERS OFFLINE; SQL> ALTER DATABASE RECOVER TABLESPACE USERS; > > 3 REDOLOG MISMATCH > =============================================================================================== > SQL> shutdown; > Database closed. > Database dismounted. > ORACLE instance shut down. > > SQL> startup RESTRICT; > ORACLE instance started. > > Total System Global Area 135338868 bytes > Fixed Size 453492 bytes > Variable Size 109051904 bytes > Database Buffers 25165824 bytes > Redo Buffers 667648 bytes > Database mounted. > ORA-16068: redo log file activation identifier mismatch > ORA-00312: online log 1 thread 1: 'H:\ORADATA\TEST\REDO01.LOG' > > SQL> SELECT GROUP#, ARCHIVED, STATUS FROM V$LOG; > > GROUP# ARC STATUS > ---------- --- ---------------- > 1 NO CURRENT > 2 YES INACTIVE > 3 YES INACTIVE > > SQL> ALTER SYSTEM SWITCH LOGFILE; > ALTER SYSTEM SWITCH LOGFILE > * > ERROR at line 1: > ORA-01109: database not open > =============================================================================================== > Redolog database ternyata bermasalah juga. bagaimana penyelesaiannya? > Kayaknya kalo yang ini harus di lakukan incomplete recovery deh.. tapi coba lakukan dulu yang 1 dan 2 sambil menunggu jagoan2 disini memberikan balasan yang jauh lebih baik lagi :) > > pendapat saya, database nya banyak masalahnya, sampai malu untuk menceritakan lebih detil. client sudah menyiapkan server backup sbg cadangan, akan tetapi saya belum yakin dapat memindahknnya bila melihat banyak masalah yg ada. saya harus memulai darimana untuk menyelamatkan database itu? > > > regard, > subekti > > [Non-text portions of this message have been removed] >
