Forum Discussion

Flako's avatar
Flako
Level 3
12 years ago

no backup found while restoring SAP offline Redolog

I do have a Problem restoring SAP offline Redologs.

Backup is doing fine. Bplist is without Problem.

 

+-------

<snip>
BR0408I BRRESTORE action ID: relghmsp
BR0409I BRRESTORE function ID: rsa
BR0419I Files will be restored from backup: aelfxcyo.svd 2013-05-20 13.29.18
BR0416I 1 file found to restore, size 35.987 MB
BR0421I Restore device type: util_file

BR0280I BRRESTORE time stamp: 2013-05-22 16.08.43
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:
BR0280I BRRESTORE time stamp: 2013-05-22 16.08.52
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

BR0280I BRRESTORE time stamp: 2013-05-22 16.08.52
BR0229I Calling backup utility with function 'restore'...
BR0278I Command output of '/usr/openv/netbackup/bin/backint -u EB3 -f restore -i /oracle/EB3/sapbackup/.relghmsp.lst -t file -p /oracle/EB3/112_64/dbs/initEB3.utl':
********************************************************************************
Program:                /usr/openv/netbackup/bin/backint 7.1
Input File:             /oracle/EB3/sapbackup/.relghmsp.lst
Profile:                /oracle/EB3/112_64/dbs/initEB3.utl
Function:               RESTORE
********************************************************************************
BR0386E No backup of file '/oracle/EB3/oraarch/EB3arch1_6619_788438682.dbf' found by backup utility
BR0278E Command output of '/usr/openv/netbackup/bin/backint -u EB3 -f restore -i /oracle/EB3/sapbackup/.relghmsp.lst -t file -p /oracle/EB3/112_64/dbs/initEB3.utl':
********************************************************************************

BR0280I BRRESTORE time stamp: 2013-05-22 16.08.52
BR0279E Return code from '/usr/openv/netbackup/bin/backint -u EB3 -f restore -i /oracle/EB3/sapbackup/.relghmsp.lst -t file -p /oracle/EB3/112_64/dbs/initEB3.utl': 2

BR0374E 0 of 1 file restored by backup utility
BR0280I BRRESTORE time stamp: 2013-05-22 16.08.52
BR0231E Backup utility call failed

<snip>

+-----

 

Bplist on same server with same user:

oraeb3@sapeb390: /oracle/EB3 % /usr/openv/netbackup/bin/bplist -t 17 -R -b -l /oracle/EB3/oraarch/EB3arch1_6619_788438682.dbf
-rw-r----- oraeb3    dba          37734912 May 20 13:29 /oracle/EB3/oraarch/EB3arch1_6619_788438682.dbf
oraeb3@sapeb390: /oracle/EB3 %

 

I dont find my Problem here.

I do have several other SAP Instances that are running well and where i dont have any Problem while restoring.

 

Anyone able to help me ?

cu Ingo
 

Backup and Recovery
Error messages
NetBackup
Restore
Solaris
Tip-How to
  • Nicolai's avatar
    Nicolai
    12 years ago

    Restore the file as root if it urgent:

    bprestore -t 17  /oracle/EB3/oraarch/EB3arch1_6619_788438682.dbf

    Else put VERBOSE = 5 in bp.conf and make sure /usr/openv/netbackup/logs/backint exist and the directory has 777 permissions. Retry the operation and attache the debug log as an file to a post. 

8 Replies

