Unsolved
This post is more than 5 years old
12 Posts
0
1799
nmsap - brrestore is failing to retrieve files
Hi,
i have a very strange issue at one of our SAP hosts.
I installed & configured all hosts by script completely identical to backup $SID using nmsap v 4.2.0.1-1.
At one of this hosts the command
brrestore -p init$SID.sap -a 3345 -d util_file -r /oracle/$SID/112_64/dbs/init$SID.utl -k no -l E -i 30
fails with strange error message
52821 05/16/2013 01:47:37 PM 2 0 0 3830896384 30485 0 zenms299.gh.de backint 30497: started
70922 05/16/2013 01:47:39 PM 2 0 0 2461558528 30497 0 zenms299.gh.de backint Backint exiting at with fatal error: Error opening input file: No such file or directory.
18416 05/16/2013 01:47:39 PM 2 0 0 3830896384 30485 0 zenms299.gh.de backint Child process 30497 output file could not be opened! Error: No such file or directory
I tried the strace command to find the file to be opened, but this was not very helpfull. But great supprise adding the lines
nsr_debug_msg = TRUE
debug_level = 6
to the init.utl file (not 0-5, but 6 to 9 are working) is causing a lot of mgs ... and the restore to run without failures.
Is this issue known? Do you have some idea or hint to look at?
TIA, Michael
ble1
2 Intern
2 Intern
•
14.3K Posts
0
May 21st, 2013 00:00
What is the backint build you use? I use 300+ and no GA version and I have never seen issue like this. Further, if you specify sap file, not need to specify utl file as sap file should already have reference to utl file (check that they are the same as you used in CLI). Next, input file backint is complaining is list of files needed for restore which is generated by BRTools as per backup file list (for archive logs /oracle/$SID/saparch and for DB /oracle/$SID/sapbackup). If this is not generated or access to that file (due to permissions) is not possible, you can get message as above. I assume you are running restore as oracle user (ora$SID)?
mschwarzer
12 Posts
0
May 21st, 2013 03:00
Hi,
yes, i start the brrecover under ora$SID user and the build version used at the SAP systems is the LNMs_2011.Build.281, which is version 4.2.0.1-1. I truncated the call to the command brtools is executing to recover the needed archlog.
Your assumtion regarding the permissions was one i checked. There are write permissions for /oracle/$SID/sapbackup to the ora$SID user, also to the /nsr/applogs directory and execute on /usr/sap/$SID/SYS/exe/run/brrecover, both with sticky bit on it.
backup, recovery scheduled and manual is working fine unless i do not decrease the debug level under 6. wich meens from my point of view permissions are not a problem. There are messages in the raw file which do not appear in the debug log. Could it be that this behavior is related to message rendering? And were can i get the 300+ no GA build of package?
BR, Michael
ble1
2 Intern
2 Intern
•
14.3K Posts
1
May 21st, 2013 05:00
You need to open a ticket with support and request latest binary. I certainly never saw this issue before, but then again I never run GA version neither.
mcella
5 Posts
0
July 16th, 2013 11:00
Hi,
I have the same problem "Backint exiting at with fatal error: Error opening input file: No such file or directory"
Do you have opened a case ?
Do you have solved the problem ?
Thanks in advance.