咨询微信: dbservice1234 7 x 24 在线支持!

oracle Database that don't start

oracle Database that don't start

We have a database that don't start. Also when we try your program, we can see the schema, even the tables, but there is no data there. We need at least to extract the data from the schema but we don't know how. We need to extract only 11 tables data.

Please find attached the reports files.

The problem apear on the alertlog, We already try to assign another scn but happens, the same, reports the error:

 

ARC1: STARTING ARCH PROCESSES COMPLETE
ARC1: Becoming the heartbeat ARCH
Wed Apr 04 15:34:07 2018
Errors in file e:\admin\orclf\udump\orclf_ora_2004.trc:
ORA-00600: código de error interno, argumentos: [2662], [0], [144940666], [0], [145107847], [4194313], [], []

Wed Apr 04 15:34:08 2018
Errors in file e:\admin\orclf\udump\orclf_ora_2004.trc:
ORA-00600: código de error interno, argumentos: [2662], [0], [144940666], [0], [145107847], [4194313], [], []

Wed Apr 04 15:34:08 2018
Error 600 happened during db open, shutting down database
USER: terminating instance due to error 600
Wed Apr 04 15:34:08 2018
Errors in file e:\admin\orclf\bdump\orclf_pmon_6108.trc:
ORA-00600: codigo de error interno, argumentos: [], [], [], [], [], [], [], []

Wed Apr 04 15:34:09 2018
Errors in file e:\admin\orclf\bdump\orclf_reco_5400.trc:
ORA-00600: codigo de error interno, argumentos: [], [], [], [], [], [], [], []

Wed Apr 04 15:34:10 2018
Errors in file e:\admin\orclf\bdump\orclf_smon_5708.trc:
ORA-00600: codigo de error interno, argumentos: [], [], [], [], [], [], [], []

Wed Apr 04 15:34:10 2018
Errors in file e:\admin\orclf\bdump\orclf_ckpt_2584.trc:
ORA-00600: codigo de error interno, argumentos: [], [], [], [], [], [], [], []

Wed Apr 04 15:34:10 2018
Errors in file e:\admin\orclf\bdump\orclf_lgwr_5840.trc:
ORA-00600: codigo de error interno, argumentos: [], [], [], [], [], [], [], []

Wed Apr 04 15:34:10 2018
Errors in file e:\admin\orclf\bdump\orclf_dbw0_2292.trc:
ORA-00600: codigo de error interno, argumentos: [], [], [], [], [], [], [], []

Wed Apr 04 15:34:10 2018
Errors in file e:\admin\orclf\bdump\orclf_mman_5324.trc:
ORA-00600: codigo de error interno, argumentos: [], [], [], [], [], [], [], []

Wed Apr 04 15:34:10 2018
Errors in file e:\admin\orclf\bdump\orclf_psp0_4412.trc:
ORA-00600: codigo de error interno, argumentos: [], [], [], [], [], [], [], []

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

 

 

I clear the log and start over. The schema have the name FRILOBON and one of the tables is vdstock.

This is the current log:

 

Parsing E:\oradata_\ORCLF\SYSTEM01.DBF file header:
DB Software version: 00 00 00 00
DB Compatibility version: 0A 20 01 00
DB id: 3086238578
DB Name: ORCLF
File logical blocks count: 64000
Database character set is WE8MSWIN1252
Database national character set is AL16UTF16
Current character set for decoding is CP1252
Current national character set for decoding is UTF16

For Community Edition, row limitation is 10,000.
If you need to recover more data, please contact ParnassusData Corp. service@parnassusdata.com

Cannot find dbf file for relative File# 7 ,TS# 8

. unloading table VDSTOCK 0 rows unloaded
Cannot find dbf file for relative File# 7 ,TS# 8

. unloading table VDSTOCK 0 rows unloaded
Exception when parseing data object VDSTOCK$AUD under schema FRILOBON: Invalid cursor state - no current row.
java.sql.SQLException: Invalid cursor state - no current row.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.newSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.checkOnRow(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.getColumn(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.getLong(Unknown Source)
at bT.a(Unknown Source)
at bT.a(Unknown Source)
at bT.d(Unknown Source)
at bT.g(Unknown Source)
at P.d(Unknown Source)
at by.m(Unknown Source)
at by.mouseClicked(Unknown Source)
at java.awt.AWTEventMulticaster.mouseClicked(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$500(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: ERROR 24000: Invalid cursor state - no current row.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 48 more
Cannot find dbf file for relative File# 7 ,TS# 8

. unloading table VDSTOCK 0 rows unloaded

You can get more documents from www.parnassusdata.com

 

It looks like you have just input one data file which the system01.dbf. You need to input all data files.

 

Ok!!!!!!!

That do the trick but i only see a few rows, like 20 or so. Whats the price of the full version?

 

1500 usd

I clear the log and start over. The schema have the name FRILOBON and one of the tables is vdstock.

This is the current log:

 

Parsing E:\oradata_\ORCLF\SYSTEM01.DBF file header:
DB Software version: 00 00 00 00
DB Compatibility version: 0A 20 01 00
DB id: 3086238578
DB Name: ORCLF
File logical blocks count: 64000
Database character set is WE8MSWIN1252
Database national character set is AL16UTF16
Current character set for decoding is CP1252
Current national character set for decoding is UTF16

For Community Edition, row limitation is 10,000.
If you need to recover more data, please contact ParnassusData Corp. service@parnassusdata.com

Cannot find dbf file for relative File# 7 ,TS# 8

. unloading table VDSTOCK 0 rows unloaded
Cannot find dbf file for relative File# 7 ,TS# 8

. unloading table VDSTOCK 0 rows unloaded
Exception when parseing data object VDSTOCK$AUD under schema FRILOBON: Invalid cursor state - no current row.
java.sql.SQLException: Invalid cursor state - no current row.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.newSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.checkOnRow(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.getColumn(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.getLong(Unknown Source)
at bT.a(Unknown Source)
at bT.a(Unknown Source)
at bT.d(Unknown Source)
at bT.g(Unknown Source)
at P.d(Unknown Source)
at by.m(Unknown Source)
at by.mouseClicked(Unknown Source)
at java.awt.AWTEventMulticaster.mouseClicked(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$500(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: ERROR 24000: Invalid cursor state - no current row.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 48 more
Cannot find dbf file for relative File# 7 ,TS# 8

. unloading table VDSTOCK 0 rows unloaded

You can get more documents from www.parnassusdata.com