DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
        b=eTk8rb8htDdRx7ZUf/Rs7mBfS3KFb1cH/gSpKDgktdEsS/OqkZSTCennyUHxUB+4PAcCKtnmiHSRE+Jous+PnZFcroTRQlEBqnS7Hv0yjtBbjWitP4kmLZhfZon3oVFTRbDNB+l+JxnrNLTyolCLleb9k22c2CwBvvktY41hsOQ=
Message-ID: <666b99c70801181314r356f4f0m701057fab7b15dba@mail.gmail.com>
Date: Fri, 18 Jan 2008 13:14:26 -0800
From: Prasad <p4cldba@gmail.com>
To: "Jeremiah Wilton" <jeremiah@ora-600.net>
Subject: Re: rman online backup with exclude undo tablespace
Cc: oracle-l <oracle-l@freelists.org>
In-Reply-To: <006801c85a15$2757fcf0$7607f6d0$@net>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_4203_9796667.1200690866222"
References: <666b99c70801180638q7e0a9e75hf35394a6e849fe07@mail.gmail.com>
	 <014601c859f2$3b8886e0$1100a8c0@rsiz.com>
	 <666b99c70801181009u78947697i9cbf4d3ef85ad771@mail.gmail.com>
	 <6A4102F59ECFA248B81F7D08F031797801F55EA0@TBDCEXCH01.US.Cingular.Net>
	 <666b99c70801181134n3f356a6fgf784c94158712157@mail.gmail.com>
	 <006801c85a15$2757fcf0$7607f6d0$@net>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: p4cldba@gmail.com
------=_Part_4203_9796667.1200690866222
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

As you mentioned I keep getting the same error no matter what i do .
I tried already   doing offline drop of undo datafile on mount while setting

 _*offline_rollback*_segments

  _*corrupted_rollback*_segments

  _*allow_resetlogs*_corruption

even the oracle support suggest me to go ahead and copy a full backup . so I
will take it as a learning and go back copy files.

thanks everybody.

-Prasad


On Jan 18, 2008 1:00 PM, Jeremiah Wilton <jeremiah@ora-600.net> wrote:

> Prasad,
>
> 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.
>
> Regards,
>
> 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.
>
>
>

------=_Part_4203_9796667.1200690866222
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<font size="2"><span style="font-family: arial,sans-serif;">As you mentioned I keep getting the same error no matter what i do .<br>I tried already&nbsp;&nbsp; doing offline drop of undo datafile on mount while setting </span></font><font style="font-family: arial,sans-serif;" color="blue" face="Garamond" size="2"><span style="font-size: 12pt; color: blue;">&nbsp; <br>
<span style="color: rgb(51, 51, 51);">&nbsp;_</span><i style="color: rgb(51, 51, 51);"><span style="font-style: italic;">offline_rollback</span></i><span style="color: rgb(51, 51, 51);">_segments</span></span></font>

<p style="color: rgb(51, 51, 51); font-family: arial,sans-serif;"><font size="2"><span style="font-size: 12pt;">&nbsp; _<i><span style="font-style: italic;">corrupted_rollback</span></i>_segments</span></font></p>

<p style="color: rgb(51, 51, 51); font-family: arial,sans-serif;"><font size="2"><span style="font-size: 12pt;">&nbsp; _<i><span style="font-style: italic;">allow_resetlogs</span></i>_corruption</span></font></p><p style="color: rgb(51, 51, 51); font-family: arial,sans-serif;">
even the oracle support suggest me to go ahead and copy a full backup . so I will take it as a learning and go back copy files. <br></p><p style="color: rgb(51, 51, 51); font-family: arial,sans-serif;">thanks everybody.</p>
<p style="color: rgb(51, 51, 51); font-family: arial,sans-serif;">-Prasad <br><font size="2"><span style="font-size: 12pt;"></span></font></p><p style="color: rgb(51, 51, 51); font-family: arial,sans-serif;"><font size="2"><span style="font-size: 12pt;"><br>
</span></font></p><br><br><div class="gmail_quote">On Jan 18, 2008 1:00 PM, Jeremiah Wilton &lt;<a href="mailto:jeremiah@ora-600.net">jeremiah@ora-600.net</a>&gt; wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Prasad,<br><br>The error you are getting from open is that the UNDO tablespace datafiles<br>are missing. &nbsp;Specifying _corrupted_rollback_segments will not solve that<br>problem. If you would like to move on to the *next* error you are going to<br>
receive, then you can re-create the controlfile with the UNDO datafiles<br>removed, or you can OFFLINE DROP them from MOUNT mode.<br><br>Notably, the method of saving time/space you devised is simply invalid. &nbsp;You<br>need undo in order to create a consistent database. &nbsp;You can technically<br>
open it without UNDO, but the result will range from inconsistent in the<br>best case, to constantly crashing in the worst.<br><br>For those performing real recoveries of production data, I think this group<br>is a great place to learn about extraordinary recovery methods, such as how<br>
to allow resetlogs/read only corruption, specify corrupted rollback<br>segments, and artificially advance the SCN. &nbsp;But for those like you who are<br>willfully persisting in a flawed approach, the desire to help, at least on<br>
my part, is greatly reduced.<br><br>Please just go back and get a copy of the UNDO tablespace which at 16G is<br>really not that big. It doesn&#39;t matter if it takes 20 hours to make the<br>copy, as long as you can bring it all consistent with archivelogs. &nbsp;As with<br>
others, I recommend taking a more conventional approach to this project. &nbsp;I<br>don&#39;t believe you will be providing your clients with a test system that is<br>consistent with professional standards if you continue on your current path.<br>
<br>Regards,<br><font color="#888888"><br>Jeremiah Wilton<br>ORA-600 Consulting<br></font><div><div></div><div class="Wj3C7c"><br><br>Prasad wrote:<br><br>&gt; Yes, it shows correctly printed in the alert log . but when I try to do<br>
show parameter it do not show . does<br>&gt; that mean it is effective on the background?&nbsp;&nbsp; but if it is effective then<br>when I try to open in resetlogs it<br>&gt; should not complain about undotbs . but right now it complains.<br>
<br><br></div></div></blockquote></div><br>

------=_Part_4203_9796667.1200690866222--
--
http://www.freelists.org/webpage/oracle-l