UNSOLVED
Recover SAP archive
Hello all,
We need recover one SAP offline redolog. The number of sequence is the 195623. When we run:
C:\winnt\sapcluster>brrestore -a P53,195623
output of command shows an error which it says does not find the file rdqmmamn.rsa. We think the extension .rsa means recovery sap file. After, we have looked for it for the SAP Server but does not appear.We would like to know what is the utility of .rsa file and which is the reason why we haven't found the file in the SAP Server.
We think rdqmmamn.rsa is an index where SAP consults where it have to search for recover the requested file, is this right?
Thanks very much.
We need recover one SAP offline redolog. The number of sequence is the 195623. When we run:
C:\winnt\sapcluster>brrestore -a P53,195623
output of command shows an error which it says does not find the file rdqmmamn.rsa. We think the extension .rsa means recovery sap file. After, we have looked for it for the SAP Server but does not appear.We would like to know what is the utility of .rsa file and which is the reason why we haven't found the file in the SAP Server.
We think rdqmmamn.rsa is an index where SAP consults where it have to search for recover the requested file, is this right?
Thanks very much.
481
0
Posted May 28th, 2006 09:00
Hello Hrvoje,
rsa file isn't in $ORACLE_HOME/sapbackup, it is the first place where we looked.
NW and SAP logs are correct. In fact , we have recovered the archive of the following way:
mminfo -avot -q "group=Group_SAP_archives" -r "volume,savetime(30),savetime dateY,ssid"
recover -vvv -s Backup_Server -S ssid1 -S ssid2 -S ssid3 ...
Finally one of the recovered ssid contained the archive that we needed . We have already opened case with SAP support.
Thanks indeed!481
0
Posted May 28th, 2006 09:00
Yes, saveset recover will work if you have in init file setting... grrr I forgot what it is, but it has to be set to old (doen't have that file here to check it out).481
0
Posted May 29th, 2006 07:00
When I have a response from SAP support I will send you it
Thanks!481
1
Posted May 29th, 2006 07:00
Yes, saveset recover will work if you have in init file setting... grrr I forgot what it is, but it has to be set to old (doen't have that file here to check it out).
Actually, it is util file and value is ssNameFormat. From util file:# Please be aware that setting ssNameFormat=new will eliminate the # possibility of recovering the database with NetWorker recover -S and brrestore # will be the only alternative to recover the savesets. Recovering with # NetWorker recover is at your sole discretion. # ssNameFormat = old
Without that even ssid recover would not work.481
0
Posted May 29th, 2006 08:00
None that I'm aware of.481
0
Posted May 29th, 2006 08:00
In our case, util file shows:
# Default Value : old
# Valid Values : old/new
# This variable controls the saveset naming convention. If the
# value is "old" the saveset name for ALL bakups is "backint: ". If
# the value is "new" the saveset name for each session will differ according
# to the files being backed up. the saveset name will be
# "backint: : .
#
# ssNameFormat = old
If ssNameFormat = old, can we recover by brrestore?481
0
Posted May 29th, 2006 08:00
Yes you can. The "only" difference between ssNameFormat = old and ssNameFormat = new in this case would be when you are doing restore via recover command. With this field set to old you can do saveset recover as you did. In case that you had this set to new than restore via recover would not be possible anymore. So this value just affects the way saveset name is formatted - and on that usability of saveset recover depends (recover -s ... -S ssidX).481
0
Posted May 29th, 2006 08:00
Thanks very much!!!
The last question that I do to you is:
Could be that some parameter of the files .utl, .sap or .cfg have caused that the file .rsa was not in the SAP Server?
ble1
6 Operator
•
14354 Posts
•
56186 Points
481
1
Posted May 27th, 2006 07:00
In there you should have timestamp_encoded_rsa.
rsa file is restore archive files index (you may have rsb abd rsf too). I have no idea why you don't have that file, but you may wish to innspect both NW and SAP logs for backup which you believe you have. Also, involving SAP support would be a good idea at this point.