| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Recovery scenario query
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
-- 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
 |
 |