Steps to Copy a Database in SAP

[Former Member]

Hi,

What are the steps to copy a database in SAP?

Thanks,

Sreekar.

[Former Member · Accepted solution]

Hi,

The steps of database copy are as below.

1. To make Database copy between two systems, you have to check file size on

Target System.

Use commands:

df -k

bdf (HP-UX)

2. On the Source System, check the files which are going to move.

Use commands:

su ora

svrmgrl

connect internal;

select name from v$controlfile;

select name from v$datafile;

select name from v$logfile;

3. Release all change requests on source system.

4. Shutdown database (Source system)

Use commands:

su - adm

stopsap

5. Copy the controlfiles, datafiles, logfiles from source system to target

system.

• Backup via tar

• ftp or rcp

For example: You can write a simple script.

rcp r src_server:/oracle/SRC/sapdata1 /oracle/TRG

rcp r src_server:/oracle/SRC/sapdata2 /oracle/TRG

rcp r src_server:/oracle/SRC/sapdata3 /oracle/TRG

.

.

or for backup

tar cvf /dev/ sapdata* dbs origlog* mirrlog*

6. Copy $Oracle_Home/dbs/init.ora parameter file from source system to

target system. Change all old SIDs to new SIDs except db_name parameter.

Save it with old SID name.

7. On the target system, change parameter /dbname= on

parameter file /usr/sap/trans/bin/TPPARAM

8. Change all owners and groups.

Use commands:

With root user.

cd /oracle/

chown R ora:dba sapdata*

chown R ora:dba origlog*

chown R ora:dba mirrlog*

9. Change the name of control files (cntrl.dbf) with new SID

10. Startup mount must work successfully.

Use command:

su ora

svrmgrl

connect internal;

startup mount;

11. Define new locations to database for data files and log files.

Use command:

su ora

svrmgrl

connect internal;

alter database rename file /old/file/name to /new/file/name;

12. Startup R/3 with startsap.

Use commands:

su - adm

startsap

13. If not start; see OSS note--> 8179 (grant connect to sapr3 identified by SAP)

14. Log on to SAP via SAP* user.

15. Run ST06 and set workbench organizer.

16. Install new license.

17. Change the spool server names on SAP system. (SPAD)

Reward points if found helpfull...

Cheers,

Siva.