Re: RMAN - Remote vs Local Backups
Metalink Note 73431.1 has an RMAN Compatibility Matrix. TargetRMANCatalog DBCatalog Schema 9.2.0>=9.0.3>=8.1.x >= RMAN executable An RMAN920 schema can be created in an Oracle 8.1.6 database that contains the recovery catalog for Oracle 9.2.0 databases. Have Fun :) DENNIS WILLIAMS wrote: Jared - Excellent point. My understanding is that the RMAN catalog must run on an Oracle version equal or greater than the target instances. Has anyone found this requirement to be a big pain? I am looking to configuring RMAN on another set of servers, but they are Oracle 9.2 and my current RMAN server is 8.1.6, and would need an O.S. upgrade to move to 9.2. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 29, 2003 8:20 PM To: Multiple recipients of list ORACLE-L Dennis, The cron job can run on B only if it is the same version of Oracle that is on A. Jared DENNIS WILLIAMS <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/29/2003 03:14 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: RMAN - Remote vs Local Backups Walter - What you describe is the standard RMAN configuration. Box B contains the RMAN catalog, therefore it must command the backup. And so the cron job must run on Box B. But the actual backup occurs on the target machine (A in your example). If you back up to tape, you must have an MML (Media Management Library). You can also back up to disk (that is what I do). Since the actual backup occurs on the target machine, not much network traffic is involved. RMAN sends some commands, the target sends some status back, and that is about it. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 29, 2003 4:30 PM To: Multiple recipients of list ORACLE-L Thanks Tim, Dennis and Ron for your feedback. I appreciate it. Let me clarify what I'm seeking. In my example, I am using a centralized catalog which is on its own dedicated database/server and backups are to tape. BCV's are not involved. Normally, in my experience, RMAN backups are initiated from the target server via a cron job. But, I've seen a case where a cron job for an RMAN backup was run from a box that was different from the database server machine. I find this configuration strange and confusing because it implies this was done for a "reason" and makes life difficult to find out where all the backups are running from. In the scenario of backing up the database on box A via an rman/cron job on box B, is this particular configuration more network resource intensive and therefore slower versus the backup being initiated from the same machine as t -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: RMAN - Remote vs Local Backups
True enough. I was making the assumption that RMAN would
be run from the client or backup server.
Of course that is not necessarily true.
Some third party tools may require it. NetBackup for instance
expects the RMAN script to run on the client, but I don't know
if that is strictly necessary.
Jared
On Friday 30 May 2003 15:14, MacGregor, Ian A. wrote:
> You can initiate backups from any machine. Here is a cold backup script
> to illustrate backing up from a database server connecting to a rman
> catalog on another machine.
>
> #!/bin/sh
> ORACLE_HOME=/opt/oracle/dbserver/9.0.1
> export ORACLE_HOME
> ORACLE_SID=XXX
> export ORACLE_SID
> NLS_DATE_FORMAT=DD-MON-:HH24:MI:SS
> export NLS_DATE_FORMAT
> $ORACLE_HOME/bin/rman < connect target /
> shutdown immediate
> startup mount
> connect catalog XX/[EMAIL PROTECTED]
> run
> {
> allocate channel c1 device type sbt format 'df_%t_%s_%p' maxpiecesize=512M
> PARMS="SBT_LIBRARY=/opt/oracle/dbserver/9.0.1/lib/libobk.so,
> ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt)";
> backup database;
> backup current controlfile;
> release channel c1;
> }
> alter database open;
> exit
> EOF
>
> -Original Message-
> Sent: Thursday, May 29, 2003 3:15 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Walter - What you describe is the standard RMAN configuration. Box B
> contains the RMAN catalog, therefore it must command the backup. And so the
> cron job must run on Box B. But the actual backup occurs on the target
> machine (A in your example). If you back up to tape, you must have an MML
> (Media Management Library). You can also back up to disk (that is what I
> do). Since the actual backup occurs on the target machine, not much network
> traffic is involved. RMAN sends some commands, the target sends some status
> back, and that is about it.
>
>
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> -Original Message-
> Sent: Thursday, May 29, 2003 4:30 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Thanks Tim, Dennis and Ron for your feedback. I appreciate it.
>
> Let me clarify what I'm seeking. In my example, I am using a centralized
> catalog which is on its own dedicated database/server and backups are to
> tape. BCV's are not involved.
>
> Normally, in my experience, RMAN backups are initiated from the target
> server via a cron job. But, I've seen a case where a cron job for an RMAN
> backup was run from a box that was different from the database server
> machine. I find this configuration strange and confusing because it implies
> this was done for a "reason" and makes life difficult to find out where all
> the backups are running from.
>
> In the scenario of backing up the database on box A via an rman/cron job on
> box B, is this particular configuration more network resource intensive and
> therefore slower versus the backup being initiated from the same machine as
> the database? If not, could someone explain why?
>
> Does this make sense?
>
> Thanks again.
> -w
>
>
>
>
> DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
>
> Walter - As RMAN was introduced in Oracle8i, that was the ideal. I think
> Oracle viewed RMAN as a high-level feature that would help you manage the
> backups for large server farms. They emphasized that the catalog was the
> way to go. With the catalog on another box, if the server was toasted, you
> could slide another system into that spot and with a couple of RMAN
> commands you could have that up and going again. Obviously if you use the
> catalog method on the box you are backing up, you must have a second
> instance, and even then you introduce more vulnerabilities than the
> configuration where the catalog is on another server. With Oracle9i, Oracle
> added many of the features that were only available in the catalog method
> to the control-file method. According to my Oracle Education Instructor
> John Hibbard who is pretty plugged into these things, Oracle is trying ! to
> emphasize that the catalog method may not suit everyone's situation and the
> control file method may best suit your need! s. As
> others on this list have pointed out, not all conference speakers have
> gotten that message.
>
>
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> -Original Message-
> Sent: Thursday, May 29, 2003 11:55 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi,
>
> Can anyone think of a reason(s) why one WOULD want to backup a database
> from a box other than the database box itself? Are there any advantages to
> this kind of configuration?
>
> For example:
>
> Box-A (production db server)
> Box-B (rman db server)
>
> A cron job runs on Box-B which backups up the database from Box-A.
>
>
> Thanks in advance!
>
> -w
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, Califor
RE: RMAN - Remote vs Local Backups
You can initiate backups from any machine. Here is a cold backup script to illustrate backing up from a database server connecting to a rman catalog on another machine. #!/bin/sh ORACLE_HOME=/opt/oracle/dbserver/9.0.1 export ORACLE_HOME ORACLE_SID=XXX export ORACLE_SID NLS_DATE_FORMAT=DD-MON-:HH24:MI:SS export NLS_DATE_FORMAT $ORACLE_HOME/bin/rman < wrote: Walter - As RMAN was introduced in Oracle8i, that was the ideal. I think Oracle viewed RMAN as a high-level feature that would help you manage the backups for large server farms. They emphasized that the catalog was the way to go. With the catalog on another box, if the server was toasted, you could slide another system into that spot and with a couple of RMAN commands you could have that up and going again. Obviously if you use the catalog method on the box you are backing up, you must have a second instance, and even then you introduce more vulnerabilities than the configuration where the catalog is on another server. With Oracle9i, Oracle added many of the features that were only available in the catalog method to the control-file method. According to my Oracle Education Instructor John Hibbard who is pretty plugged into these things, Oracle is trying ! to emphasize that the catalog method may not suit everyone's situation and the control file method may best suit your need! s. As others on this list have pointed out, not all conference speakers have gotten that message. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 29, 2003 11:55 AM To: Multiple recipients of list ORACLE-L Hi, Can anyone think of a reason(s) why one WOULD want to backup a database from a box other than the database box itself? Are there any advantages to this kind of configuration? For example: Box-A (production db server) Box-B (rman db server) A cron job runs on Box-B which backups up the database from Box-A. Thanks in advance! -w -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] OM 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: MacGregor, Ian A. INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: RMAN - Remote vs Local Backups
Jared - Excellent point. My understanding is that the RMAN catalog must run on an Oracle version equal or greater than the target instances. Has anyone found this requirement to be a big pain? I am looking to configuring RMAN on another set of servers, but they are Oracle 9.2 and my current RMAN server is 8.1.6, and would need an O.S. upgrade to move to 9.2. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 29, 2003 8:20 PM To: Multiple recipients of list ORACLE-L Dennis, The cron job can run on B only if it is the same version of Oracle that is on A. Jared DENNIS WILLIAMS <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/29/2003 03:14 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: RMAN - Remote vs Local Backups Walter - What you describe is the standard RMAN configuration. Box B contains the RMAN catalog, therefore it must command the backup. And so the cron job must run on Box B. But the actual backup occurs on the target machine (A in your example). If you back up to tape, you must have an MML (Media Management Library). You can also back up to disk (that is what I do). Since the actual backup occurs on the target machine, not much network traffic is involved. RMAN sends some commands, the target sends some status back, and that is about it. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 29, 2003 4:30 PM To: Multiple recipients of list ORACLE-L Thanks Tim, Dennis and Ron for your feedback. I appreciate it. Let me clarify what I'm seeking. In my example, I am using a centralized catalog which is on its own dedicated database/server and backups are to tape. BCV's are not involved. Normally, in my experience, RMAN backups are initiated from the target server via a cron job. But, I've seen a case where a cron job for an RMAN backup was run from a box that was different from the database server machine. I find this configuration strange and confusing because it implies this was done for a "reason" and makes life difficult to find out where all the backups are running from. In the scenario of backing up the database on box A via an rman/cron job on box B, is this particular configuration more network resource intensive and therefore slower versus the backup being initiated from the same machine as t -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: RMAN - Remote vs Local Backups
Walter - This is a common question about RMAN. The Oracle response has been "not a significant amount". I haven't noticed anything, but haven't specifically tried to measure it. As I mentioned, there are only a few commands going B -> A and some status information going A -> B. The actual backup itself occurs entirely on A. If this is unacceptable, then consider using the RMAN control file configuration. Then only A is involved. I wouldn't recommend putting the RMAN catalog on A, because that introduces vulnerabilities and the reason for moving to RMAN is to reduce vulnerabilities. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 29, 2003 6:05 PM To: Multiple recipients of list ORACLE-L In my scenario, target DB to be backed up on box A and rman database/catalog on Box B, I can "run" the backup from A or from B no problem. But, what I'm trying to get at is it better, worse or indifferent to "run" the backup from B or A. I would think there is extra network traffic to "run" the backup from B. DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: Walter - What you describe is the standard RMAN configuration. Box B contains the RMAN catalog, therefore it must command the backup. And so the cron job must run on Box B. But the actual backup occurs on the target machine (A in your example). If you back up to tape, you must have an MML (Media Management Library). You can also back up to disk (that is what I do). Since the actual backup occurs on the target machine, not much network traffic is involved. RMAN sends some commands, the target sends some status back, and that is about it. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 29, 2003 4:30 PM To: Multiple recipients of list ORACLE-L Thanks Tim, Dennis and Ron for your feedback. I appreciate it. Let me clarify what I'm seeking! . In my example, I am using a centralized catalog which is on its own dedicated database/server and backups are to tape. BCV's are not involved. Normally, in my experience, RMAN backups are initiated from the target server via a cron job. But, I've seen a case where a cron job for an RMAN backup was run from a box that was different from the database server machine. I find this configuration strange and confusing because it implies this was done for a "reason" and makes life difficult to find out where all the backups are running from. In the scenario of backing up the database on box A via an rman/cron job on box B, is this particular configuration more network resource intensive and therefore slower versus the backup being initiated from the same machine as the database? If not, could someone explain why? Does this make sense? Thanks again. -w DENNIS WILLIAMS wrote: Walter - As RMAN was introduced in Oracle8i, that was the ideal. I think Oracle viewed RMAN as a high-level feature that would help you manage the backups for large server farms. They emphasized that the catalog was the way to go. With the catalog on another box, if the server was toasted, you could slide another system into that spot and with a couple of RMAN commands you could have that up and going again. Obviously if you use the catalog method on the box you are backing up, you must have a second instance, and even then you introduce more vulnerabilities than the configuration where the catalog is on another server. With Oracle9i, Oracle added many of the features that were only available in the catalog method to the control-file method. According to my Oracle Education Instructor John Hibbard who is pretty plugged into these things, Oracle is trying ! to emphasize that the catalog method may not suit everyone's situation and the c! ontrol file method may best suit your needs. As others on this list have pointed out, not all conference speakers have gotten that message. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 29, 2003 11:55 AM To: Multiple recipients of list ORACLE-L Hi, Can anyone think of a reason(s) why one WOULD want to backup a database from a box other than the database box itself? Are there any advantages to this kind of configuration? For example: Box-A (production db server) Box-B (rman db server) A cron job runs on Box-B which backups up the database from Box-A. Thanks in advance! -w -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] OM 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mail
RE: RMAN - Remote vs Local Backups
-w. The method I use to perform the RMAN backup is different than the question you posed. Box-a is the database(target). OpenVMS - Production server Box-b is the repository(catalog) database. OpenVMS - Development server Box-c is the controling(cron source). Linux - play and learn server. I have the Box-c cron run the RMAN commands and connect to the target and catalog servers. The box-c RMAN then initiates the backup level0 and level2 at different days that I set in the cron. The log of events are stored on the box-c ( for ease of reading and access) The RMAN backups are stored on the box-a disks eliminating network traffic and ease of restoral if needed. Box-a has a large storage capacity for the RMAN backups and the backups are copied to tape nightly by the os backup. The network traffic is as follows: box-a to box-b catalog information only. box-a to box-c RMAN commands and log info. box-c to box-b RMAN commands. It keeps the traffic to a minamum and allows me the ability the perform the RMAN functions on an OS that is friendly to me. Ron >>> [EMAIL PROTECTED] 05/29/03 05:30PM >>> Thanks Tim, Dennis and Ron for your feedback. I appreciate it. Let me clarify what I'm seeking. In my example, I am using a centralized catalog which is on its own dedicated database/server and backups are to tape. BCV's are not involved. Normally, in my experience, RMAN backups are initiated from the target server via a cron job. But, I've seen a case where a cron job for an RMAN backup was run from a box that was different from the database server machine. I find this configuration strange and confusing because it implies this was done for a "reason" and makes life difficult to find out where all the backups are running from. In the scenario of backing up the database on box A via an rman/cron job on box B, is this particular configuration more network resource intensive and therefore slower versus the backup being initiated from the same machine as the database? If not, could someone explain why? Does this make sense? Thanks again. -w DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: Walter - As RMAN was introduced in Oracle8i, that was the ideal. I think Oracle viewed RMAN as a high-level feature that would help you manage the backups for large server farms. They emphasized that the catalog was the way to go. With the catalog on another box, if the server was toasted, you could slide another system into that spot and with a couple of RMAN commands you could have that up and going again. Obviously if you use the catalog method on the box you are backing up, you must have a second instance, and even then you introduce more vulnerabilities than the configuration where the catalog is on another server. With Oracle9i, Oracle added many of the features that were only available in the catalog method to the control-file method. According to my Oracle Education Instructor John Hibbard who is pretty plugged into these things, Oracle is trying to emphasize that the catalog method may not suit everyone's situation and the control file method may best suit your needs. As others on this list have pointed out, not all conference speakers have gotten that message. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 29, 2003 11:55 AM To: Multiple recipients of list ORACLE-L Hi, Can anyone think of a reason(s) why one WOULD want to backup a database from a box other than the database box itself? Are there any advantages to this kind of configuration? For example: Box-A (production db server) Box-B (rman db server) A cron job runs on Box-B which backups up the database from Box-A. Thanks in advance! -w -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Ron Rogers INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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 in
RE: RMAN - Remote vs Local Backups
Dennis, The cron job can run on B only if it is the same version of Oracle that is on A. Jared DENNIS WILLIAMS <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/29/2003 03:14 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: RMAN - Remote vs Local Backups Walter - What you describe is the standard RMAN configuration. Box B contains the RMAN catalog, therefore it must command the backup. And so the cron job must run on Box B. But the actual backup occurs on the target machine (A in your example). If you back up to tape, you must have an MML (Media Management Library). You can also back up to disk (that is what I do). Since the actual backup occurs on the target machine, not much network traffic is involved. RMAN sends some commands, the target sends some status back, and that is about it. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 29, 2003 4:30 PM To: Multiple recipients of list ORACLE-L Thanks Tim, Dennis and Ron for your feedback. I appreciate it. Let me clarify what I'm seeking. In my example, I am using a centralized catalog which is on its own dedicated database/server and backups are to tape. BCV's are not involved. Normally, in my experience, RMAN backups are initiated from the target server via a cron job. But, I've seen a case where a cron job for an RMAN backup was run from a box that was different from the database server machine. I find this configuration strange and confusing because it implies this was done for a "reason" and makes life difficult to find out where all the backups are running from. In the scenario of backing up the database on box A via an rman/cron job on box B, is this particular configuration more network resource intensive and therefore slower versus the backup being initiated from the same machine as t -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: RMAN - Remote vs Local Backups
In my scenario, target DB to be backed up on box A and rman database/catalog on Box B, I can "run" the backup from A or from B no problem. But, what I'm trying to get at is it better, worse or indifferent to "run" the backup from B or A. I would think there is extra network traffic to "run" the backup from B.DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: Walter - What you describe is the standard RMAN configuration. Box Bcontains the RMAN catalog, therefore it must command the backup. And so thecron job must run on Box B. But the actual backup occurs on the targetmachine (A in your example). If you back up to tape, you must have an MML(Media Management Library). You can also back up to disk (that is what Ido).Since the actual backup occurs on the target machine, not much networktraffic is involved. RMAN sends some commands, the target sends some statusback, and that is about it.Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message-Sent: Thursday, May 29, 2003 4:30 PMTo: Multiple recipients of list ORACLE-LThanks Tim, Dennis and Ron for your feedback. I appreciate it.Let me clarify what I'm seeking! . In my example, I am using a centralizedcatalog which is on its own dedicated database/server and backups are totape. BCV's are not involved.Normally, in my experience, RMAN backups are initiated from the targetserver via a cron job. But, I've seen a case where a cron job for an RMANbackup was run from a box that was different from the database servermachine. I find this configuration strange and confusing because it impliesthis was done for a "reason" and makes life difficult to find out where allthe backups are running from.In the scenario of backing up the database on box A via an rman/cron job onbox B, is this particular configuration more network resource intensive andtherefore slower versus the backup being initiated from the same machine asthe database? If not, could someone explain why?Does this make sense?Thanks again.-wDENNIS WILLIAMS <[EMAIL PROTECTED]>wrote:Walter - As RMAN was introduced in Oracle8i, that was the ideal. I thinkOracle viewed RMAN as a high-level feature that would help you manage thebackups for large server farms. They emphasized that the catalog was the wayto go. With the catalog on another box, if the server was toasted, you couldslide another system into that spot and with a couple of RMAN commands youcould have that up and going again. Obviously if you use the catalog methodon the box you are backing up, you must have a second instance, and eventhen you introduce more vulnerabilities than the configuration where thecatalog is on another server.With Oracle9i, Oracle added many of the features that were onlyavailable in the catalog method to the control-file method. According to myOracle Education Instructor John Hibbard who is pretty plugged into thesethings, Oracle is trying ! to emphasize that the catalog method may not suiteveryone's situation and the c! ontrol file method may best suit your needs.As others on this list have pointed out, not all conference speakers havegotten that message.Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message-Sent: Thursday, May 29, 2003 11:55 AMTo: Multiple recipients of list ORACLE-LHi,Can anyone think of a reason(s) why one WOULD want to backup a database froma box other than the database box itself? Are there any advantages to thiskind of configuration?For example:Box-A (production db server)Box-B (rman db server)A cron job runs on Box-B which backups up the database from Box-A.Thanks in advance!-w-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: DENNIS WILLIAMSINET: [EMAIL PROTECTED] OMFat City Network Services -- 858-538-5051 http://www.fatcity.comSan! Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: DENNIS WILLIAMSINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BO! DY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: RMAN - Remote vs Local Backups
Walter - What you describe is the standard RMAN configuration. Box B contains the RMAN catalog, therefore it must command the backup. And so the cron job must run on Box B. But the actual backup occurs on the target machine (A in your example). If you back up to tape, you must have an MML (Media Management Library). You can also back up to disk (that is what I do). Since the actual backup occurs on the target machine, not much network traffic is involved. RMAN sends some commands, the target sends some status back, and that is about it. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 29, 2003 4:30 PM To: Multiple recipients of list ORACLE-L Thanks Tim, Dennis and Ron for your feedback. I appreciate it. Let me clarify what I'm seeking. In my example, I am using a centralized catalog which is on its own dedicated database/server and backups are to tape. BCV's are not involved. Normally, in my experience, RMAN backups are initiated from the target server via a cron job. But, I've seen a case where a cron job for an RMAN backup was run from a box that was different from the database server machine. I find this configuration strange and confusing because it implies this was done for a "reason" and makes life difficult to find out where all the backups are running from. In the scenario of backing up the database on box A via an rman/cron job on box B, is this particular configuration more network resource intensive and therefore slower versus the backup being initiated from the same machine as the database? If not, could someone explain why? Does this make sense? Thanks again. -w DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: Walter - As RMAN was introduced in Oracle8i, that was the ideal. I think Oracle viewed RMAN as a high-level feature that would help you manage the backups for large server farms. They emphasized that the catalog was the way to go. With the catalog on another box, if the server was toasted, you could slide another system into that spot and with a couple of RMAN commands you could have that up and going again. Obviously if you use the catalog method on the box you are backing up, you must have a second instance, and even then you introduce more vulnerabilities than the configuration where the catalog is on another server. With Oracle9i, Oracle added many of the features that were only available in the catalog method to the control-file method. According to my Oracle Education Instructor John Hibbard who is pretty plugged into these things, Oracle is trying ! to emphasize that the catalog method may not suit everyone's situation and the control file method may best suit your needs. As others on this list have pointed out, not all conference speakers have gotten that message. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 29, 2003 11:55 AM To: Multiple recipients of list ORACLE-L Hi, Can anyone think of a reason(s) why one WOULD want to backup a database from a box other than the database box itself? Are there any advantages to this kind of configuration? For example: Box-A (production db server) Box-B (rman db server) A cron job runs on Box-B which backups up the database from Box-A. Thanks in advance! -w -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] OM 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: RMAN - Remote vs Local Backups
Thanks Tim, Dennis and Ron for your feedback. I appreciate it. Let me clarify what I'm seeking. In my example, I am using a centralized catalog which is on its own dedicated database/server and backups are to tape. BCV's are not involved. Normally, in my experience, RMAN backups are initiated from the target server via a cron job. But, I've seen a case where a cron job for an RMAN backup was run from a box that was different from the database server machine. I find this configuration strange and confusing because it implies this was done for a "reason" and makes life difficult to find out where all the backups are running from. In the scenario of backing up the database on box A via an rman/cron job on box B, is this particular configuration more network resource intensive and therefore slower versus the backup being initiated from the same machine as the database? If not, could someone explain why? Does this make sense? Thanks again. -w DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: Walter - As RMAN was introduced in Oracle8i, that was the ideal. I thinkOracle viewed RMAN as a high-level feature that would help you manage thebackups for large server farms. They emphasized that the catalog was the wayto go. With the catalog on another box, if the server was toasted, you couldslide another system into that spot and with a couple of RMAN commands youcould have that up and going again. Obviously if you use the catalog methodon the box you are backing up, you must have a second instance, and eventhen you introduce more vulnerabilities than the configuration where thecatalog is on another server.With Oracle9i, Oracle added many of the features that were onlyavailable in the catalog method to the control-file method. According to myOracle Education Instructor John Hibbard who is pretty plugged into thesethings, Oracle is trying ! to emphasize that the catalog method may not suiteveryone's situation and the control file method may best suit your needs.As others on this list have pointed out, not all conference speakers havegotten that message.Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message-Sent: Thursday, May 29, 2003 11:55 AMTo: Multiple recipients of list ORACLE-LHi,Can anyone think of a reason(s) why one WOULD want to backup a database froma box other than the database box itself? Are there any advantages to thiskind of configuration?For example:Box-A (production db server)Box-B (rman db server)A cron job runs on Box-B which backups up the database from Box-A.Thanks in advance!-w-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: DENNIS WILLIAMSINET: [EMAIL PROTECTED] OMFat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: RMAN - Remote vs Local Backups
Sure, several: 1) Centralized backup management, maybe there will eventually be a Box-C which can also be backed up by Box-B. 2) Maybe Box-B is a Veritas master media server or the equivilent with other backup software. 3) Most important: Box-A has a 'crash and burn', you don't lose your RMAN catalog too. >>> [EMAIL PROTECTED] 05/29/03 11:54AM >>> Hi, Can anyone think of a reason(s) why one WOULD want to backup a database from a box other than the database box itself? Are there any advantages to this kind of configuration? For example: Box-A (production db server) Box-B (rman db server) A cron job runs on Box-B which backups up the database from Box-A. Thanks in advance! -w -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: RMAN - Remote vs Local Backups
Walter - As RMAN was introduced in Oracle8i, that was the ideal. I think Oracle viewed RMAN as a high-level feature that would help you manage the backups for large server farms. They emphasized that the catalog was the way to go. With the catalog on another box, if the server was toasted, you could slide another system into that spot and with a couple of RMAN commands you could have that up and going again. Obviously if you use the catalog method on the box you are backing up, you must have a second instance, and even then you introduce more vulnerabilities than the configuration where the catalog is on another server. With Oracle9i, Oracle added many of the features that were only available in the catalog method to the control-file method. According to my Oracle Education Instructor John Hibbard who is pretty plugged into these things, Oracle is trying to emphasize that the catalog method may not suit everyone's situation and the control file method may best suit your needs. As others on this list have pointed out, not all conference speakers have gotten that message. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 29, 2003 11:55 AM To: Multiple recipients of list ORACLE-L Hi, Can anyone think of a reason(s) why one WOULD want to backup a database from a box other than the database box itself? Are there any advantages to this kind of configuration? For example: Box-A (production db server) Box-B (rman db server) A cron job runs on Box-B which backups up the database from Box-A. Thanks in advance! -w -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: RMAN - Remote vs Local Backups
-w A simple disk crash containing the database and the RMAN data woulf wipe you out. If bax-a crashed you could use box-b to recover your data. Ron >>> [EMAIL PROTECTED] 05/29/03 12:54PM >>> Hi, Can anyone think of a reason(s) why one WOULD want to backup a database from a box other than the database box itself? Are there any advantages to this kind of configuration? For example: Box-A (production db server) Box-B (rman db server) A cron job runs on Box-B which backups up the database from Box-A. Thanks in advance! -w -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: RMAN - Remote vs Local Backups
Well How about if you are performing BCV snapshots of the storage under Box-A (prod server) and then mounting those BCVs on Box-B, mounting (not opening!) the database on Box-B, and performing RMAN backups? That would remove any resource consumption from the all-important Box-A as far as backups are concerned. Of course, archived redo log backups should continue to be performed from Box-A, but the datafile backups can be performed from Box-B. I'm not sure, but perhaps Box-B would even be able to perform the "re-silvering" operation to re-mirror the BCV volumes back into the main RAID-1 set, thus truly relieving Box-A of the burdens of backups... It would be highly advisable to use a centralized "recovery catalog" database in this situation (instead of NOCATALOG mode). Since both database images on both servers will have the same DBID, the "recovery catalog" database should record both types of backups (datafile on Box-B and everything else on Box-A) as if they were all performed from Box-A... Just an idea... -Tim > Hi, > > Can anyone think of a reason(s) why one WOULD want to > backup a database from a box other than the database box > itself? Are there any advantages to this kind of > configuration? > > For example: > > Box-A (production db server) > Box-B (rman db server) > > A cron job runs on Box-B which backups up the database > from Box-A. > > > Thanks in advance! > > -w > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: RMAN - Remote vs Local Backups
Just a thought. Possibly to assist in recovery of the database box. If you have a complete media failure on the DB host, you greatly simplify the recovery process if your RMAN database is somewhere safe. Steve McClure -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Walter KSent: Thursday, May 29, 2003 9:55 AMTo: Multiple recipients of list ORACLE-LSubject: RMAN - Remote vs Local Backups Hi, Can anyone think of a reason(s) why one WOULD want to backup a database from a box other than the database box itself? Are there any advantages to this kind of configuration? For example: Box-A (production db server) Box-B (rman db server) A cron job runs on Box-B which backups up the database from Box-A. Thanks in advance! -w
RMAN - Remote vs Local Backups
Hi, Can anyone think of a reason(s) why one WOULD want to backup a database from a box other than the database box itself? Are there any advantages to this kind of configuration? For example: Box-A (production db server) Box-B (rman db server) A cron job runs on Box-B which backups up the database from Box-A. Thanks in advance! -w
