Networker

Re: [Networker] [Oracle backup]

2009-04-17 07:57:01
Subject: Re: [Networker] [Oracle backup]
From: Matthew Huff <mhuff AT OX DOT COM>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Fri, 17 Apr 2009 07:47:49 -0400
Did you do the steps in the install guide to link the networker shared library 
into the oracle tree? If you did, you still need to bounce any oracle instance 
before you can back it up. The oracle process has to have the shared library 
loaded for it to connect to the tape.


On 4/17/09 3:52 AM, "Batjargal.R" <batjargal AT MOBICOM DOT MN> wrote:

Dear Networkers,



I'm using Networker 7.4 SP1 with Windows 2003 clustering server, disk
storage. I can't backup oracle database from Linux client server (RH AS4).

On this client installed Networker client.



My RMAN script is:

connect target sys/oracle@batja

run {

  allocate channel ch1 type 'SBT_TAPE';



  backup

    format '%d_%U'

    tag bak

    (tablespace 'BATJATB'

      ,'SYSAUX'

      ,'SYSTEM'

      ,'UNDOTBS1'

      ,'USERS'

    include current controlfile);



  backup

    archivelog all;



  release channel ch1;

}





NetWorker server backup error:

savegrp: suppressed 2 lines of verbose output

RMAN-00571: ===========================================================

RMAN-03009: failure of allocate command on ch1 channel at 04/17/2009
16:27:13

ORA-19554: error allocating device, device type: SBT_TAPE, device name:

ORA-27211: Failed to load Media Management Library



Recovery Manager complete.



RMAN script execution is not successful. RMAN exited with return code '1'.

nsrnmostart returned status of 254

/usr/sbin/nsrnmo4 exiting.



My RMAN configuration parameters are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
'/test/backup/%F';

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/test/backup/%U';

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO
'/test/app/oracle/10gR2/dbs/snapcf_batja.f'; # default





How to resolve this problems.



BR,



Batja


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>