11-19-2015 07:32 AM
NBU 7.6.0.3
during restores, i find that i have to babysit because it may ask for media that are not in the library.
is there a way to find what are the medias required for a particular restore job?
Solved! Go to Solution.
11-20-2015 11:16 AM
STEP 1
First Use BPLIST command with the time stamp of the First handle and time stamp of the last handle (Get this information from DBA)
bplist -B -C client_name -S master -t 4 -k RMAN_Policy -keyword database_name -s mm/dd/yyyy hh:mm:ss -e mm/dd/yyyy hh:mm:ss -R -l -u /
Above command should list out all the handles, important is the keyword which should match with the database name. Compare the handle Names given by the DBA and they should match exactly. If don't make sure timestamp is correct. If the names of the handles does not match with names from DBA list you cannot proceed further.
STEP 2-
Then use the BPIMAGELIST command with same time stamp
bpimagelist -client client_name -policy RMAN_Policy -keyword database_name -d mm/dd/yyyy hh:mm:ss -e mm/dd/yyyy hh:mm:ss -U
Above command should give similar number of image output as in STEP 1
STEP 3
Run the same command in STEP2 just add -media at the end and it should give you the medias required for the restore of the RMAN backup
bpimagelist -client client_name -policy RMAN_Policy -keyword database_name -d mm/dd/yyyy hh:mm:ss -e mm/dd/yyyy hh:mm:ss -U -media
11-19-2015 07:52 AM
Hello,
if it is a restore which can be performed via Backup,Archive and Restore GUI (so files, VMware, Exchange, and a few more), then there is a menu option Restore\Preview Media. where you can review list of media in advance.
When it is a database related restore launched from native db GUIs (Oracle RMAN, MS SQL Agent,..) then it is not so straightforward. You must map required backup ID with Images On Tape report, for example.
Michal
11-19-2015 09:08 AM
oic. it's an RMAN restore.
thanks.
11-19-2015 12:07 PM
11-20-2015 01:22 AM
With RMAn, you can use list commands like "list backup of database" or "list backup of archivelog from" which shows also media ID
Refer to RMAN commands guidelines
Michal
11-20-2015 11:16 AM
STEP 1
First Use BPLIST command with the time stamp of the First handle and time stamp of the last handle (Get this information from DBA)
bplist -B -C client_name -S master -t 4 -k RMAN_Policy -keyword database_name -s mm/dd/yyyy hh:mm:ss -e mm/dd/yyyy hh:mm:ss -R -l -u /
Above command should list out all the handles, important is the keyword which should match with the database name. Compare the handle Names given by the DBA and they should match exactly. If don't make sure timestamp is correct. If the names of the handles does not match with names from DBA list you cannot proceed further.
STEP 2-
Then use the BPIMAGELIST command with same time stamp
bpimagelist -client client_name -policy RMAN_Policy -keyword database_name -d mm/dd/yyyy hh:mm:ss -e mm/dd/yyyy hh:mm:ss -U
Above command should give similar number of image output as in STEP 1
STEP 3
Run the same command in STEP2 just add -media at the end and it should give you the medias required for the restore of the RMAN backup
bpimagelist -client client_name -policy RMAN_Policy -keyword database_name -d mm/dd/yyyy hh:mm:ss -e mm/dd/yyyy hh:mm:ss -U -media
11-22-2015 08:15 AM
11-27-2015 01:25 AM
thanks. yup found all required tapes.