Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Urgent - Restoration of Database

RE: Urgent - Restoration of Database

From: Paul van Dijken <paul.vandijken_at_sema.nl>
Date: Fri, 26 May 2000 16:02:50 +0200
Message-Id: <10509.106873@fatcity.com>


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
Received on Fri May 26 2000 - 09:02:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US