[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question
[x]
Attachment Details

Oracle hot back up script

Asked by COMPSUPP in Databases Miscellaneous, Oracle CRM

Hi
I have a simple unix hot backup script which puts a tablespace into backup mode, copies the unix file, then ends the backup mode and continues on for all the tablespaces.
At the end I then compress all the copied datafiles.  Can I compress the datafiles as I go along? I am having trouble with disk space.
It can take a long time to compress some of the really big ones and so would there be any problems with a long delay between the hot backups of each tablespace?
example of existing script:
alter tablespace WEBS begin backup;
host echo 'Starting WEBS data backup'
host cp /local1..../webs_data01.dbf /local3/..../hotbackup
alter tablespace WEBS end backup;
host echo 'End WEBS data backup'

alter tablespace WEBSINDEX begin backup;
host echo 'Starting WEBSINDEX backup'
host cp /local2/......../webs_index01.dbf /local3/......../hotbackup
alter tablespace WEBSINDEX end backup;
host echo 'End WEBSINDEX backup'

I would like to change to this:
alter tablespace WEBS begin backup;
host echo 'Starting WEBS data backup'
host cp /local1..../webs_data01.dbf /local3/..../hotbackup
host gzip /local3/...../hotbackup/webs_data01.dbf
alter tablespace WEBS end backup;
host echo 'End WEBS data backup'

alter tablespace WEBSINDEX begin backup;
host echo 'Starting WEBSINDEX backup'
host cp /local2/......../webs_index01.dbf /local3/......../hotbackup
host gzip /local3/...../hotbackup/webs_index01.dbf
alter tablespace WEBSINDEX end backup;
host echo 'End WEBSINDEX backup'
[+][-]11/05/09 05:28 AM, ID: 25749152Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/05/09 07:24 AM, ID: 25750418Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/05/09 07:35 AM, ID: 25750558Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091021-EE-VQP-81 - Hierarchy / EE_QW_3_20080625