Loading...
Posts Tagged ‘undo tablespace’
  1. if you get ORA-00600 or the following error message on your Oracle standby database:

    Fri Mar 09 10:57:49 2007
    Errors in file c:\oracle\admin92\crm\bdump\crmsb_mrp0_524.trc:
    ORA-00600: internal error code, arguments: [3020], [356515961], [1], [4606], [2], [16], [], []
    ORA-10567: Redo is inconsistent with data block (file# 85, block# 121)
    ORA-10564: tablespace UNDOTBS2
    ORA-01110: data file 85: ‘K:\ORADATA\CRM\UNDOTBS02_1.DBF’
    ORA-10560: block type ‘KTU SMU HEADER BLOCK’

    Or your undo tablespace has grown to unmanageable size (~ 35 Gbytes), you may want to recreate unto tablespace. Here is how:
    More…

    Popularity: 49% [?]

Powered by ExtJS Theme flavored Wordpress.