Re: db backup on tape and archive log backup on disk
Date: Wed, 19 Feb 2014 09:17:13 -0600
Message-ID: <CAKoJ+qA8J6X-Bt=smyLUn1ZECTi2C_kGOwHx7Cp+vHkg5=0y3w_at_mail.gmail.com>
my appoligies for not being clear enough. What i mean with regards to the "MV" command is that. lately we have had some issues where the symantic pure disk appliance been crashing and we do not have any place to back it up...while the SA try to figure out what is wrong we the DBA have to move our archive logs to a secondary destination using MV command(and then catalog it for RMAN to pick it up)...
I have followed the oracle note with regards to setting up the NFS and also had open ticket with oracle and after the trace they told us its not oracle and we will have to work with the vendor to figure out why the write is slow....
obviously with netbackup in place, that is a additional software layer in place and its pushing data out really fast(compared to NFS)...
we like the idea of physcially going to the NFS directory and see all our files compared to netbackup(SBT) were we cannot see those files....
On Wed, Feb 19, 2014 at 2:47 AM, Chitale, Hemant K <Hemant-K.Chitale_at_sc.com>wrote:
> > As its a simple mv cmd from archive log directory to NFS directory(but
> when netbackup in place we cannot do that)
>
> That is NOT an archivelog **backup**. That is still an archivelog.
>
>
>
> Your question is "i have my archive log backup to go disk/NFS" which is
> addressed by using RMAN to make backupsets of the archivelogs.
>
> If you are moving archivelogs to NFS, you are not making backups of them.
> For each archivelog you still have only the 1 copy (that is now on NFS
> instead of local disk).
>
>
>
> Shouldn't you be backing up your archivelogs as well - to either Symantec
> pure disk appliance or via NetBackup ?
>
>
>
>
>
> As for the NFS performance, how is the transfer done ? Does Symantec pure
> disk appliance mean that there is some other software sitting between RMAN
> and the NFS mount point ? Is that adding overheads ? Are the NFS mount
> parameters a performance issue (Oracle Support has a couple of notes on NFS
> mount parameters and performance for RMAN writes to NFS) ?
>
>
>
>
>
>
>
>
>
> Hemant K Chitale
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *max scalf
> *Sent:* Wednesday, February 19, 2014 3:39 AM
> *To:* oracle-l_at_freelists.org
> *Subject:* db backup on tape and archive log backup on disk
>
>
>
> Hello List,
>
>
>
> I just wanted to get some ideas on a problem we have and a solution that
> we might put in place and see what the community think about it. RMAN
> backup with multiple versions/multiple OS
>
>
>
> We backup our DB to symatic pure disk appliance. This goes over NFS and
> lately we been seeing some performance issue on backup. Especially our big
> DB backup time they been increasing as more and more system backup are
> being added to this pure disk appliance(but its not pure disk fault). So
> we tried another option that was to do our Backup, but using the netbackup
> tape library simulation(at the end of the day it writes to the pure disk
> appliance but goes though netbackup media server). The backup times are
> very different. For a 1TB backup going through NFS is taking about 5hours,
> while backup going through Netbackup is taking less than an hour. Big
> difference. Sad part is we have 10Gig cards install on these server. So
> seems like NFS is not able to push out that much data to the symantic pure
> disk appliance while the netbackup media server is able to push out
> data(and push it out fast).
>
>
>
> so we are going to move our backup to go though netbackup. My question
> is, can i have my archive log backup to go disk/NFS(were i can see them)
> and have my database backup go to NBU(i cannot see these as its not a
> NFS)...if so what are some of the pros/cons of this type of setup..the
> reason why we want to do this is because we have space constraints on where
> our archive logs are setup and we have to be constantly be moving archive
> log around and using that NFS helps big time. As its a simple mv cmd from
> archive log directory to NFS directory(but when netbackup in place we
> cannot do that)
>
>
>
> That is why i wanted to ask the community on what are some pros/cons on
> this. Once thing i can think of is, when doing restore/recovery that might
> be harder(as now my DB backup is coming from SBT_TAPE per say and archive
> logs are comming from DISK).
>
>
>
> P.S.
>
> I have tried DNFS as well, but we got maybe 10% improvement but nothing
> like going through netbackup.
>
> This email and any attachments are confidential and may also be
> privileged. If you are not the intended recipient, please delete all copies
> and notify the sender immediately. You may wish to refer to the
> incorporation details of Standard Chartered PLC, Standard Chartered Bank
> and their subsidiaries at https://www.sc.com/en/incorporation-details.html
> .
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 19 2014 - 16:17:13 CET