05-03-2017 07:26 AM
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)
Solved! Go to Solution.
05-03-2017 07:47 AM
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.
05-03-2017 07:47 AM
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.
05-03-2017 08:08 AM
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
05-03-2017 12:59 PM
$ORACLE_HOME/bp.conf
( Marianne may be offline by now )
05-03-2017 07:53 PM
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,
05-03-2017 11:16 PM
Hi Will_Restore,
Thank you for the confirmation.
05-03-2017 11:24 PM
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
05-04-2017 12:17 AM
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
05-04-2017 01:33 AM - edited 05-04-2017 01:33 AM
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
05-04-2017 01:39 AM
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
05-04-2017 01:42 AM
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
05-04-2017 04:56 AM
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
05-04-2017 05:14 AM
"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)
05-04-2017 05:36 AM
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.
05-04-2017 05:44 AM
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.
05-04-2017 06:10 AM - edited 05-04-2017 06:23 AM
05-06-2017 11:35 PM
Hi Marianne/Tousif,
Thank you for all your input. I'm now able to connect from client.
Regards,
J