RE: Datafile Coruption

From: Christopher Spence <cspence_at_FuelSpot.com>
Date: Sun, 10 Jun 2001 10:09:15 -0700
Message-ID: <F001.00323677.20010610093522@fatcity.com>

That would certainly work, although the time your typing, the datafile may have changed, and thus your aborting older transactions. That is if vi can even open the file as it has file open limits.

"Walking on water and developing software from a specification are easy if both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot

-----Original Message-----
Sent: Friday, June 08, 2001 9:50 PM
To: Multiple recipients of list ORACLE-L

I would like to simulate the corruption and recovery of a datafile on my development database. How can I corrupt the file and initiate recovery while the database is online? I was thinking I could open the file in VI while the database had it open and append some random characters to it, but would like to hear any other suggestions others may have.

Thanks
Erik

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Erik Williams
INET: ewilliams_at_brownco.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Christopher Spence
INET: cspence_at_FuelSpot.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------