Вы здесь

UNDO

Место в тейблспейсах

 
column "Схема"   format a15;
column "Таблица"   format a15;
 
SELECT a.owner "Схема",
       a.table_name "Таблица",
       b.bytes "Размер (Мб)",
       TRUNC((a.blocks * 100) / b.blocks) "Занято(%)",
       b.extents "Экстентов"
FROM dba_tables a,
     (
        SELECT owner, segment_name, SUM(bytes)/1024/1024 bytes,
               SUM(blocks) blocks, COUNT(*) extents
          FROM dba_extents

ORA-01578: ORACLE data block corrupted in UNDO

SQL> STARTUP;
ORACLE instance started.

Total System Global Area 2.1379E+10 bytes
Fixed Size 2185160 bytes
Variable Size 1.0133E+10 bytes
Database Buffers 1.1207E+10 bytes
Redo Buffers 36151296 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-01578: ORACLE data block corrupted (file # 3, block # 240)
ORA-01110: data file 3: 'G:\APP\ORACLE\ORADATA\ORUSX2\UNDOTBS01.DBF'

При попыке пересоздать

Как пересоздать табличное пространство TEMP

Here is a script that will display the contents of the TEMP tablespace.

set pagesize 60 linesize 132 verify off
break on file_id skip 1

column file_id heading "File|Id"
column tablespace_name for a15
column object          for a15
column owner           for a15
column MBytes          for 999,999

 

Резвимся на UNDO

SQL> sho parameter undo

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 86700
undo_tablespace string UNDOTBS1

SQL> select sum(bytes)/1024/1024 from dba_undo_extents;

SUM(BYTES)/1024/1024
--------------------
4199.5

Пересоздать undo

Смена UNDO TABLESPACE Во-первых, необходимо узнать текущие UNDO параметры:

SQL> show parameter undo;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

undo_management string AUTO

Подписка на RSS - UNDO