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
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
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
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
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
Hi,
Can anyone think of a reason(s) why oneWOULD 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 upthe
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 oneWOULD want to backup a
database from a box other than the database box itself? Are there any
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
-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
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
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
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
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
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
]
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
-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
16 matches
Mail list logo
