Return-Path: <root@fatcity.cts.com>
Received: from ensim.rackshack.net (root@localhost)
 by orafaq.net (8.11.6/8.11.6) with ESMTP id h09Kri130973
 for <oracle-l@orafaq.net>; Thu, 9 Jan 2003 14:53:44 -0600
X-ClientAddr: 209.68.248.164
Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164])
 by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h09Kric30968
 for <oracle-l@orafaq.net>; Thu, 9 Jan 2003 14:53:44 -0600
Received: from fatcity.UUCP (uucp@localhost)
 by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id JAA31281;
 Thu, 9 Jan 2003 09:35:27 -0800 (PST)
Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0052B590; Thu, 09 Jan 2003 09:14:27 -0800
Message-ID: <F001.0052B590.20030109091427@fatcity.com>
Date: Thu, 09 Jan 2003 09:14:27 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
X-Comment: Oracle RDBMS Community Forum
X-Sender: Paula_Stankus@doh.state.fl.us
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: Paula_Stankus@doh.state.fl.us
Subject: RE: RE : RMAN Repository
Organization: Fat City Network Services, San Diego, California
X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman
Precedence: bulk
Mime-Version: 1.0
Content-Type: multipart/alternative;	boundary="----_=_NextPart_001_01C2B802.55DB0E60"
------_=_NextPart_001_01C2B802.55DB0E60
Content-Type: text/plain;
 charset="iso-8859-1"

I find it useful for organizing and keeping track of my backups so that
during recovery it is as simple as running pre-scripted queries to see what
I have available - geez am I the only one who likes RMAN and doesn't think
it makes things that difficult - really?  Robert Freeman - what say you?

-----Original Message-----
Sent: Thursday, January 09, 2003 11:25 AM
To: Multiple recipients of list ORACLE-L


Gene - Which Oracle version(s)? How many instances will you be backing up?



Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
dwilliams@lifetouch.com 

-----Original Message-----
Sent: Thursday, January 09, 2003 9:50 AM
To: Multiple recipients of list ORACLE-L


Interesting thread, since I am just embarking on using RMAN.  If the
repository is to go away then why bother learning the intricacies of it.
Has anyone else heard the RMAN repository was going away?  It appears much
simpler to setup w/out the repository.  Besides reporting advantages, what
are the real benefits to using a repository?
 
Thanks,
Gene
PS. Now reading Robert's book. 

>>> jtesta@dmc-it.com 01/08/03 05:19PM >>>
its a pain in the arse but you have to pull out the backed up 
controlfile(you did backup the controlfile, eh?) out of the rman backup 
piece(i've got a script that will do it automagically based on the 
filename pieces you pass it).

then once the backed up controlfile is restored, then you can do normal 
recovery procedure.

joe


Jared.Still@radisys.com wrote:

>And how does one go about restoring a database when all control files
>are lost, and the only recovery data is stored in the control file?
>
>This doesn't sound very reasonable.
>
>Jared
>
>
>
>
>
>
>"Deshpande, Kirti" <kirti.deshpande@verizon.com>
>Sent by: root@fatcity.com
> 01/08/2003 11:44 AM
> Please respond to ORACLE-L
>
> 
>        To:     Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
>        cc: 
>        Subject:        RE : RMAN Repository
>
>
>Joe,
> That's what I have heard (from 2 Oracle University 
>Professors/Lecturers/Demonstrators). But no one would tell me when it may 
>happen. We do not use RMAN (yet) so I did not pursue it further. 
>
>- Kirti 
>
>-----Original Message-----
>Sent: Wednesday, January 08, 2003 1:08 PM
>To: Multiple recipients of list ORACLE-L
>
>
><snip> 
>
>Obilgatory oracle statement/question:  rumor has it by some instructors 
>that RMAN repository is going away and only control file recoveries 
>will be possible, truth or fiction?
>
>joe
>
>  
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
<http://www.orafaq.net> 
-- 
Author: Joe Testa
  INET: jtesta@dmc-it.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
<http://www.fatcity.com> 
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS@LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

------_=_NextPart_001_01C2B802.55DB0E60
Content-Type: text/html;
 charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2654.45">
