Re: Backups via RMAN or Shell Script

In our last gripping episode "Howard J. Rogers" <howardjr_at_www.com> wrote:
> I'm slightly gob-smacked if there is still a catrman script in 8.1.5,
 and I
> can only think they put it there for compatibility reasons.... 'cause
 in the
> training materials, there's no reference to it all, and it is in fact
> utterly redundant, even in 8.1.5. I'm doing RMAN tomorrow, actually -
 and
> there'll be no use of any catrman script. And we are still training
 on
> 8.1.5.
>
> He could have phrased his response rather more politely, but John is
> basically correct that use of the script in any version of 8i is
> unnecessary.
>
> Regards
> HJR
>
> "David Fitzjarrell" <oratune_at_aol.com> wrote in message
> news:944qv8$cp5$1_at_nnrp1.deja.com...
> > In our last gripping episode "John Jones" <john.jones_at_duke.edu>
 wrote:
> > > Know what you are talking about before you answer.
> > >
> > > There is no Catrman script for 8.1.6. Basically you connect to
 your
 source
> > > and to your target and then you "register" your database. The
 stored
 procs
> > > are already there
> > >
> > > --
> > > John Jones
> > > Senior Oracle DBA
> > > Duke University, OIT
> > > john.jones_at_duke.edu
> > > David Fitzjarrell <oratune_at_aol.com> wrote in message
> > > news:9423fg$2ip$1_at_nnrp1.deja.com...
> > > > In our last gripping episode Erik Zhang
 <yzhang3_at_mail.med.upenn.edu>
> > > > wrote:
> > > > > Hi, I am interested about your talk about RMAN. I wonder any
 of
 you
 can tell
> > > > > me where can I find script "catrman.sql". I installed Oracle
 8.1.6
> > > > > Enterprise Edition on Window NT, And I cannot get that script
 anywhere.
> > > > > thank you.
> > > > > Erik
> > > > >
> > > > >
> > > >
> > > > You should find it at <drive>\oracle\ora81\rdbms\admin, for
 example:
> > > >
> > > > c:\oracle\ora81\rdbms\admin
> > > >
> > > >
> > > >
> > > > --
> > > > David Fitzjarrell
> > > > Oracle Certified DBA
> > > >
> > > >
> > > > Sent via Deja.com
> > > > http://www.deja.com/
> > >
> > >
> >
> > Apparently this has changed in 8.1.6, and, not having an 8.1.6
 instance
> > to check I went with what I knew, that in 8.1.5 there IS a
 catrman.sql
> > script, found where I stated.
> >
> > It must be quite invigorating to be right all of the time.
> >
> > --
> > David Fitzjarrell
> > Oracle Certified DBA
> >
> >
> > Sent via Deja.com
> > http://www.deja.com/
>
>

I shall consider myself suitably chastised for my lack of forethought. Apparently one of the support staff copied the catrman.sql script from an 8.0.5 instance to the 8.1.5 installation. Seeing it missing sent fear into his heart and to rectify the situation (which was not necessary) the file was placed in the requisite location. Performing a rudimentary search of the rdbms/admin directory unearthed a copy of the script; seeing it in 8.1.5 I naturally presumed it was also in 8.1.6. As Howard so nicely phrased it (and John so abruptly stated) its presence is no longer necessary.

I have never run the script in 8.1.5, and we have setup RMAN for testing purposes, so seeing the file where it was supposed to be led me to believe it was still part of the 8i installation.

I apologise to all who may have tried to take my 'advice' and failed.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com
http://www.deja.com/