Forum Discussion

HCVN_u's avatar
HCVN_u
Level 3
5 years ago

Restore MSSQL error

When I restored DB of MS-SQL server, it's showed error: 
"  5  The restore failed to recover the requested files "

and detail session as below:

"

 

  • Jul 02, 2020 10:06:34 AM - begin Restore
  • Jul 02, 2020 10:06:36 AM - Info dbclient (pid=21104) INF - Results of executing <C:\Tmp\Restored\VN-VWL5044_02072020.bch>:
  • Jul 02, 2020 10:06:37 AM - Info dbclient (pid=21104) <0> operations succeeded. <1> operations failed.

 

"

And this is log in C:\Program Files\Veritas\NetBackup\logs\bprd

 

"

10:07:04.989 [6212.6300] <4> is_remote_host_connect_disabled: Failed to read key from bp.conf, errorcode:227. LEGACY_SERVICES_LOOPBACK_ONLY is not defined, using default.
10:07:04.989 [6212.6300] <2> bprd: socket fd from accept() is 1284
10:07:05.004 [6212.6300] <2> listen_loop: request complete
10:07:05.067 [41712.27184] <2> daemon_proxy_proto: Preparing to do daemon protocol for (127.0.0.1:13720 <- 127.0.0.1:65239)
10:07:05.067 [41712.27184] <2> logconnections: BPRD ACCEPT FROM 127.0.0.1.65239 TO 127.0.0.1.13720 fd = 1284
10:07:05.067 [41712.27184] <2> process_request: setsockopt SO_LINGER on 1284 succeeded.
10:07:05.067 [41712.27184] <2> connected_peer: Connection from host VN-BWL5001.hcg.homecredit.net, 127.0.0.1, on non-reserved port 65239
10:07:05.067 [41712.27184] <16> vnet_get_client_name_from_gateway_request: connection_info_json is not json object
10:07:05.067 [41712.27184] <2> copy_preferred_network_list: ../../libvlibs/nbconf.c.2282: pseudo PN for : vn-bwl5001.hcg.homecredit.net
10:07:05.067 [41712.27184] <4> process_request: JWT token found
10:07:05.067 [41712.27184] <2> get_job_initiator: JWT found
10:07:05.067 [41712.27184] <2> get_job_initiator: subject = IntraWebappCall
10:07:05.067 [41712.27184] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1851] in failed file cache ERR=11001 NAME=VN-BWL5001.hcg.homecredit.vn SVC=NULL
10:07:05.067 [41712.27184] <8> vnet_cached_getaddrinfo: [vnet_addrinfo.c:1520] vnet_cached_getaddrinfo_and_update() failed, name=VN-BWL5001.hcg.homecredit.vn, service=NULL, status=6
10:07:05.067 [41712.27184] <8> vnet_same_host_and_update: [vnet_addrinfo.c:3303] vnet_cached_getaddrinfo() failed STAT=6 RV=11001 NAME2=VN-BWL5001.hcg.homecredit.vn
10:07:05.067 [41712.27184] <2> process_request: command C_READ_HOST_CONFIG (73) received
10:07:05.067 [41712.27184] <2> set_audit_identity: JWT found
10:07:05.082 [41712.27184] <2> copy_preferred_network_list: ../../libvlibs/nbconf.c.2282: pseudo PN for : vn-bwl5001.hcg.homecredit.net
10:07:05.082 [41712.27184] <2> read_client: dname=., offline=0, online_at=0 offline_at=0 offlineres=0 onlineres_at=0 offlineres_at=0
10:07:05.082 [41712.27184] <2> read_client: dname=.., offline=0, online_at=0 offline_at=0 offlineres=0 onlineres_at=0 offlineres_at=0
10:07:05.082 [41712.27184] <2> read_client: dname=CO_0, offline=0, online_at=0 offline_at=0 offlineres=0 onlineres_at=0 offlineres_at=0
10:07:05.082 [41712.27184] <2> read_client: dname=host_info, offline=0, online_at=0 offline_at=0 offlineres=0 onlineres_at=0 offlineres_at=0
10:07:05.082 [41712.27184] <2> read_client: dname=OA_0, offline=0, online_at=0 offline_at=0 offlineres=0 onlineres_at=0 offlineres_at=0
10:07:05.098 [41712.27184] <2> logconnections: BPCD CONNECT FROM 10.19.205.202.65240 TO 10.19.205.202.13782 fd = 884
10:07:05.160 [41712.27184] <2> copy_preferred_network_list: ../../libvlibs/nbconf.c.2282: pseudo PN for : vn-bwl5001.hcg.homecredit.net
10:07:05.160 [41712.27184] <2> bpcr_get_version_rqst: bpcd version: 08200000
10:07:05.160 [41712.27184] <2> bpcr_get_version_rqst: bpcd version: 08200000
10:07:05.176 [41712.27184] <2> process_request: EXIT STATUS 0
10:07:05.176 [6212.6300] <4> is_remote_host_connect_disabled: Failed to read key from bp.conf, errorcode:227. LEGACY_SERVICES_LOOPBACK_ONLY is not defined, using default.
10:07:05.176 [6212.6300] <2> bprd: socket fd from accept() is 1284
10:07:05.192 [6212.6300] <2> listen_loop: request complete
10:07:05.254 [6556.21048] <2> daemon_proxy_proto: Preparing to do daemon protocol for (127.0.0.1:13720 <- 127.0.0.1:65242)
10:07:05.254 [6556.21048] <2> logconnections: BPRD ACCEPT FROM 127.0.0.1.65242 TO 127.0.0.1.13720 fd = 1284
10:07:05.254 [6556.21048] <2> process_request: setsockopt SO_LINGER on 1284 succeeded.
10:07:05.254 [6556.21048] <2> connected_peer: Connection from host VN-BWL5001.hcg.homecredit.net, 127.0.0.1, on non-reserved port 65242
10:07:05.254 [6556.21048] <16> vnet_get_client_name_from_gateway_request: connection_info_json is not json object
10:07:05.254 [6556.21048] <2> copy_preferred_network_list: ../../libvlibs/nbconf.c.2282: pseudo PN for : vn-bwl5001.hcg.homecredit.net
10:07:05.254 [6556.21048] <4> process_request: JWT token found
10:07:05.254 [6556.21048] <2> get_job_initiator: JWT found
10:07:05.254 [6556.21048] <2> get_job_initiator: subject = IntraWebappCall
10:07:05.254 [6556.21048] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1851] in failed file cache ERR=11001 NAME=VN-BWL5001.hcg.homecredit.vn SVC=NULL
10:07:05.254 [6556.21048] <8> vnet_cached_getaddrinfo: [vnet_addrinfo.c:1520] vnet_cached_getaddrinfo_and_update() failed, name=VN-BWL5001.hcg.homecredit.vn, service=NULL, status=6
10:07:05.254 [6556.21048] <8> vnet_same_host_and_update: [vnet_addrinfo.c:3303] vnet_cached_getaddrinfo() failed STAT=6 RV=11001 NAME2=VN-BWL5001.hcg.homecredit.vn
10:07:05.254 [6556.21048] <2> process_request: command C_AUTO_UNLOCK_USER (221) received
10:07:05.254 [6556.21048] <2> C_AUTO_UNLOCK_USER: Calling Auto Unlock Method for all users.
10:07:05.270 [6556.21048] <2> read_legacy_touch_file: Found C:\Program Files\Veritas\NetBackupDB\data\vxdbms.conf; requested from (../vxdbms_conf.cpp.1503).
10:07:05.411 [6556.21048] <2> C_AUTO_UNLOCK_USER: EXIT STATUS 365
10:07:05.411 [6212.6300] <4> is_remote_host_connect_disabled: Failed to read key from bp.conf, errorcode:227. LEGACY_SERVICES_LOOPBACK_ONLY is not defined, using default.
10:07:05.411 [6212.6300] <2> bprd: socket fd from accept() is 1396
10:07:05.426 [6212.6300] <2> listen_loop: request complete
10:07:05.473 [22084.23532] <2> daemon_proxy_proto: Preparing to do daemon protocol for (127.0.0.1:13720 <- 127.0.0.1:65243)
10:07:05.473 [22084.23532] <2> logconnections: BPRD ACCEPT FROM 127.0.0.1.65243 TO 127.0.0.1.13720 fd = 1396
10:07:05.473 [22084.23532] <2> process_request: setsockopt SO_LINGER on 1396 succeeded.
10:07:05.473 [22084.23532] <2> connected_peer: Connection from host VN-BWL5001.hcg.homecredit.net, 127.0.0.1, on non-reserved port 65243
10:07:05.473 [22084.23532] <16> vnet_get_client_name_from_gateway_request: connection_info_json is not json object
10:07:05.473 [22084.23532] <2> copy_preferred_network_list: ../../libvlibs/nbconf.c.2282: pseudo PN for : vn-bwl5001.hcg.homecredit.net
10:07:05.473 [22084.23532] <4> process_request: JWT token found
10:07:05.473 [22084.23532] <2> get_job_initiator: JWT found
10:07:05.473 [22084.23532] <2> get_job_initiator: subject = IntraWebappCall
10:07:05.473 [22084.23532] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1851] in failed file cache ERR=11001 NAME=VN-BWL5001.hcg.homecredit.vn SVC=NULL
10:07:05.473 [22084.23532] <8> vnet_cached_getaddrinfo: [vnet_addrinfo.c:1520] vnet_cached_getaddrinfo_and_update() failed, name=VN-BWL5001.hcg.homecredit.vn, service=NULL, status=6
10:07:05.473 [22084.23532] <8> vnet_same_host_and_update: [vnet_addrinfo.c:3303] vnet_cached_getaddrinfo() failed STAT=6 RV=11001 NAME2=VN-BWL5001.hcg.homecredit.vn
10:07:05.473 [22084.23532] <2> process_request: command C_IS_USER_ACCOUNT_LOCKED (220) received
10:07:05.473 [22084.23532] <2> C_IS_USER_ACCOUNT_LOCKED: user_name[vn-administrator], host_name[NOT_APPLICABLE], domain_name[VN-BWL5001], domain_type[0]
10:07:05.473 [22084.23532] <2> decode_spaces: Decoding user name [vn-administrator]
10:07:05.473 [22084.23532] <2> decode_space_in_input: Decoded input value is [vn-administrator]
10:07:05.473 [22084.23532] <2> decode_spaces: Decoding domain name [VN-BWL5001]
10:07:05.473 [22084.23532] <2> decode_space_in_input: Decoded input value is [VN-BWL5001]
10:07:05.504 [22084.23532] <2> read_legacy_touch_file: Found C:\Program Files\Veritas\NetBackupDB\data\vxdbms.conf; requested from (../vxdbms_conf.cpp.1503).
10:07:05.629 [22084.23532] <2> C_IS_USER_ACCOUNT_LOCKED: EXIT STATUS 0
10:07:05.864 [6212.6300] <4> is_remote_host_connect_disabled: Failed to read key from bp.conf, errorcode:227. LEGACY_SERVICES_LOOPBACK_ONLY is not defined, using default.
10:07:05.864 [6212.6300] <2> bprd: socket fd from accept() is 1396
10:07:05.879 [6212.6300] <2> listen_loop: request complete
10:07:05.942 [21816.35200] <2> daemon_proxy_proto: Preparing to do daemon protocol for (127.0.0.1:13720 <- 127.0.0.1:65248)
10:07:05.942 [21816.35200] <2> logconnections: BPRD ACCEPT FROM 127.0.0.1.65248 TO 127.0.0.1.13720 fd = 1396
10:07:05.942 [21816.35200] <2> process_request: setsockopt SO_LINGER on 1396 succeeded.
10:07:05.942 [21816.35200] <2> connected_peer: Connection from host VN-BWL5001.hcg.homecredit.net, 127.0.0.1, on non-reserved port 65248
10:07:05.942 [21816.35200] <16> vnet_get_client_name_from_gateway_request: connection_info_json is not json object
10:07:05.942 [21816.35200] <2> copy_preferred_network_list: ../../libvlibs/nbconf.c.2282: pseudo PN for : vn-bwl5001.hcg.homecredit.net
10:07:05.942 [21816.35200] <4> process_request: JWT token found
10:07:05.942 [21816.35200] <2> get_job_initiator: JWT found
10:07:05.942 [21816.35200] <2> get_job_initiator: subject = IntraWebappCall
10:07:05.942 [21816.35200] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1851] in failed file cache ERR=11001 NAME=VN-BWL5001.hcg.homecredit.vn SVC=NULL
10:07:05.942 [21816.35200] <8> vnet_cached_getaddrinfo: [vnet_addrinfo.c:1520] vnet_cached_getaddrinfo_and_update() failed, name=VN-BWL5001.hcg.homecredit.vn, service=NULL, status=6
10:07:05.942 [21816.35200] <8> vnet_same_host_and_update: [vnet_addrinfo.c:3303] vnet_cached_getaddrinfo() failed STAT=6 RV=11001 NAME2=VN-BWL5001.hcg.homecredit.vn
10:07:05.942 [21816.35200] <2> process_request: command C_UPDATE_USER_LOGIN_DETAILS (222) received
10:07:05.942 [21816.35200] <2> decode_spaces: Decoding user name [vn-administrator]
10:07:05.942 [21816.35200] <2> decode_space_in_input: Decoded input value is [vn-administrator]
10:07:05.942 [21816.35200] <2> decode_spaces: Decoding domain name [VN-BWL5001]
10:07:05.942 [21816.35200] <2> decode_space_in_input: Decoded input value is [VN-BWL5001]
10:07:05.942 [21816.35200] <2> C_UPDATE_USER_LOGIN_DETAILS: user_name[vn-administrator], host_name[NOT_APPLICABLE], domain_name[VN-BWL5001], domain_type[0], auth_status[1]
10:07:05.973 [21816.35200] <2> read_legacy_touch_file: Found C:\Program Files\Veritas\NetBackupDB\data\vxdbms.conf; requested from (../vxdbms_conf.cpp.1503).
10:07:06.114 [21816.35200] <2> C_UPDATE_USER_LOGIN_DETAILS: EXIT STATUS 0
10:07:08.239 [6212.6300] <4> is_remote_host_connect_disabled: Failed to read key from bp.conf, errorcode:227. LEGACY_SERVICES_LOOPBACK_ONLY is not defined, using default.
10:07:08.239 [6212.6300] <2> bprd: socket fd from accept() is 1944
10:07:08.255 [6212.6300] <2> listen_loop: request complete
10:07:08.302 [26244.22224] <2> daemon_proxy_proto: Preparing to do daemon protocol for (127.0.0.1:13720 <- 127.0.0.1:65251)
10:07:08.302 [26244.22224] <2> logconnections: BPRD ACCEPT FROM 127.0.0.1.65251 TO 127.0.0.1.13720 fd = 1944
10:07:08.302 [26244.22224] <2> process_request: setsockopt SO_LINGER on 1944 succeeded.
10:07:08.302 [26244.22224] <2> connected_peer: Connection from host VN-BWL5001.hcg.homecredit.net, 127.0.0.1, on non-reserved port 65251
10:07:08.302 [26244.22224] <16> vnet_get_client_name_from_gateway_request: connection_info_json is not json object
10:07:08.302 [26244.22224] <2> copy_preferred_network_list: ../../libvlibs/nbconf.c.2282: pseudo PN for : vn-bwl5001.hcg.homecredit.net
10:07:08.302 [26244.22224] <4> process_request: JWT token found
10:07:08.302 [26244.22224] <2> get_job_initiator: JWT found
10:07:08.302 [26244.22224] <2> get_job_initiator: subject = VN-BWL5001:VN-Administrator:nt
10:07:08.302 [26244.22224] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1851] in failed file cache ERR=11001 NAME=VN-BWL5001.hcg.homecredit.vn SVC=NULL
10:07:08.302 [26244.22224] <8> vnet_cached_getaddrinfo: [vnet_addrinfo.c:1520] vnet_cached_getaddrinfo_and_update() failed, name=VN-BWL5001.hcg.homecredit.vn, service=NULL, status=6
10:07:08.302 [26244.22224] <8> vnet_same_host_and_update: [vnet_addrinfo.c:3303] vnet_cached_getaddrinfo() failed STAT=6 RV=11001 NAME2=VN-BWL5001.hcg.homecredit.vn
10:07:08.302 [26244.22224] <2> process_request: command C_USER_PASSWORD_EXPIRATION_INFO (266) received
10:07:08.302 [26244.22224] <2> decode_spaces: Decoding user name [VN-Administrator]
10:07:08.302 [26244.22224] <2> decode_space_in_input: Decoded input value is [VN-Administrator]
10:07:08.302 [26244.22224] <2> decode_spaces: Decoding domain name [VN-BWL5001]
10:07:08.302 [26244.22224] <2> decode_space_in_input: Decoded input value is [VN-BWL5001]
10:07:12.927 [26244.22224] <2> C_USER_PASSWORD_EXPIRATION_INFO: Password expiry information logs [: user name is:VN-Administrator and domain name is:VN-BWL5001. Successfully retrieved ADsGetObject info. WinNT user case. using userFlags. Password for this user will never expire. Return code from get_ads_object_info method is:0. Return code using WinNT protocol is :0.]

