The reason most people do a "cold backup" is that they don't want to
spend the money on the Legato Networker Module for Oracle (NMO). Since
you already have, why not do a regular RMAN backup? Using archive logs
is a very good thing(tm). I've had Oracle support over the years tell me
they consider a database not using archive logs a "non-production"
database.
There is always the fear that the archive logs will fill up, and the
database will halt, but there are a couple of solutions. The simpliest
is just to buy enough disk space to hold a lot of archive logs (it
doesn't need to be high performance disks). Otherwise just have
something monitor the disk usage and if it reaches a threshold you can
even have a script delete all the archive logs and resync the rman
catalog, you'd be no worse off if they are deleted then the cold backup
you have now.
----
Matthew Huff | One Manhattanville Rd
Dir of Operations | Purchase, NY 10577
OTA LLC | Phone: 914-460-4039
www.otaotr.com | Fax: 914-460-4139
-----Original Message-----
From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU] On
Behalf Of Vince Howard
Sent: Tuesday, April 24, 2007 11:20 AM
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
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
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
|
