Re: [Networker] Some questions on Oracle backups using RMAN?

See below



George Sinclair <George.Sinclair AT NOAA DOT GOV> 
Sent by: EMC NetWorker discussion <NETWORKER AT LISTSERV.TEMPLE DOT EDU>
10/16/2006 06:23 PM
Please respond to
EMC NetWorker discussion <NETWORKER AT LISTSERV.TEMPLE DOT EDU>; Please respond 
to
George Sinclair <George.Sinclair AT NOAA DOT GOV>


To
NETWORKER AT LISTSERV.TEMPLE DOT EDU
cc

Subject
[Networker] Some questions on Oracle backups using RMAN?






Hi,

1. How does NetWorker's schedule work with RMAN or does it?   We use 
autosys.   Can use any scheduler.

2. Do you have to write a separate script for each part of the database 
you want to recover?   Depends on what kind of recovery is needed.   RMAN 
will do tablespace, full, partial if done to an auxiallary database, many 
to choose from.  The DBA should be responsible for this and know how to do 
it.  If not get a new DBA.

3. Can you do a traditional incremental like NetWorker does with regular 
data backups?  Absolutely.   In 10G you can get granular down to the block 
level.

4. How do you recover from a particular NetWorker backup or point in time? 
  A database would not base its recovery on Networker.  The recovery would 
be based upon the database SCN.

5. Does it matter that the bootstrap is not automatically backed up 
during an Oracle backup?   Not sure on this one.  I know we have problems 
if the "indexes" aren't in sync when we do a Disaster Recovery.

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