Re: backup to tape when using ASM
Date: Fri, 24 Oct 2014 18:30:15 +0000
Message-ID: <966049154.407744.1414175415351.JavaMail.yahoo_at_jws106129.mail.bf1.yahoo.com>
I've decided to duplex with rman.Works beautifully when I do it thru a unix/rman script. However, when I run the backups thru Enterprise Manager (using dbconsole) it fails
I'm writing to two destinations, one copy to ASM, and the other to local disk that only exists on one node.
It seems the backups fail because I am running the backups as "cluster database" rather than "instance" backups. If I run as an instance backup, I can specify which instance/node to run on, and therefore I specify the one with the extra disk for the second channel/copy.
But.. what's the difference between an instance and a cluster database backup? Does an instance backup only include redo from that instance? and if my archivelogs are stored in ASM, will it make a difference?
Is there a better way to do this thru OEM?
Thanks in advance!-ck
On Tuesday, October 21, 2014 2:15 PM, Chris King <ckaj111_at_yahoo.ca> wrote:
Appreciate the feedback! Thanks!
On Tuesday, October 21, 2014 2:07 PM, "Ruel, Chris" <Chris.Ruel_at_lfg.com> wrote:
#yiv3782414305 -- filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv3782414305 filtered {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}#yiv3782414305 p.yiv3782414305MsoNormal, #yiv3782414305 li.yiv3782414305MsoNormal, #yiv3782414305 div.yiv3782414305MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv3782414305 a:link, #yiv3782414305 span.yiv3782414305MsoHyperlink {color:blue;text-decoration:underline;}#yiv3782414305 a:visited, #yiv3782414305 span.yiv3782414305MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv3782414305 span.yiv3782414305EmailStyle17 {color:#1F497D;}#yiv3782414305 .yiv3782414305MsoChpDefault {font-size:10.0pt;}#yiv3782414305 filtered {margin:1.0in 1.0in 1.0in 1.0in;}#yiv3782414305 div.yiv3782414305WordSection1 {}#yiv3782414305 If you go this route, make sure your tape software supports backup and restore to ACFS. For instance, Tivoli does not list it as a supported file system for backups to tape. I ran into this problem with Netbackup a few years as well (not sure what version). Anyway, nowadays, maybe there are fewer problems but just thought it worth mentioning. Chris.. _____________________________________________________________________ Chris Ruel * Oracle Database Administrator * Lincoln Financial Group cruel_at_lfg.com * Desk:317.759.2172 * Cell 317.523.8482 From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Freek D'Hooge
Sent: Tuesday, October 21, 2014 3:28 AM
To: ckaj111_at_yahoo.ca
Cc: Don Seiler; oracle-l_at_freelists.org; sethmiller.sm_at_gmail.com Subject: Re: backup to tape when using ASM You could write the backups to local disk if you want or to NFS if you want a clustered filesystem. But if you want to make use of your asm disks, you could create an ACFS filesystem and use that as a backup location. That would allow you to make use of your asm disks and to backup to backupsets to tape using normal filesystem backups without having to copy them first.
Kind regards,
Freek D'Hooge
On ma, 2014-10-20 at 13:44 -0500, Seth Miller wrote: Chris,
I'm assuming you were not previously using RMAN to write the backup files to tape. You were most likely using a third party backup tool to pull the files off disk and write them to tape (very common). This is still possible but as Don mentioned, you first have to get a copy of the files from ASM to a file system.
The most efficient way is to do this is to duplex your backups; one copy going to your ASM disk group and the other to your clustered file system. The biggest advantage to doing it this way is that RMAN is now aware of both copies of the backup and can manage the retention for both sets of files so you don't have to manually manage the second set of files.
If duplexing is not what you are looking for, you can use RMAN to make a copy of the backup files from ASM to disk after the initial backup or use a database job to copy the files with DBMS_FILE_TRANSFER. Another option is to use asmcmd to copy the files.
Seth Miller
On Mon, Oct 20, 2014 at 1:25 PM, Don Seiler <don_at_seiler.us> wrote:
You could still write the first backups into an ASM diskgroup and then later run an RMAN job to backup/copy that backup to a tape device (assuming you have the MML configured properly) or some other filesystem disk that would later be pushed to tape.
Don.
On Mon, Oct 20, 2014 at 1:16 PM, Chris King <ckaj111_at_yahoo.ca> wrote:
Quick question I think.. For standalone databases, I've been writing rman backups to disk and then backing up the rman backup files to tape. Now we're using RAC and the backups are written to ASM disk. Is there an easy way to copy those backups written to ASM to tape? Or will I need to run the oracle rman backups directly to tape with netbackup?
Thanks in advance all!
-- Don Seiler http://www.seiler.us Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.** -- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 24 2014 - 20:30:15 CEST