can any one tell me how can I simulate or cause block corruption on test DB
in order to test my recovery procedures in case of block corruption.
note that I know that there is a way to do so but oracle support do not show it
Printable View
can any one tell me how can I simulate or cause block corruption on test DB
in order to test my recovery procedures in case of block corruption.
note that I know that there is a way to do so but oracle support do not show it
Create a small tablespace with a single datafile, then "corrupt" it by copying some other file into the datafile.
I already tried it and I could not open the database.
I know that there is a oracles' utility that can cause corruption
Have you tried editing the file with a HEX editor. I would get about half way into the file, then key in a bunch of null values.