"

 

 

 

  • HCVN_u, please make sure your .bch restore script is set correctly & all the values matches with defined values in the backup configuration. The log file you shared says the backup policy name in the script does not exists in NetBackup. That means it could not find the backup details using this backup_policy (class) name.

    10:06:34.703 [33812.18556] <2> read_class: policy NONE does not exist
    10:06:34.703 [33812.18556] <2> process_request: db_getCLASS failed - EC status = the specified policy does not exist in the configuration database

    • HCVN_u's avatar
      HCVN_u
      Level 3

      Thanks so much, i'll check again the *.bch file again

    • HCVN_u's avatar
      HCVN_u
      Level 3

      Hi Pro,

       

      can you show me to resolve the "policy NONE does not exist" error. I checked the .bch file but it didn't resolve the error.

      i attached .bch file.

      Thanks

      • quebek's avatar
        quebek
        Moderator

        Hey

        I see in your bch file such entries ==> after valid lines

        please remove these  and retry

        DATABASE "ELEARNING" ====> name DB
        MOVE "ELEARNING"
        TO "E:\MSSQL\DATA\ELEARNING_NEW.mdf" ==> new link mdf files
        MOVE "ELEARNING_log"
        TO "T:\MSSQL\LOG\ELEARNING_NEW_log.ldf" ==> new link log files
        NBIMAGE "VN-VWL5044.MSSQL7.VN-VWL5044.db.ELEARNING.~.7.001of001.20200613185853..C"
        SQLHOST "VNHQSQL01" ==> host need to restore DB
        NBSERVER "VN-BWL5001" ==> Masster Server
        BROWSECLIENT "VN-VWL5044" ==> Client backed up DB

        all these ==> are not welcome as well what is after that.... my take.