Re: How does one manually corrupt a database (database file, redo logs and backups)

  • From: Andrey Kriushin <Andrey.Kriushin@xxxxxxxx>
  • To: alever@xxxxxxxxx
  • Date: Sun, 03 Sep 2006 14:12:46 +0400

Actually, nice suggestion. In 8i (and probably earlier) no check was made on controlfile size (in the file header against fs) when mounting/opening the database. One of our customers had a problem then with the standby database - he incorrectly transfered cf to standby site (something like dd if=...| rsh 'dd of= '). I.e. standard error of local dd was written somewhere at the end. Problem showed only on cf extend on standby. One thing that helped during investigation - the resulting file size was an ODD number of bytes :-).

Fixed in 9i. Not checked in 10g.

--Andrey

Alessandro Vercelli wrote:
I believe a simple way to corrupt an oracle datafile, redolog, controlfile 
could be:

echo "<somewhat string>" >> oracle_file

-- //www.freelists.org/webpage/oracle-l


Other related posts: