Dear Senior Oracle.
Saya sedang ngalami masalah serius dengan oracle server saya,
yaitu database tidak bisa open setelah mounting database
( tidak bisa di alter database open dengan pesan
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open )
kemudian saya lakukan reset log
SVRMGR> alter database open resetlogs;
alter database open resetlogs
*
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/data1/oradata/SKKERIS/system01.dbf'
lalu saya lakukan recover database from backup control file
SVRMGR> recover database until cancel using backup controlfile;
ORA-00279: change 10155239765 generated at 09/08/2008 16:50:35 needed for
thread
1
ORA-00289: suggestion : /exp_backup/SKKERIS/arch/arch_1_56093.arc
ORA-00280: change 10155239765 for thread 1 is in sequence #56093
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
saya tidak punya archive sesui yang direcomendasikan
saya punya archive dngan sequence 56092
pada waktu saya masukan 56092
/exp_backup/SKKERIS/arch/arch_1_56092.arc
ORA-00310: archived log contains sequence 56092; sequence 56093 required
ORA-00334: archived log: '/exp_backup/SKKERIS/arch/arch_1_56092.arc'
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error
below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/data1/oradata/SKKERIS/system01.dbf'
saya tidak tahu harus bagaimana
adakah rekan2 senior oracle yang bisa bantu ,
terima kasih atas perhantiannya sebelumnya
salam,
agung
Oh ya oracle = 8.1.7 , OS Tru Unix 64
[Non-text portions of this message have been removed]
