Thanks. Please see my replies below.

George

Doug Brown wrote:

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.*

going to communicate to NetWorker to get the data off tape?

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

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

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