Networker

Re: [Networker] RMAN backup newbie

2007-04-24 12:17:25
Subject: Re: [Networker] RMAN backup newbie
From: Doug Brown <Doug.Brown AT ABBOTT DOT COM>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Tue, 24 Apr 2007 11:12:32 -0500

Just a guess but I'm thinking you lose the allocation once you do all those shutdowns and startups.   Try doing those first, then allocate the channel right before doing the backup.



Vince Howard <V.Howard AT WANSBECK.GOV DOT UK>
Sent by: EMC NetWorker discussion <NETWORKER AT LISTSERV.TEMPLE DOT EDU>

04/24/2007 10:20 AM
Please respond to
EMC NetWorker discussion <NETWORKER AT LISTSERV.TEMPLE DOT EDU>; Please respond to
Vince Howard <V.Howard AT WANSBECK.GOV DOT UK>

To
NETWORKER AT LISTSERV.TEMPLE DOT EDU
cc
Subject
[Networker] RMAN backup newbie





Hi Gurus,

I'm a complete newbie to Oracle backups in NetWorker so I'm turning to
you guys in the hope you'll be able to help me out.  I can't find
anything specifically to do with this in the NetWorker archives.

I've set up a NetWorker client to back up an Oracle host - NW
server/client 7.2.1 build 311 and NMO 4.2.  RMAN is producing 6GBs of
backup file, but when the script tries to close the channel it was using
I get the following and the backup group fails:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of release command at 04/24/2007 15:48:30
RMAN-06012: channel: t1 not allocated

RMAN script is for a consistent database backup, as follows (no archive
logs, no catalog):

connect target target_user/target_passwd@target_Netservicename

run {
   set command id to 'RBTRAIN1';

   allocate channel t1 type 'SBT_TAPE';

   shutdown immediate;

   startup force dba;
   shutdown immediate;

   startup mount;

   backup
       format 'FULL_%d_%U'
    (database include current controlfile);

   release channel t1;

   alter database open;
}

Can anyone point out where I'm going wrong or, ideally, be kind enough
to supply sample scripts for full and incremental backups for me to
build from?




Best Regards,



Vince




Vince Howard

Programmer/UNIX System Administrator

IT Section

Wansbeck District Council

Front Street West

Bedlington

Northumberland

NE22 5TU

UK



Tel (DDI): +44 (0)1670 843472

Fax:       +44 (0)1670 843484

e-mail:    v.howard AT wansbeck.gov DOT uk
Web:       www.wansbeck.gov.uk <http://www.wansbeck.gov.uk/>
<mailto:v.howard AT wansbeck.gov DOT ukP>


P  Please consider the environment before printing this email. Thank
you.
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

This e-mail and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom
they are addressed.  If you have received this e-mail in error please
notify the originator of the message.

Any views expressed in this message are those of the individual
sender, except where the sender specifies and with authority,
states them to be the views of Wansbeck District Council.

This footer also confirms that this e-mail message has been scanned
for the presence of computer viruses.

Wansbeck District Council Web Site is: www.wansbeck.gov.uk


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>