Buck Turgidson wrote:
>
> 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.
Yes there would.
>
> 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.
No, the instance would not be opened. The message would be that files
need media recovery. IMO, your DBAs need to be doing some sort of hot
backup (either scripted hot backups, or RMAN backups). An export of the
instance may be good to recover data, but it will not allow for
rebuilding/recovery of the instance in the event of a disaster. You've
been pretty lucky so far, but I wouldn't want to be them in this
situation.
>
> Thanks for any replies.
>
> Buck
Comments embedded above...
--
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.
Received on Fri Nov 02 2001 - 11:20:30 CST
