Networker

Re: [Networker] Oracle 10g ASM backup in NetWorker

2008-08-13 15:23:14
Subject: Re: [Networker] Oracle 10g ASM backup in NetWorker
From: Bruce Breidall <Bruce.Breidall AT CONCUR DOT COM>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Wed, 13 Aug 2008 12:17:49 -0700
About your only other option is to incorporate storage nodes into your
environment. That would depend on the amount of data. If you have an
oracle server with 500GB or more of data to backup, then it would make
sense to make that oracle server also a NW storage node to get the LAN
free backups.

I am a huge advocate of ASM. From a storage perspective, it is
completely controlled by the DBAs and requires no storage management. I
think the unix admins like it for the same reasons.

-----Original Message-----
From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU] On
Behalf Of Matthew Huff
Sent: Wednesday, August 13, 2008 1:57 PM
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Subject: Re: [Networker] Oracle 10g ASM backup in NetWorker

Powersnap uses the OS file system for creating snapshots. Since ASM is
actually a live database, the snapshot cannot make it consistent. I'm
not a big fan of ASM.

The NMO module should be able to have reasonable performance. How big is
your database and network connections. You can setup multiple streams in
NMO to greatly increase performance. For example:

run {
        set command id to 'HIST';

        allocate channel t1 type 'SBT_TAPE' parms
'ENV=(NSR_DATA_VOLUME_POOL=OTAFull)';
        allocate channel t2 type 'SBT_TAPE' parms
'ENV=(NSR_DATA_VOLUME_POOL=OTAFull)';
        allocate channel t3 type 'SBT_TAPE' parms
'ENV=(NSR_DATA_VOLUME_POOL=OTAFull)';
        allocate channel t3 type 'SBT_TAPE' parms
'ENV=(NSR_DATA_VOLUME_POOL=OTAFull)';

        backup database filesperset  4 force format='/%d_DATA_%U/'
        plus archivelog filesperset 16 force format='/%d_ARCH_%U/'
        delete all input;

        release channel t1;
        release channel t2;
        release channel t3;
        release channel t4;
        }

This will get you 4 streams.

On 8/13/08 6:07 AM, "anandhg" <networker-forum AT BACKUPCENTRAL DOT COM> wrote:

Recently we have mograted most of our Oracle database running in 9i to
10g with ASM. But Networker's powersnap module does not support Oracle
ASM. If you are having 10g ASM databases how are you backing up the
database. We are taking it using NMO module over LAN, but is there any
better way we can improve this.

+----------------------------------------------------------------------
|This was sent by anandhg AT gmail DOT com via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------

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 with 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=NETWORKER

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 with 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

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 with 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

<Prev in Thread] Current Thread [Next in Thread>