SAP Redirected Restore

[Amit_Bhabal]

bash-3.2$ brrestore -d util_file -a 110232 -m /usr/sap/VEP/ASCS00

BR0401I BRRESTORE 7.20 (22)

BR0405I Start of file restore: rekerfko.rsa 2012-12-27 16.50.14

BR0484I BRRESTORE log file: /oracle/VEP/sapbackup/rekerfko.rsa

BR0414I Offline redolog file for restore of database instance VEP: 110232

BR0280I BRRESTORE time stamp: 2012-12-27 16.50.15

BR0407I Restore of database: VEP

BR0408I BRRESTORE action ID: rekerfko

BR0409I BRRESTORE function ID: rsa

BR0419I Files will be restored from backup: aejyxwab.svd 2012-11-27 07.37.13

BR0416I 1 file found to restore, size 26.186 MB

BR0421I Restore device type: util_file

BR0280I BRRESTORE time stamp: 2012-12-27 16.50.15

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:

c

BR0280I BRRESTORE time stamp: 2012-12-27 16.50.20

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRRESTORE time stamp: 2012-12-27 16.50.20

BR0229I Calling backup utility with function 'restore'...

BR0278I Command output of '/usr/sap/VEP/SYS/exe/run/backint -u VEP -f restore -i /oracle/VEP/sapbackup/.rekerfko.lst -t file -p /oracle/VEP/112_64/dbs/initVEP.utl':

********************************************************************************

Program:                /usr/sap/VEP/SYS/exe/run/backint 7.1

Input File:             /oracle/VEP/sapbackup/.rekerfko.lst

Profile:                /oracle/VEP/112_64/dbs/initVEP.utl

Function:               RESTORE

********************************************************************************

[24469.00] Restore started Thu Dec 27 16:50:20 2012

[24469.00]

[24469.00]

[24469.00] 16:50:21 (42164.xxx) Restore job id 42164 will require 1 image.

[24469.00] 16:50:21 (42164.xxx) Media id WKLQAL is needed for the restore.

[24469.00]

[24469.00] 16:50:26 (42164.001) Restoring from copy 1 of image created Tue Nov 27 07:38:21 2012

[24469.00] 16:50:28 (42164.001) TAR STARTED 24486

[24469.00] 16:50:28 (42164.001) INF - If Media id WKLQAL is not in a robotic library administrative interaction may be required to satisfy this mount request.

[24469.00] 16:50:29 (42164.001) INF - No drives available or requesting resources

[24469.00] 16:51:02 (42164.001) INF - Waiting for mount of media id WKLQAL on server vepldc-db for reading.

[24469.00] 16:52:03 (42164.001) INF - Waiting for positioning of media id WKLQAL on server vepldc-db for reading.

[24469.00] 16:53:04 (42164.001) INF - Beginning restore from server vepldc-db to client velldc-bkrt.

[24469.00] 16:53:05 (42164.001) /oracle/VEP/oraarch/VEParch1_110232_782304565.dbf

[24469.00] 16:53:05 (42164.001) Read access to /oracle/VEP/oraarch/VEParch1_110232_782304565.dbf was denied

[24469.00] 16:53:05 (42164.001) INF - TAR EXITING WITH STATUS = 0

[24469.00] 16:53:05 (42164.001) INF - TAR RESTORED 0 OF 1 FILES SUCCESSFULLY

[24469.00] 16:53:05 (42164.001) INF - TAR KEPT 0 EXISTING FILES

[24469.00] 16:53:05 (42164.001) INF - TAR PARTIALLY RESTORED 0 FILES

[24469.00]

[24469.00] 16:53:06 (42164.001) Status of restore from copy 1 of image created Tue Nov 27 07:38:21 2012 = the restore failed to recover the requested files

[24469.00]

[24469.00] 16:53:07 INF - Server status = 2826

[24469.00] 16:53:08 (42164.xxx) INF - Status = invalid error number.

[24469.00]

********************************************************************************

BR0374E 0 of 1 file restored by backup utility

BR0280I BRRESTORE time stamp: 2012-12-27 16.53.19

BR0231E Backup utility call failed

BR0406I End of file restore: rekerfko.rsa 2012-12-27 16.53.19

BR0280I BRRESTORE time stamp: 2012-12-27 16.53.19

BR0404I BRRESTORE terminated with errors

bash-3.2$

Getting above error while running SAP redirected restore.

Netbackup 7.1

Master, Media & Client - Solaris 10

Not able to find any solution.

Regards,

Amit Bhabal

[RamNagalla · Accepted solution]

hi

http://www.symantec.com/business/support/index?page=content&id=TECH54998

When performing an SAP redirected restore, the user ID being used for the restore must have read permissions to the backup information and write permissions to the target location.  Usually, the user id and group id are the same, but sometimes this is not possible. In these cases, the user id or group id needs to have permissions as described above because of the way the original user saves the data during the backup.

If this error occurs, it is possible to restore the controlfile using the bprestore command (running as root) to recover the missing files, then manually copying them to the location necessary for the new database.

so you may need to check with the user who iniciated the restore about the permissions .

hope this helps.

[Nicolai]

Follow up to Nagalla post. Ensure the group id (usually dba) is the same on both source and destination.

If not the same - edit group ID's - Restart Oracle (needed) and take a new backup.

[Amit_Bhabal]

I am using same user id as Prod server is using.

Taken new Backup of Production Database , but still getting same error.

[Amit_Bhabal]

After changing UID & GID restore is working ok.

[Marianne]

17 January:

I am using same user id as Prod server is using.

7 March:

After changing UID & GID restore is working ok.