Networker

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

2007-05-07 16:30:41
Subject: Re: [Networker] How to make unique save set names for Oracle backups?
From: Doug Brown <Doug.Brown AT ABBOTT DOT COM>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Mon, 7 May 2007 15:28:51 -0500
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