Re: DBMS_REPAIR Package

[Richard Foote]

Title: Message

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 ----- Original Message ----- From: Stefick Ronald S Contr ESC/HRIDD To: Multiple recipients of list ORACLE-L Sent: Thursday, July 17, 2003 11:54 PM Subject: DBMS_REPAIR Package Has anyone ever used DBMS_REPAIR? If so, what do you think of it, does the DB have to be shutdown to run it. Does it really fix any corrupt blocks in the datafiles?  We ran DBVerify and found several corrupt DB files in one of our DB's.   TIA, Scott Stefick MILPDS OCP Oracle DBA [EMAIL PROTECTED]  210-565-2540