Networker

[Networker] Some questions on Oracle backups using RMAN?

2006-10-16 19:25:18
Subject: [Networker] Some questions on Oracle backups using RMAN?
From: George Sinclair <George.Sinclair AT NOAA DOT GOV>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Mon, 16 Oct 2006 19:23:01 -0400
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