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: Recovery scenario query

RE: Recovery scenario query

From: Kimberly Smith <ksmith2_at_myfirstlink.net>
Date: Fri, 11 Jan 2002 09:25:31 -0800
Message-ID: <F001.003EDCD5.20020111074527@fatcity.com>

My take on this is, if you have stuff in your database that is not used get it out. Then you have more space and you are not dealing with the maintenance on things that are not relevant.

If they are needed but not updated, put them in a tablespace that is read only, back it up once, onto a permanent tape, and be done with it.

Surely you are not backing up by data file but rather by tablespace. So this seems like a rather simple thing to work around to me. However, Rachel's suggestions are the way to go if you are going to keep things the way they are and really can deal with the end result.

Whatever you do, do it quick. One of the primary functions of a DBA is to protect the data that they entrust to the database. Right now its not being done.

-----Original Message-----
Carmichael
Sent: Friday, January 11, 2002 5:31 AM
To: Multiple recipients of list ORACLE-L

Sean,

If they are not being backed up, you won't be able to open the database with them in it if you have to recover. You would have to mount the database, alter the datafiles offline drop (this tells Oracle you don't care what was in them anyway, so ignore errors on them) and then after finishing the recovery and opening the database, you'd have to drop the tablespaces.

Now, if there WERE updates to data in those datafiles, the updates would be lost (and the offline during recovery would let recovery go through). If updates to that data were done in the same transaction as updates to data in tables that WERE backed up, the update to the backed up data would be effectively rolled back.

You might want to turn on auditing for update/delete on those tables for a short time, to confirm that nothing is being changed. If you trap changes, you can then go to them with proof and tell them to reconsider what the backup policy is.

Rachel


Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  INET: ksmith2_at_myfirstlink.net

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).
Received on Fri Jan 11 2002 - 11:25:31 CST

Original text of this message

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