Oracle cross restore failing.

[Ramiro-Magan]

Hi guys, I am needing some help here with an oracle cross restore.

My environment is like this:

Location 1:
Master server
Tape Library

Data Domain

Location 2:

media server

tape library

data domain.

Oracle server is in location 1, so I grabed the tapes, and took them to location 2.

what I have done so far is the following:

- In altnames I created a file named as the destination server, with the name of the origin server inside.

- in the master server config, under general server placed the original backup server as the master, and the restore server as the media.

- Changed the media owner of the tapes from the master to the media.

After all this, when the restore starts, it tries to find the tape in the master server instead of the media.

What could it be that I am not seeing?

thanks in advance.

[Nicolai]

Is Oracle backup from location 1 also available in location 2 ?

If that is the case, you can simply promote the backup from location 2 to primary copy.

http://www.veritas.com/docs/000044148

[Marianne]

Do you have bprd log folder on the master server?

If not, please create the folder and restart NBU, followed by retry of the restore.

bprd log will tell us why the master server is used as restore media server and not the media server.

[Ramiro-Magan]

Nicolai, I moved the tapes so I don´t have to set the copy as primary coz it´s the only copy.

Marianne, I just tried doing the restore again and logged the results, you can see them in the attachment.

Originating server is :cfhq002so0232

destination server: ar-gecs21

Master; myarsw00403bk01

I took a look at the logs but couldn´t figure anything from it.

thanks.

[areznik]

I think by default, Netbackup will use the server that wrote the backup to restore the backup. This is why we have to use "FORCE_RESTORE_MEDIA_SERVER" bp.conf entries with regular backups when we want them restored by another media server in the same NBU environment. I dont think that entry will work for an Oracle restore, what I would try is to reassign the images on that tape to be owned by the media server in Loc2.

This command should do it: 

/usr/openv/netbackup/bin/admincmd/bpmedia -movedb -oldserver ******  -newserver ****** -m <tapeid>

EDIT: I just saw that you might have done this already. If possible please post the bpimagelist -l output for the image you're restoring, and the nbemmcmd -listmedia -media <tapeid> output for one of the tapes. 

[Ramiro-Magan]

example of what I got from bpimagelist

FRAG 2 1 15587360 0 2 6 11 OVA315 myarsw00403bk01 262144 2931166 1461441756 5 0 *NULL* 1464703541 0 65539 0 1 0 1 1464703541 1462034549 1 1 *NULL* *NULL* 0 0
IMAGE cfhq002so0232 0 0 10 cfhq002so0232_1462025092 CF_HS_ORA_DBPRD11_HOT 4 *NULL* oracle Aplicacion-Semanal 2 9 1462025092 8 1464703492 0 0 20256 1 1 1 0 CF_HS_ORA_DBPRD11_HOT_1462025092_UBAK.f *NULL* *NULL* 0 2 0 0 0 gecap 0 0 0 0 0 0 0 *NULL* 0 0 0 *NULL* 715834 1 0 641 0 0 *NULL* 004-VTL-Prod-Semanal-Hot-New 3 0 1 0 *NULL* *NULL* 0 12 0 0
HISTO 0 0 0 0 0 0 0 0 0 0

nbemmcmd

C:\Users\adm-900000009>nbemmcmd -listmedia -mediaid ova315
NBEMMCMD, Version: 7.6.1.2
====================================================================
Media GUID:                     ad0c6db7-206c-43a6-9028-f4398f6c7c03
Media ID:                       OVA315
Partner:                        -
Media Type:                     HCART
Volume Group:                   000_00001_TLD
Application:                    Netbackup
Media Flags:                    1
Description:                    ---
Barcode:                        OVA315L4
Partner Barcode:                --------
Last Write Host:                myarsw00200bk01
Created:                        02/10/2016 17:11
Time Assigned:                  04/23/2016 17:02
First Mount:                    02/12/2016 06:31
Last Mount:                     05/02/2016 15:00
Volume Expiration:              -
Data Expiration:                06/01/2016 07:32
Last Written:                   05/02/2016 15:06
Last Read:                      -
Robot Type:                     TLD
Robot Control Host:             myarsw00200bk01
Robot Number:                   1
Slot:                           10
Side/Face:                      -
Cleanings Remaining:            -
Number of Mounts:               20
Maximum Mounts Allowed:         0
Media Status:                   ACTIVE
Kilobytes:                      1594672608
Images:                         27
Valid Images:                   27
Retention Period:               3
Number of Restores:             0
Optical Header Size Bytes:      1024
Optical Sector Size Bytes:      0
Optical Partition Size Bytes:   0
Last Header Offset:             6229269
Adamm Guid:                     00000000-0000-0000-0000-000000000000
Rsm Guid:                       00000000-0000-0000-0000-000000000000
Origin Host:                    NONE
Master Host:                    myarsw00403bk01
Server Group:                   NO_SHARING_GROUP
Upgrade Conflicts Flag:
Pool Number:                    13
Volume Pool:                    Oracle
Previous Pool Name:             Scratch
Vault Flags:                    -
Vault Container:                -
Vault Name:                     -
Vault Slot:                     -
Session ID:                     -
Date Vaulted:                   -
Return Date:                    -
Media on Hold:                  0
====================================================================
Command completed successfully.
 

[Marianne · Accepted solution]

Seems this is the issue: Found D:\GEAplications\Veritas\Netbackup\db\config\USE_BACKUP_MEDIA_SERVER_FOR_RESTORE; I think you will need to temporarily remove/rename this file for 'media server override' (FORCE_RESTORE...) to work.

[Ramiro-Magan]

Will give it a shot.

You know I had to add that out of the blue recently since it was not able to do AD granular restores, it worked one day, the started failing.

Found a post here from a guy that had the same problem, added that line and started working.

[Ramiro-Magan]

Marianne, you should be promoted to CEO of this forum! 

You never cease to impress with what you come up with.

Another issue solved, I can not thank you enough.

[PatS729]

Fantastic.... go ahead and mark this thread as Solved.

[Marianne]

I have learned the value of bprd log to troubleshoot restores early in my 'NBU life'. 

Shortly after "restorefiles" entries in the log, you will see "find_files" entries.

"find_files: Got CONTINUE from bpdbm " signals the end of bpdbm comms where backup media server is found.
At this point the restore media server is selected. 
This is where I expect to see "FORCE_RESTORE_MEDIA_SERVER" entry.
Or 'something else' that will indicate why the FORCE_RESTORE entry is not used.

I had obviously no idea that you had USE_BACKUP_MEDIA_SERVER_FOR_RESTORE touch file in place until I saw the entry in the bprd log.

This touch file is extremely useful when there are multiple OST appliances and media servers at different locations.
Without this touch file, we see that a remote media server is often chosen for duplication and/or restores.

Glad I could help!