Dear All.....
Saya lagi mencoba untuk restore dan startup database. Saat ini saya memiliki
datafile2 lengkap dengan system.dbf. Saya coba create new controlfile dan
berhasil...
SQL> @/data003/oradata/orcl/elltst_from_ellprd.sql
ORACLE instance started.
Total System Global Area 1207959552 bytes
Fixed Size 2072424 bytes
Variable Size 318767256 bytes
Database Buffers 872415232 bytes
Redo Buffers 14704640 bytes
Control file created.
Kemudian muncul masalah pada saat startup.
SQL> startup
ORACLE instance started.
Total System Global Area 1207959552 bytes
Fixed Size 2072424 bytes
Variable Size 318767256 bytes
Database Buffers 872415232 bytes
Redo Buffers 14704640 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
saya baca2 ternyata perlu direset Log-nya. Sudah saya lakukan dan berhasil.
SQL> Recover database using backup controlfile;
ORA-00279: change 2576389724 generated at 11/02/2008 15:37:00 needed for thread
1
ORA-00289: suggestion :
/usr/oracle/product/10.2.0/flash_recovery_area/ELLGPP2/archivelog/2008_11_02/o1_
mf_1_1_%u_.arc
ORA-00280: change 2576389724 for thread 1 is in sequence #1
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/usr/oracle/product/10.2.0/flash_recovery_area/ELLGPP2/archivelog/2008_11_02/log3b_ellprd.log
Log applied.
Media recovery complete.
Kemudian saya recovery, muncul pesan dibawah..
SQL> Alter database open resetlogs;
Alter database open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
Masalahnya Oracle instance terminated. kemudian saya liat alert log, sebgai
berikut:
ARCH: Connecting to console port...
*** 2008-11-02 15:54:33.214
Prior to RESETLOGS processing...
ALTER SYSTEM ARCHIVE LOG ALL USING BACKUP CONTROLFILE start
Database is not in archivelog mode
ALTER SYSTEM ARCHIVE LOG ALL USING BACKUP CONTROLFILE complete
*** 2008-11-02 15:54:33.264
Thread 1: Sequence reset to 1.
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
So, masalahnya kemudian, dibilang kalau database harus jalan dengan UPGRADE
option. Muncul pesan :
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 1207959552 bytes
Fixed Size 2072424 bytes
Variable Size 318767256 bytes
Database Buffers 872415232 bytes
Redo Buffers 14704640 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1:
'/data003/oradata/ellgpp2/dbs/data101/system_ellprd.dbf'
Pesan diatas muncul karena recovery belum dilakukan. Tapi pada saat saya coba
recovery log, akan muncul pesan bahwa startup harus ugrade option...
Adapun database yang direstore dari 9i ke 10G...
Apakah memang tidak bisa restore database dengan copy datafile ke beda versi
oracle..?? atau mungkin ada yang salah dengan cara yang saya lakukan...
Mohon dengan sangat masukkannya...
Salam,
Dharma Setiadi
