Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: not including temp neither undo tablespace in full backup
I think RMAN by default does not backup temp tablespace.
How do I ask RMAN to backup temp datafiles in "backup database" command?
Thanks,
Roger
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dennis Williams
Sent: Wednesday, October 12, 2005 1:09 PM
To: juancarlosreyesp_at_gmail.com
Cc: oracle list
Subject: Re: not including temp neither undo tablespace in full backup
Juan Carlos,
> We have decided not to backup temp neither undo tablespaces in a full
> backup we get periodically.
> Because it can be easily recreated.
I find that the times backups are needed are usually not calm times, but often contain moments of sheer terror. Sometimes you are awakened from a deep sleep and must perform a recovery while you mind is still partially asleep.
Therefore, my goal is to make database recovery as simple as possible. You may save some backup time by omitting the temp space (Oracle tends to do that). However, during a recovery it is easy to forget the additional step of recreating the temp space. So you tell the users the database is recovered and go back to sleep. Just about the time you are drifting off to sleep the phone rings again with the joyous news that the users are receiving some weird Oracle error about a missing datafile. Eventually you get the exact error and it occurs to you that you forgot to recreate the temp datafile. The users are less than amused because they are now convinced that you lied to them when you said the database was ready for their use.
Dennis Williams
-- http://www.freelists.org/webpage/oracle-l For technical support please email tech_support_at_dp7uptx.com or you can call (972)721-8257. This email has been scanned for all viruses by the MessageLabs Email Security System. This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the material. ____________________________________________________________________ This email has been scanned for all viruses by the MessageLabs Email Security System. Any questions please call 972-721-8257 or email your request to tech_support_at_dp7uptx.com. -- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 12 2005 - 13:45:04 CDT
![]() |
![]() |