Networker

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

2007-05-08 01:24:02
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:24:21 +0200
Davina Treiber schrieb:
George Sinclair wrote:
Hi,

Is is possible to create unique save set names with Oracle backups using
NMO and RMAN?

Our save set names are always the name of the rman script itself. For
example, when we run our level 1
backups, mminfo reports something like this:

vol001 client 05/07/07 257 KB full RMAN:/oracle/rman/level1_test.rcv vol001 client 05/07/07 9473 KB full RMAN:/oracle/rman/level1_test.rcv vol001 client 05/07/07 2561 KB full RMAN:/oracle/rman/level1_test.rcv vol001 client 05/07/07 83 MB full RMAN:/oracle/rman/level1_test.rcv vol001 client 05/07/07 8705 KB full RMAN:/oracle/rman/level1_test.rcv vol001 client 05/07/07 257 KB full RMAN:/oracle/rman/level1_test.rcv
vol001    client    05/07/07 290 KB       9  index:client

How do we change it so the save set names are unique?

You need to use the format command within the RMAN script.
Our RMAN scripts has the format string as well. But the
save set names are named like the rman script anyway:

yellow-eyed:~ # mminfo -a -v -r 'ssid,name,volume' | more
 ssid      name                           volume
3524087915 ASR:\                          AXM340L1
3624751195 C:\                            AXM340L1
3339538558 D:\                            AXM340L1
3238875286 E:\                            AXM340L1
3960295478 SYSTEM DB:\                    AXM340L1
4111290418 SYSTEM STATE:\                 AXM340L1
3389870202 ASR:\                          AXM340L1
3188543653 C:\                            AXM340L1
3842854971 SYSTEM DB:\                    AXM340L1
4027404341 SYSTEM STATE:\                 AXM340L1
3423424629 ASR:\                          AXM340L1
3373092986 C:\                            AXM340L1
3708637272 SYSTEM DB:\                    AXM340L1
4178399281 SYSTEM STATE:\                 AXM340L1
51204144   /                              AXM340L1
135090222  /boot                          AXM340L1
1745674415 /u01/sicherung/scripte/rman_evn10g_arch.scr AXM340L1
722265146  /u01/sicherung/scripte/rman_evn10g_arch.scr AXM340L1
705487941  /u01/sicherung/scripte/rman_evn10g_arch.scr AXM340L1
[...]
2014109632 /u01/sicherung/scripte/rman_arch920_arch.scr AXM340L1
1930223568 /u01/sicherung/scripte/rman_arch920_arch.scr AXM340L1
1896669141 /u01/sicherung/scripte/rman_arch920_arch.scr AXM340L1
1528292205 /u01/sicherung/scripte/rman_arch920_full.scr AXM340L1
1310188841 /u01/sicherung/scripte/rman_arch920_full.scr AXM340L1
924313485  /u01/sicherung/scripte/rman_arch920_full.scr AXM340L1
538438250  /u01/sicherung/scripte/rman_arch920_full.scr AXM340L1
270003190  /u01/sicherung/scripte/rman_arch920_full.scr AXM340L1
169340148  /u01/sicherung/scripte/rman_arch920_full.scr AXM340L1
85454374   /u01/sicherung/scripte/rman_arch920_full.scr AXM340L1
4246204207 /u01/sicherung/scripte/rman_arch920_full.scr AXM340L1
3927437369 /u01/sicherung/scripte/rman_arch920_full.scr AXM340L1


But why do you want to change the save set names? You dont restore
them yourself. RMAN requests them from the networker server in
case of restore/recovery.

--
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