Dear All.... Masih berkutat dengan restore database,hehe... Terakhir saya coba dengan orale 9i, create controlfile berhasil, recovery redolog juga berhasil, kemudian pada saat saya open database 'alter database open resetlogs;' muncul pesan error :
SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-00603: ORACLE server session terminated by fatal error Dan oracle-nya mati, saya liat alert log-nya sbg berikut : word xsoqcursormaxrowstocacheperreq_ [1101FB7DC, 1101FB7E0) = 00000365 word xsoqcursormaxtimeforpartialcache_ [1101FB7E0, 1101FB7E4) = 00000366 word xsoqsourcetrace_ [1101FB7E4, 1101FB7E8) = 00000367 struct _xsawpga * xsawpga_ [1101FB7E8, 1101FB7F0) = 00000000 00000000 struct _xsoqpga * xsoqpga_ [1101FB7F0, 1101FB7F8) = 00000000 00000000 word ksmpgl_ [1101FB7F8, 1101FB7FC) = 00000000 ----- Dump of the Fixed SGA ----- ***** SGA not mapped ***** ----- Dump of the Fixed UGA ----- ***** no UGA ***** KSTDUMP: SGA no longer mapped Simple saya, SGA-nya kurang, saya coba naikkan (dengan ubah di inidatabase.ora) tetap tidak bisa... Kira-kira kenapa ya? Kemungkinan datafile-datafile nya rusak ada mungkin ga ya? Salam dan Terimakasih Dharma Setiadi --- On Mon, 11/3/08, Yoel Susanto <[EMAIL PROTECTED]> wrote: > From: Yoel Susanto <[EMAIL PROTECTED]> > Subject: Re: [indo-oracle] restore database dari 9i ke 10g dengan datafile... > To: [email protected] > Date: Monday, November 3, 2008, 9:24 PM > ORA-01152: file 1 was not restored from a sufficiently old > backup > artinya backup set yang anda restore lebih current daripada > controlfilenya. > > beberapa referensi yang mungkin berguna tentang Backup > & Recovery > > http://www.indo-oracletech.com/forum/viewtopic.php?f=7&t=143 > http://www.indo-oracletech.com/forum/viewtopic.php?f=7&t=145 > > 2008/11/4 Dharma Setiadi <[EMAIL PROTECTED]> > > > Dear All.... > > > > Akhirnya saya coba dengan oracle 9i dan tidak bisa > startup, tapi pesan > > errornya beda lagi.... > > Pertama saya create controlfile dan sukses. Kemudian > saya alter : > > > > > > SQL> alter database open resetlogs; > > alter database open resetlogs > > * > > ERROR at line 1: > > ORA-01152: file 1 was not restored from a sufficiently > old backup > > ORA-01110: data file 1: > > > '/data003/oradata/ellgpp2/dbs/data101/system_ellprd.dbf' > > > > Menurut saya ini karena belum saya recover > database-nya, saya coba jalankan > > perintah dibawah : > > > > SQL> Recover database using backup controlfile; > > ORA-00279: change 2576349671 generated at 09/26/2008 > 13:29:08 needed for > > thread > > 1 > > ORA-00289: suggestion : > /usr/oracle/product/9.2.0/dbs/arch1_5.dbf > > ORA-00280: change 2576349671 for thread 1 is in > sequence #5 > > > > Specify log: {<RET>=suggested | filename | AUTO > | CANCEL} > > /data003/oradata/ellgpp2/dbs/data101/log1a_ellprd.log > > Log applied. > > Media recovery complete. > > > > Sukses, saya masukkan log file yang sebelumnya. > kemudian saya coba open > > lagi dan muncul pesan dibawah... > > > > SQL> alter database open resetlogs; > > alter database open resetlogs > > * > > ERROR at line 1: > > ORA-00603: ORACLE server session terminated by fatal > error > > > > Saya coba liat alert lognya, sebagai berikut : > > > > 700000000029B70 00000000 00000000 00000000 00000000 > [................] > > 700000000029B80 00000000 00000000 00010000 00000000 > [................] > > 700000000029B90 00000001 00000000 00000000 00000000 > [................] > > 700000000029BA0 07000000 00029BA8 0000004D 00000000 > [...........M....] > > 70000000002 > > > > *** DUMP FILE SIZE IS LIMITED TO 5242880 BYTES *** > > > > Kira-kira kenapa ya?? Yang saya bingung perintah > revocer database, maksud > > perintah ini recovery redolog database. Jadi Perintah > "Recover database > > using backup controlfile;" mengembalikan redolog > yang ada. Misalkan saya > > maunya redolog-nya kembali dari awal gmn ya? saya > sudah coba CANCEL sebagai > > berikut : > > > > SQL> Recover database using backup controlfile; > > ORA-00279: change 2576349674 generated at 11/04/2008 > 09:07:22 needed for > > thread > > 1 > > ORA-00289: suggestion : > /usr/oracle/product/9.2.0/dbs/arch1_1.dbf > > ORA-00280: change 2576349674 for thread 1 is in > sequence #1 > > > > Specify log: {<RET>=suggested | filename | AUTO > | CANCEL} > > CANCEL > > Media recovery cancelled. > > > > Kemudian database minta recovery lagi.... > > > > SQL> alter database open resetlogs; > > alter database open resetlogs > > * > > ERROR at line 1: > > ORA-01113: file 1 needs media recovery > > ORA-01110: data file 1: > > > '/data003/oradata/ellgpp2/dbs/data101/system_ellprd.dbf' > > > > Ada ide? kira2 salahnya dimana ya? > > > > Terimakasih sebelumnya... > > Salam, > > Dharma Setiadi > > > > --- On Mon, 11/3/08, Yoel Susanto > <[EMAIL PROTECTED]<yoel.susanto%40gmail.com>> > > wrote: > > > > > From: Yoel Susanto <[EMAIL PROTECTED] > <yoel.susanto%40gmail.com>> > > > Subject: Re: [indo-oracle] restore database dari > 9i ke 10g dengan > > datafile... > > > To: [email protected] > <indo-oracle%40yahoogroups.com> > > > Date: Monday, November 3, 2008, 12:14 AM > > > > > 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]<greensea_setiadi%40yahoo.com> > > > > > > > > > > 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> > > > <ffahlevi%40gmail.com>> > > > > wrote: > > > > > > > > > From: Abi <[EMAIL PROTECTED] > <ffahlevi%40gmail.com> > > > <ffahlevi%40gmail.com>> > > > > > Subject: Re: [indo-oracle] restore > database dari > > > 9i ke 10g dengan > > > > datafile... > > > > > To: [email protected] > <indo-oracle%40yahoogroups.com> > > > <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> > > <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] > > > > > > > > > > -- > Cheers, > Yoel Susanto > > www.indo-oracletech.com > > > [Non-text portions of this message have been removed]
