Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: rman duplex

RE: rman duplex

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Wed, 9 Feb 2005 16:16:56 -0500
Message-ID: <004501c50eec$af83d350$8459000a@vttaxnet.tax.state.vt.us>


The Oracle user has permissions to use the backup facility on the OS and I have the combination to the computer room so I can put in my tapes.

We do have to restore the tape to disk for a restore/recovery application but it doesn't happen all that often. I work for the State and money is the driving consideration, hence we do it this way.

Ruth

-----Original Message-----
From: delysid_at_amber.monochrome.net
[mailto:delysid_at_amber.monochrome.net]On Behalf Of David Sent: Wednesday, February 09, 2005 4:10 PM To: Ruth Gramolini
Cc: oracle-l_at_freelists.org
Subject: RE: rman duplex

I would hope backing up via rman to disk would be faster than going to tape. ;)

Have you tried the duplex option at all? I'm wondering if the overall speed to complete is gated by the slowest device or if the operations are independant in that regard.

If you use OS commands to go to tape, then you have to involve the SA's, no...where as if you used rman to go to disk and tape, then they would not be needed. Recovery would just specifiy which device to restore from?

For restoring from recent time(time that backupset is on disk), we would restore from disk...otherwise tape.

Also, if you use non rman commands to copy to tape, then you have to have the files restored from tape to disk and then use rman to restore/recdoiver from disk to disk...versus tape to actual db location on disk.

We also need to plan for conurrent recoveries - worst case.

--
..
David


> I do rman backups to disk and copy them to tape using the OS backup
> facility
> (sysback on AIX). rman backup to disk is much faster than rman backup to
> tape. The copy to tape can be done in the background while users are on
> with little impact on database performance.
>
> HTH,
> Ruth.
-- http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 09 2005 - 16:19:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US