Kalau sudah muncul error seperti ini lain ceritanya pak. Dugaan saya redo lognya corrupt - mungkin karena blackout tiba - tiba sementara database masih ada transaksi yang aktif. Bapak bilang ini database di rumah, berarti hanya database coba coba kan??Kalau bapak mau open database, redo log-nya harus direset dulu. Boleh coba command ini SQL> alter database open resetlogs;
regards, adipt 2009/10/21 Alif Sokhibi <[email protected]> > > > salam, > > sudah saya coba pak, berikut hasilnya : > > > SQL> select name, database_role, open_mode from v$database; > NAME DATABASE_ROLE OPEN_MODE > --------- ---------------- ---------- > CARD PRIMARY MOUNTED > > > SQL> alter database open; > alter database open > * > ERROR at line 1: > ORA-00320: cannot read file header from log 3 of thread 1 > ORA-00312: online log 3 thread 1: 'C:\ORACLE\ORADATA\CARD\REDO03.LOG' > > > > > masih tidak bisa juga pak. > > thank's > > Alif > > --- On Wed, 21/10/09, mohammad arief pradipto > <[email protected]<aa.adipt%40gmail.com>> > wrote: > > From: mohammad arief pradipto <[email protected] <aa.adipt%40gmail.com>> > Subject: Re: [indo-oracle] ORA-01033: ORACLE initialization or shutdown in > progress > To: [email protected] <indo-oracle%40yahoogroups.com> > Date: Wednesday, 21 October, 2009, 2:14 PM > > > > > Kalau dapat error tsb, berarti keadaan database tidak dalam keadaan open, > bisa jadi dia dalam keadaan nomount atau mount. Untuk mengeceknya ketikkan > command berikut > SQL> select name, database_role, open_mode from v$database; > > apabila betul nilai open_mode-nya bukan 'OPEN', maka buka database tsb > > SQL> alter database open; > > CMIIW > regards, > > adipt > > 2009/10/21 Alif Sokhibi <alif_sokhibi@ yahoo.com> > > > > > > > salam, > > > > dear all Indo Oracle, > > mohon bantuannya di karenakan akhir2 ini rumah saya selalu mati lampu, > yang > > akhirnya menyebabkan komputer harus hidup - mati - hidup -mati melulu... > > nah setelah lampu menyala saya coba untuk connect ke Oracle kembali namun > > ngga bisa masuk-masuk dan ada pesan errornya yaitu : > > > > ORA-01033: ORACLE initialization or shutdown in progress > > > > mohon solusinya para master oracle semuanya... > > > > thank's > > > > Alif > > > > New Email addresses available on Yahoo! > > Get the Email name you've always wanted on the new @ymail and > > @rocketmail. > > Hurry before someone else does! > > http://mail. promotions. yahoo.com/ newdomains/ aa/ > > > > [Non-text portions of this message have been removed] > > > > > > > > -- > adipt > aa.ad...@gmail. com > 021 68 535 141 > http://adipt. blogspot. com/ > > [Non-text portions of this message have been removed] > > Get your preferred Email name! > Now you can @ymail.com and @rocketmail.com. > http://mail.promotions.yahoo.com/newdomains/aa/ > > [Non-text portions of this message have been removed] > > > -- adipt [email protected] 021 68 535 141 http://adipt.net/ [Non-text portions of this message have been removed]
