Although, I am no rman expert, I can speak to this. We use to do our
Oracle backups with the method you suggest (writing a file to disk and
backing that up). It took 3 hours to create the file (29GB) and another
10 minutes to back it up.
Using the NMO module, we are able to backup the database using rman
scripts in 20 minutes and a restore is only slightly slower. If time is
a problem, and it usually is, I would use the NMO module.
I believe rman can write to tape directly, because the NMO module
basically reads messages from rman. Rman does all of the real work.
But, I cannot tell you how to do that.
R. Scott McKnight
-----Original Message-----
From: Legato NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU]
On Behalf Of IT-Administration ST
Sent: Wednesday, April 05, 2006 5:36 AM
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Subject: [Networker] Backup of Oracle using rman - interface to
Networker / interface for tape devices ?
Hello dear fellow networkers,
at the moment we backup our oracle databases, located on Solaris
machines, with a special module called "nsrora", which is supplied by
FSC. This module saves the whole amount of space which is reserved, so
if the DB is 150 GB, it saves 150 GB, even if the amount of the real
data in the tablespaces is just 2 GB.
We would like to use rman instead of nsrora. Is is true that for using
rman together with networker we would need another module called "nmo" ?
At the moment we consider to get rman writing backups to a file in the
filesystem and then save that file with networker. A restore would imply
recovering that file to the filesystem and then restore parts of the
oracle database or the full database with rman.
What is the benefit of the nmo?
Is there a way to get rman writing directly to tape without the nmo?
Roman
To sign off this list, send email to listserv AT listserv.temple DOT edu and
type "signoff networker" in the
body of the email. Please write to networker-request AT listserv.temple DOT edu
if you have any problems
wit this list. You can access the archives at
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER
--------------------------------------------------------
Princeton Retirement Group, Inc - Important Terms
This E-mail is not intended for distribution to, or use by, any person or
entity in any location where such distribution or use would be contrary to law
or regulation, or which would subject Princeton Retirement Group, Inc. or any
affiliate to any registration requirement within such location.
This E-mail may contain privileged or confidential information or may otherwise
be protected by work product immunity or other legal rules. No confidentiality
or privilege is waived or lost by any mistransmission. Access, copying or
re-use of information by non-intended or non-authorized recipients is
prohibited. If you are not an intended recipient of this E-mail, please notify
the sender, delete it and do not read, act upon, print, disclose, copy, retain
or redistribute any portion of this E-mail.
The transmission and content of this E-mail cannot be guaranteed to be secure
or error-free. Therefore, we cannot represent that the information in this
E-mail is complete, accurate, uncorrupted, timely or free of viruses, and
Princeton Retirement Group, Inc. cannot accept any liability for E-mails that
have been altered in the course of delivery. Princeton Retirement Group, Inc.
reserves the right to monitor, review and retain all electronic communications,
including E-mail, traveling through its networks and systems (subject to and in
accordance with local laws). If any of your details are incorrect or if you no
longer wish to receive mailings such as this by E-mail please contact the
sender by reply E-mail.
--------------------------------------------------------
To sign off this list, send email to listserv AT listserv.temple DOT edu and
type "signoff networker" in the
body of the email. Please write to networker-request AT listserv.temple DOT edu
if you have any problems
wit this list. You can access the archives at
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER
|