Problem:
How to take backup of SAP Tables using brtools in Oracle.
Solution:
Table Export --
oracle > brspace -p init<SID>.sap -u / -c force -f tbexport -p 10 -l expdp -t "HTTPURLLOC,USR02,RFCDES" -u /oracle/<SID>/sapreorg -f
Table Import --
oracle > brspace -p init<SID>.sap -u / -c force -f tbimport -y tables -p 10 -a replace -t "HTTPURLLOC,USR02,RFCDES" -o SAPSR3 -x "/oracle/<SID>/sapreorg/sfiuvudl.edd/expdat.dmp,/oracle/<SID>/sapreorg/sfiuvudl.edd/expdat01.dmp" -f
Note:
Ensure you have successful DB backup before import activity.
No comments:
Post a Comment