conceptnya : 1. Restore dengan Oracle9i Home 2. Test dulu bisa gak di buka databasenya 3. Kalau bisa, lanjutkan dengan upgrade ke 10g
Cara ganti env dengan contoh ORACLE_HOME export ORACLE_HOME=<path> export PATH=$ORACLE_HOME/bin dan selanjutnya. 2008/11/3 Dharma Setiadi <[EMAIL PROTECTED]> > 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] <ffahlevi%40gmail.com>> > wrote: > > > From: Abi <[EMAIL PROTECTED] <ffahlevi%40gmail.com>> > > Subject: Re: [indo-oracle] restore database dari 9i ke 10g dengan > datafile... > > To: [email protected] <indo-oracle%40yahoogroups.com> > > 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]<greensea_setiadi%40yahoo.com> > > > > > > > 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] > > > -- Cheers, Yoel Susanto www.indo-oracletech.com [Non-text portions of this message have been removed]
