RE: Urgent - Restoration of Database

Not so easily. afaik, you need to restore the datafiles (1), the controlfiles (2), the redo-logfiles(3) and the init.ora(4).

The datafiles contain the data except for the transactions still waiting to be flushed in the redo-log files, the control file(s) contain the information on all physical aspects of the database (datafiles, redo-logfiles, etc.) and the redo log files contain the latest transactions.

Without (2) you need to recreate the database with the same datafiles, shutdown the db and overwrite the new datafiles with the old ones (and hope Oracle will forgive you for this).

Without (3) you may miss the latest transactions. You may need a roll forward using the archive log files. You do need the original controlfiles for this.

But of course you have a backup and can recreate the whole lot using the backup and archive log files.

Paul

-----Original Message-----
From: Manivannan.M [mailto:manivannan.m_at_tatainfotech.com] Sent: 26 May 2000 16:06
To: Multiple recipients of list ORACLE-L Subject: Re: Urgent - Restoration of Database

It will!
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, May 26, 2000 6:36 PM

> Hello seniors,
> Because of some virus problem systems guys has formatted the HDD on which
> Oracle server software was installed. ALl the datafiles are intact on
other
> drive. The information i could gather was are as follows:-
> 1. instance_name,dbname,service_names = 'pvcs'
> 2. database was shutdown with 'immediate' option
> 3. the database was running in archivelog mode(there was
> indication of shutting down of ARCH process)
> Now if i install oracle server, create an instance with the name 'pvcs'
> and startup the database giving pfile parameter with correct path.
> Will it work? if no then how to solve this problem.
> Please provide your help to solve this problem
> Thankx a lot
> Ravi
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --
> Author: Ravi Babu
> INET: lravibabu_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Author: Manivannan.M
  INET: manivannan.m_at_tatainfotech.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may