Re: [Networker] How to make unique save set names for Oracle backups?
2007-05-07 16:30:41
You'll need to provide the rman script and version you're using to give a
correct answer to you specific case but as far as rman goes it can and
will give a unique name to each backupset. You can see it in Legato as
in this rman script example where it formats the backupset. Puts 2
files per backupset and then names the backupset using the oracle provided
format string. Ask whoever put the rman backup together to show you the
script. Shouldn't be a secret.
replace script level0 {
execute script alloc_tapes;
# we don't want any problems with the system
# tablespace to go unnoticed.
resync catalog;
set command id to 'rman';
set maxcorrupt for datafile 1 to 0;
backup
incremental level 0 cumulative
tag backup_db_level_0
# The skip inaccessible clause ensures the backup will continue
# if any of the datafiles are inaccessible.
filesperset 2
format '/%d_%t_%s_%p.dbf'
which translates into
/TR2_621872449_3097_1.dbf
which is the sid and a timestamp in the name that you can easily see
browsing the tape.
Darren Dunham <ddunham AT TAOS DOT COM>
Sent by: EMC NetWorker discussion <NETWORKER AT LISTSERV.TEMPLE DOT EDU>
05/07/2007 03:01 PM
Please respond to
EMC NetWorker discussion <NETWORKER AT LISTSERV.TEMPLE DOT EDU>; Please respond
to
Darren Dunham <ddunham AT TAOS DOT COM>
To
NETWORKER AT LISTSERV.TEMPLE DOT EDU
cc
Subject
Re: [Networker] How to make unique save set names for Oracle backups?
> Is is possible to create unique save set names with Oracle backups using
> NMO and RMAN?
I don't have an oracle client installation to examine right now. Does
the oracle script (or one of its children) call or reference the NSR
binary? The normal backup program (save) can take an option to override
the save set name. I don't know if the same technique is available to
the oracle client.
--
Darren Dunham ddunham AT taos DOT com
Senior Technical Consultant TAOS http://www.taos.com/
Got some Dr Pepper? San Francisco, CA bay area
< This line left intentionally blank to confuse you. >
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
|
|
|