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]
