Tar and zip at same time - for hot backup

[diwakar]

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

[davey23uk]

horrible, truely horrible

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

[pando]

you can tar and zip at same time but I dont think you can do that with appending

[slimdave]

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.

[diwakar]

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

[davey23uk]

Originally posted by slimdave
Presumably you pity tha' fool who do that.

damn you! was waiting to slip that in somwhere

[pando]

why you dont simply tar-zip all datafiles and at the end create a tarball?

[stmontgo]

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

[gandolf989]

Originally posted by davey23uk
damn you! was waiting to slip that in somwhere

You're talking a whole lotta Jibba-Jabba!

[slimdave]

Originally posted by davey23uk
damn you! was waiting to slip that in somwhere

Shut up, fool!