Re: [Networker] RMAN backup newbie
2007-04-24 12:17:25
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
|
|
|