Networker

Re: [Networker] How to make unique save set names for Oracle backups?

2007-05-08 01:21:17
Subject: Re: [Networker] How to make unique save set names for Oracle backups?
From: Ronny Egner <Ronny.Egner AT SIV DOT DE>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Tue, 8 May 2007 07:20:38 +0200
run {
set command id to 'something.offline';
#
allocate channel t1 type 'SBT_TAPE'
parms
'ENV=(NSR_SERVER=myserver,NSR_DATA_VOLUME_POOL=7day,NSR_SAVESET_EXPIRATION=7
days)';
allocate channel t2 type 'SBT_TAPE'
parms
'ENV=(NSR_SERVER=myserver,NSR_DATA_VOLUME_POOL=7day,NSR_SAVESET_EXPIRATION=7
days)';
#
backup
  filesperset 4
  skip inaccessible
  tag 'something.offline'
  format 'something.offline_%n.%u'
  (database);
#
release channel t1;
release channel t2;
}

Just an addition:

"skip inaccessible" is absolutely dangerous! With this option set
rman skips datafils which are currently offline (by corruption or
whatever). If this datafile is longer online and you dont have the
archivelogs from where the datafile was put offline you *cannot*
put it back online again - the data is LOST!

So: Only use "skip inaccessible" if you know what
you´re doing!!

--
Mit freundlichen Grüßen

Ronny Egner
Diplom-Ingenieur (BA)
Systeme & Service
Oracle DBA

Telefon: +49 381 2524-422
Telefax: +49 381 2524-399


mailto:ronny.egner AT siv DOT de
http://www.siv.de

SIV.AG - Service für Informationsverarbeitung AG
Hauptsitz: Konrad-Zuse-Str. 1, 18184 Roggentin
Handelsregister: Amtsgericht Rostock, HRB 8677, Ust.-IdNr.: DE 137477226
Vorstand: Jörg Sinnig (Vorsitzender), Andreas Lehmann, Arno Weichbrodt
Aufsichtsratsvorsitzender: Peter Gronemeier
***************************************************************************************
Aus Rechtsgründen ist die in dieser E-Mail gegebene Information nicht
rechtsverbindlich. Eine rechtsverbindliche Bestätigung reichen wir Ihnen auf Anforderung in schriftlicher Form nach. Diese Nachricht ist ausschließlich für den
bezeichneten Adressaten oder dessen Vertreter bestimmt.

The information contained in this email is not legally binding. At your request, we will provide you with a legally binding confirmation in written form. This
message is intended solely for the addressee, entity to which the email
is addressed or the authorised agent.
***************************************************************************************

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