Riyaj You need redo files, but not undo neither temp tablespaces.
This is a dangerous and very misleading statement to make. Hopefully, newbies will read the full thread before accepting your advice.
Just because one test case is successful, does not mean that the theory is correct. As Jonathan Lewis would say "It takes only one test case to disprove a theory". Without undo tablespace, there is a very high potential for data corruption and instance will shutdown during SMON's instance recovery. In fact, Oracle support would let you set couple of parameters to open the database with corruption, if you don't have undo tablespace backup. But right after that you must rebuild your database if you want further support.
Database can not rollback the outstanding transactions without rollback segments during instance recovery. Consistent view of the data can not be recreated either. Expect corruption all around the database in a very active database.
Miniurl, in case, you can't access the above link:
You want test case, try this:
You will then agree that undo tablespace is absolutely needed to be backed up!! Do NOT, I repeat, do NOT try this in any database, that you can not afford to lose!!
Juan Carlos Reyes Pacheco wrote:
Riyaj You need redo files, but not undo neither temp tablespaces. A few times I lose them and recreated successfully.
You will need undo, if you abort your database, otherwise you don't need. (obviously I'm not talking in rac environment, I don't have idea about that)
This is not a theory I tested it agains my will previously. :)
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.