Quality Refresh

[Former Member]

Hi Gurus,

I am working as senior basis consultant.

I am doing the Quality refresh.

I have 3 instances in a single host.

solman, dev and quality.

I have taken the offline backup of prd.

while restoring the database from TSM server it is showing the error permission denied.

when I have checked the data file it is showing solution manager ora user as owner.

please give some hint so that I can proceed forward.

Thanks in advance.

Biswajit

[Former Member]

Hello,

please check the permissions of the brtools (note 113747).

Regards

Christian

[Former Member]

Hi All,

Thanks a Lot !! The problem has been resolved. The issue was in my TSM server. The data cannot properly transfering. I have restore one by one using backfm. and then change the ownership and permission.

Biswajit

[Former Member]

BKI4001E: File '/oracle/HRQ/sapdata1/sr3700_2/sr3700.data2' cannot be created. Reason: errno(13) Permi
ssion denied

Check whether you have permissions to create a folder sr3700_2 or not?

If not- as a workaround just give full access to your /oracle/SID, perform a restore and then revert/correct the permisions on FSs.

Regards,

Nick Loy

[markus_doehr2]

> while restoring the database from TSM server it is showing the error permission denied.

What is the exact error message and which tools is giving that error?

> when I have checked the data file it is showing solution manager ora user as owner.

> please give some hint so that I can proceed forward.

We don't know what commands you used to restore the backup, I suggest you contact your TSM admin to help you.

Markus

[Former Member]

Tried with this command :

nohup brrestore -b beghgxcu.aff -d util_file -c force -r /oracle/HRQ/102_64/dbs/initHRQ_tivoli.utl -m full -l E &

FOLLOWED SYSTEM REFRESH PROCEDURE :

_____________________________________

CONVENTION : In this document, we follow the given convention while referring to systems:

Source System  The system whose database backup is taken and applied on the other system

Target System  The system which will be refreshed.

1. Login to the target system:

As <sid>adm,  stopsap

Ex : hrqadm -> stopsap

2. If the target system is in a host which houses no other AS, then stop the listener:

lsnrctl stop

NOTE: In case the host houses other AS, proceed without this step

3. In the target system switch user to ora<sid>

su u2013 ora<target_sid>

Ex: su - orahrq

4. In the target system, move the contents of the /oracle/<sid>/saptrace/ directory:

mkdir /oracle/<sid>/saptrace/background/old/

Ex: mkdir /oracle/HRQ/saptrace/background/old/

mkdir /oracle/<sid>/saptrace/usertrace/old/

Ex: mkdir /oracle/HRQ/saptrace/usertrace/old/

