Using RMAN will reduce your backup time, as it only backs up used blocks. It also takes less space.
Jared On Saturday 26 January 2002 07:40, [EMAIL PROTECTED] wrote: > 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: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).