salam, sudah saya coba pak tapi masih tidak bisa juga, SQL>alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-00139: RESETLOGS option only valid after an incomplete database recovery thank's Alif
--- On Wed, 21/10/09, mohammad arief pradipto <[email protected]> wrote: From: mohammad arief pradipto <[email protected]> Subject: Re: [indo-oracle] ORA-01033: ORACLE initialization or shutdown in progress To: [email protected] Date: Wednesday, 21 October, 2009, 4:01 PM 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 <alif_sokhibi@ yahoo.com> > > > 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 <aa.ad...@gmail. > com<aa.adipt%40gmail. com>> > wrote: > > From: mohammad arief pradipto <aa.ad...@gmail. com <aa.adipt%40gmail. com>> > Subject: Re: [indo-oracle] ORA-01033: ORACLE initialization or shutdown in > progress > To: indo-oracle@ yahoogroups. com <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 aa.ad...@gmail. com 021 68 535 141 http://adipt. net/ [Non-text portions of this message have been removed] 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]
