Monday, 8 October 2018

ORA-00600: internal error code, arguments: [4194], [#], [#]


Error: ORA-00600: internal error code, arguments: [4194], [#], [#]
You can see this error in alert log file, when starting the PDB, alter Tablespace command, and it may crash db any time.
Oracle Database Edition Release 12.2.0.1.0 – 64bit Production.
This error indicates that a mismatch has been detected between redo records and rollback (undo) records.
Here ARGUMENTS: [4194], [#], [#]
Arg [a] – Maximum Undo record number in Undo block
Arg [b] – Undo record number from Redo block
Resolution steps are as follows:
alter session set container=PDB01;

create undo tablespace UNDOTBS3 datafile '/user1/containerdb/undotbs03.db' size 2000M;

SQL> alter system set undo_tablespace=UNDOTBS3 scope=both;

SQL> drop tablespace UNDOTBS1 including contents and datafiles;

select tablespace_name, status, segment_name from dba_rollback_segs where status != 'OFFLINE';

TABLESPACE_NAME           STATUS               SEGMENT_NAME
--------------------      -------            ---------------- 
SYSTEM                    ONLINE             SYSTEM
UNDOTBS3                  ONLINE             _SYSSMU1_2906661113$


SQL> shutdown immediate;
Pluggable Database closed.
SQL> startup;
Pluggable Database opened.
SQL> show pdbs

CON_ID        CON_NAME      OPEN MODE           RESTRICTED
----------    -----------   -------------       ----------   
10            OSDC141       READ WRITE          NO

No comments:

Post a Comment