RE: not including temp neither undo tablespace in full backup
- From: "Roger Xu" <roger_xu@xxxxxxxxxxx>
- To: <oracledba.williams@xxxxxxxxx>
- Date: Wed, 12 Oct 2005 13:42:40 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dennis Williams
Sent: Wednesday, October 12, 2005 1:09 PM
To: juancarlosreyesp@xxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
For technical support please email tech_support@xxxxxxxxxxx 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@xxxxxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
Other related posts:
