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?
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?
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?
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]
