RE: rman online backup with exclude undo tablespace

From: Jeremiah Wilton <>
Date: Fri, 18 Jan 2008 13:00:24 -0800
Message-ID: <006801c85a15$2757fcf0$7607f6d0$@net>


The error you are getting from open is that the UNDO tablespace datafiles are missing. Specifying _corrupted_rollback_segments will not solve that problem. If you would like to move on to the *next* error you are going to receive, then you can re-create the controlfile with the UNDO datafiles removed, or you can OFFLINE DROP them from MOUNT mode.

Notably, the method of saving time/space you devised is simply invalid. You need undo in order to create a consistent database. You can technically open it without UNDO, but the result will range from inconsistent in the best case, to constantly crashing in the worst.

For those performing real recoveries of production data, I think this group is a great place to learn about extraordinary recovery methods, such as how to allow resetlogs/read only corruption, specify corrupted rollback segments, and artificially advance the SCN. But for those like you who are willfully persisting in a flawed approach, the desire to help, at least on my part, is greatly reduced.

Please just go back and get a copy of the UNDO tablespace which at 16G is really not that big. It doesn't matter if it takes 20 hours to make the copy, as long as you can bring it all consistent with archivelogs. As with others, I recommend taking a more conventional approach to this project. I don't believe you will be providing your clients with a test system that is consistent with professional standards if you continue on your current path.


Jeremiah Wilton
ORA-600 Consulting

Prasad wrote:

> Yes, it shows correctly printed in the alert log . but when I try to do
show parameter it do not show . does
> that mean it is effective on the background?   but if it is effective then
when I try to open in resetlogs it
> should not complain about undotbs . but right now it complains.

Received on Fri Jan 18 2008 - 15:00:24 CST

Original text of this message