| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN[2]
Surendra -
With RMAN, you are only sending commands across the network. Plus, mostly you set it up to work automatically off-hours. Therefore it puts only a negligible load on the network. The heavy load is the actual backup performed locally on the target database.
Each of the configurations you describe is valid. You have the catalog on a
separate system from the target database, so if there is a failure on the
target system, your RMAN catalog is available to recover the target
database.
Where you invoke RMAN from is irrelevant. The only exception I can recall
is if you are starting the target database using RMAN that it may use a
local init.ora file.
Maybe you are thinking of your automated backup scripts. I would assume
that you would want them with the catalog for convenience.
Don't forget to create a backup strategy for your RMAN catalog. I intend
to export the RMAN catalog after the backup and FTP that export over to the
target system so my backups and export end up on the same backup tape. That
way, in case of a disaster, we can retrieve the backup tape from the offsite
storage and have everything we need.
I would recommend that you purchase the book "Oracle Backup & Recovery
101" by Smith & Haisley. Do the exercises. Then you will see for yourself
how RMAN works. I think this will clarify a lot of your questions. It really
helped me.
Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
[mailto:Surendra.Tirumala_at_mail.state.ky.us]
Sent: Tuesday, June 11, 2002 8:28 AM
To: Multiple recipients of list ORACLE-L
Dennis,
How much do you think the network matters in the following scenarios?
Case 1:
Catalog is on Box A and Target is on Box B and we are invoking RMAN from Box
C
Case 2:
Catalog is on Box A and Target is on Box B and we are invoking RMAN from Box
A
Case 3:
Catalog is on Box A and Target is on Box B and we are invoking RMAN from Box
B
I am thinking that there won't be much difference from case 1 to 2 as RMAN writes very little to the catalog. Where as with Case 3, we will get real advantage. I am assuming similar network speeds between all the machines.
Thanks for your help.
Surendra
-----Original Message-----
Sent: Monday, June 10, 2002 6:39 PM
To: Multiple recipients of list ORACLE-L
Surendra - That is inherent in RMAN. RMAN only writes on the target system. I do believe that one is on the exam.
Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
[mailto:Surendra.Tirumala_at_mail.state.ky.us]
Sent: Monday, June 10, 2002 3:24 PM
To: Multiple recipients of list ORACLE-L
I have been doing this only. Still it is trying to write on target machine.
Thanks,
Surendra
-----Original Message-----
Sent: Monday, June 10, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L
sorry ...
there is another way ....
install RMAN on the remote machine and connect to the remote database with sql*net
;-) Ciao
> Hi.
> you must share the remote filesystem or make RMAN able to write on DLT.
>
> :-) Ciao
> ----- Original Message -----
> From: <Surendra.Tirumala_at_mail.state.ky.us>
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Monday, June 10, 2002 6:53 PM
> Subject: RMAN
>
>
> > Hello All,
> >
> > I have been working on a strategy to implement a RMAN based backup and
> > recovery strategy.
> > Can anyone please suggest me if there is a way to force the RMAN to
write
> > the backups to a machine other than the one on which target database is
> > present?
> >
> > Thanks for your help.
> >
> > Surendra
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: Surendra.Tirumala_at_mail.state.ky.us
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > 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.com -- Author: claudio cutelli INET: c_cutelli_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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.com -- Author: INET: Surendra.Tirumala_at_mail.state.ky.us Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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.com -- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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.com -- Author: INET: Surendra.Tirumala_at_mail.state.ky.us Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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.com -- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).Received on Tue Jun 11 2002 - 12:24:30 CDT
 |
 |