Solved: Question - Performing a redirected restore of Orac...

technimdaxviii · ‎05-03-2017

Example - Performing a redirected restore of Oracle
For example, assume the following:
- Source client is camel
- Destination client is giraffe
- Master server is lion
- ORACLE_SID is test
- The user is connected to the Oracle database using a local connection, not
SQL*Net
- UNIX user is ora on both camel and giraffe

To perform a redirected restore (example)1 Create the following file on server lion:
Windows: install_path\NetBackup\db\altnames\giraffe
UNIX: /usr/openv/netbackup/db/altnames/giraffe
Edit giraffe to contain the name camel:
2 Do one of the following:
- Windows: Use the BAR GUI to set lion as the master server.
- UNIX: Log onto giraffe as ora. Set SERVER=lion in $ORACLE_HOME/bp.conf.This server must be the first server that is listed in the bp.conf file.

Just want to confirm if the line marked in red should be created manually in destination client. I've checked our production system, but I can't find the file under $ORACLE_HOME either.

Reference:

Symantec NetBackup™ for Oracle Administrator's Guide UNIX, Windows, and Linux Release 7.7 (Page 127)

Marianne · ‎05-03-2017

bp.conf in Oracle user home directory is not compulsory.

The SERVER entry should be verified IF the file exists.

The manual says the following a few pages back:

About the bp.conf file on UNIX systems
A NetBackup for Oracle user can create a bp.conf file in the Oracle user’s home
directory on the NetBackup for Oracle client host. When a NetBackup for Oracle
operation is started, the user’s bp.conf file is searched before the master
configuration file (/usr/openv/netbackup/bp.conf). Any option that is found at
the user level overrides the same option’s setting at the master level.

Handy NetBackup Links

View solution in original post

Marianne · ‎05-03-2017

bp.conf in Oracle user home directory is not compulsory.

The SERVER entry should be verified IF the file exists.

The manual says the following a few pages back:

About the bp.conf file on UNIX systems
A NetBackup for Oracle user can create a bp.conf file in the Oracle user’s home
directory on the NetBackup for Oracle client host. When a NetBackup for Oracle
operation is started, the user’s bp.conf file is searched before the master
configuration file (/usr/openv/netbackup/bp.conf). Any option that is found at
the user level overrides the same option’s setting at the master level.

Handy NetBackup Links

technimdaxviii · ‎05-03-2017

Hi Marianne,

Thanks again for answering my inquiry :)

A NetBackup for Oracle user can create a bp.conf file in the Oracle user’s home directory on the NetBackup for Oracle client host

Regarding to the statement above, it should be in Oracle user's home($HOME) or in $ORACLE_HOME?

bash-4.1$ echo $HOME
/export/home/oracle
bash-4.1$ echo $ORACLE_HOME
/u01/app/oracle/product/11.2/db_1

Will_Restore · ‎05-03-2017

$ORACLE_HOME/bp.conf

( Marianne may be offline by now )

Tousif · ‎05-03-2017

Hello,

Need to create the bp.conf file under path "/u01/app/oracle/product/11.2/db_1".

In general user use the default bp.conf file located under /usr/openv/netbackup/bp.conf.

May I know, why are you creating bp.conf file for oracle user?

Please let us know your requirement so we can suggest best practice.

Regards,

technimdaxviii · ‎05-03-2017

Hi Will_Restore,

Thank you for the confirmation.

technimdaxviii · ‎05-03-2017

Hi Tousif,

I'm currently reviewing the steps to restore rman backup into alternate server. As mentioned on the steps,Set SERVER=lion in $ORACLE_HOME/bp.conf. When I checked the file, it does not exist.

My main objective is to do DR testing. I'm done building the server with the same file structure and oracle software installed.

Regards,

J

Tousif · ‎05-04-2017

Hello,

Great, If you want to override the default bp.conf file (/usr/openv/netbckup/bp.conf) on target client due to specific requriment then only create manually bp.conf file in oracle user home directory.

I don't think currently you required that file.