Sort By
  • Nicolai's avatar
    Nicolai
    Moderator
    12 years ago

    Restore the file as root if it urgent:

    bprestore -t 17  /oracle/EB3/oraarch/EB3arch1_6619_788438682.dbf

    Else put VERBOSE = 5 in bp.conf and make sure /usr/openv/netbackup/logs/backint exist and the directory has 777 permissions. Retry the operation and attache the debug log as an file to a post. 

  • Flako's avatar
    Flako
    Level 3
    12 years ago

     

    12:10:21.019 [28354] <4> get_Policy_Methodtype: VxBSAGetPolicyInfo - SUCCESS
    12:10:21.019 [28354] <4> get_Policy_Methodtype: Exit with status 0
    12:10:21.019 [28354] <2> find_max_min_time: Start date : 01/01/70 01:00:00 (0)
    12:10:21.019 [28354] <2> find_max_min_time: End date from : 01/19/38 04:14:06 (2147483646)
    12:10:21.019 [28354] <2> find_max_min_time: Start date from backint.time : 01/01/70 01:00:00 (0)
    12:10:21.019 [28354] <2> find_max_min_time: End date from backint.time : 01/01/70 01:00:00 (0)
    12:10:21.019 [28354] <2> find_max_min_time: global sap policy type = 0 ; standard policy type = 0
    12:10:21.020 [28354] <4> /usr/openv/netbackup/bin/backint 7.1: ********************************************************************************
    12:10:21.020 [28354] <4> /usr/openv/netbackup/bin/backint 7.1: Program:         /usr/openv/netbackup/bin/backint 7.1
    12:10:21.020 [28354] <4> /usr/openv/netbackup/bin/backint 7.1: Input File:              /oracle/EB3/sapbackup/.relglpjj.lst
    12:10:21.020 [28354] <4> /usr/openv/netbackup/bin/backint 7.1: Profile:         /oracle/EB3/112_64/dbs/initEB3.utl
    12:10:21.020 [28354] <4> /usr/openv/netbackup/bin/backint 7.1: Function:                RESTORE
    12:10:21.020 [28354] <4> /usr/openv/netbackup/bin/backint 7.1: ********************************************************************************
    12:10:21.020 [28354] <4> do_restore: Enter.
    12:10:21.020 [28354] <4> read_input_file: Entering.
    12:10:21.020 [28354] <4> read_inquire_input_file: Quering new image.
    12:10:21.020 [28354] <2> read_inquire_input_file: malloc image_info struct: 1
    12:10:21.021 [28354] <2> read_inquire_input_file: malloc fifo_info struct: 0
    12:10:21.021 [28354] <2> read_inquire_input_file: file line: VXF1369049368 /oracle/EB3/oraarch/EB3arch1_6619_788438682.dbf /tmp
    12:10:21.021 [28354] <2> remove_vxfs_extension: Remove vxfs extension input: /oracle/EB3/oraarch/EB3arch1_6619_788438682.dbf
    12:10:21.021 [28354] <2> remove_vxfs_extension: Remove vxfs extension output: /oracle/EB3/oraarch/EB3arch1_6619_788438682.dbf
    12:10:21.021 [28354] <2> backint_check_raw_partition: Entering
    12:10:21.021 [28354] <4> read_input_file: Exiting.
    12:10:21.021 [28354] <2> do_restore: Display inquire_info structure
    12:10:21.021 [28354] <2> do_restore:    file_path_name = >/oracle/EB3/oraarch/EB3arch1_6619_788438682.dbf<
    12:10:21.021 [28354] <2> do_restore:    actual_file_path = >/oracle/EB3/oraarch/EB3arch1_6619_788438682.dbf<
    12:10:21.021 [28354] <2> do_restore:    bid = >VXF1369049368< dest_dir = >/tmp<
    12:10:21.021 [28354] <2> do_restore:    start_unix_time = 0 ; end_unix_time = 2147483646 ; image_time = 0
    12:10:21.021 [28354] <2> do_restore:    found = 0 ; raw_par = 0 ; time_pos = 0 file_size = 0
    12:10:21.021 [28354] <2> backint_do_restore: Starting
    12:10:21.021 [28354] <2> backint_do_restore: Display inquire_info structure
    12:10:21.021 [28354] <2> backint_do_restore:    file_path_name = >/oracle/EB3/oraarch/EB3arch1_6619_788438682.dbf<
    12:10:21.021 [28354] <2> backint_do_restore:    actual_file_path = >/oracle/EB3/oraarch/EB3arch1_6619_788438682.dbf<
    12:10:21.021 [28354] <2> backint_do_restore:    bid = >VXF1369049368< dest_dir = >/tmp<
    12:10:21.021 [28354] <2> backint_do_restore:    start_unix_time = 0 ; end_unix_time = 2147483646 ; image_time = 0
    12:10:21.021 [28354] <2> backint_do_restore:    found = 0 ; raw_par = 0 ; time_pos = 0 file_size = 0
    12:10:21.021 [28354] <2> backint_do_restore: Found bid : VXF1369049368
    12:10:21.021 [28354] <2> backint_do_restore: Display inquire_info structure
    12:10:21.021 [28354] <2> backint_do_restore:    file_path_name = >/oracle/EB3/oraarch/EB3arch1_6619_788438682.dbf<
    12:10:21.021 [28354] <2> backint_do_restore:    actual_file_path = >/oracle/EB3/oraarch/EB3arch1_6619_788438682.dbf<
    12:10:21.022 [28354] <2> backint_do_restore:    bid = >VXF1369049368< dest_dir = >/tmp<
    12:10:21.022 [28354] <2> backint_do_restore:    start_unix_time = 1369049368 ; end_unix_time = 1369049368 ; image_time = 0
    12:10:21.022 [28354] <2> backint_do_restore:    found = 0 ; raw_par = 0 ; time_pos = 0 file_size = 0
    12:10:21.022 [28354] <2> backint_find_master_time: start time = 05/20/13 13:29:28; start_unix_time = 1369049368
    12:10:21.022 [28354] <2> backint_find_master_time: end time = 05/20/13 13:29:28; end_unix_time = 1369049368
    12:10:21.022 [28354] <2> backint_find_master_time: Display inquire_info structure
    12:10:21.022 [28354] <2> backint_find_master_time:      file_path_name = >/oracle/EB3/oraarch/EB3arch1_6619_788438682.dbf<
    12:10:21.022 [28354] <2> backint_find_master_time:      actual_file_path = >/oracle/EB3/oraarch/EB3arch1_6619_788438682.dbf<
    12:10:21.022 [28354] <2> backint_find_master_time:      bid = >VXF1369049368< dest_dir = >/tmp<
    12:10:21.022 [28354] <2> backint_find_master_time:      start_unix_time = 1369049368 ; end_unix_time = 1369049368 ; image_time = 0
    12:10:21.022 [28354] <2> backint_find_master_time:      found = 0 ; raw_par = 0 ; time_pos = 0 file_size = 0
    12:10:21.022 [28354] <2> backint_find_master_time: running norm command: /usr/openv/netbackup/bin/bplist -t 17 -X -U -B -R -l -b -S dsnnbus1 -C dsneb3 -keyword "" -s 1369049368 -e 1369049368 /
    12:10:21.022 [28354] <4> bsa_bplist: entering bsa_bplist
    12:10:21.023 [28354] <2> bprd_connect: Ignoring local_name dsneb3.
    12:10:21.023 [28354] <2> bprd_connect: Ignoring owner_name oraeb3.
    12:10:21.023 [28354] <2> vnet_sortaddrs: ../../libvlibs/vnet_addrinfo.c.4067: 0: sorted addrs:: 1 0x00000001
    12:10:21.023 [28354] <2> get_pref_netconnection: ../../libvlibs/vnet_addrinfo.c.4962: 0: Override REQUIRED_INTERFACE resolves to: : 10.100.200.90
    12:10:21.023 [28354] <2> get_pref_netconnection: ../../libvlibs/vnet_addrinfo.c.5037: 0: targaddr is : 10.100.200.230
    12:10:21.023 [28354] <2> get_pref_netconnection: ../../libvlibs/vnet_addrinfo.c.5039: 0: prefnet = : ANY
    12:10:21.024 [28354] <2> get_pref_netconnection: ../../libvlibs/vnet_addrinfo.c.5060: 0: prefnet = : REQIF
    12:10:21.024 [28354] <2> vnet_sortaddrs: ../../libvlibs/vnet_addrinfo.c.4067: 0: sorted addrs:: 1 0x00000001
    12:10:21.024 [28354] <2> get_pref_netconnection: ../../libvlibs/vnet_addrinfo.c.4962: 0: Override REQUIRED_INTERFACE resolves to: : 10.100.200.90
    12:10:21.024 [28354] <2> get_pref_netconnection: ../../libvlibs/vnet_addrinfo.c.5037: 0: targaddr is : 10.100.200.230
    12:10:21.024 [28354] <2> get_pref_netconnection: ../../libvlibs/vnet_addrinfo.c.5039: 0: prefnet = : ANY
    12:10:21.024 [28354] <2> get_pref_netconnection: ../../libvlibs/vnet_addrinfo.c.5060: 0: prefnet = : REQIF
    12:10:21.024 [28354] <2> vnet_sortaddrs: ../../libvlibs/vnet_addrinfo.c.4067: 0: sorted addrs:: 1 0x00000001
    12:10:21.024 [28354] <2> get_pref_netconnection: ../../libvlibs/vnet_addrinfo.c.4962: 0: Override REQUIRED_INTERFACE resolves to: : 10.100.200.90
    12:10:21.024 [28354] <2> get_pref_netconnection: ../../libvlibs/vnet_addrinfo.c.5037: 0: targaddr is : 10.100.200.230
    12:10:21.024 [28354] <2> get_pref_netconnection: ../../libvlibs/vnet_addrinfo.c.5039: 0: prefnet = : ANY
    12:10:21.024 [28354] <2> get_pref_netconnection: ../../libvlibs/vnet_addrinfo.c.5060: 0: prefnet = : REQIF
    12:10:21.025 [28354] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1200: 0: connect in progress: 1 0x00000001
    12:10:21.034 [28354] <2> vnet_pbxConnect: pbxConnectEx Succeeded
    12:10:21.034 [28354] <2> do_pbx_service: ../../libvlibs/vnet_connect.c.1784: 0: via PBX: bprd CONNECT FROM 10.100.200.90.63935 TO 10.100.200.230.1556 fd = 8
    12:10:21.035 [28354] <2> vnet_async_connect: ../../libvlibs/vnet_connect.c.1367: 0: connect: async CONNECT FROM 10.100.200.90.63935 TO 10.100.200.230.1556 fd = 8
    12:10:21.035 [28354] <2> logconnections: BPRD CONNECT FROM 10.100.200.90.63935 TO 10.100.200.230.1556 fd = 8
    12:10:21.035 [28354] <2> vnet_check_vxss_client_magic_with_info: ../../libvlibs/vnet_vxss_helper.c.833: 0: VxSS not supported: 0 0x00000000
    12:10:21.035 [28354] <2> bsa_bplist: start_date = Mon May 20 13:29:28 2013

    12:10:21.035 [28354] <2> bsa_bplist: end_date = Mon May 20 13:29:28 2013

    12:10:21.035 [28354] <2> bsa_bplist: Request = oraeb3 dba dsneb3 dsneb3 dsneb3 NONE 0  3 999 1369049368 1369049368 4 4 1 0 1 0 17 10902 1000 3 0 C C C C C 0 0 0 0 0
    12:10:21.035 [28354] <4> bsa_bplist: Filepath = /
    12:10:21.035 [28354] <2> backint_find_master_time: get next string from norm bplist
    12:10:21.247 [28354] <2> dbc_get_string: Output = EXIT STATUS 227
    12:10:21.247 [28354] <2> backint_find_master_time: ERR - dbc_get_string for norm returned : 227
    12:10:21.247 [28354] <2> backint_find_master_time: End of norm bplist
    12:10:21.247 [28354] <2> backint_find_master_time: raw_flag = 0 : norm_flag = 0
    12:10:21.247 [28354] <4> backint_find_master_time: WARNING: not found in bplist list: /oracle/EB3/oraarch/EB3arch1_6619_788438682.dbf
    12:10:21.247 [28354] <2> backint_find_master_time: Display inquire_info structure
    12:10:21.247 [28354] <2> backint_find_master_time:      file_path_name = >/oracle/EB3/oraarch/EB3arch1_6619_788438682.dbf<
    12:10:21.247 [28354] <2> backint_find_master_time:      actual_file_path = >/oracle/EB3/oraarch/EB3arch1_6619_788438682.dbf<
    12:10:21.247 [28354] <2> backint_find_master_time:      bid = >VXF1369049368< dest_dir = >/tmp<
    12:10:21.247 [28354] <2> backint_find_master_time:      start_unix_time = 1369049368 ; end_unix_time = 1369049368 ; image_time = 0
    12:10:21.247 [28354] <2> backint_find_master_time:      found = 0 ; raw_par = 0 ; time_pos = 0 file_size = 0
    12:10:21.247 [28354] <2> backint_find_master_time: exit status = 2
    12:10:21.247 [28354] <4> backint_do_restore: #NOTFOUND /oracle/EB3/oraarch/EB3arch1_6619_788438682.dbf
    12:10:21.247 [28354] <4> do_restore: Exit.
    12:10:21.247 [28354] <4> /usr/openv/netbackup/bin/backint 7.1: ********************************************************************************

  • Flako's avatar
    Flako
    Level 3
    12 years ago

    The "bprestore -t 17 /oracle/EB3/oraarch/EB3arch1_6619_788438682.dbf" gives a "SAP Policy restore error (2822)"  ???    %-(

  • Nicolai's avatar
    Nicolai
    Moderator
    12 years ago

    From log file:

    12:10:21.023 [28354] <2> get_pref_netconnection: ../../libvlibs/vnet_addrinfo.c.4962: 0: Override REQUIRED_INTERFACE resolves to: : 10.100.200.90

    Does the system uses/has multiple network interfaces and names ?. Are the client name in bp.conf and .util file  EXACTLY (including domain) the same. 

    /usr/openv/netbackup/bin/bplist -t 17 -X -U -B -R -l -b -S dsnnbus1 -C dsneb3 -keyword "" -s 1369049368 -e 1369049368 /

    Does the above bplist command work if yo run it by hand.

     

  • Flako's avatar
    Flako
    Level 3
    12 years ago

    First.  THANX a lot.

    I figured out to restore the File with bprestore.

    That does not solve why not to restore via SAP Tools.

    Will check your entries next.

    Just wanted to give you feedback that i i'm back in Game.    ;-)

  • Nicolai's avatar
    Nicolai
    Moderator
    12 years ago

    Glad to hear :-)

    Please share what you did. We may have another user tomorrow with the same issues ;-)

  • Flako's avatar
    Flako
    Level 3
    12 years ago

    Your bprestore got it !

    I know every Backup was correct.

    I saw everything correct with 'bplist -t 17 ...' and 'bpimagelist ...'  .

    Following bprestore was succesful:

     

    bprestore   -t 17

                    -C <clientname>

                    -D <clientname>

                    -S <mastername>

                    -p <policyname>

                    -L <logfile>

                    -s mm/dd/yyyy hh:mm:ss

                    -e mm/dd/yyyy hh:mm:ss

                    <logfilename>

     

    With some more time i maybe able to strip the CMD down to some shorter way.

    Now i will search, why my brtools dont work.

    Thanx again to Nicolai. He gave me the Tip to try the Restore with 'bprestore -t 17 ...'