Re: Disaster Recovery HELP!!

What is there not trust?! It's all perfectly straightforward -provided (as ever) that you know what you are doing. Your problem appears to have been lost redo -that can affect cold backups just as much as hot ones. You tend to need rather more redo to recover from hot backups, but it's only a matter of a few archive logs.

Bear in mind that backup is one operation, and recovery is another. You can screw up backup, and that will of course stuff you badly when you want to recover. But (and much more common) your backups can be fine and its the recovery side of things that goes haywire... because it's rather subtler and more complicated than backing up.

You might care to checkup my Backup and Recovery page and have a look at the 70-page document there for the relevant discussions. In particular, you'll discover that there's a very good reason why backup exec won't take an online copy of the Online Redo Logs -because it would be pointless to do so. The files would be internally inconsistent, and what mechanism have we got to make them consistent?? Nada is the short answer.

Regards
HJR

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


"George" <corcorang_at_my-deja.com> wrote in message
news:8ule0r$9vk$1_at_nnrp1.deja.com...


> Ok I think i have managed to open the database and reset the logs.

> This is what happened i started recovery and when it got to the archive

> log that i didn't have, i restored an online log file that just

> happened to get backed up.  The recover took the log and finished

> recovery and open sesame it worked.  Now backupexec oracle client

> doesn't backup online log files and i was just lucky the grp2 log was

> on another disk that i backed up.  I now downed the server stopped all

> services and took a cold backup of the entire server so I think i will

> be ok.  I don't think i trust this hot backup stuff.  Thanks for all

> the advice.

>

>

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

> Before you buy.