Re: Test Recovery from Hot Backups

1. Try and drop a single datafile.
2. How about opening up the current redo log in the text editor of your choice, and typing some text then saving it (guaranteed to corrupt your current log).

You might also try:

3. Drop every single control file and see what happens!

4. Delete an archived log and practise doing incomplete recoveries.

5. Drop a tablespace and recover it (requires a backup binary control file)

6. Delete files from a non-SYSTEM tablespace, and practice recovering the tablespace having brought up the rest of the database first.

7. Delete a data file, and recover it to a different location from the original -practice relocating datafiles prior to recovery.

You might want to see my backup and recovery page -download the 70-page document that's there, and see if that gives you some ideas.

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------



<sanbara_at_my-deja.com> wrote in message news:8pp8md$4or$1_at_nnrp1.deja.com...


> Hi,

>

> I'm running Oracle Version 7.3.4.5 with NT 4.0

>

> I'm testing my first ever "Restore" from hot backups and I've got some

> questions on the basics(pardon me!!)

>

> 1. How to create disaster situation which requires a DB restore?.

>  e.g Should I delete all the datafiles and control file and leave the

> online redo logs?

>

> 2.  What other scenarios I can test the recovery process with?

>

> I'm using the normal oracle online backup scripts as well as ARCServeIT

> Oracle backup agent for testing (2 diff cases)..Any comments on using

> ArcServe Oralce Agent for this?

>

> Any help on this will be highly appreciated..

>

> Thanks in advance.

> Anbu.

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.