Confirm the below requirement.

Master and Media server able to communicate with target client.

Run the below command from master and media server. Make sure the command should exit without any error.

#bptestbpcd -client <target server> -verbose

Then make sure that below command showing backup pieces of sources machine on target machine, which you want restore.

#/usr/openv/netbackup/bin/bplist -C db-backup-source -t 4 -R -l /

If not then create touch file No.Restrictions file on master server and run the command again.

This command should provide you the successful output. Without backup piece output we cannot move further.

Reference:

https://www.veritas.com/support/en_US/article.v15496837_nbu_oracle_web

Also same article have other link about RMAN redirect restore.

Recommendation:

Go through the NBU oracle agent admin guide. It have complete procedure to perform redirect client restore.

Reference topic "Redirecting a restore to a different client" page 93:

Admin Guide : https://www.veritas.com/support/en_US/article.DOC5175

technimdaxviii · ‎05-04-2017

Hi,

Great, If you want to override the default bp.conf file (/usr/openv/netbckup/bp.conf) on target client due to specific requriment then only create manually bp.conf file in oracle user home directory.

What other options/parameters should be added on this file (bp.conf) if I'm going to create it manually? Current parameters after I've installed the client were:

SERVER = hq-vnb.domain.com
#SERVER = hq-db02.domain.com
#SERVER = hq-db01.domain.com
CLIENT_NAME = hq-dev.domain.com
CONNECT_OPTIONS = localhost 1 0 2

We have 3 media servers, I've commented out the 2 servers to remove any possible connection to prod. These two media servers were used by the backup to be restore. Do I need to use these servers instead of hq-vnb.domain.com?

Run the below command from master and media server. Make sure the command should exit without any error.

#bptestbpcd -client <target server> -verbose

root@hq-vnb:/opt/openv/netbackup/bin# bptestbpcd -client hq-dev.domain.com -verbose
1 1 1
10.xxx.xxx.47:48405 -> 10.xxx.xxx.56:1556
10.xxx.xxx.47:63546 -> 10.xxx.xxx.56:1556
PEER_NAME = hq-vnb.domain.com
HOST_NAME = hq-dev.domain.com
CLIENT_NAME = hq-dev.domain.com
VERSION = 0x07600002
PLATFORM = solaris_x86_10_64
PATCH_VERSION = 7.6.0.2
SERVER_PATCH_VERSION = -1.-1.-1.-1
MASTER_SERVER = hq-vnb.domain.com
EMM_SERVER = hq-vnb.domain.com
NB_MACHINE_TYPE = CLIENT
10.xxx.xxx.47:48393 -> 10.xxx.xxx.56:1556

Then make sure that below command showing backup pieces of sources machine on target machine, which you want restore.

#/usr/openv/netbackup/bin/bplist -C db-backup-source -t 4 -R -l /

root@hq-dev:/usr/openv/netbackup/bin# /usr/openv/netbackup/bin/bplist -C hq-db02.domain.com -t 4 -R -l -s 05/03/2017 00:00:00 /
-rw-rw---- oracle    oinstall     13893632 May 04 00:06 /ctrl_dPROD02_uuds3bph1_s10189_p1_t943056417
-rw-rw---- oracle    oinstall       786432 May 04 00:02 /arch_dPROD02_uucs3bp7t_s10188_p1_t943056125
-rw-rw---- oracle    oinstall    23802624K May 03 23:54 /arch_dPROD02_uu9s3boop_s10185_p1_t943055641
-rw-rw---- oracle    oinstall    22992384K May 03 23:54 /arch_dPROD02_uubs3booq_s10187_p1_t943055642
-rw-rw---- oracle    oinstall    23906048K May 03 23:54 /arch_dPROD02_uuas3booq_s10186_p1_t943055642
-rw-rw---- oracle    oinstall       262144 May 03 23:51 /bk_dPROD02_uu8s3bojf_s10184_p1_t943055471
-rw-rw---- oracle    oinstall     13893632 May 03 23:49 /bk_dPROD02_uu7s3bogn_s10183_p1_t943055383
-rw-rw---- oracle    oinstall    11428352K May 03 23:42 /bk_dPROD02_uu6s3bo2q_s10182_p1_t943054938

