Re: events to corrupt a database
- From: Chip Briggs <chip.briggs@xxxxxxxxx>
- To: Josh.Collier@xxxxxxxxxxxx
- Date: Fri, 16 May 2014 07:04:59 -0600
Login as sysdba followed by using SQL to generate SQL that drops SYS
dtabase objects.
Such a script is useful when want to drop all database objects in a schema
followed by importing them.
Alternate challenge is dropping a number of tables, then finding out
various backup files are missing so one month of secondary storage has one
complete set of database files spanning several backups. Desired data
existed before earliest backup set and did not change during the month.
Can the data be recovered ?
RMAN hot backup, change temp tablespace from dictionary managed to locally
managed, followed by truncating a table. Can data be recovered ?
On Mon, May 12, 2014 at 12:16 PM, Josh Collier <Josh.Collier@xxxxxxxxxxxx>wrote:
> I am looking for different events to set that will corrupt a database,
> or mimic a crash or error condition. For testing and training purposes? Any
> awesome ways to break an oracle database beyond the standard “delete a live
> redo log”, “delete a live datafile”, and “kill pmon”
>
>
>
> Josh C.
>
Other related posts:
