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.







29 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. 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
  3. 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
  4. 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
  5. 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
  6. Nice Blog for Oracle apps DBA,we provide online training,On line job Support and Consulting
    eBiztechnics-Oracle apps Blog

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

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

    ReplyDelete
  9. 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
  10. Jharkhand Labour Department Recruitment 2016



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

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

    ReplyDelete
  12. 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

  13. 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
  14. 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
  15. your blog is so impressive ,its a great pleasure to read the post in your blog SAP Netweaver Training in Hyderabad

    ReplyDelete