Re: [Networker] Oracle 10g ASM backup in NetWorker
2008-08-13 15:00:12
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
|
|
|