194 Posts

November 30th, 2007 09:00

Don't know if you can use this method but the way we handle coordinating our RMAN to disk backups with NetWorker is to execute the RMAN scripts as precmd using the savepnpc command. That way the RMAN backups run just before NetWorker does the tape backups.

2 Intern

 • 

724 Posts

November 30th, 2007 09:00

Use nsradmin, mminfo and nsrinfo. Depeding on how much independent you need your script you won't need all of them.

Simple solution would be to use mminfo to get nsavetime from the last backup of the saveset, and them list the files using nsrinfo, then you know what can ve overwritten or not.

But there's a lot of articles in KB about how Nw handle archive bits, so you may find a better solution there for your needs :)

7 Posts

November 30th, 2007 09:00

Thank you very much. I'll post and example if I get a method scripted.

7 Posts

November 30th, 2007 11:00

mminfo -s server -c clientnode -N /dbbackup -t 11/30/2007 -r "ssflags,nfiles,totalsize"
ssflags nfiles total
vF 1708 508601203600

If the backup is incomplete the "i" would would be in the first column

7 Posts

November 30th, 2007 15:00

Thanks the precmd option is worth discussing. We are engineering this thing from the perspective of moving files out of a directory after we are sure that a valid tape backup exists and then kicking off RMAN.

7 Posts

December 11th, 2007 14:00

ended using nsavetime in the mminfo query ( -r "ssflags,nfiles,nsavetime") to grab and the savetime with nsrinfo.

nsrinfo -s server -t $nsavet client/host > /tmp/session.info to get the file listing for the session.
No Events found!

Top