technimdaxviii · ‎05-04-2017

Hi,

Great, If you want to override the default bp.conf file (/usr/openv/netbckup/bp.conf) on target client due to specific requriment then only create manually bp.conf file in oracle user home directory.

What other options/parameters should be added on this file (bp.conf) if I'm going to create it manually? Current parameters after I've installed the client were:

SERVER = hq-vnb.domain.com
#SERVER = hq-db02.domain.com
#SERVER = hq-db01.domain.com
CLIENT_NAME = hq-dev.domain.com
CONNECT_OPTIONS = localhost 1 0 2

We have 3 media servers, I've commented out the 2 servers to remove any possible connection to prod. These two media servers were used by the backup to be restore. Do I need to use these servers instead of hq-vnb.domain.com?

Run the below command from master and media server. Make sure the command should exit without any error.

#bptestbpcd -client <target server> -verbose

root@hq-vnb:/opt/openv/netbackup/bin# bptestbpcd -client hq-dev.domain.com -verbose
1 1 1
10.xxx.xxx.47:48405 -> 10.xxx.xxx.56:1556
10.xxx.xxx.47:63546 -> 10.xxx.xxx.56:1556
PEER_NAME = hq-vnb.domain.com
HOST_NAME = hq-dev.domain.com
CLIENT_NAME = hq-dev.domain.com
VERSION = 0x07600002
PLATFORM = solaris_x86_10_64
PATCH_VERSION = 7.6.0.2
SERVER_PATCH_VERSION = -1.-1.-1.-1
MASTER_SERVER = hq-vnb.domain.com
EMM_SERVER = hq-vnb.domain.com
NB_MACHINE_TYPE = CLIENT
10.xxx.xxx.47:48393 -> 10.xxx.xxx.56:1556

Then make sure that below command showing backup pieces of sources machine on target machine, which you want restore.

#/usr/openv/netbackup/bin/bplist -C db-backup-source -t 4 -R -l /

root@hq-dev:/usr/openv/netbackup/bin# /usr/openv/netbackup/bin/bplist -C hq-db02.domain.com -t 4 -R -l -s 05/03/2017 00:00:00 /
-rw-rw---- oracle    oinstall     13893632 May 04 00:06 /ctrl_dPROD02_uuds3bph1_s10189_p1_t943056417
-rw-rw---- oracle    oinstall       786432 May 04 00:02 /arch_dPROD02_uucs3bp7t_s10188_p1_t943056125
-rw-rw---- oracle    oinstall    23802624K May 03 23:54 /arch_dPROD02_uu9s3boop_s10185_p1_t943055641
-rw-rw---- oracle    oinstall    22992384K May 03 23:54 /arch_dPROD02_uubs3booq_s10187_p1_t943055642
-rw-rw---- oracle    oinstall    23906048K May 03 23:54 /arch_dPROD02_uuas3booq_s10186_p1_t943055642
-rw-rw---- oracle    oinstall       262144 May 03 23:51 /bk_dPROD02_uu8s3bojf_s10184_p1_t943055471
-rw-rw---- oracle    oinstall     13893632 May 03 23:49 /bk_dPROD02_uu7s3bogn_s10183_p1_t943055383
-rw-rw---- oracle    oinstall    11428352K May 03 23:42 /bk_dPROD02_uu6s3bo2q_s10182_p1_t943054938

technimdaxviii · ‎05-04-2017

Hi,

Great, If you want to override the default bp.conf file (/usr/openv/netbckup/bp.conf) on target client due to specific requriment then only create manually bp.conf file in oracle user home directory.

What other options/parameters should be added on this file (bp.conf) if I'm going to create it manually? Current parameters after I've installed the client were:

