After server was accidentally powered off by hosting provider, I cannot 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 2 asim.__java_pool_size=16777216 asim.__large_pool_size=1677721 6 asim.__oracle_base='/opt/app/o racle'#ORACLE_BASE set from environment asim.__pga_aggregate_target=51 00273664
asim.__sga_target=1610612736 asim.__shared_io_pool_size=0 asim.__shared_pool_size=503316 480 asim.__streams_pool_size=16777 216 undo_management = manual event = '10513 trace name context forever, level 2' _allow_resetlogs_corruption=TR UE _allow_error_simulation=TRUE *.audit_file_dest='/opt/app/or acle/admin/orcl/adump' *.audit_trail='db' *.compatible='11.2.0.0.0' *.control_files='/opt/app/orac
le/oradata/orcl/control01.ctl','/opt/app/Oracle/flash_recove ry_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=4 070572032 *.diagnostic_dest='/opt/app/or acle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=asimXDB)' *.open_cursors=300 *.pga_aggregate_target=5093982 208 *.processes=500
*.remote_login_passwordfile='E XCLUSIVE' *.sga_target=1610612736 *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' Can you help and how much it costs?
You can try our recovery tool here: DBRECOVER for Oracle. See current pricing on the product page.
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 editionAvailable .
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.
DBRECOVER Recovery Options
For Oracle incidents, start with the DBRECOVER for Oracle trial to verify table visibility, row previews, and export readiness on copied datafiles. For MySQL and InnoDB incidents, DBRECOVER for MySQL is free software and can inspect.ibd files, ibdata1, and database directories locally.
When the case is urgent, preserve the original files first, work from copies, and contact paid emergency support with the database version, platform, error messages, file list, and recovery objective.