Email: service@parnassusdata.com 7 x 24 online support!
Service request: after recovery comes ORA- 00600 [2663], [3] and DB stops
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=104018739
asim.__java_pool_size=16777216
asim.__large_pool_size=1677721
asim.__oracle_base='/opt/app/o
asim.__pga_aggregate_target=51
asim.__sga_target=1610612736
asim.__shared_io_pool_size=0
asim.__shared_pool_size=503316
asim.__streams_pool_size=16777
undo_management = manual
event = '10513 trace name context forever, level 2'
_allow_resetlogs_corruption=TR
_allow_error_simulation=TRUE
*.audit_file_dest='/opt/app/or
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/opt/app/orac
*.db_block_size=8192
*.db_domain=''
*.db_name='orcl'
*.db_recovery_file_dest='/opt/
*.db_recovery_file_dest_size=4
*.diagnostic_dest='/opt/app/or
*.dispatchers='(PROTOCOL=TCP) (SERVICE=asimXDB)'
*.open_cursors=300
*.pga_aggregate_target=5093982
*.processes=500
*.remote_login_passwordfile='E
*.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)
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.