Service request: after recovery comes ORA- 00600 [2663], [3] and DB stops

Posted by PDSERVICE on Oct 23, 2018 In

after server was ocasionally powered off by hosting provider, I can not

recover my database.

SQL> connect / as sysdba;

Connected to an idle instance.

SQL> startup restrict pfile=init.ora;

ORACLE instance started.

Total System Global Area 1603411968 bytes

Fixed Size 2213776 bytes

Variable Size 553650288 bytes

Database Buffers 1040187392 bytes

Redo Buffers 7360512 bytes

Database mounted.

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01092: ORACLE instance terminated. Disconnection forced

ORA-00600: internal error code, arguments: [2663], [3], [1513108817], [3],

[1513126862], [], [], [], [], [], [], []

Process ID: 24438

Session ID: 292 Serial number: 5

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

PL/SQL Release 11.2.0.1.0 - Production

CORE 11.2.0.1.0 Production

TNS for Linux: Version 11.2.0.1.0 - Production

NLSRTL Version 11.2.0.1.0 - Production

SQL> select log_mode from v$database;

LOG_MODE

------------

NOARCHIVELOG

$ cat init.ora

asim.__db_cache_size=1040187392

asim.__java_pool_size=16777216

asim.__large_pool_size=16777216

asim.__oracle_base='/opt/app/oracle'#ORACLE_BASE set from environment

asim.__pga_aggregate_target=5100273664

asim.__sga_target=1610612736

asim.__shared_io_pool_size=0

asim.__shared_pool_size=503316480

asim.__streams_pool_size=16777216

undo_management = manual

event = '10513 trace name context forever, level 2'

_allow_resetlogs_corruption=TRUE

_allow_error_simulation=TRUE

*.audit_file_dest='/opt/app/oracle/admin/orcl/adump'

*.audit_trail='db'

*.compatible='11.2.0.0.0'

*.control_files='/opt/app/oracle/oradata/orcl/control01.ctl','/opt/app/oracle/flash_recovery_area/orcl/control02.ctl'

*.db_block_size=8192

*.db_domain=''

*.db_name='orcl'

*.db_recovery_file_dest='/opt/app/oracle/flash_recovery_area'

*.db_recovery_file_dest_size=4070572032

*.diagnostic_dest='/opt/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=asimXDB)'

*.open_cursors=300

*.pga_aggregate_target=5093982208

*.processes=500

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=1610612736

*.undo_management='AUTO'

*.undo_tablespace='UNDOTBS1'

Can you help and how much it costs?

You can try our recover tool here: parnassusdata.com ,the software costs 1500usd.

We also provide recover service .

Okay, but how I can be sure that your tool can recover my database? I can mount but I can not open it it crashes with ORA 600 error. Can you tool really connect to it and get data and stored objects?

You can download the software ,and try it first.

Can your tool also recover views, stored procedures and triggers?

yes , it can recover ddl statement including view procedure & trigger .

Hello, which recovery mode should I choose in my case (mode = noarchivelogs, Oracle crashes with 600 error after standard recovery attempt)?

dictionary-mode is ok

Well I began with the system tablespace and give the tool its single datafile system01.dbf. But I see only table definition in the tool. Can I see stored procedures, packages, views?

The stored procedures, packages, views creation scripts are Enterprise Edition functions.

The trial version will not extract these info.

How can I be sure that these functions are really supported and work with my database? Because it is really important for me.

the software read ddl from base table like sys.view$ ,sys.source$ , if this tables can be recovered , that means there is no problem with ddl.

Do you have another options for purchase? Standard edition or something else? Because 1500 $ is very expensive for me ...

standard edition is no longer available , only enterprise edition available .

which DB_NAME is to be entered? Corrupted DB or new DB for bridging/copy?

Corrupted DB

How quick you send me the license or download link for software if i purchase your license?

in 10 minutes.

can this db name be changed or if i need to repair another DB I need to buy one more license?

another DB with different db_name require one more license.

does your tool support partitioned tables?
if some view is not valid, can your tool put it in the database?
will the licensed version show me the objects DDLs in the tree view (Linux version)

yes

yes

				in text , not in tree view.

You are here

Service request: after recovery comes ORA- 00600 [2663], [3] and DB stops

Service request: after recovery comes ORA- 00600 [2663], [3] and DB stops