Re: How to break Oracle so that I must recover from hot backup

From: Jerry Gitomer <jgitomer_at_erols.com>
Date: Sat, 31 Mar 2001 23:58:37 +0000
Message-ID: <9a6cf2$9ht$2@bob.news.rcn.net>

> Rhugga wrote:
>
> > I am running 817 on SuSE 7.0 in archivelog mode. I want to
> > simulate a failure, thus requiring me to recover from
> > archive logs and the last hot backup of the datafiles.
> >
> > What is the easiest way to do this?
> >

On the test database go into the Linux command line and copy a null file to one of the Oracle datafiles. Restore from the latest backup and then recover.

-- 
Jerry Gitomer
Once I learned how to spell DBA, I became one

Received on Sat Mar 31 2001 - 17:58:37 CST