Preserve tables exports before db refresh

[Former Member]

Hi experts,

we are going to DB refresh the so please suggest me tables name so we take export.

and import after refresh??

for Backgrounds jobs which table used.

oracle 10G ecc 6.0 on RHEL5.3

Regards,

vivek

[Reagan · Accepted solution]

Hello

If you want to restore the RFC's and EDI tables then you need to export and import it back

Export RFC

Create control file RFC_export file under the home directory of sidadm with the below contents.

EXPORT

file = 'QUA_RFC'

delete from RFCATTRIB

select * from RFCATTRIB

delete from RFCCHECK

select * from RFCCHECK

delete from RFCCMC

select * from RFCCMC

delete from RFCDES

select * from RFCDES

delete from RFCDESSECU

select * from RFCDESSECU

delete from RFCDOC

select * from RFCDOC

delete from RFCSYSACL

select * from RFCSYSACL

delete from RFCTRUST

select * from RFCTRUST

delete from LOGIC_DEST

select * from LOGIC_DEST

delete from RSECTAB

select * from RSECTAB

delete from RSECACTB

select * from RSECACTB

R3trans -w RFC_export.log RFC_export

Export EDI

Create control file EDI_export file under the home directory of sidadm with the below contents.

EXPORT

file = 'QUA_EDI'

delete from EDPP1

select * from EDPP1

delete from EDP12

select * from EDP12

delete from EDP13

select * from EDP13

delete from EDP21

select * from EDP21

delete from EDIPORT

select * from EDIPORT

delete from EDIPOA

select * from EDIPOA

delete from TBD00

select * from TBD00

delete from TBD00T

select * from TBD00T

delete from TBD05

select * from TBD05

delete from TBD06

select * from TBD06

delete from TBDBR

select * from TBDBR

delete from TBDBRF

select * from TBDBRF

R3trans -w ALE_export.log EDI_export

To import them back.

Import RFC

Create control file RFC_import file under the home directory of sidadm with the below contents.

import

client=ALL

file='QUA_RFC'

R3trans -w RFC_import.log RFC_import

Import EDI

Create control file EDI_import file under the home directory of sidadm with the below contents.

IMPORT

client=ALL

file = 'QUA_EDI'

R3trans -w EDI_import.log EDI_import

Also check this link which has some additional tables but not necessarily required.

http://sap.ittoolbox.com/groups/technical-functional/sap-basis/best-practices-before-a-sap-system-co...

Cheers

RB

[Former Member · Accepted solution]

Thank u and what about background job preservation.

and what is the use of delete statement in file.

Regards

[ashish_mishra2 · Accepted solution]

Hi,

Go through below URL. you will get complete refresh procedure along with presteps, post steps and restore/recovery method.

All table to be exported are also given.

http://blog.sapadmin.co.in/?p=334

Excellent procedure. just blindly follow this. No issues.

Cheers !!!

Ashish

[Reagan · Accepted solution]

Good Day

The entries present in the control files are NOT SQL statements and the delete statements mentioned in the control file are added into the file exported when you perform the export.

When you perform the import these delete statements are executed to delete the entries present in the table before you import the table contents from the dump file.

Cheers

RB