Re: Backup/Recovery Question

"Buck Turgidson" <jc_va_at_hotmail.com> wrote in message news:f98999c8.0111020523.15b23b19_at_posting.google.com...
> Our DBA's are using various backup/recovery strategies, but one is the
> following:
>
> A complete server (HP Unix) backup is done, including OS, and all
> relevant Oracle files. Basically, it is a complete volume backup of
> the server. On one of the volumes is a nightly export file of the
> database.
>
> The database itself is used 24/7, and is always in a state of flux.
> And it is not taken offline during the server backup.
>
> If we had to restore to another server in a disaster, it sounds to me
> like all the SCN's in the files, versus the control file would be out
> of sync, and there'd be problems.
>
> But would it be enough for them to get back and running if they used
> the Oracle OS files, and overlaid the Oracle export on top of them? I
> would imagine they could get the database to a mount state, but
> probably not open it, prior to starting the import.

You would have to recreate the db from scratch and then import. You would lose any data since the export. In fact all that backing up the oracle datafiles does is prolong the backup time to no useful end.

24*7 pretty much implies that loss of data is bad and so the database has to be running archivelog and hot backup.

--
Niall Litchfield
Oracle DBA
Audit Commission Uk