Oracle-L: RE: one datafile lost.

From: Sinardy Xing <SinardyXing_at_bkgcomsvc.com>
Date: Thu, 16 Jan 2003 10:45:14 -0800
Message-ID: <F001.00531D24.20030116104514@fatcity.com>

Hi Big Planet,

They db files are not consistence you can apply the changes with archived redo log since.

How you recover your database is depend on how you backup your database.

For example you can use old "redundancy set" + latest exported dump file

Sinardy

-----Original Message-----
Sent: 17 January 2003 01:29
To: Multiple recipients of list ORACLE-L

Just wondering what will happen in this condition .

supposse I have two tablespaces data_large and data_small . with datafiles data_large01.dbf and data_small01.dbf . some transactions affects tables in both tablespaces . Now one day I lost data_small01.dbf data files . I thought of recovering that data file from one day old backup . when I recover this data data file , will oracle maintain transactio consistency for all transaction happened today . becuase data_large01.dbf is up to date . but data_small01.dbf is one day old . will oracle keep this in mind while applying archived logs at the time of recovery .

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Sinardy Xing
INET: SinardyXing_at_bkgcomsvc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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). Received on Thu Jan 16 2003 - 12:45:14 CST