1

Topic: Despite recovery, the Oracle falls with 600 an error

Colleagues I welcome;
After at the server  a supply, despite  recovery, the Oracle falls with 600 an error. Tried all recipes, including _ALLOW_RESETLOGS_CORRUPTION=TRUE and alter system set "_ktb_debug_flags" =8... Does not want to rise in any way. More low that I do that.
Help please!
Many thanks!
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'

2

Re: Despite recovery, the Oracle falls with 600 an error

Can it is necessary roll an update of Oraklu?
Still found the exception recipe corrupted rollback segments: http://www.acehints.com/2012/02/databas … pted.html, who can already so did, can advise how much it is applicable in my case?
Thanks!