Re: Restoration Case....

From: Denny Koovakattu <denny_vk_at_my-dejanews.com>
Date: Fri, 26 Feb 1999 17:14:28 GMT
Message-ID: <7b6kp9$g1l$1@nnrp1.dejanews.com>

Are you running in ARCHIVELOG mode ? Do you have a copy of the current control file ? Do you have all the archive logs ? If you are not in ARCHIVELOG mode you can only restore the cold backup and restart from that point. ( You cannot recover to the point in time of failure. ) If you are in ARCHIVELOG mode, make sure you don't copy back the online redo logs. Copy the datafiles and the current controlfile. If you don't have the current controlfile then use the one you backed up but recover with the 'using backup controlfile' clause.

Denny

In article <ABrB2.10205$_w2.5463_at_news.rdc2.occa.home.com>, "Earl Park" <earlpark_at_home.com> wrote:
> Situation:
> NT server hard disk failed. I only have backup of Datafiles, Control
> File, and Logfiles. The backup is performed by formal dba using Seagate
> Backup Exec... Cold backup.
> I installed new hard disk and installed NT, SP3, and Seagate Backup
> Exec. I know dba username and password.
>
> What is the procedure to restore datafile and run it?
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Feb 26 1999 - 11:14:28 CST