Re: why need to backup undo tablespace?

On Thu, 09 Dec 2004 09:43:04 -0700, niy38 <niy38_at_hotmail.com> wrote:

>For the close backup, it's obvious we don't have to
>backup undo: you even can create a new one after deleting
>the original one.
>
>This is quite understandable: since after shutdown
>(normal, transactional, immediate), all transactions
>are over. ( here I didn't consider undo_retention)
>
>So I suppose for a must of backup undo, it's hot backup.
>For an tablespace USERS, after I do a hot backup,
>and its datafiles corrupt, now I do recovery, do I
>need undo?

Please explain, with pointers to the docs, why you think you 'obviously' don't need to backup your undo tablespace during cold backup.
Then do the following

- find a different job
- make a cold backup without backing up the undo tablespace
- delete your database
- recover your database from backup
- Get sacked by your employer.

--
Sybrand Bakker, Senior Oracle DBA