Well df/cf.. come from your scripts :
backup database ... format ..._df_.....
backup controlfile ... format ..._cf_....
Off course, nothing prevent a _CF_ to contain data and reverse.
Same as for your level. Change the format naming depending of
your rman script. (eg use 1 rman_full_bkp and 1 rman_diff_bkp)
Just naming ...
eg :
run {
configure default device type to sbt;
configure controlfile autobackup on;
configure device type sbt parallelism 1;
configure datafile backup copies for device type 'sbt_tape' to 1;
allocate channel t1 type 'SBT_TAPE';
allocate channel t2 type 'SBT_TAPE';
send 'NSR_ENV=(NSR_SERVER=localhost,
NSR_CLIENT=localhost,
NSR_DATA_VOLUME_POOL=AdvFileDevPool,
NSR_COMPRESSION=true,
NSR_SAVESET_BROWSE=month,
NSR_SAVESET_RETENTION=month)';
backup full filesperset 1 format 'localhost_%d_df_full_%u' database;
backup current controlfile format "localhost_%d_cf_%s_%p";
release channel t1;
release channel t2;
}
Same if you backup / and you call it /usr
(save -N /usr /), nothing prevents /usr nor / to contain
something different than / or /usr ;-)
Kind regards - Bien cordialement - Vriendelijke groeten,
Thierry FAIDHERBE
HP Services - Storage Division
Tru64 Unix and Legato Enterprise Backup Solutions Consultant
********* ********* HEWLETT - PACKARD
******* h ******* 1 Rue de l'aeronef/Luchtschipstraat
****** h ****** 1140 Bruxelles/Brussel/Brussels
***** hhhh pppp *****
***** h h p p ***** 100/102 Blv de la Woluwe/Woluwedal
***** h h pppp ***** 1200 Bruxelles/Brussel/Brussels
****** p ****** BELGIUM
******* p *******
********* ********* Phone : +32 (0)2 / 729.85.42
Mobile : +32 (0)498/ 94.60.85
Fax : +32 (0)2 / 729.88.30
I N V E N T Email/MSN : thierry.faidherbe(at)hp.com
Internet : http://www.hp.com/
Enterprise number 0402.220.594 - RPM/RPR Brussels
-----Original Message-----
From: Bhaskar Mylavarapu [mailto:Bhaskar.Mylavarapu AT noaa DOT gov]
Sent: lundi 7 mai 2007 19:29
To: EMC NetWorker discussion; Faidherbe, Thierry
Cc: George Sinclair
Subject: Re: [Networker] RMAN backups levels and Networker Media
database levels
We'd like to implement this, but one question is how does your rman
script know that it's backing
up the control file versus a data file versus the spfile, etc.? In other
words, what prevents the
save set that contains, say, the control file from getting named the
same as the ones that contain data
files?
I assume the '<type>' value is not a parameter that rman fill figure
out. We have to supply that by hard coding the rman
script, correct? If we do that, though, then every save set will have
the same type value.
Here's our current rman backup command for a cumulative level 0 (full).
How can we change this to do what yours does?
backup as backup set incremental level 0 cumulative database;
Can you show us a sample rman script that does this?
Thanks.
Bhaskar
Faidherbe, Thierry wrote:
> What I usually try to do, configuring a backup with RMAN,
> is to change default Oracle Rman streams names (format field
> in rman backup command).
>
> I usually set to
> backup ....
> format "<hostname>_%d_<level>_<type>_%s.%p" ...
>
> being :
> <hostname>, the dbase server,
> %d, the Oracle SID,
> <level>, the oracle rman backup from oracle (eg Full, Lvl1,....)
> <type>, df for datafile, cf for controlfile, ar for archive, sp for
> spfile ....
> %s.%p, increment number making the rman file unique.
>
> I also sometime add _<backupdate> in format because if you recreate
the
> db
> and open resetlog, you will get a new incarnation number of your DB
> and increment will reset to 0 (causing duplicate rman file in indexes)
>
> So, seeing DF+CF+SP, you can "group/retrieve" your rman backup cycles,
> seeing AR, you know it is oracle archivelogs.
> seeing level full/diff, you can better see dependency using name and
> not saveset level.
>
> Work like a charm.
>
> HTH,
>
> TH
>
>
> Kind regards - Bien cordialement - Vriendelijke groeten,
>
> Thierry FAIDHERBE
>
> HP Services - Storage Division
> Tru64 Unix and Legato Enterprise Backup Solutions Consultant
>
> ********* ********* HEWLETT - PACKARD
> ******* h ******* 1 Rue de l'aeronef/Luchtschipstraat
> ****** h ****** 1140 Bruxelles/Brussel/Brussels
> ***** hhhh pppp *****
> ***** h h p p ***** 100/102 Blv de la Woluwe/Woluwedal
> ***** h h pppp ***** 1200 Bruxelles/Brussel/Brussels
> ****** p ****** BELGIUM
> ******* p *******
> ********* ********* Phone : +32 (0)2 / 729.85.42
> Mobile : +32 (0)498/ 94.60.85
> Fax : +32 (0)2 / 729.88.30
> I N V E N T Email/MSN : thierry.faidherbe(at)hp.com
> Internet : http://www.hp.com/
> Enterprise number 0402.220.594 - RPM/RPR Brussels
>
> -----Original Message-----
> From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU]
On
> Behalf Of George Sinclair
> Sent: vendredi 4 mai 2007 16:40
> To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
> Subject: Re: [Networker] RMAN backups levels and Networker Media
> database levels
>
> We always see level fulls reported regardless of the level we run.
> However, the sizes are what we would expect
> for an incremental. The other thing we notice, though, is that
NetWorker
>
> only reports the rman script name
> as the save set name, so all the save sets have the same name. We're
> running Oracle 10g with NW 7.2.2 and
> NMO 4.2. Behavior could be different in later NW releases?
>
> We've tested recovering these incrementals by first restoring the
> previous full and then the desired incremental.
> We run one full (level 0) per week and a level 1 cumulative
incremental
> five days per week. One day is a skip.
> We use a one month policy on the Oracle side and a 5 week browse
policy
> on the NetWorker side.
>
> George
>
> Allan, Kevin wrote:
>
>> We are currently testing the use of incremental Oracle RMAN backups
>>
> but
>
>> we have noticed that the level recorded by Networker is always full.
>>
>> This causes us concern as the logic inside Networker for protecting
>> incremental backups to ensure your browse and retention polices are
>> meant will not work.
>>
>> Test Scenario:
>>
>> In our test configuration we setup one full followed by six
>>
> incremental
>
>> backups per week, with a 14 day browse/retention. we ran the first
>>
> week
>
>> of backups okay and the intentionally broke the next full and ran the
>> other six incremental without a problem.
>>
>>
>> We therefore had a scenario where we had 12 incremental backups
>>
> reliant
>
>> on a single full (RMAN view), but in Networker there were no recorded
>> dependences as all savesets were marked as FULL. Once ran the next
>>
> full
>
>> week of the cycle we therefore lost the first full, as it had expired
>> but this also meant all twelve incremental backups were left useless.
>> The end result being we only had a recovery window of one week.
>>
>> Day of Week S M T W T F S S M T W T F S S M T W
>> T F S
>>
>> Networker Level F F F F F F F X F F F F F F F F F F
>>
> F F F
>
>> X=Failure
>>
>> RMAN Level 0 1 1 1 1 1 1 X 1 1 1 1 1 1 0 1 1 1
>> 1 1 1
>> X=Failure
>>
>> We are running Networker 7.2.2, Oracle 10.2.0 and NMO 4.2 on a
Solaris
>>
> 9
>
>> server.
>>
>> I would appreciate your comments/views.
>>
>> We have looked at using the NSR_RETENTION_DISABLED=TRUE, this would
>>
> move
>
>> the media management control to the RMAN Catalog and may have it's
own
>> headache.
>>
>> Regards
>> Kevin
>>
>> 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
|
