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]> 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, 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]>
>
> > 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]
