Sebaiknya, Anda melakukan prosedur restore/recover masih di 9i sampai selesai, baru kemudian lakukan prosedur upgrade ke 10g.
Salam AM --- In [email protected], Dharma Setiadi <[EMAIL PROTECTED]> wrote: > > 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 >
