oracle sap- copy restore database

[Former Member]

hi

for copy system in oracle DB and windows OS.

I installed new system,

and in the end I had restore the databese to Production database.

(replace the new DB with Production DB.

now I need the process for post installation -

all the steps after restore DB IN ORACLE.

CONTROL FILE..

all the path for the new db...

what exactly  I need to preform for making the system work.

thanks

yossi

.

[Reagan]

If the database is up and running (I hope the control files are recreated and the recovery has been completed) then you need to recreate the OPS$ users to start SAP.

Once the OPS$ users are created then you need to start SAP and login with SAP* user and install license.

The other steps include TMS configuration, deletion of logs (Job, Spool etc), spool server configuration, BDLS execution.

Regards

RB

[Former Member]

Download system copy guide and then follow the steps/procedure.

It clears all of your doubts.

service.sap.com/systemcopy

SAP Developer Network (SDN): Downloads, Discussions, eLearning, and Documentation for Developers

Regards,

Nick Loy

[Former Member]

thanks:-)

[Former Member]

this has ben discussed may times, do you want to restore using SQL commands or brtools?

[Former Member]

hi

I will explain.

I build new system SID=QAS (ecc 6)in a new server.

db= oracle

os-windows.

after the  installation, my DBA replace the databse (restore) with refreshed of Production DataBase.

now the DB in up.

the DBA change the control file.

and gave the name QAS to the database refreshed.

my question is what next. please:-)

thanks

yossi

[Former Member]

Ok,

Is your SAP now up? perform the following SAP specific post install steps:

Import Profiles

Configure transport using STMS

reconfigure SMLG

Reconfigure RZ12 RFC Server Group

Change Client Setting SCC4
Execute SICK

apply license SAPLICENSE

Reconfigure batch jobs including SAP Standard SM36

[Former Member]

hi

sap is not up.

what I need to check after what I already write. to make the sap up please.

thanks

yossi

[Former Member]

Hi Yossi

Can you please confirm your current status ?  Is your new system ( NON PROD ) up and running fine .

Some of the initial steps which needs to be done :

a) Disable all RFC connections to the PROD environment ( SM59 )

b) Delete all jobs from the DB13 which must have been copied over from PROD and schedule them again for the NON PROD systems

c)  Adjust Operation Mode ( RZ04 ) after importing the correct  profiles  in RZ10

d)  Remove all PROD jobs ( from Released to Scheduled ) and schedule only the standard jobs from SM36.

Thanks

Rishi

[Former Member]

Hi Yossi,

The issue discussed many times on the forum. Check the thread, below;

https://scn.sap.com/message/10319684

Best regards,

Orkun Gedik

[Former Member]

hi Orkun

the restore donn by dba.

now the oracle is up.

what the step I need to for the sap to make it up.

what exactle I need to check please

yossi

[Former Member]

Hi Yossi

Please check the database instance ID for the Oracle DB which has been restored by the DBA.

Has the SID been changed from PROD ---> QAS ?

Follow the guide as suggested by Nick ..

Thanks

Rishi

[Former Member]

You can do that by logging into SQLPLUS and then giving :

select status , instance_name from v$instance ;

Please share the output

Thanks

Rishi

[Former Member]

hi rishi

do I need do renew some trace file ??

for all the path database file - after restor.

the file path in the production are not the same as qas.

[Former Member]

hi Rishi

when I run this

select status.....

im getting  the correct instance:

qas.

the sap start and after 3 min fall again.

I attached the disp_dev log

can you look please.

yossi

dev_disp.txt.zip

[Reagan]

Did you recreate the OPS$ users ?

Run R3trans -d and provide the trans.log file

Provide the dev_w0 trace file

Regards

RB

[Former Member]

I run the opt command-

this is the dev_00

dev_w0.txt.zip

[Reagan]

Hello

This is what I see

C     OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:
C     ORA-01017: invalid username/password; logon denied                                                                        
C  *** ERROR => CONNECT failed with sql error '1017'

Follow this SAP note

400241 - Problems with ops$ or sapr3 connect to Oracle

Regards

RB

[Former Member]

hi Rishi

his is the trans log

yossi

trans.txt.zip

[Former Member]

ok

I will implement it.

thanks for everything
🙂

yossi

[Reagan]

Hello

I believe you have recreated the OPS$ users. if not you may create the OPS$ users by following this SAP note 50088 - Creating OPS$ users on Windows NT/Oracle

I also see that the account is locked.

4 ETW000  [dev trc     ,00000]     DbSlConnect(con=-1) -> orc=0, 99=DBSL_ERR_DB                           12  0.168038
4 ETW000  [dblink      ,00000]  ***LOG BY2=>sql error 28000  performing CON                               57  0.168095
4 ETW000  [dblink      ,00000]  ***LOG BY0=>ORA-28000: the account is locked                              15  0.168110

Open a command prompt and run these

sqlplus "/as sysdba"

ALTER USER SAPSR3 ACCOUNT UNLOCK;

exit

Now change the password of the SAPSR3 user.

Run this from the command prompt.

brconnect -u / -f chpass -o SAPSR3 -p WhateVer

Now run R3trans -d and check whether the RC=0000

Regards

RB