DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 17

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

Threaded View

  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.

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