SERVER = hq-vnb.domain.com
#SERVER = hq-db02.domain.com
#SERVER = hq-db01.domain.com
CLIENT_NAME = hq-dev.domain.com
CONNECT_OPTIONS = localhost 1 0 2

We have 3 media servers, I've commented out the 2 servers to remove any possible connection to prod. These two media servers were used by the backup to be restore. Do I need to use these servers instead of hq-vnb.domain.com?

Run the below command from master and media server. Make sure the command should exit without any error.

#bptestbpcd -client <target server> -verbose

root@hq-vnb:/opt/openv/netbackup/bin# bptestbpcd -client hq-dev.domain.com -verbose
1 1 1
10.xxx.xxx.47:48405 -> 10.xxx.xxx.56:1556
10.xxx.xxx.47:63546 -> 10.xxx.xxx.56:1556
PEER_NAME = hq-vnb.domain.com
HOST_NAME = hq-dev.domain.com
CLIENT_NAME = hq-dev.domain.com
VERSION = 0x07600002
PLATFORM = solaris_x86_10_64
PATCH_VERSION = 7.6.0.2
SERVER_PATCH_VERSION = -1.-1.-1.-1
MASTER_SERVER = hq-vnb.domain.com
EMM_SERVER = hq-vnb.domain.com
NB_MACHINE_TYPE = CLIENT
10.xxx.xxx.47:48393 -> 10.xxx.xxx.56:1556

Then make sure that below command showing backup pieces of sources machine on target machine, which you want restore.

#/usr/openv/netbackup/bin/bplist -C db-backup-source -t 4 -R -l /

root@hq-dev:/usr/openv/netbackup/bin# /usr/openv/netbackup/bin/bplist -C hq-db02.domain.com -t 4 -R -l -s 05/03/2017 00:00:00 /
-rw-rw---- oracle    oinstall     13893632 May 04 00:06 /ctrl_dPROD02_uuds3bph1_s10189_p1_t943056417
-rw-rw---- oracle    oinstall       786432 May 04 00:02 /arch_dPROD02_uucs3bp7t_s10188_p1_t943056125
-rw-rw---- oracle    oinstall    23802624K May 03 23:54 /arch_dPROD02_uu9s3boop_s10185_p1_t943055641
-rw-rw---- oracle    oinstall    22992384K May 03 23:54 /arch_dPROD02_uubs3booq_s10187_p1_t943055642
-rw-rw---- oracle    oinstall    23906048K May 03 23:54 /arch_dPROD02_uuas3booq_s10186_p1_t943055642
-rw-rw---- oracle    oinstall       262144 May 03 23:51 /bk_dPROD02_uu8s3bojf_s10184_p1_t943055471
-rw-rw---- oracle    oinstall     13893632 May 03 23:49 /bk_dPROD02_uu7s3bogn_s10183_p1_t943055383
-rw-rw---- oracle    oinstall    11428352K May 03 23:42 /bk_dPROD02_uu6s3bo2q_s10182_p1_t943054938

technimdaxviii · ‎05-04-2017

Hi,

I've replied back earlier but seems not posted.

Master and Media server able to communicate with target client.

We have 1 master and 3 media server. After installing the client to DR server (hq-dev.domain.com), bp.conf was created with the parameters below. 2 server was commented out by me to removed any point going to these server.

SERVER = hq-vnb.domain.com
#SERVER = hq-db02.domain.com
#SERVER = hq-db01.domain.com
CLIENT_NAME = hq-dev.domain.com
CONNECT_OPTIONS = localhost 1 0 2

hq-db02.domain.com was used by PROD02. Can I used any of these 3? Like using hq-vnb.domain.com, instead of hq-db02.domain.com.

Run the below command from master and media server. Make sure the command should exit without any error.

#bptestbpcd -client <target server> -verbose

