RE: Quick Question on hotbackup

From: Rao, Maheswara <Maheswara.Rao_at_Sungardp3.com>
Date: Mon, 03 Dec 2001 12:43:50 -0800
Message-ID: <F001.003D3BCD.20011203122039@fatcity.com>

Seema,

You do not need to switch current log file at the beginning of your job. You switch the log file before taking the copy of archive log files.

Generally, listener and tnsnames files copy is not required.

Overall the steps you outlined are ok. But remember at every step to check for the success or failure of your step before proceeding with the next step.

If you are trying to write the script in Unix, I suggest the following additional things.

Before starting the hot backup job, check whether the db is up or not. If the db is not up, then abort the job and send a mail to the Daring Boys All (DBAs).
Before putting a tablespace in the hot backup mode, check whether the tablespace is already in hot backup mode. This could happen if another DBA is doing hot backup on the same tablespace.
After copying the datafile, do unix compare. If it fails, then abort the job and send a mail to DBA.
Also after copying the archive log files, you need to delete the archive logs. Else, your archive log space would keep increasing.
Once all the tablespaces and archive logs are copied, it is a good practice to compress these files.

Rao

-----Original Message-----

Sent: Monday, December 03, 2001 2:35 PM
To: Multiple recipients of list ORACLE-L

Hi
The following files are backed in hotbackup right?
-Switch the current log
-take the structure of database by alter database backup controlfile to
trace;
-Data files (ALter tablespace begin backup and
ALter tablespace end backup )
-All parameter like init.ora,listener.ora,tnsnames.ora and passwd file
-All archive log files

Is any things missing in this list?
Thanks
-Seema

--

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

Author: Rao, Maheswara
INET: Maheswara.Rao_at_Sungardp3.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 Mon Dec 03 2001 - 14:43:50 CST