cancel
Showing results for 
Search instead for 
Did you mean: 

finding rest of media during a restore

manatee
Level 6

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?

1 ACCEPTED SOLUTION

Accepted Solutions

Tape_Archived
Moderator
Moderator
   VIP   

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

View solution in original post

7 REPLIES 7

Michal_Mikulik1
Moderator
Moderator
Partner    VIP    Accredited Certified

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

manatee
Level 6

oic. it's an RMAN restore.

thanks.

Marianne
Level 6
Partner    VIP    Accredited Certified
bpimagelist -client (name ) -d (start-date) -e (end-date) -media -U You may want to add -pt Oracle

Michal_Mikulik1
Moderator
Moderator
Partner    VIP    Accredited Certified

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

 

Tape_Archived
Moderator
Moderator
   VIP   

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

Marianne
Level 6
Partner    VIP    Accredited Certified
Did you manage to find all the tapes?

manatee
Level 6

thanks. yup found all required tapes.