root@hq-vnb:/opt/openv/netbackup/bin# bptestbpcd -client hq-dev.domain.com -verbose
1 1 1
10.xxx.xxx.47:48405 -> 10.xxx.xxx.56:1556
10.xxx.xxx.47:63546 -> 10.xxx.xxx.56:1556
PEER_NAME = hq-vnb.domain.com
HOST_NAME = hq-dev.domain.com
CLIENT_NAME = hq-dev.domain.com
VERSION = 0x07600002
PLATFORM = solaris_x86_10_64
PATCH_VERSION = 7.6.0.2
SERVER_PATCH_VERSION = -1.-1.-1.-1
MASTER_SERVER = hq-vnb.domain.com
EMM_SERVER = hq-vnb.domain.com
NB_MACHINE_TYPE = CLIENT
10.xxx.xxx.47:48393 -> 10.xxx.xxx.56:1556

Then make sure that below command showing backup pieces of sources machine on target machine, which you want restore.

#/usr/openv/netbackup/bin/bplist -C db-backup-source -t 4 -R -l /

root@hq-dev:/usr/openv/netbackup/bin# /usr/openv/netbackup/bin/bplist -C hq-db02.domain.com -t 4 -R -l -s 05/03/2017 00:00:00 /
-rw-rw---- oracle    oinstall     13893632 May 04 00:06 /ctrl_dPROD02_uuds3bph1_s10189_p1_t943056417
-rw-rw---- oracle    oinstall       786432 May 04 00:02 /arch_dPROD02_uucs3bp7t_s10188_p1_t943056125
-rw-rw---- oracle    oinstall    23802624K May 03 23:54 /arch_dPROD02_uu9s3boop_s10185_p1_t943055641
-rw-rw---- oracle    oinstall    22992384K May 03 23:54 /arch_dPROD02_uubs3booq_s10187_p1_t943055642
-rw-rw---- oracle    oinstall    23906048K May 03 23:54 /arch_dPROD02_uuas3booq_s10186_p1_t943055642
-rw-rw---- oracle    oinstall       262144 May 03 23:51 /bk_dPROD02_uu8s3bojf_s10184_p1_t943055471
-rw-rw---- oracle    oinstall     13893632 May 03 23:49 /bk_dPROD02_uu7s3bogn_s10183_p1_t943055383
-rw-rw---- oracle    oinstall    11428352K May 03 23:42 /bk_dPROD02_uu6s3bo2q_s10182_p1_t943054938

Marianne · ‎05-04-2017

"hq-db02.domain.com was used by PROD02. Can I used any of these 3? Like using hq-vnb.domain.com, instead of hq-db02.domain.com."

Do you mean hq-db02.domain.com was backed up by PROD02 media server?

What kind of media was used by the backup?
If tape was used, then PROD02 media server will be used by default for the restore.
There are various way to force the restore to another media server:
- Change image ownership (bpimage)
- Change media ownership (bpmedia)
- Force all restores for PROD02 to the master (Media Host override)

Handy NetBackup Links

technimdaxviii · ‎05-04-2017

Hi Marriane,

Do you mean hq-db02.domain.com was backed up by PROD02 media server?

Yes. PROD02 database was running on hq-db02.domain.com. At the same time, this host act as one of the media server. Do I need to update bp.conf?

What kind of media was used by the backup?
If tape was used, then PROD02 media server will be used by default for the restore.

Yes, its from the tape.

Marianne · ‎05-04-2017

Yes, update bp.conf as hq-db02.domain.com will by default be the media server to perform the restore.

Unless you use one of the methods that I have listed to restore via the master or another media server (and remember to change back afterwards).

PS:

There is no need to create another bp.conf.

The default one in /usr/openv/netbackup is perfectly fine.

Handy NetBackup Links

Tousif · ‎05-04-2017

Hello
If you want to use different media server for restore then make entry of that media server in bp.conf on target client. Do the changes at media or image ownership as suggested.

Connect to RMAN on target client
to perform restore. You can refer same guide suggested in my previous post.

Regards

technimdaxviii · ‎05-06-2017

Hi Marianne/Tousif,

Thank you for all your input. I'm now able to connect from client.

Regards,

J

VOX

Question - Performing a redirected restore of Oracle