Re: Should we backup TEMP tablespace

Marlene L Theriault (mtheriau_at_us.oracle.com) wrote:
> In a previous article, sjs_at_shell.portal.com asked if they should backup the
> TEMP tablespace and I (too hastily) replied "not necessary". After playing
> several disaster/recovery scenarios, I retract my statement. Without backup
> of the TEMP tablespace data file, you have no fall-back position for recovery.
> I am sorry if my initial answer caused and problems or confusion.
 

> Marlene Theriault

Definitions required ...

1. Backup: copy files to tape? or export?

	 If copy files to tape, I hope the database is shut down
	 otherwise some changes could be taking place even if no
	 users are on system.

2) TEMP tablespace:  tablespace used exclusively for internal 
	      operations?  or place for users to put stuff temporarily? 
								 
	If TEMP is used exclusively for internal operations, 
	and database is shut down, then nothing should exist   
	in the tablespace.  Similar statement for Rollback tablespace. 
												  
	Neither the TEMP or RBS tablespaces need to be exported. 
														   

However, the control files and the tablespaces keep sequence info that is required to recreate the database from backup files. From my experience, all database files must be backed up (to tape) to guarantee recovery.

/Hans Received on Tue Dec 20 1994 - 16:54:08 CET