Tar and zip at same time - for hot backup
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Thread: Tar and zip at same time - for hot backup

  1. #1
    Join Date
    May 2002
    Posts
    193

    Unhappy Tar and zip at same time - for hot backup

    Hi all,

    I have a requirement like this :

    Iam creating a tar file and append files to the tar file for backup.

    I need to zip the file at the same time.

    I can do something like this :
    ------------------------------------------------------------------------
    (AG8)/data/oracle/AG8: tar cvEf /data/export/temp_ag8/ag8.tar control01.dbf
    a control01.dbf 2072K

    Iam adding one more file to this tar file:

    (AG8)/data/oracle/AG8: tar uvEf /data/export/temp_ag8/ag8.tar control02.dbf
    a control02.dbf 2072K

    -----------------------------------------------------------------------

    but when I try to do this - not possible:

    (AG8)/data/oracle/AG8: tar cvEf - /data/oracle/AG8/usersAG801.dbf|gzip>/data/export/temp_ag8/ag8.tar.gz
    a /data/oracle/AG8/usersAG801.dbf 10248K

    Iam adding one more file to this tar file:

    (AG8)/data/oracle/AG8: tar uvEf - /data/oracle/AG8/users2AG801.dbf|gzip>/data/export/temp_ag8/ag8.tar.gz
    tar: can only create standard output archives.
    (AG8)/data/oracle/AG8:



    ----------------------------------------------------------------------

    But I need to append files to a TAR file and zip at the same time, for hot backup, for datafiles in every tablespace one by one .
    Iam executing the backup from a procedure and putting all the datafiles in a tablespace into a cursor and tar'ing the files.

    Kindly share your ideas for this issue.

    Regards,

    K.Diwakar
    Last edited by diwakar; 05-05-2005 at 12:28 PM.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    horrible, truely horrible

    You cant do what you are doing, you would have to tar all the files up first then zip it

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you can tar and zip at same time but I dont think you can do that with appending

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by davey23uk
    You cant do what you are doing, you would have to tar all the files up first then zip it
    Presumably you pity tha' fool who do that.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  5. #5
    Join Date
    May 2002
    Posts
    193
    Originally posted by pando
    you can tar and zip at same time but I dont think you can do that with appending
    Thanks PANDO,

    Iam actually tar'ing and zip'ing at same time but wanted to know if there is a possibility to append.....

    Regards,

    K.Diwakar

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Originally posted by slimdave
    Presumably you pity tha' fool who do that.
    damn you! was waiting to slip that in somwhere

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    why you dont simply tar-zip all datafiles and at the end create a tarball?

  8. #8
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Originally posted by pando
    why you dont simply tar-zip all datafiles and at the end create a tarball?
    my cat had a tarball last night but after a fresh bowl of water and some annoying hacking she was fine
    I'm stmontgo and I approve of this message

  9. #9
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    Originally posted by davey23uk
    damn you! was waiting to slip that in somwhere
    You're talking a whole lotta Jibba-Jabba!
    this space intentionally left blank

  10. #10
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by davey23uk
    damn you! was waiting to slip that in somwhere
    Shut up, fool!
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width