The following might help in some circumstances, and
you could adapt it.

It's easy to write a script that does, say, 10000 unique inserts
into 100 tables, and run it from from a dozen terminals
at the same time.

At the start, middle, and end of it take backups.

Backups don't count for anything unless you can restore from them,
so do a sample restore of one table from the "start", "middle",
and "end" backup.

Now repeat the experiment, taking the database down
in the middle of running the scripts right after the "middle"
backup.

Try to restore.

Practice various checkpoint, export, and RMAN commands until
you are an expert at RESTORING from your backups.

The only secret to backing up is: test your restores
often. By often I mean take the backups often and don't
count them as being right until you do a tiny sample restore
from them to a quality assurance database.

Mike Brenner

Cowen Jeffrey wrote:
>
> Does anyone have any docs with some good test case/recovery scenarios?
>
> I have to put a production environment up in a very short time and could
> really use some good test cases to test our backup/recovery solutions.
>
> Any docs would greatly be appreciated!
>
> Thanks in advance.
>
> Jeffrey
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page