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
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