Fast Cold Backup to DDS3

From: Sinardy <sinardyxing_at_bcsis.com>
Date: Tue, 28 Aug 2001 04:22:50 -0700
Message-ID: <F001.003795E3.20010828042521@fatcity.com>

Hi all,

I have redundancy set (database files, redo logs, control files, no archive, *.ora) files total about 10 GIG
and I need them to be backup every week to DDS3 tape.

Current script something like

tar -cv file1
tar -uv file2
tar -uv file3

It took 1 whole day !!!! <operator complain>

So I thinking to tune this script to be like

1. Shutdown database
2. compress all those files to other name
3. Startup database
4. split those files compressed file if more than 2 GB 5a. tar -cvf file1 file2 file3 is all in one block or 5b. tar -cvf /dev/rmt/0n file1 is new block tar -cvf /dev/rmt/0n file2 is new block

My problem is in step 2 and 5

1. how to compress a file with output to other files, so that I can proceed to step #3 without wait till backup finish and uncompress those compressed files. (Perhaps I can copy the compressed file into other name - quick and dirty !!?)
2. To "utilise the I/O" or "not rewinding the tape", what is the suitable option (parameter) for my tar command, especially if we have long block in front of the tape.

Or perhaps you have other methods

Thank You

Sinardy

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Sinardy
  INET: sinardyxing_at_bcsis.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Aug 28 2001 - 06:22:50 CDT