Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ora-01092 oracle instance terminated

JohnMackanziNov 29 2012 — edited Nov 30 2012
please help me regarding recovery of database

When i connect sys as sysdba
after successfully login
startup
nomout successfull
mount successfull
when open then error generate
ora-01092 oracle instance terminated

i have tried my best to resolve this issue but i could not find any solution plz help me because i have no backup
or i could not under stand why error occur

when i see my alert log file

Errors in file d:\oracle\product\10.2.0\admin\ora10g\udump\ora10g_ora_684.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [31], [9], [], [], [], [], []

Error 604 happened during db open, shutting down database
USER: terminating instance due to error 604
Thu Nov 29 15:36:19 2012
Errors in file d:\oracle\product\10.2.0\admin\ora10g\bdump\ora10g_pmon_2928.trc:
ORA-00604: error occurred at recursive SQL level

Thu Nov 29 15:36:19 2012
Errors in file d:\oracle\product\10.2.0\admin\ora10g\bdump\ora10g_mman_888.trc:
ORA-00604: error occurred at recursive SQL level

Thu Nov 29 15:36:19 2012
Errors in file d:\oracle\product\10.2.0\admin\ora10g\bdump\ora10g_dbw0_3904.trc:
ORA-00604: error occurred at recursive SQL level

Thu Nov 29 15:36:19 2012
Errors in file d:\oracle\product\10.2.0\admin\ora10g\bdump\ora10g_reco_3972.trc:
ORA-00604: error occurred at recursive SQL level

Thu Nov 29 15:36:19 2012
Errors in file d:\oracle\product\10.2.0\admin\ora10g\bdump\ora10g_smon_284.trc:
ORA-00604: error occurred at recursive SQL level

Thu Nov 29 15:36:19 2012
Errors in file d:\oracle\product\10.2.0\admin\ora10g\bdump\ora10g_ckpt_2584.trc:
ORA-00604: error occurred at recursive SQL level

Thu Nov 29 15:36:19 2012
Errors in file d:\oracle\product\10.2.0\admin\ora10g\bdump\ora10g_lgwr_3920.trc:
ORA-00604: error occurred at recursive SQL level

Thu Nov 29 15:36:19 2012
Errors in file d:\oracle\product\10.2.0\admin\ora10g\bdump\ora10g_psp0_3756.trc:
ORA-00604: error occurred at recursive SQL level

Instance terminated by USER, pid = 684
ORA-1092 signalled during: alter database open resetlogs

trace file error
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [31], [9], [], [], [], [], []
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 28 2012
Added on Nov 29 2012
9 comments
741 views