This post is more than 5 years old
6 Posts
0
9578
Restore oracle database to different client using networker
Hi,
We have Networker installed in a windows server machine (2008R2), version 8.0.2. We are using it to backup all our oracle/sap databases that are hosted in many IBM AIX 7.1 machines. We have DEV, QA e Prod machives. The backup and restore we are using the BRTOOLS and it works quite successful. Now, we have to restore some databases from PROD to QA for tests. We have copied that necessary files (sapbackup files, .ult file, .sap file, etc) from our source to the target machine. But when we start the recover, the logs show "permission denied" and we are not able to recover the files. We have already checked the configuration in the networker regarding our source and target client and both have the "@" in the remote access (globals 2 of 2).
Please, any help is welcome!
Regards,
Rafael Melo
ble1
2 Intern
2 Intern
•
14.3K Posts
0
May 15th, 2014 12:00
Try to add *@* on admin server list. Permission denied in this case might also be permision on UNIX system, but from the error log we can't see that really. I assume backint is owned as sapadm user? Sometimes, when permissions are not set as they should, changing it to root and adding suid bit might do the trick, but this is now guess works as I can't really say what is the issue in your case. We do this on regular basis on both AIX and HPUX and I never had this issue.
Alternative, if in hurry, is to do ssid restore which will work just fine too, but obviously you wish to have this handled by brtools.
ble1
2 Intern
2 Intern
•
14.3K Posts
0
May 15th, 2014 11:00
Can you paste the whole log here please?
Rafael_Melo
6 Posts
0
May 15th, 2014 12:00
And this is the log generate by brtools
BR0401I BRRESTORE 7.20 (30)
BR0405I Start of file restore: renwagqd.rsb 2014-05-15 15.35.39
BR0484I BRRESTORE log file: /oracle/TDE/sapbackup/renwagqd.rsb
BR0101I Parameters
Name Value
oracle_sid TDE
oracle_home /oracle/TDE/112_64
oracle_profile /oracle/TDE/112_64/dbs/initTDE.ora
sapdata_home /oracle/TDE
sap_profile /oracle/TDE/112_64/dbs/initTDE.sap
recov_interval 30
restore_mode ALL
backup_dev_type util_file
util_par_file /oracle/TDE/112_64/dbs/initTDE.utl
util_path /sapmnt/TDE/exe
system_info oratde/oratde myserver01 AIX 1 7 000952EBD400
oracle_info TDE 11.2.0.3.0
make_info rs6000_64 OCI_112 Feb 9 2013
command_line brrestore -m all -d util_file -r initTDE.utl
BR0454W Values of oracle_sid are different: current 'TDE', backup benvtxzq.anf 'CDE'
BR0455W Value 'TDE' of oracle_sid will be used for restore
BR0454W Values of oracle_home are different: current '/oracle/TDE/112_64', backup benvtxzq.anf '/oracle/CDE/112_64'
BR0455W Value '/oracle/TDE/112_64' of oracle_home will be used for restore
BR0454W Values of sapdata_home are different: current '/oracle/TDE', backup benvtxzq.anf '/oracle/CDE'
BR0455W Value '/oracle/TDE' of sapdata_home will be used for restore
BR0280I BRRESTORE time stamp: 2014-05-15 15.35.39
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:
BR0280I BRRESTORE time stamp: 2014-05-15 15.35.40
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
BR0427I Files from the old sapdata_home /oracle/CDE will be restored into the new sapdata_home /oracle/TDE
BR0456I Probably the database must be recovered due to restore from online backup
BR0280I BRRESTORE time stamp: 2014-05-15 15.35.40
BR0407I Restore of database: TDE
BR0408I BRRESTORE action ID: renwagqd
BR0409I BRRESTORE function ID: rsb
BR0449I Restore mode: ALL
BR0419I Files will be restored from backup: benvtxzq.anf 2014-05-14 08.40.46
BR0416I 84 files found to restore, total size 235028.656 MB
BR0421I Restore device type: util_file
BR0280I BRRESTORE time stamp: 2014-05-15 15.35.40
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:
BR0280I BRRESTORE time stamp: 2014-05-15 15.35.41
BR0257I Your reply: 'c'
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
BR0280I BRRESTORE time stamp: 2014-05-15 15.35.41
BR0229I Calling backup utility with function 'restore'...
BR0278I Command output of '/sapmnt/TDE/exe/backint -u CDE -f restore -i /oracle/TDE/sapbackup/.renwagqd.lst -t file -p /oracle/TDE/112_64/dbs/initTDE.utl':
BR0375E Backup utility has reported an error while restoring file /oracle/TDE/sapdata1/undo_1/undo.data1
BR0278E Command output of '/sapmnt/TDE/exe/backint -u CDE -f restore -i /oracle/TDE/sapbackup/.renwagqd.lst -t file -p /oracle/TDE/112_64/dbs/initTDE.utl':
BR0375E Backup utility has reported an error while restoring file /oracle/TDE/sapdata2/sr3_6/sr3.data6
BR0375E Backup utility has reported an error while restoring file /oracle/TDE/sapdata2/sr3_2/sr3.data2
BR0375E Backup utility has reported an error while restoring file /oracle/TDE/sapdata3/sr3731x_3/sr3731x.data3
BR0375E Backup utility has reported an error while restoring file /oracle/TDE/sapdata2/sr3_3/sr3.data3
BR0375E Backup utility has reported an error while restoring file /oracle/TDE/sapdata2/sr3_4/sr3.data4
BR0375E Backup utility has reported an error while restoring file /oracle/TDE/sapdata2/sr3_5/sr3.data5
BR0375E Backup utility has reported an error while restoring file /oracle/TDE/sapdata4/sr3usr_1/sr3usr.data1
BR0280I BRRESTORE time stamp: 2014-05-15 15.37.42
BR0279E Return code from '/sapmnt/TDE/exe/backint -u CDE -f restore -i /oracle/TDE/sapbackup/.renwagqd.lst -t file -p /oracle/TDE/112_64/dbs/initTDE.utl': 2
BR0374E 0 of 84 files restored by backup utility
BR0280I BRRESTORE time stamp: 2014-05-15 15.37.42
BR0231E Backup utility call failed
BR0406I End of file restore: renwagqd.rsb 2014-05-15 15.37.42
BR0280I BRRESTORE time stamp: 2014-05-15 15.37.42
BR0404I BRRESTORE terminated with errors
Regards,
Rafael
Rafael_Melo
6 Posts
0
May 15th, 2014 12:00
This is the backint.log ( I cut out repeated information)
bash-3.2$ vi backintTDE.log
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 28 lg_open(): Calling open64().
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 49 -------------------------------------------------
18448 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 36 Starting Backint for NetWorker at %s 1 35 15 May 15 15:35:42
74295 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 17 Release : %s (%s) 2 0 7 4.2.0.1 0 19 LNMs_2011.Build.281
18517 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 18 Architecture : %s 1 0 11 IBM RS/6000
18518 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 18 CPU Type : %s 1 0 7 PowerPC
18519 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 18 OS Name : %s 1 0 7 AIX 7.1
18520 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 18 Number of CPU : %d 1 1 2 12
18521 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 18 Client OS : %s 1 0 5 AixOS
52856 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 18 Local Host : %s 1 12 21 myserver.mydomian.com.br
52841 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 19 Reading input file. 0
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 74 1400067666 /oracle/CDE/sapdata2/sr3_1/sr3.data1 /oracle/TDE/sapdata2/sr3_1
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 77 1400068137 /oracle/CDE/sapdata2/sr3_23/sr3.data23 /oracle/TDE/sapdata2/sr3_23
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 74 1400067675 /oracle/CDE/sapdata2/sr3_3/sr3.data3 /oracle/TDE/sapdata2/sr3_3
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 74 1400067672 /oracle/CDE/sapdata2/sr3_4/sr3.data4 /oracle/TDE/sapdata2/sr3_4
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 74 1400067663 /oracle/CDE/sapdata2/sr3_5/sr3.data5 /oracle/TDE/sapdata2/sr3_5
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 74 1400067678 /oracle/CDE/sapdata2/sr3_6/sr3.data6 /oracle/TDE/sapdata2/sr3_6
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 74 1400067754 /oracle/CDE/sapdata2/sr3_7/sr3.data7 /oracle/TDE/sapdata2/sr3_7
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 74 1400067795 /oracle/CDE/sapdata2/sr3_8/sr3.data8 /oracle/TDE/sapdata2/sr3_8
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 74 1400067958 /oracle/CDE/sapdata2/sr3_9/sr3.data9 /oracle/TDE/sapdata2/sr3_9
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 77 1400067952 /oracle/CDE/sapdata2/sr3_10/sr3.data10 /oracle/TDE/sapdata2/sr3_10
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 77 1400067821 /oracle/CDE/sapdata2/sr3_11/sr3.data11 /oracle/TDE/sapdata2/sr3_11
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 77 1400067854 /oracle/CDE/sapdata2/sr3_12/sr3.data12 /oracle/TDE/sapdata2/sr3_12
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 77 1400067907 /oracle/CDE/sapdata2/sr3_13/sr3.data13 /oracle/TDE/sapdata2/sr3_13
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 77 1400067943 /oracle/CDE/sapdata2/sr3_14/sr3.data14 /oracle/TDE/sapdata2/sr3_14
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 77 1400067946 /oracle/CDE/sapdata2/sr3_15/sr3.data15 /oracle/TDE/sapdata2/sr3_15
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 77 1400067955 /oracle/CDE/sapdata2/sr3_16/sr3.data16 /oracle/TDE/sapdata2/sr3_16
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 77 1400067828 /oracle/CDE/sapdata2/sr3_17/sr3.data17 /oracle/TDE/sapdata2/sr3_17
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 77 1400067903 /oracle/CDE/sapdata2/sr3_18/sr3.data18 /oracle/TDE/sapdata2/sr3_18
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 77 1400067812 /oracle/CDE/sapdata2/sr3_19/sr3.data19 /oracle/TDE/sapdata2/sr3_19
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 77 1400067815 /oracle/CDE/sapdata2/sr3_20/sr3.data20 /oracle/TDE/sapdata2/sr3_20
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 77 1400067784 /oracle/CDE/sapdata2/sr3_21/sr3.data21 /oracle/TDE/sapdata2/sr3_21
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 77 1400067818 /oracle/CDE/sapdata2/sr3_22/sr3.data22 /oracle/TDE/sapdata2/sr3_22
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 74 1400067654 /oracle/CDE/sapdata2/sr3_2/sr3.data2 /oracle/TDE/sapdata2/sr3_2
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068366 /oracle/CDE/sapdata4/sr3731_25/sr3731.data25 /oracle/TDE/sapdata4/sr3731_25
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068328 /oracle/CDE/sapdata4/sr3731_26/sr3731.data26 /oracle/TDE/sapdata4/sr3731_26
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068348 /oracle/CDE/sapdata4/sr3731_27/sr3731.data27 /oracle/TDE/sapdata4/sr3731_27
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068331 /oracle/CDE/sapdata4/sr3731_28/sr3731.data28 /oracle/TDE/sapdata4/sr3731_28
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068335 /oracle/CDE/sapdata4/sr3731_29/sr3731.data29 /oracle/TDE/sapdata4/sr3731_29
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068339 /oracle/CDE/sapdata4/sr3731_30/sr3731.data30 /oracle/TDE/sapdata4/sr3731_30
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068146 /oracle/CDE/sapdata4/sr3731_31/sr3731.data31 /oracle/TDE/sapdata4/sr3731_31
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068181 /oracle/CDE/sapdata4/sr3731_32/sr3731.data32 /oracle/TDE/sapdata4/sr3731_32
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068289 /oracle/CDE/sapdata4/sr3731_33/sr3731.data33 /oracle/TDE/sapdata4/sr3731_33
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068325 /oracle/CDE/sapdata4/sr3731_34/sr3731.data34 /oracle/TDE/sapdata4/sr3731_34
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068356 /oracle/CDE/sapdata4/sr3731_35/sr3731.data35 /oracle/TDE/sapdata4/sr3731_35
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068369 /oracle/CDE/sapdata4/sr3731_36/sr3731.data36 /oracle/TDE/sapdata4/sr3731_36
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068363 /oracle/CDE/sapdata1/sr3731_37/sr3731.data37 /oracle/TDE/sapdata1/sr3731_37
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068351 /oracle/CDE/sapdata1/sr3731_38/sr3731.data38 /oracle/TDE/sapdata1/sr3731_38
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068342 /oracle/CDE/sapdata1/sr3731_39/sr3731.data39 /oracle/TDE/sapdata1/sr3731_39
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068359 /oracle/CDE/sapdata1/sr3731_40/sr3731.data40 /oracle/TDE/sapdata1/sr3731_40
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 83 1400068241 /oracle/CDE/sapdata4/sr3731_1/sr3731.data1 /oracle/TDE/sapdata4/sr3731_1
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 83 1400068256 /oracle/CDE/sapdata4/sr3731_2/sr3731.data2 /oracle/TDE/sapdata4/sr3731_2
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 83 1400068143 /oracle/CDE/sapdata4/sr3731_3/sr3731.data3 /oracle/TDE/sapdata4/sr3731_3
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 83 1400068149 /oracle/CDE/sapdata4/sr3731_4/sr3731.data4 /oracle/TDE/sapdata4/sr3731_4
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 83 1400068184 /oracle/CDE/sapdata4/sr3731_5/sr3731.data5 /oracle/TDE/sapdata4/sr3731_5
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 83 1400068187 /oracle/CDE/sapdata4/sr3731_6/sr3731.data6 /oracle/TDE/sapdata4/sr3731_6
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 83 1400068190 /oracle/CDE/sapdata4/sr3731_7/sr3731.data7 /oracle/TDE/sapdata4/sr3731_7
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 83 1400068196 /oracle/CDE/sapdata4/sr3731_8/sr3731.data8 /oracle/TDE/sapdata4/sr3731_8
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 83 1400068199 /oracle/CDE/sapdata4/sr3731_9/sr3731.data9 /oracle/TDE/sapdata4/sr3731_9
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068202 /oracle/CDE/sapdata4/sr3731_10/sr3731.data10 /oracle/TDE/sapdata4/sr3731_10
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068206 /oracle/CDE/sapdata4/sr3731_11/sr3731.data11 /oracle/TDE/sapdata4/sr3731_11
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068226 /oracle/CDE/sapdata4/sr3731_12/sr3731.data12 /oracle/TDE/sapdata4/sr3731_12
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068238 /oracle/CDE/sapdata4/sr3731_13/sr3731.data13 /oracle/TDE/sapdata4/sr3731_13
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068247 /oracle/CDE/sapdata4/sr3731_14/sr3731.data14 /oracle/TDE/sapdata4/sr3731_14
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068304 /oracle/CDE/sapdata4/sr3731_15/sr3731.data15 /oracle/TDE/sapdata4/sr3731_15
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068300 /oracle/CDE/sapdata4/sr3731_16/sr3731.data16 /oracle/TDE/sapdata4/sr3731_16
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068296 /oracle/CDE/sapdata4/sr3731_17/sr3731.data17 /oracle/TDE/sapdata4/sr3731_17
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068293 /oracle/CDE/sapdata4/sr3731_18/sr3731.data18 /oracle/TDE/sapdata4/sr3731_18
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068317 /oracle/CDE/sapdata4/sr3731_19/sr3731.data19 /oracle/TDE/sapdata4/sr3731_19
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068281 /oracle/CDE/sapdata4/sr3731_20/sr3731.data20 /oracle/TDE/sapdata4/sr3731_20
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068278 /oracle/CDE/sapdata4/sr3731_21/sr3731.data21 /oracle/TDE/sapdata4/sr3731_21
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068271 /oracle/CDE/sapdata4/sr3731_22/sr3731.data22 /oracle/TDE/sapdata4/sr3731_22
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068314 /oracle/CDE/sapdata4/sr3731_23/sr3731.data23 /oracle/TDE/sapdata4/sr3731_23
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068307 /oracle/CDE/sapdata4/sr3731_24/sr3731.data24 /oracle/TDE/sapdata4/sr3731_24
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400067979 /oracle/CDE/sapdata3/sr3731x_1/sr3731x.data1 /oracle/TDE/sapdata3/sr3731x_1
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068003 /oracle/CDE/sapdata3/sr3731x_2/sr3731x.data2 /oracle/TDE/sapdata3/sr3731x_2
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400067660 /oracle/CDE/sapdata3/sr3731x_3/sr3731x.data3 /oracle/TDE/sapdata3/sr3731x_3
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068007 /oracle/CDE/sapdata3/sr3731x_4/sr3731x.data4 /oracle/TDE/sapdata3/sr3731x_4
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068051 /oracle/CDE/sapdata3/sr3731x_5/sr3731x.data5 /oracle/TDE/sapdata3/sr3731x_5
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068054 /oracle/CDE/sapdata3/sr3731x_6/sr3731x.data6 /oracle/TDE/sapdata3/sr3731x_6
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068062 /oracle/CDE/sapdata3/sr3731x_7/sr3731x.data7 /oracle/TDE/sapdata3/sr3731x_7
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068065 /oracle/CDE/sapdata3/sr3731x_8/sr3731x.data8 /oracle/TDE/sapdata3/sr3731x_8
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 86 1400068068 /oracle/CDE/sapdata3/sr3731x_9/sr3731x.data9 /oracle/TDE/sapdata3/sr3731x_9
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 89 1400068059 /oracle/CDE/sapdata3/sr3731x_10/sr3731x.data10 /oracle/TDE/sapdata3/sr3731x_10
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 89 1400068074 /oracle/CDE/sapdata3/sr3731x_11/sr3731x.data11 /oracle/TDE/sapdata3/sr3731x_11
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 89 1400068077 /oracle/CDE/sapdata3/sr3731x_12/sr3731x.data12 /oracle/TDE/sapdata3/sr3731x_12
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 89 1400068128 /oracle/CDE/sapdata3/sr3731x_13/sr3731x.data13 /oracle/TDE/sapdata3/sr3731x_13
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 89 1400068134 /oracle/CDE/sapdata3/sr3731x_14/sr3731x.data14 /oracle/TDE/sapdata3/sr3731x_14
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 89 1400068131 /oracle/CDE/sapdata3/sr3731x_15/sr3731x.data15 /oracle/TDE/sapdata3/sr3731x_15
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 89 1400068259 /oracle/CDE/sapdata3/sr3731x_16/sr3731x.data16 /oracle/TDE/sapdata3/sr3731x_16
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 83 1400068372 /oracle/CDE/sapdata4/sr3usr_1/sr3usr.data1 /oracle/TDE/sapdata4/sr3usr_1
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 77 1400067657 /oracle/CDE/sapdata1/undo_1/undo.data1 /oracle/TDE/sapdata1/undo_1
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 83 1400068265 /oracle/CDE/sapdata1/sysaux_1/sysaux.data1 /oracle/TDE/sapdata1/sysaux_1
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 83 1400068268 /oracle/CDE/sapdata1/system_1/system.data1 /oracle/TDE/sapdata1/system_1
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 83 1400068140 /oracle/CDE/sapdata1/system_2/system.data2 /oracle/TDE/sapdata1/system_2
52847 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 9 %d files. 1 1 2 84
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 0
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 0
18621 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 24 Server parallelism is %d 1 1 2 32
51478 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 25 Maximum parallelism is %d 1 1 1 8
0 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 2 %s 1 0 0
18730 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 31 %d recovery calls will be made. 1 1 2 84
18411 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 9 Files: %d 1 1 2 84
18412 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 12 Sessions: %d 1 1 2 84
18413 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 15 Parallelism: %d 1 1 1 8
52821 1400178942 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 12 %ld: started 1 2 8 13041794
52821 1400178943 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 12 %ld: started 1 2 7 7602422
52821 1400178943 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 12 %ld: started 1 2 7 6946862
52821 1400178943 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 12 %ld: started 1 2 8 11534544
52821 1400178943 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 12 %ld: started 1 2 7 9961564
52821 1400178943 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 12 %ld: started 1 2 7 8192000
52821 1400178943 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 12 %ld: started 1 2 8 12255386
52821 1400178943 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 12 %ld: started 1 2 7 5374108
0 1400178943 2 0 0 1 7602422 0 myserver.mydomian.com.br backint 2 %s 1 0 28 lg_open(): Calling open64().
0 1400178944 2 0 0 1 7602422 0 myserver.mydomian.com.br backint 2 %s 1 0 0
0 1400178944 2 0 0 1 7602422 0 myserver.mydomian.com.br backint 48 ------------------------------------------------ 0
39553 1400178944 2 0 0 1 7602422 0 myserver.mydomian.com.br backint 43 Starting batch recover with pid %lu at %s: 2 2 7 7602422 35 15 May 15 15:35:44
6494 1400178946 2 0 0 1 7602422 0 myserver.mydomian.com.br backint 21 %s: Permission denied 1 0 38 /oracle/CDE/sapdata1/undo_1/undo.data1
67847 1400178946 2 0 0 1 7602422 0 myserver.mydomian.com.br backint 27 Failed to recover files: %s 1 49 36 6211 2 %s 1 0 19 Nothing to recover
52905 1400178946 2 0 0 1 7602422 0 myserver.mydomian.com.br backint 37 Recover with pid %lu completed at %s 2 2 7 7602422 35 15 May 15 15:35:46
18418 1400178946 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 81 Session %d with pid %lu finished. Reported succeeded files: %d, failed files: %d. 4 1 1 1 2 7 7602422 1 1 0 1
1 1
52821 1400178946 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 12 %ld: started 1 2 7 7602424
0 1400178943 2 0 0 1 5374108 0 myserver.mydomian.com.br backint 2 %s 1 0 28 lg_open(): Calling open64().
0 1400178945 2 0 0 1 5374108 0 myserver.mydomian.com.br backint 2 %s 1 0 0
0 1400178945 2 0 0 1 5374108 0 myserver.mydomian.com.br backint 48 ------------------------------------------------ 0
39553 1400178945 2 0 0 1 5374108 0 myserver.mydomian.com.br backint 43 Starting batch recover with pid %lu at %s: 2 2 7 5374108 35 15 May 15 15:35:45
6494 1400178946 2 0 0 1 5374108 0 myserver.mydomian.com.br backint 21 %s: Permission denied 1 0 36 /oracle/CDE/sapdata2/sr3_6/sr3.data6
67847 1400178946 2 0 0 1 5374108 0 myserver.mydomian.com.br backint 27 Failed to recover files: %s 1 49 36 6211 2 %s 1 0 19 Nothing to recover
52905 1400178946 2 0 0 1 5374108 0 myserver.mydomian.com.br backint 37 Recover with pid %lu completed at %s 2 2 7 5374108 35 15 May 15 15:35:46
18418 1400178946 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 81 Session %d with pid %lu finished. Reported succeeded files: %d, failed files: %d. 4 1 1 7 2 7 5374108 1 1 0 1
1 1
1 1
52821 1400178946 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 12 %ld: started 1 2 7 5374110
0 1400178943 2 0 0 1 13041794 0 myserver.mydomian.com.br backint 2 %s 1 0 28 lg_open(): Calling open64().
0 1400178944 2 0 0 1 13041794 0 myserver.mydomian.com.br backint 2 %s 1 0 0
0 1400178944 2 0 0 1 13041794 0 myserver.mydomian.com.br backint 48 ------------------------------------------------ 0
39553 1400178944 2 0 0 1 13041794 0 myserver.mydomian.com.br backint 43 Starting batch recover with pid %lu at %s: 2 2 8 13041794 35 15 May 15 15:35:44
6494 1400178946 2 0 0 1 13041794 0 myserver.mydomian.com.br backint 21 %s: Permission denied 1 0 36 /oracle/CDE/sapdata2/sr3_2/sr3.data2
67847 1400178946 2 0 0 1 13041794 0 myserver.mydomian.com.br backint 27 Failed to recover files: %s 1 49 36 6211 2 %s 1 0 19 Nothing to recover
52905 1400178946 2 0 0 1 13041794 0 myserver.mydomian.com.br backint 37 Recover with pid %lu completed at %s 2 2 8 13041794 35 15 May 15 15:35:46
18418 1400178946 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 81 Session %d with pid %lu finished. Reported succeeded files: %d, failed files: %d. 4 1 1 0 2 8 13041794 1 1 0
1 1 1
52821 1400178946 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 12 %ld: started 1 2 7 6029336
0 1400178943 2 0 0 1 6946862 0 myserver.mydomian.com.br backint 2 %s 1 0 28 lg_open(): Calling open64().
0 1400178945 2 0 0 1 6946862 0 myserver.mydomian.com.br backint 2 %s 1 0 0
0 1400178945 2 0 0 1 6946862 0 myserver.mydomian.com.br backint 48 ------------------------------------------------ 0
39553 1400178945 2 0 0 1 6946862 0 myserver.mydomian.com.br backint 43 Starting batch recover with pid %lu at %s: 2 2 7 6946862 35 15 May 15 15:35:45
6494 1400178947 2 0 0 1 6946862 0 myserver.mydomian.com.br backint 21 %s: Permission denied 1 0 44 /oracle/CDE/sapdata3/sr3731x_3/sr3731x.data3
67847 1400178947 2 0 0 1 6946862 0 myserver.mydomian.com.br backint 27 Failed to recover files: %s 1 49 36 6211 2 %s 1 0 19 Nothing to recover
52905 1400178947 2 0 0 1 6946862 0 myserver.mydomian.com.br backint 37 Recover with pid %lu completed at %s 2 2 7 6946862 35 15 May 15 15:35:47
18418 1400178947 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 81 Session %d with pid %lu finished. Reported succeeded files: %d, failed files: %d. 4 1 1 2 2 7 6946862 1 1 0 1
1 1
52821 1400178947 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 12 %ld: started 1 2 7 6946864
0 1400178943 2 0 0 1 12255386 0 myserver.mydomian.com.br backint 2 %s 1 0 28 lg_open(): Calling open64().
0 1400178947 2 0 0 1 12255386 0 myserver.mydomian.com.br backint 2 %s 1 0 0
0 1400178947 2 0 0 1 12255386 0 myserver.mydomian.com.br backint 48 ------------------------------------------------ 0
39553 1400178947 2 0 0 1 12255386 0 myserver.mydomian.com.br backint 43 Starting batch recover with pid %lu at %s: 2 2 8 12255386 35 15 May 15 15:35:47
6494 1400178948 2 0 0 1 12255386 0 myserver.mydomian.com.br backint 21 %s: Permission denied 1 0 36 /oracle/CDE/sapdata2/sr3_3/sr3.data3
67847 1400178948 2 0 0 1 12255386 0 myserver.mydomian.com.br backint 27 Failed to recover files: %s 1 49 36 6211 2 %s 1 0 19 Nothing to recover
52905 1400178948 2 0 0 1 12255386 0 myserver.mydomian.com.br backint 37 Recover with pid %lu completed at %s 2 2 8 12255386 35 15 May 15 15:35:48
18418 1400178948 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 81 Session %d with pid %lu finished. Reported succeeded files: %d, failed files: %d. 4 1 1 6 2 8 12255386 1 1 0
1 1 1
52821 1400178948 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 12 %ld: started 1 2 8 12255388
0 1400179061 2 0 0 1 11534564 0 myserver.mydomian.com.br backint 48 ------------------------------------------------ 0
39553 1400179061 2 0 0 1 11534564 0 myserver.mydomian.com.br backint 43 Starting batch recover with pid %lu at %s: 2 2 8 11534564 35 15 May 15 15:37:41
6494 1400179062 2 0 0 1 11534564 0 myserver.mydomian.com.br backint 21 %s: Permission denied 1 0 42 /oracle/CDE/sapdata4/sr3usr_1/sr3usr.data1
67847 1400179062 2 0 0 1 11534564 0 myserver.mydomian.com.br backint 27 Failed to recover files: %s 1 49 36 6211 2 %s 1 0 19 Nothing to recover
52905 1400179062 2 0 0 1 11534564 0 myserver.mydomian.com.br backint 37 Recover with pid %lu completed at %s 2 2 8 11534564 35 15 May 15 15:37:42
18418 1400179062 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 81 Session %d with pid %lu finished. Reported succeeded files: %d, failed files: %d. 4 1 2 83 2 8 11534564 1 1 0
1 1 1
18423 1400179062 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 24 %d of %d files reported. 2 1 2 84 1 2 84
18514 1400179062 2 0 0 1 7929934 0 myserver.mydomian.com.br backint 24 %d of %d files %s at %s. 4 1 1 0 1 2 84 0 8 restored 35 15 May 15 15:37:42
Regards.
Rafael
Rafael_Melo
6 Posts
0
May 15th, 2014 13:00
Where is this "admin server list"? On the networker server or on my client (AIX)?
This client (dev) where a i am trying to restore a database (from other client-prod), has its own backup done by networker in the past days. So, i'm able do drop all files and restore it all again from brrestore/backint/networker.
I've checked the backint ownership and i saw that it is owned by root:system.
When in my client (dev), i change the .utl file and set the client as "my prod server", the brrestore restore all the folders regarding the prod structure into my sapdata* but the files not. So, my opinion is that this permission error is not about the UNIX permission (my opinion). I looks like the networker server does not permit other client other than that one that have done the backup to restore it.
We are new about using brtools/sap/networker. We have networker for some time, but for FS, SQL Server, etc. Now, we are deploying SAP system and we got a new structure with datadomain.
p.s: sorry my poor English.
Regards,
Rafael
ble1
2 Intern
2 Intern
•
14.3K Posts
0
May 15th, 2014 13:00
You will find under server properties (in NMC) or (it is the same) under User groups resources.
If it is owned by root, it should be suid. Normally, it should be owned by sapuser and appropriate group (dba most likely). There is SAP article about it. Normal permission set is something like:
me@myself:/usr/sap/SID/SYS/exe/run
$ ll b*
-rwxr-xr-x 1 sidadm sapsys 15564992 Feb 26 11:13 backint
-rwsrwxr-- 1 orasid sapsys 15555112 May 13 2011 brarchive
-rwsrwxr-- 1 orasid sapsys 16127440 May 13 2011 brbackup
-rwsrwxr-- 1 orasid sapsys 20410056 May 13 2011 brconnect
-rwxr-xr-x 1 sidadm sapsys 16767088 May 13 2011 brrecover
-rwxr-xr-x 1 sidadm sapsys 6981152 May 13 2011 brrestore
-rwxr-xr-x 1 sidadm sapsys 22245280 May 13 2011 brspace
-rwxr-xr-x 1 sidadm sapsys 9050680 May 13 2011 brtools
Permission on BRTools and backint are strictly defined by SAP and essential for correct and error free workflow so you better check those too.
Rafael_Melo
6 Posts
0
May 15th, 2014 14:00
Hrvoje Crvelin,
I have started be brrestore with the root user and now i'm able to restore the datafiles.... (The restore is running right now.... doesn't finished yet)
Your points where really valuable. Now, i wondering to discover why root user was necessary since the user i was using has permission to create file/folder in the oracle database path, permission to restore its own database, to execute brtools.. Why?
Best Regards,
Rafael Melo
ble1
2 Intern
2 Intern
•
14.3K Posts
0
May 15th, 2014 15:00
This usually happens when BRTools set is not set with right permissions or overall permission set on folders is not right. Usually SAP guys run saproot.sh to adjust this permissions, but sometimes it may be needle in the haystack finding it really where it breaks and why.
Rafael_Melo
6 Posts
0
May 16th, 2014 07:00
I restored successfully the database using root. I noticed that the user and group id are different from my source and target machine. I think this is why i wasn't able to restore using my target sap user. But, thanks God (and your help, lol) i restore my database.
Once one, thank you for your valuable time and patience!
Regards,
Rafael Melo