hi,
Saya coba bantu yah,
- Coba anda check space untuk destination archive lognya,full atau tidak? Hal
ini bisa terjadi dikarenakan log destination nya full.
- Jika memang full , coba shutdown immediate dan startup mount lalu set
archivelog OFF.
- Coba lagi open database nya. Cek juga di alert lognya.
- Bisa anda attach file dumpnya "/u02/acccls/dump/bdump/acccls_smon_6781.trc" ?
- Bila Database nya berhasil di open pasti kan anda shutdown immediate lagi dan
startup kembali. Cek juga di alert log nya, jika masih ada error.
Semoga membantu
Andrew
nhomsan <[EMAIL PROTECTED]> wrote: dh ,
para oracle mania ... tolongin donkkk ...
aku punya database production . sewaktu aku mau Up , ada pesen error
ORA-01092: ORACLE instance terminated. Disconnection forced
di alert lognya yang aku lihat spt ini :
Errors in file /u02/acccls/dump/udump/acccls_ora_6809.trc:
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-08103: object no longer exists
Fri Mar 31 07:47:59 2006
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Fri Mar 31 07:47:59 2006
Errors in file /u02/acccls/dump/bdump/acccls_smon_6781.trc:
ORA-00704: bootstrap process failure
Fri Mar 31 07:47:59 2006
ARC0: Completed archiving log 3 thread 1 sequence 4
ARC0: Detected ARCH process failure
ARC0: STARTING ARCH PROCESSES
di file acccls_ora_6809.trc errornya spt ini :
.....
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 0
Average hash chain = 0/0 = 0.0
Max compares per lookup = 0
Avg compares per lookup = 0/0 = 0.0
----------------------------------------------
*** 2006-03-31 07:47:59.581
KCRA: start recovery claims for 0 data blocks
*** 2006-03-31 07:47:59.581
KCRA: buffers claimed = 0/0, eliminated = 0
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 0
Average hash chain = 0/0 = 0.0
Max compares per lookup = 0
Avg compares per lookup = 0/0 = 0.0
----------------------------------------------
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-08103: object no longer exists
gimana caranya agar database tsb bisa di Up yach ..?? apa
ada cara untuk force Up atau ngetrace object apa yang hilang ..??
please .. tolong bantuannya .. soalnya penting ...
Thank's
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "indo-oracle" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
---------------------------------
New Yahoo! Messenger with Voice. Call regular phones from your PC for low, low
rates.
---------------------------------
How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates.
[Non-text portions of this message have been removed]
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
