7 x 24 在线支持!
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.
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)