<TITLE>RE: RE : RMAN Repository</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>I find it useful for organizing and keeping track of =
my backups so that during recovery it is as simple as running =
pre-scripted queries to see what I have available - geez am I the only =
one who likes RMAN and doesn't think it makes things that difficult - =
really?&nbsp; Robert Freeman - what say you?</FONT></P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: DENNIS WILLIAMS [<A =
HREF=3D"mailto:DWILLIAMS@LIFETOUCH.COM">mailto:DWILLIAMS@LIFETOUCH.COM</=
A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Thursday, January 09, 2003 11:25 AM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: RE: RE : RMAN Repository</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Gene - Which Oracle version(s)? How many instances =
will you be backing up?</FONT>
</P>
<BR>
<BR>

<P><FONT SIZE=3D2>Dennis Williams </FONT>
<BR><FONT SIZE=3D2>DBA, 40%OCP </FONT>
<BR><FONT SIZE=3D2>Lifetouch, Inc. </FONT>
<BR><FONT SIZE=3D2>dwilliams@lifetouch.com </FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>Sent: Thursday, January 09, 2003 9:50 AM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Interesting thread, since I am just embarking on =
using RMAN.&nbsp; If the</FONT>
<BR><FONT SIZE=3D2>repository is to go away then why bother learning =
the intricacies of it.</FONT>
<BR><FONT SIZE=3D2>Has anyone else heard the RMAN repository was going =
away?&nbsp; It appears much</FONT>
<BR><FONT SIZE=3D2>simpler to setup w/out the repository.&nbsp; Besides =
reporting advantages, what</FONT>
<BR><FONT SIZE=3D2>are the real benefits to using a repository?</FONT>
<BR><FONT SIZE=3D2>&nbsp;</FONT>
<BR><FONT SIZE=3D2>Thanks,</FONT>
<BR><FONT SIZE=3D2>Gene</FONT>
<BR><FONT SIZE=3D2>PS. Now reading Robert's book. </FONT>
</P>

<P><FONT SIZE=3D2>&gt;&gt;&gt; jtesta@dmc-it.com 01/08/03 05:19PM =
&gt;&gt;&gt;</FONT>
<BR><FONT SIZE=3D2>its a pain in the arse but you have to pull out the =
backed up </FONT>
<BR><FONT SIZE=3D2>controlfile(you did backup the controlfile, eh?) out =
of the rman backup </FONT>
<BR><FONT SIZE=3D2>piece(i've got a script that will do it =
automagically based on the </FONT>
<BR><FONT SIZE=3D2>filename pieces you pass it).</FONT>
</P>

<P><FONT SIZE=3D2>then once the backed up controlfile is restored, then =
you can do normal </FONT>
<BR><FONT SIZE=3D2>recovery procedure.</FONT>
</P>

<P><FONT SIZE=3D2>joe</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Jared.Still@radisys.com wrote:</FONT>
</P>

<P><FONT SIZE=3D2>&gt;And how does one go about restoring a database =
when all control files</FONT>
<BR><FONT SIZE=3D2>&gt;are lost, and the only recovery data is stored =
in the control file?</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;This doesn't sound very reasonable.</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;Jared</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;&quot;Deshpande, Kirti&quot; =
&lt;kirti.deshpande@verizon.com&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;Sent by: root@fatcity.com</FONT>
<BR><FONT SIZE=3D2>&gt; 01/08/2003 11:44 AM</FONT>
<BR><FONT SIZE=3D2>&gt; Please respond to ORACLE-L</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
To:&nbsp;&nbsp;&nbsp;&nbsp; Multiple recipients of list ORACLE-L =
&lt;ORACLE-L@fatcity.com&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cc: =
</FONT>
<BR><FONT SIZE=3D2>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
Subject:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RE : RMAN =
Repository</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;Joe,</FONT>
<BR><FONT SIZE=3D2>&gt; That's what I have heard (from 2 Oracle =
University </FONT>
<BR><FONT SIZE=3D2>&gt;Professors/Lecturers/Demonstrators). But no one =
would tell me when it may </FONT>
<BR><FONT SIZE=3D2>&gt;happen. We do not use RMAN (yet) so I did not =
pursue it further. </FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;- Kirti </FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>&gt;Sent: Wednesday, January 08, 2003 1:08 PM</FONT>
<BR><FONT SIZE=3D2>&gt;To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;&lt;snip&gt; </FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;Obilgatory oracle statement/question:&nbsp; =
rumor has it by some instructors </FONT>
<BR><FONT SIZE=3D2>&gt;that RMAN repository is going away and only =
control file recoveries </FONT>
<BR><FONT SIZE=3D2>&gt;will be possible, truth or fiction?</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;joe</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;&nbsp; </FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
</P>

<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.net" =
TARGET=3D"_blank">http://www.orafaq.net</A></FONT>
<BR><FONT SIZE=3D2>&lt;<A HREF=3D"http://www.orafaq.net" =
TARGET=3D"_blank">http://www.orafaq.net</A>&gt; </FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Joe Testa</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: jtesta@dmc-it.com</FONT>
</P>

<P><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- =
858-538-5051 <A HREF=3D"http://www.fatcity.com" =
TARGET=3D"_blank">http://www.fatcity.com</A></FONT>
<BR><FONT SIZE=3D2>&lt;<A HREF=3D"http://www.fatcity.com" =
TARGET=3D"_blank">http://www.fatcity.com</A>&gt; </FONT>
<BR><FONT SIZE=3D2>San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Mailing list =
and web hosting services</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
------</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru@fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
from).&nbsp; You may</FONT>
<BR><FONT SIZE=3D2>also send the HELP command for other information =
(like subscribing).</FONT>
</P>
<BR>
<BR>

<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.net" =
TARGET=3D"_blank">http://www.orafaq.net</A></FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: DENNIS WILLIAMS</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: DWILLIAMS@LIFETOUCH.COM</FONT>
</P>

<P><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- =
858-538-5051 <A HREF=3D"http://www.fatcity.com" =
TARGET=3D"_blank">http://www.fatcity.com</A></FONT>
<BR><FONT SIZE=3D2>San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Mailing list =
and web hosting services</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
------</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru@fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
from).&nbsp; You may</FONT>
<BR><FONT SIZE=3D2>also send the HELP command for other information =
(like subscribing).</FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C2B802.55DB0E60--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Paula_Stankus@doh.state.fl.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

