[Networker] Some questions on Oracle backups using RMAN?
2006-10-16 19:25:18
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
|
|
|