Hello community.
I have an issue with "alter database open resetlogs" issue.
It doesn't matter, who is "executor". SQLPLUS or RMAN. The same stuck.
"alter database open resetlogs" stuck at "somewhere" after redo logs cleanup. All redologs are cleaned successfully.
"Last" detected activity
SQL> select EVENT, STATE, SID,serial#, status, sql_id from v$session where program like 'rman%' and status='ACTIVE';
EVENT STATE SID SERIAL# STATUS SQL_ID
---------------------------------------------------------------- ------------------- ---------- ---------- -------- -------------
db file sequential read WAITED SHORT TIME 548 3 ACTIVE 7j16t46cacjt9
SQL> select sql_text from v$sql where sql_id='7j16t46cacjt9';
SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------
alter database open resetlogs
SQL> select P1TEXT||'='||p1 as "file", P2TEXT||'='||p2 as "block", P3TEXT||'='||p3 as "blocks" from v$session where program like 'rman%' and status='ACTIVE';
file block blocks
--------------- --------------- ---------------
file#=1 block#=44385 blocks=1
SQL> select segment_name, segment_type, owner
from dba_extents
where file_id = 1
and 44385 between block_id
and block_id + blocks -1; 2 3 4 5
SEGMENT_NAME SEGMENT_TYPE OWNER
--------------------------------------------------------------------------------- ------------------ ------------------------------
I_CCOL2 INDEX SYS
- it stucks for a ~ 48hrs and got an exception
RMAN-06136: ORACLE error from auxiliary database: ORA-00603: ORACLE server session terminated by fatal error
ORA-04030: out of process memory when trying to allocate 16360 bytes (callheap,kcbtmal allocation)
ORA-04030: out of process memory when trying to allocate 1712 bytes (callheap,kprbalo temp memory)
I would appreciate for any ideas.