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
|