Preview Media Command for NetBackup Oracle Agent
Currently, RMAN doesn't have the ability to query the NetBackup catalog. It would be nice if the NetBackup Oracle agent included a command that you could run to query the NB catalog to see what media is necessary for a restore, similar to the Preview Media in the Backup, Archive, Restore GUI. The command should also return a media status field which would indicate if the media was currently available (loaded in the library).
This feature would allow our DBA's to notify the NB adminstrator if a tape recall was necessary for a restore that they need to perform, rather than initiating the restore, waiting for it to fail and then contacting the NB administrator to recall the necessary tapes (which only show in the failed job in the Activity Monitor).
Comments
USE BPIMAGELIST on master server
Try this:
bpimagelist -media -U -d 02/16/2010 -e 02/18/2010 -policy "RMAN.POLICY.NAME"
This will list all media for that policy for those dates.
You can also use -client "CLIENT.NAME"
OR there is a command you can run on the client for each oracle piece - it is not as good.
NBU 7.0.1 on Solaris 10
writing to EMC 4206 VTL
duplicating to LTO2 in SL8500
(Soon to be LTO5)
using ACSLS 7.3.1
I had initially disagreed
I had initially disagreed with this idea - but my DBA needs to search for media by the bk value in the RMAN logs and NetBackup does not seem to allow this except on the client originally backup made on.
Not handy in a DR situation!
NBU 7.0.1 on Solaris 10
writing to EMC 4206 VTL
duplicating to LTO2 in SL8500
(Soon to be LTO5)
using ACSLS 7.3.1
Query needs to be refined by "file list"
We have many jobs run from each client under the same policy, so we need a way to query the "file list". The DBA will give us the the Oracle piece names that are needed for the restore, I need a way to query the catalog using the piece names and have it return the media that is needed.
Would you like to reply?
Login or Register to post your comment.