Hi Stefick,
Running stored procedures/packages is somewhat
difficult with a shutdown database, so the database needs to be
opened.
Depending on the type of corrupted block in
question answers whether or not the block is actually repaired (eg. bitmap block
in ASSM segments, freelist blocks...) or simply marked as corrupt and thus could
be made "skippable" meaning that your FTS will now work and skip the stuffed
buggers.
That said, I would recommend restoring you stuffed
datafile, perform a database recovery and hope the corruption wasn't duplicated
in your backup(s). dbms_repair should be used if all else fails (or you don't
really mind losing that "bit" of your database).
Good Luck
Richard Foote
|
Title: Message
- DBMS_REPAIR Package Stefick Ronald S Contr ESC/HRIDD
- RE: DBMS_REPAIR Package Stefick Ronald S Contr ESC/HRIDD
- Re: RE: DBMS_REPAIR Package rgaffuri
- RE: DBMS_REPAIR Package Richard Foote
- RE: DBMS_REPAIR Package Jared . Still
- Re: DBMS_REPAIR Package Daniel Fink
- Re: DBMS_REPAIR Package Tanel Poder