Re: bad backup recovery scenario

John,

> Is this at all possible, to recover partially, completely etc, some data if
> I had to restore all files from a backup?

Yes, but it requires the Oracle Data unloader tool. It costs $10,000 for 4 hours for someone to come out and use it.

that should justify a bit of expense in additional hardware to support archivelog mode.
you can run a hot backup from the OS - it just have to be able to connect to the database to put each tablespace into backup mode. Or - you could install/configure a third party backup tool, such as Veritas or ARCServeIT, which have Oracle Agents.

hth,

Paul

John Kelly wrote:
>
> I have a situation that I have no control with, but know I will be asked to
> fix when a problem occurs.
> Can one recover a database that is ONLY backed up from a OS backup utility
> (basically backing up every file ) when the database is opened. I know this
> is bad, I've told them, but I know I will be involved in recovery some data?
> Is this at all possible, to recover partially, completely etc, some data if
> I had to restore all files from a backup?
>
> Reds,
> John
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
Received on Thu Apr 12 2001 - 02:26:39 CDT