Re: Backup flashback logs to tape

zigzagdna_at_yahoo.com wrote:

> Also regarding 2 (there is no need to backup), I pointed out a hole in
> design what happens if disk carshes (where flashback logs are
> stotred) or some flashback logs are accidently deleted, one may then
> have to rest flashback database by turing it off and on and lossing
> all falshback logs.

Database crashing and the location of flashback logs is irrelevant. One has no bearing on the other.

If someone can accidentally delete anything then you have a security problem you need to deal with. Oracle technology may be "unbreakable" but it is not immune to the actions of stupid people doing stupid things.

An equivalent question would be what to do if someone walks into the server room, logs on as root and types:
cd /
rm -rf *

If your processes are so poor that these questions are important to you I'd suggest hiring a competent employee or consultant to help you with basic procedures.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org