<Harry_Boswell_at_deq.state.ms.us> wrote in message
news:34oui0phcf5p2kmnbdhisd80morh3vpo7j_at_4ax.com...
> On Fri, 27 Aug 2004 15:50:03 GMT, Hans Forbrich <forbrich_at_yahoo.net>
> wrote:
>
> >Harry_Boswell_at_deq.state.ms.us wrote:
> >
> >> Actually, What I want to do is test my backup and recovery procedures.
> >> So I'm wanting to come up with ways to break the database. There are
> >> obvious ways - delete a control file or redo log file, or just
> >> accidentally change some data. But are there other potential mishaps
> >> I could cause to occur to test the plans?
> >>
> >> Thanks,
> >> Harry Boswell
> >
> >The OS is relevant to your question.
>
> Sorry!
>
> Solaris 2.6 & Solaris 9.
>
> Oracle 8.1.7 and Oracle 9.2.0.5.
>
>
>
- rm all you archivelogs and rm all your redologs.
shutdown abort.
rm the system tablespace.
try to restart.
- Or have the unix sysadmins restore the whole box from a few days before.
- Or disable archivelog mode, and do 1. above without a cold backup
anywhere.
Received on Mon Aug 30 2004 - 18:43:24 CDT
