Monday, September 1, 2014

Compressing the Oracle EBS TOPs and Uncompressing using tar and gzip

 Hi Apps DBA,

We usually do cloning by copying the Application tops from Source(TEST1) to Target(TEST2).
First we compress the files in source and than we copy those file from source to target and finally we uncompress followed by renaming and further process .Below are the useful commands and safe one to do this task.

Step 1:Tarring and zipping:

nohup tar -cvpf - ./test1appl 2> /u01/app/test1/test1appl.log | gzip -c -> /u01/app/test1/test1appl.gz &

nohup tar -cvpf - ./test1comn 2> /u01/app/test1/test1comn.log | gzip -c -> /u01/app/test1/test1comn.gz &

nohup tar -cvpf - ./test1ora 2> /u01/app/test1/test1ora.log | gzip -c -> /u01/app/test1/test1ora.gz &

Step 2:scp from source  to target:
Assuming we are on target server,we copy files from source to target as below:

scp -rp apptest1@uslaxorcap19:/u01/app/test1/*.tar.gz .

passwd:apptest1

Step 3:Untarring and Unzipping:

nohup cat /u02/app/test2/test1appl.tar.gz|gunzip| tar xvf - >/u02/app/test2/test1appl.log &
nohup cat /u02/app/test2/test1comn.tar.gz|gunzip| tar xvf - >/u02/app/test2/test1comn.log &
nohup cat /u02/app/test2/test1ora.tar.gz|gunzip| tar xvf - >/u02/app/test2/test1ora_27Jun.log &

Note 1:Below command comes in single line in Unix shell prompt
Note 2:Advantage of above command is we can check logs and make sure the compressing and Uncompressing  is done successfully.



Enjoy doing Apps DBA tasks...


Best regards,

Rafi

Note:Check www.orasols.com for the services we offer.







37 comments:

  1. Really something Grate in this article Thanks for sharing this. We are providing ORACLE courses training online. After reading this slightly am changed my way of introduction about my training to people. And also refer my website for ORACLE Training and solutions of ORACLE applications. Please Visit Us @ ORACLE training courses online

    ReplyDelete
  2. Thanks for Information Our Online-Training-Informatica proven expert in all Hyperion Modules like Hyperion Financial Management, Hyperion Financial Data Quality, Hyperion Financial Reporting, Hyperion Essbase, Hyperion Planning, Smart view and Data Relationship management.Hyperion Essbase Online Training

    ReplyDelete
  3. Thanks for Information Oracle Online Training Oracle is an object-relational database management system created and marketed by Oracle Corporation.Oracle Online Training

    ReplyDelete
  4. I am Sridevi Koduru, Senior Oracle Apps Trainer at Oracleappstechnical.com With 8 Yrs Exp on Oracle Apps and 13 Yrs IT Exp Providing Online Training on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Apps SCM, Oracle Apps HRMS, Oracle Financial for Indian Localization, SQL, PL/SQL and D2K. I have Provided Training for 500+ Professionals Most of them are Working in Real Time now.

    Contact for (One to One Personal Online Training) on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Financial for Indian Localization, Oracle Apps SCM, Oracle Apps HRMS, SQL, PL/SQL and D2K at training@oracleappstechnical.com | sridevikoduru@oracleappstechnical.com | +91 – 9581017828 | http://www.oracleappstechnical.com

    LinkedIn profile - http://in.linkedin.com/pub/sridevi-koduru/8b/76a/9b8/

    ReplyDelete
  5. Lead Online training is a brand and providing quality online to students in world wide. We are giving best online training on ORACLE DBA .Every faculty has Real Time experience .Trained Resources placed in countries like USA, UK, Canada, Malaysia, Australia, India, Singapore etc. Lead Online training classes are conducted every day. Weekend trainings for job goers. Flexible timings in accordance with the resource comfort ability.

    oracle apps DBA Online Training

    ReplyDelete
  6. It was very nice article and it is very useful to Oracle Apps DBA Commerce learners.We also provide Cub training software online training.

    ReplyDelete
  7. IQ Online Training Portal offers Oracle APEX Online training throughout the world and is specialists in online trainings.
    Oracle APEX online training in USA

    ReplyDelete
  8. A debt of gratitude is in order for the post on Oracle apps dba is was great. Here are some more indpth data on Oracle apps dba preparing and free demo likewise accessible please visit our site..
    Check this site mindmajix for indepth Oracle apps dba blogs.
    Go here if you’re looking for information on Oracle apps dba training.

    ReplyDelete
  9. Nice Blog for Oracle apps DBA,we provide online training,On line job Support and Consulting
    eBiztechnics-Oracle apps Blog

    ReplyDelete
  10. If wants to get real time Oracle Training visit this blog They give professional and job oriented training for all students.To make it easier for you Greens Technologies trained as visualizing all the real-world Application and how to implement in Archiecture trained with expert trainners guide may you want.. Start brightening your career with us Green Technologies In Chennai

    ReplyDelete
  11. Thank you very much for providing latest salesforce online training.You can search and visit our website.with best regards:
    salesforce online training

    ReplyDelete
  12. Thank you for the useful post. It helps a lot in my training. I share your blog with my students. Keep posting more.
    Selenium Training in Chennai

    ReplyDelete
  13. Really awesome blog. Your blog is really useful for me. Thanks for sharing this informative blog. Keep update your blog.
    QTP Training in Chennai

    ReplyDelete
  14. Very good article. I am facing some of these issues as well..
    Hadoop Online Training

    ReplyDelete
  15. Very good information. Lucky me I came across your website by chance. I’ve saved it for later!
    SAP APO Online Training

    ReplyDelete
  16. Really something Grate in this article Thanks for sharing this. We are providing Online Training Classes. After reading this slightly I am changed my way of introduction about my training to people.
    ORACLE DBA ONLINE TRAINING

    ReplyDelete
  17. Jharkhand Labour Department Recruitment 2016



    Information provided was extremely useful and informative. Thanks a lot for useful stuff placed here........

    ReplyDelete
  18. Being a student of Rafi Sir, I regularly follow his blogs. Thank you sir.
    government jobs

    ReplyDelete
  19. Great post and informative blog.it was awesome to read, thanks for sharing this great content to my vision.
    Informatica Training In Chennai
    Hadoop Training In Chennai
    Oracle Training In Chennai
    SAS Training In Chennai

    ReplyDelete
  20. Really awesome blog. Your blog is really useful for me. Thanks for sharing this informative blog. Keep update your blog.
    Hadoop Training In Chennai

    ReplyDelete
  21. very nice blogs!!! i have to learning for lot of information for this sites...Sharing for wonderful information.Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing.
    Pega Training In Chennai

    ReplyDelete

  22. Recently I was asked to arrange an event for my company; I took help from an established event organizing company. The event was nice and successful.Nice post dear. I really like it.


    Cloud Hosting Service in Chennai

    ReplyDelete
  23. Nice Post & a good info. Persuing it is very beneficial CAPM Certification Training in USA This also increases the market value.

    ReplyDelete
  24. Excellent posts..
    SAS Institute introduced the SAS Certified Professional Program,training proper understanding of how the SAS software works. Among the five certification programs that SAS Institute has come up with, SAS training can be considered as the entry point into the big data and the data analytics industry.
    SAS online training in hyderabad

    ReplyDelete
  25. your blog is so impressive ,its a great pleasure to read the post in your blog SAP Netweaver Training in Hyderabad

    ReplyDelete