This is how we do it .

1. We set up a networker klient (as per usual, se manage clients)  where the 
saveset is: path/rmanscript.rcv

2. I belive you have to write one script for each database to recover.

3. You don't inc backup databases in my opinion (well maybe you do but then you 
will have far more work when doing restores).
Use Oracle archive logging.
Make two rman scripts, one for archive logging (set interval as needed) and one 
for full db backup.
Rman can handle the situation if they happen to run at the same time (ie it's 
not a problem).

4. You write an rman script, after allocate channel you'll have: 
set until time "to_date (se man for exact syntax)
Rman will handle use both full backups and archive log backups to get to the 
specified time.
If you do a restore the rman catalog will be reset.
If you want to restore for testing to another server, use duplicate.

5. It's entirely up to you. 
But you will need to backup the backupserver RMAN database once in awhile. To 
do this you generally shut it down and take a cold backup.

/regards
Anders Wickström



________________________________

Från: EMC NetWorker discussion genom George Sinclair
Skickat: ti 2006-10-17 01:23
Till: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Ämne: [Networker] Some questions on Oracle backups using RMAN?



Hi,

1. How does NetWorker's schedule work with RMAN or does it?

2. Do you have to write a separate script for each part of the database
you want to recover?

3. Can you do a traditional incremental like NetWorker does with regular
data backups?

4. How do you recover from a particular NetWorker backup or point in time?

5. Does it matter that the bootstrap is not automatically backed up
during an Oracle backup?

I know very little about Oracle, but working with our DBA , and we're
trying to test backing up/recovering an Oracle 10g test database using
NetWorker 7.2.2 on Unix. We're using RMAN. So far, we've been  able to
run backups using two RMAN scripts (see below), but it seems that it
always reports a level full for the saveset (RMAN:/script name)
regardless of the level specified, and it's unclear how the schedule on
the NetWorker side affects this, or if it's moot since the level is
specified in the RMAN script, anyway? Also, it appears that Oracle only
allows backup levels 0-4, so am I correct in thinking that to run the
equivalent of a traditional Legato incremental we would need to run the
same level again, like a level 4 and then another level 4 or a level 3
and then another 3 or something like that?

Another thing I was reading in the documentation is that the server's
bootstrap is supposed to get backed up following a scheduled Oracle
backup, but I've not seen that happen. The group runs with no
errors and completes, but no bootstrap ever gets saved. I even tried a
scheduled backup (no manual start). Ditto. I don't see why the server's
bootstrap should need to get backed up just because an
Oracle backup ran, though. If the server's group runs later anyway,
you're still going to get a bootstrap backup, right?

Finally, I'm unclear on how exactly you recover the darn data, and how
to tell NetWorker that you want it from a certain time or date?

We have a custom pool (oracle) and two NSR client resources, each
specifies one of the two different RMAN scripts below so we can have
fulls or incrementals. Each client is in a different group, and both 
groups are members of the pool. I've read through so much NetWorker
Oracle documentation my head is spinning [sigh].

Any help would be much appreciated.

George

<<< script to run incrementals >>

connect line goes here

run {
   allocate channel t1 type 'SBT_TAPE';

   backup incremental level 4
   format 'INCR_%d_%U'
   (database);

   release channel t1;

}


<<< script to handle level fulls >>>

connect line goes here

run {
   allocate channel t1 type 'SBT_TAPE';

   backup full filesperset 4
   format 'FULL_%d_%U'
   (database);

   release channel t1;

}

--
George Sinclair - NOAA/NESDIS/National Oceanographic Data Center
SSMC3 4th Floor Rm 4145       | Voice: (301) 713-3284 x210
1315 East West Highway        | Fax:   (301) 713-3301
Silver Spring, MD 20910-3282  | Web Site:  http://www.nodc.noaa.gov/
- Any opinions expressed in this message are NOT those of the US Govt. -

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