| 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: Hot backup and TEMP tablespace
If you are using a temp tablespace with a temp file you really are not suppose to back it up. This comes from Oracle, not folks trying to save time. You cannot put them into backup mode so how do you recommend backing them up?
-----Original Message-----
Thomas F
Sent: Monday, January 28, 2002 5:31 AM
To: Multiple recipients of list ORACLE-L
Traci,
Yes, you can skip backing up the TEMP tablespaces, and as Kirti suggested, and have instructions in your recovery manual on how to rebuild the tablespace when you are going thru a recovery.
In my humble opinion, I would not do this. It's kinda like using duct tape to cover a crack in the window - it works, but its really not right.
Do you really want to be in the position of performing "extra" recovery steps just to save yourself some time during backups? Why stop at backing up the TEMP tablespace - why not the ROLLBACK tablespace - this could be dropped and re-created also. Why not INDEX tablespaces - heck, if you have the scripts, these could be re-created too!
My point (as a professional DBA) is that, backups should be intact so that you can recover easily without having to do "extra work". It is really one less thing to remember and have to worry about.
If your real issue is that you cannot perform your backup in the time allotted, or that you need more disk space to perform your backup, you should either investigate Rman (as Jared suggested), or buy more disk - both should be considered the "cost of doing business". I am a strong proponent of Rman - it solves MANY backup and recovery problems.
Hope this helps!
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Saturday, January 26, 2002 10:40 AM
To: Multiple recipients of list ORACLE-L
I was wondering if anyone could offer any suggestions to this issue, or the pro's and con's...
We are trying to shorten the time frame that it takes to complete our Oracle hot backups, and the subsequent file copies to tape. I have read that it is ok to skip the TEMP tablespace, and then do an off-line drop of the datafile(s) in the temporary tablespace, drop the tablespace, and then recreate it.
Our temporary tablespaces are 900mb, and they take a chunk of the total time it takes to complete the hot backups. Are there any issues or ramifications of not including that tablespace in the event of a recovery? It seems to me that it would be much quicker to re-create that tablespace if needed.
Any suggestions are greatly appreciated.
Traci Rebman
Oracle Database Administrator
R.R. Donnelley & Sons - Financial Division
Lancaster, PA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: traci.l.rebman_at_rrd.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
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 Liststo: 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 Mon Jan 28 2002 - 10:19:33 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |