MIME-Version: 1.0
In-Reply-To: <52A8FC5C.5000503@comcast.net>
References: <52A8FC5C.5000503@comcast.net>
From: Paresh Yadav <yparesh@gmail.com>
Date: Wed, 11 Dec 2013 19:53:01 -0500
Message-ID: <CAPXEL0Luyu4+0YjYJ8fXcUUs=Gg9JNqNkmeeTH=eTLG2wpkgpQ@mail.gmail.com>
Subject: Re: Why I don't like RMAN repositories
To: rjgoulet@comcast.net
Cc: oracle-l <oracle-l@freelists.org>
Content-Type: multipart/alternative; boundary=001a113429c0aa9d9704ed4bc52f
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: yparesh@gmail.com
--001a113429c0aa9d9704ed4bc52f
Content-Type: text/plain; charset=ISO-8859-1

Excellent thread. There is a "magical" workaround to getting older control
file from storage media even when CONTROL_FILE_RECORD_KEEP_TIME = 7 (or
whatever the value is) as long as the backups are retained on the media. Not
sure if this was available in 8i, 9i but have used this in 10g recovery at
a large Canadian grocer.  In RMAN configure controlfile autobackup to ON.
With that, when you ask RMAN to recover a controlfile to a particular point
in time it asks media manager to restore files and provides appropriate
file names to the media manager. This works because with controlfile
autoback, the backup pieces that have controlfile are named in particular
fashion. This is all well documented. It has been 5+ years when this was
done so don't remenber the details or the control file autobackup piece
naming convention. There are few gotchas with that e.g. if you have an
hourly script to add "partitions + tablespace" to table/s, there will be a
controlfile autobackup triggered with each tablespace/data file addition
(as designed) but this holds controlfile enque for duration of the backup
(as far as I can remember)...

Thanks
Paresh
416-688-1003


On Wed, Dec 11, 2013 at 6:59 PM, Dick Goulet <rjgoulet@comcast.net> wrote:

> To catalog or not to catalog has always been a question that never has had
> a good answer.  So let me put it this way, I have a catalog db and I use
> it.  But I also practice restores without it and don't have a problem.
>  Course it helps to have a tape librarian with lots of memory.  Ours likes
> to retain stuff for 3 years.  The controlfile 90 days.  Try "restore
> controlfile from '<media handle>';" where <media handle> =
> c-<date>-<dbid>-00 if you need something beyond that 90 day point.
>
> Dick Goulet
> Senior Oracle Dba
>
> ----------------------------------------------------------------------
>
> From: Dustin Hayden<DHayden@sprich.com>
> Subject: RE: Why I don't like RMAN repositories
> Date: Mon, 9 Dec 2013 12:53:12 +0000
>
> So what it if ages out you can always just re-catalog it and then restore.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--001a113429c0aa9d9704ed4bc52f
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Excellent thread. There is a &quot;magical&quot; workaroun=
d to getting older control file from storage media even when <span style=3D=
"font-family:arial,sans-serif;font-size:13px">CONTROL_FILE_RECORD_KEEP_TIME=
 =3D 7 (or whatever the value is) as long as the backups are retained on th=
e media.=A0</span>Not sure if this was available in 8i, 9i but have used th=
is in 10g recovery at a large Canadian grocer. =A0In RMAN configure control=
file autobackup to ON. With that, when you ask RMAN to recover a controlfil=
e to a particular point in time it asks media manager to restore files and =
provides appropriate file names to the media manager. This works because wi=
th controlfile autoback, the backup pieces that have controlfile are named =
in particular fashion. This is all well documented. It has been 5+ years wh=
en this was done so don&#39;t remenber the details or the control file auto=
backup piece naming convention. There are few gotchas with that e.g. if you=
 have an hourly script to add &quot;partitions + tablespace&quot; to table/=
s, there will be a controlfile autobackup triggered with each tablespace/da=
ta file addition (as designed) but this holds controlfile enque for duratio=
n of the backup (as far as I can remember)...=A0</div>

<div class=3D"gmail_extra"><br clear=3D"all"><div><div dir=3D"ltr">Thanks<b=
r>Paresh<br><div>416-688-1003<br><div><br></div></div></div></div>
<br><br><div class=3D"gmail_quote">On Wed, Dec 11, 2013 at 6:59 PM, Dick Go=
ulet <span dir=3D"ltr">&lt;<a href=3D"mailto:rjgoulet@comcast.net" target=
=3D"_blank">rjgoulet@comcast.net</a>&gt;</span> wrote:<br><blockquote class=
=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padd=
ing-left:1ex">

To catalog or not to catalog has always been a question that never has had =
a good answer. =A0So let me put it this way, I have a catalog db and I use =
it. =A0But I also practice restores without it and don&#39;t have a problem=
. =A0Course it helps to have a tape librarian with lots of memory. =A0Ours =
likes to retain stuff for 3 years. =A0The controlfile 90 days. =A0Try &quot=
;restore controlfile from &#39;&lt;media handle&gt;&#39;;&quot; where &lt;m=
edia handle&gt; =3D c-&lt;date&gt;-&lt;dbid&gt;-00 if you need something be=
yond that 90 day point.<br>


<br>
Dick Goulet<br>
Senior Oracle Dba<br>
<br>
------------------------------<u></u>------------------------------<u></u>-=
---------<br>
<br>
From: Dustin Hayden&lt;<a href=3D"mailto:DHayden@sprich.com" target=3D"_bla=
nk">DHayden@sprich.com</a>&gt;<br>
Subject: RE: Why I don&#39;t like RMAN repositories<br>
Date: Mon, 9 Dec 2013 12:53:12 +0000<br>
<br>
So what it if ages out you can always just re-catalog it and then restore.<=
br>
<br>
--<br>
<a href=3D"http://www.freelists.org/webpage/oracle-l" target=3D"_blank">htt=
p://www.freelists.org/<u></u>webpage/oracle-l</a><br>
<br>
<br>
</blockquote></div><br></div>

--001a113429c0aa9d9704ed4bc52f--
--
http://www.freelists.org/webpage/oracle-l