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]
