Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

SAP Redirected Restore

Created: 27 Dec 2012 • Updated: 07 Mar 2013 | 5 comments
This issue has been solved. See solution.

 

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

Comments 5 CommentsJump to latest comment

RamNagalla's picture

hi

http://www.symantec.com/business/support/index?pag...

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.

SOLUTION
Nicolai's picture

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.

Assumption is the mother of all mess ups.

If this post answered your'e qustion -  Please mark as a soloution.

Amit_Bhabal's picture

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

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

 

Amit_Bhabal's picture

After changing UID & GID restore is working ok.

Marianne's picture

17 January:

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

7 March:

After changing UID & GID restore is working ok.

 

surprise  indecision  surprise

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links