Dear All... Terimakasih masukkannya... Tapi tetap ga bisa... kok jadinya susah ya... Hehe... Oke, saya coba step2 yang dibawah, tapi ga bisa. Pada saat alter database, muncul pesan terminated, jadi untuk create database-nya sendiri masih bermasalah. Mungkin harusnya saya startup dulu dengan 9i baru upgrade 10g..
So, sebenarnya database-nya startup saja belum bisa, gimana mau upgrade... Sekarang masalahnya bagaimana saya startup di 9i?? Di server saya ada 9i dan 10g. default-nya 10g misalkan saya mau gunain yang 9i gmn ya? Cara pengubah env-nya gmn? hehe... Salam, Dharma Setiadi --- On Sun, 11/2/08, Abi <[EMAIL PROTECTED]> wrote: > From: Abi <[EMAIL PROTECTED]> > Subject: Re: [indo-oracle] restore database dari 9i ke 10g dengan datafile... > To: [email protected] > Date: Sunday, November 2, 2008, 7:05 PM > Pak Dharma, > Ketika bapak sudah restore datafile-create controlfile > (Kondisi database > dalam keadaan mount), mungkin bisa dicoba cara berikut pak: > - database harus diopen upgrade : > SQL> Alter database open resetlogs upgrade; > - Install and upgrade database components > SQL>@?/rdbms/admin/catuprgd.sql > - Check Status upgrade > SQL>@?/rdbms/admin/utlu102s.sql > - Shutdown > SQL>shutdown immediate > - startup normal > SQL>startup > - compile invalid objects > SQL>@?/rdbms/admin/utlrp.sql > Selamat mencoba pak... > > regards, > > Fahmi > 2008/11/2 Dharma Setiadi <[EMAIL PROTECTED]> > > > 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 > > > > . > > > > > > > > > [Non-text portions of this message have been removed]
