Networker

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

2008-08-13 15:00:12
Subject: Re: [Networker] Oracle 10g ASM backup in NetWorker
From: Matthew Huff <mhuff AT OX DOT COM>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Wed, 13 Aug 2008 14:56:46 -0400
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

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