После создания таблицы repair_table пакет DBMS_REPAIR можно запускать.
В эту таблицу будет заноситься информация обо всех повреждённых данных.

alter database create standby controlfile as 'path\name01.ctl';

1. alter database create standby controlfile as 'path\name01.ctl';
2. переименовываем name01.ctl в name02.ctl
3. alter tablespace tbs_01 begin backup;
4. копирование управляющих и одного битого датафайла на стенбай.
5. отслеживание undo tbs.
6.  alter tablespace tbs_01 end backup;

SQL> analyze table c_dictionary validate structure cascade online;

Table analyzed.

SQL> analyze table c_dictionary validate structure cascade online;

Table analyzed.

-- Create the INVALID_ROWS table
SQL> @C:\Oracle\901\rdbms\admin\UTLVALID.SQL

-- Validate the table structure.
SQL> ANALYZE TABLE scott.emp VALIDATE STRUCTURE;

-- Validate the table structure along with all it's indexes.
SQL> ANALYZE TABLE scott.emp VALIDATE STRUCTURE CASCADE;

-- Validate the index structure.
SQL> ANALYZE INDEX scott.pk_emp VALIDATE STRUCTURE;

SQL> @C:\Oracle\product\11.2.0\dbhome_1\RDBMS\ADMIN\utlvalid.sql

Table created.

SQL> analyze table prv validate structure cascade online;

Table analyzed.

SQL> select * from invalid_rows;

no rows selected

create global temporary table INVALID_ROWS (
  owner_name         varchar2(30),
  table_name         varchar2(30),
  partition_name     varchar2(30),
  subpartition_name  varchar2(30),
  head_rowid         rowid,
  analyze_timestamp  date
) on commit preserve rows;

shu immediate;
startup open read only;
analyze table prv validate structure cascade online;
set lines 130;
spool c:\invalid_rows\invalid_rows.log
select * from invalid_rows;
spool off;

spool c:\invalid_rows\invalid_rows.log
analyze table prv validate structure cascade online;
select * from invalid_rows;
spool off;