Go to the FreeLists Home Page Home Signup Help Login
 



[oracle-l] || [Date Prev] [09-2006 Date Index] [Date Next] || [Thread Prev] [09-2006 Thread Index] [Thread Next]

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


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






[ Home | Signup | Help | Login | Archives | Lists ]

All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
Everything else ©2007 Avenir Technologies, LLC.