mv /oracle/<sid>/saptrace/background/* /oracle/<sid>/saptrace/background/old/

Ex: mv /oracle/HRQ/saptrace/background/* /oracle/HRQ/saptrace/background/old/

Hrq_Dwg*

Hrq_Lg*

Hrq_Ora*

Hrq_Cmon*

Hrq_Psp*

Hrq_cj*

Hrq_ck*

Hrq_mm*

mv /oracle/<sid>/saptrace/usertrace/* /oracle/<sid>/saptrace/usertrace/old/

Ex: mv /oracle/HRQ/saptrace/usertrace/* /oracle/HRQ/saptrace/usertrace/old/

5. In the target system, remove the .dbf files from the origlog and mirrorlog directories

rm /oracle/<sid>/origlogB/*.dbf

rm /oracle/<sid>/origlogA/*.dbf

rm /oracle/<sid>/mirrlogB/*.dbf

rm /oracle/<sid>/mirrlogA/*.dbf

Ex :

rm /oracle/HRQ/origlogB/*.dbf

rm /oracle/HRQ/origlogA/*.dbf

rm /oracle/HRQ/mirrlogB/*.dbf

rm /oracle/HRQ/mirrlogA/*.dbf

6. In the target system, delete the contents of all the sapdata<n> directories

cd /oracle/<sid>/sapdata<n>

rm u2013r *

Ex:

cd /oracle/HRQ/sapdata1

rm u2013r *

cd /oracle/HRQ/sapdata2

rm u2013r *

cd /oracle/HRQ/sapdata3

rm u2013r *

cd /oracle/HRQ/sapdata4

rm u2013r *

7. In the target system take backup the following files which are in /oracle/HRQ/102_64/dbs

mv init<sid>.ora init<sid>.ora.orig

mv init<sid>.dba init<sid>.dba.orig

mv init<sid>.sap init<sid>.sap.orig

mv init<sid>.utl init<sid>.utl.orig

mv init<sid>.bki init<sid>.bki.orig

Ex:

/oracle/HRQ/102_64/dbs

mv initHRQ.ora initHRQ.ora_orig

mv initHRQ.dba initHRQ.dba_orig

mv initHRQ_tivoli.sap initHRQ_tivoli.sap_orig

mv initHRQ_tivoli.utl initHRQ_tivoli.utl_orig

mv initHRQ.bki initHRQ.bki_orig

8. Copy the following files from the source system to the target system directory /oracle/<target_sid>/102_64/dbs using:

cd /oracle/<target_sid>/102_64/dbs

sftp <source_sid>adm@<source system IP>

cd /oracle/<source_sid>/102_64/dbs/

get init<source_sid>.ora

get init<source_sid>.dba

get init<source_sid>.sap

get init<source_sid>.utl

get init<source_sid>.bki

Ex :

cd /oracle/HRQ/102_64/dbs/

rcp 10.105.3.170:/oracle/HRP/102_64/dbs/initHRP.dba /oracle/HRQ/102_64/dbs/initHRP.dba

Rcp 10.105.3.170:/oracle/HRP/102_64/dbs/initHRP.bki /oracle/HRQ/102_64/dbs/initHRP.bki

Rcp 10.105.3.170:/oracle/HRP/102_64/dbs/initHRP.ora /oracle/HRQ/102_64/dbs/initHRP.ora

Rcp 10.105.3.170:/oracle/HRP/102_64/dbs/initHRP_tivoli.sap /oracle/HRQ/102_64/dbs/ initHRP_tivoli.sap

Rcp 10.105.3.170: /oracle/HRP/102_64/dbs/InitHRP_tivoli.utl /oracle/HRQ/102_64/dbs/ InitHRP_tivoli.utl

9. Also copy the latest .aff/.anf and .log file from the source system to the target system directory /oracle/<target_sid>/sapbackup:

cd /oracle/<target_sid>/sapbackup

sftp ora<source_sid>@<source system IP>

cd /oracle/<source_sid>/sapbackup

ls u2013ltr

get <latest>.aff

get back<source_sid>.log

Ex :

Cd /oracle/HRQ/sapbackup

HRQ permission :

HRP permission :

rcp 10.105.3.170:/oracle/HRP/sapbackup/beghgxcu.aff /oracle/HRQ/sapbackup/beghgxcu.aff

chown orahrq:sapsys beghgxcu.aff

rcp 10.105.3.170:/oracle/HRP/sapbackup/beghgxcu.aff /oracle/HRQ/sapbackup/beghjwks.anf

chown orahrq:sapsys beghjwks.anf

rcp 10.105.3.170:/oracle/HRP/sapbackup/backHRP.log /oracle/HRQ/sapbackup/backHRP.log

chown orahrq:sapsys backHRP.log

Checked in bakkHRQ.log file for the offline backup:

In case of online backup restore, also get the following file:

cd /oracle/<source_sid>/saparch

get arch<source_sid>.log

10. Change the name of the .log file in the target system:

mv back<source_sid>.log back<target_sid>.log

mv arch<source_sid>.log arch<target_sid>.log

Ex :

mv backHRP.log backHRQ.log

11. Also rename the init<sid>.* files in the target system brought from source system in step 7

Eg: mv init<source_sid>.ora init<target_sid>.ora

Earlier to rename:

Ex:

mv initHRP.dba initHRQ.dba

mv initHRP.bki initHRQ.bki

mv initHRP.ora initHRQ.ora

mv initHRP_tivoli.sap initHRQ_tivoli.sap

mv initHRP_tivoli.utl initHRQ_tivoli.utl

After Remame :

12. In the target system, change the contents of the init<sid>.* files by replacing all occurrence of

<source_sid> with <target_sid>. However, in the following lines of the files, the <source_sid> should be left unchanged:

 In the init<sid>.sap file, the volume_archive and volume_backup fields

 In the init<sid>.utl file, the BACKUPIDPREFIX field

Ex :

The parameter is different : in .sap file

HRP : backup_root_dir = /home/orahrp/prdbkp

HRQ : backup_root_dir = /saphpbackup

Will Change below parameters:

[root@VWVIHRDQ]/oracle/HRQ/102_64/dbs # more initHRQ_tivoli.sap | grep hrp

backup_root_dir = /home/orahrp/prdbkp

[root@VWVIHRDQ]/oracle/HRQ/102_64/dbs # more initHRQ_tivoli.sap | grep HRP

stage_root_dir = /oracle/HRP/sapbackup

compress_dir = /oracle/HRP/sapreorg

archive_copy_dir = /oracle/HRP/sapbackup

archive_stage_dir = /oracle/HRP/sapbackup

volume_archive = (HRPA01, HRPA02, HRPA03, HRPA04, HRPA05,

HRPA06, HRPA07, HRPA08, HRPA09, HRPA10,

HRPA11, HRPA12, HRPA13, HRPA14, HRPA15,

HRPA16, HRPA17, HRPA18, HRPA19, HRPA20,

HRPA21, HRPA22, HRPA23, HRPA24, HRPA25,

HRPA26, HRPA27, HRPA28, HRPA29, HRPA30)

volume_backup = (HRPB01, HRPB02, HRPB03, HRPB04, HRPB05,

HRPB06, HRPB07, HRPB08, HRPB09, HRPB10,

HRPB11, HRPB12, HRPB13, HRPB14, HRPB15,

HRPB16, HRPB17, HRPB18, HRPB19, HRPB20,

HRPB21, HRPB22, HRPB23, HRPB24, HRPB25,

HRPB26, HRPB27, HRPB28, HRPB29, HRPB30)

util_par_file = /oracle/HRP/102_64/dbs/initHRP_tivoli.utl

1. mount_par_file = initHRP.mnt

2. recov_copy_dir = /oracle/HRP/sapbackup

3. space_copy_dir = /oracle/HRP/sapreorg

4. exp_dump_dir = /oracle/HRP/sapreorg

Parameters changed to :

stage_root_dir = /oracle/HRQ/sapbackup

compress_dir = /oracle/HRQ/sapreorg

archive_copy_dir = /oracle/HRQ/sapbackup

archive_stage_dir = /oracle/HRQ/sapbackup

util_par_file = /oracle/HRQ/102_64/dbs/initHRQ_tivoli.utl

The parameter is different: in .utl file

[root@VWVIHRDQ]/oracle/HRQ/102_64/dbs # more initHRQ_tivoli.utl | grep HRP

BACKUPIDPREFIX HRP___

CONFIG_FILE /oracle/HRQ/102_64/dbs/initHRP.bki

ADSMNODE VWVHRPCI_TDP # Tivoli Storage Manager Nodename

Result :

CONFIG_FILE /oracle/HRQ/102_64/dbs/initHRQ.bki

13. Both in the target system and the source system, see the name of the TSM Server from the

dsm.sys file:

cd /usr/tivoli/tsm/client/ba/bin

more dsm.sys

The first line of the file shows the SERVERNAME

Ex :

HRQ: /opt/tivoli/tsm/client/ba/bin # more dsm.sys

SErvername ITSM01

COMMMethod TCPip

TCPPort 1500

TCPServeraddress 10.105.2.190

Nodename VWVIHRDQ

HRP :/opt/tivoli/tsm/client/ba/bin # more dsm.sys

SErvername ITSM01

COMMMethod TCPip

TCPPort 1500

TCPServeraddress 10.105.2.190

Nodename VWVHRPCI

14. If the source and the target systems are on different tsm servers, then execute the following steps:

In Target system:

cd /usr/tivoli/tsm/client/ba/bin

mv dsm.opt dsm.opt.old

mv dsm.sys dsm.sys.old

sftp root@<source_IP>

cd /usr/tivoli/tsm/client/ba/bin

get dsm.opt

get dsm.sys

bye

chmod 755 dsm.opt

chmod 755 dsm.sys

cd /oracle/<target_sid>/102_64/dbs

vi dsm.opt

Change the VirtualNodeName in the dsm.opt file to that in the dsm.opt of the source system.

15. Check the connection to the TSM server using the following commands:

backint u2013p /oracle/<SID>/102_64/dbs/init<SID>.utl u2013f password

backfm u2013p /oracle/<SID>/102_64/dbs/init<SID>.utl

Ex :

backint u2013p /oracle/HRQ/102_64/dbs/initHRQ_tivoli.utl u2013f password

pass: password

backfm u2013p /oracle/HRQ/102_64/dbs/initHRQ_tivoli.utl

Giving proper parameter file path solve

16. Start the restore with the following command:<sapbackup>

nohup brrestore -b <.anf file> -d util_file -c force u2013r /oracle/<target_sid>/102_64/dbs/init<target_sid>.utl -m full -l E &

Ex:

change user:

su u2013 orahrq

cd /oracle/HRQ/sapbackup

nohup brrestore -b beghgxcu.aff u2013d util_file -c force u2013r /oracle/HRQ/102_64/dbs/initHRQ_tivoli.utl -m full -l E &

17. In case of online backup restore take the archive log backup: restore

nohup brrestore -a <start_log#>-<end_log#> -c force -d util_file -r /oracle/<target_sid>/102_64/dbs/init<target_sid>.utl &

I have tried with backfm also. It is showing the same error.

Thanks for the reply.

T

[Former Member]

Backfm log :

Back error log.

[root@VWVIHRDQ]/oracle/HRQ/sapbackup # more backfm_20110612131253.log

Data Protection for SAP(R)

Interface between BR*Tools and Tivoli Storage Manager

- Version 5, Release 5, Modification 0.0 for HP-UX LF IA64 -

Build: 316B compiled on Oct 24 2007

(c) Copyright IBM Corporation, 1996, 2007, All Rights Reserved.

BKI2027I: Using TSM-API version 5.5.0.0 (compiled with 5.3.0.0).

BKI2000I: Successfully connected to ProLE on port tdpr3ora64.

BKI0005I: Start of program at: Tue Jul 12 13:12:53 2011 .

-- Parameters --

Input File : /var/tmp/eaa005838

Profile : /oracle/HRQ/102_64/dbs/initHRQ_tivoli.utl

Configfile : /oracle/HRQ/102_64/dbs/initHRQ.bki

Manual sorting file : disabled

Tracefile : disabled

Traceflags : disabled

Parallel sessions : 1

Multiplexed files : disabled

RL compression : disabled

Exit on error : disabled

BATCH : disabled

Buffer size : 4194304

Buffer Copy Mode : SIMPLE

Redologcopies : disabled

Versioning : disabled

Backup Type : unknown

TSM log server : disabled

TSM server : ITSM01 with 2 sessions configured

TSM client node : VWVHRPCI_TDP

Days for backup : Sun Mon Tue Wed Thu Fri Sat

Backup mgmt class : MDB

Archiv mgmt class : MLOG1 MLOG2

BKI5016I: Time: 07/12/11 13:12:54 New TSM session created: MGMNT-CLASS: , TSM-Server: ITSM01, type: SIMP

LE

BKI4001E: File '/oracle/HRQ/sapdata1/sr3700_2/sr3700.data2' cannot be created. Reason: errno(13) Permi

ssion denied

BKI0101I: Please enter 'c[ont]' to continue or 's[top]' to cancel.

[root@VWVIHRDQ]/oracle/HRQ/sapbackup #