RE: RE : RMAN Repository

Gene - I would think your site would be just what the repository was designed for. You could use a single repository for all 25 databases. Then each day you could execute a simple query and receive an exception report that tells you any backup vulnerabilities for any of the 25 systems. Without the repository you'd have to spend a lot of your time either typing commands each day or creating programs to perform what RMAN offers built in.

    As to the rumors that Oracle is going to soon abandon the RMAN repository, I agree with Robert (if I recall correctly). How could they? Large Oracle customers are heavily committed to the repository, and Oracle usually doesn't do anything that stupid. But people are whining about why they are forced to use the repository, so Oracle is emphasizing that you can get most of the benefits without a repository. But in your situation, I would strongly consider the repository.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com  

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

Dennis - I am now running 8.1.6 & 8.1.7 w/out RMAN, soon to upgrade to 9.2 then implement RMAN. I have 25 db instances. I am thinking of using RMAN w/out a repository unless there are great reasons not to :) Gene

>>> DWILLIAMS_at_LIFETOUCH.COM 01/09/03 11:24AM >>>
Gene - Which Oracle version(s)? How many instances will you be backing up?

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_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_at_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_at_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_at_verizon.com>
>Sent by: root_at_fatcity.com
> 01/08/2003 11:44 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_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> 
< http://www.orafaq.net <http://www.orafaq.net> > 
-- 
Author: Joe Testa
  INET: jtesta_at_dmc-it.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
<http://www.fatcity.com> 
< 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_at_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
<http://www.orafaq.net> 
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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_at_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_at_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_at_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).