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

  • From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
  • To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
  • Date: Sun, 3 Sep 2006 09:57:27 +0200

echo "<somewhat string>" >> oracle_file

This should alter the file offset (I don't know if this is
the correct technical term) for every binary file and thus
making it corrupted towards and Oracle db.
The command should also work for both unix and windows.

try it, I doubt it..appending junk at the end of a datafile might not cause any headache until the next autoextend...

On Solaris:
[...]

'echo "<somewhat string>" >> oracle_file' will corrupt the file, but oracle will detect it only when it tries to read/write to that block(s) at the end of the file. Rman, as far as I know, will detect it immediately too, except for some spacial cases (block change tracking enabled with certain type of backup).



Regards
Dimitre


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


Other related posts: