Message-Id: <10603.115716@fatcity.com> From: "Koivu, Lisa" Date: Tue, 29 Aug 2000 08:07:32 -0400 Subject: RE: Backup also ? This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C011B1.B5F86594 Content-Type: text/plain; charset="iso-8859-1" Depends on whether or not you want to keep it.... I'm kidding. Back up your controlfile frequently. It's quick and easy. Lisa Ft. Lauderdale, FL, USA -----Original Message----- From: Slamet Fusianto [mailto:yangken@cbn.net.id] Sent: Tuesday, August 29, 2000 6:00 AM To: Multiple recipients of list ORACLE-L Subject: Backup also ? Dear lister, We are using Oracle v8.0.5 and Windows NT 4.0. The database is 24x7. In the Oracle documentation (Backu & Recovery Guide) it is said that 'we should backup controlfile after making a structural modification'. 1. We are using hot backup and only backup all the datafile. The question: is it necessary to backup also controlfile each time we do hot backup ? And init file and parameter file ? If I see the documentation, and paper, only dafafiles is 'backup'-ed when doing hot backup. Thank you for the answer. Regards, Slamet Fusianto -- Author: Slamet Fusianto INET: yangken@cbn.net.id 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@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). ------_=_NextPart_001_01C011B1.B5F86594 Content-Type: text/html; charset="iso-8859-1" RE: Backup also ?

Depends on whether or not you want to keep it....

I'm kidding.  Back up your controlfile frequently.  It's quick and easy.

Lisa
Ft. Lauderdale, FL, USA

-----Original Message-----
From: Slamet Fusianto [mailto:yangken@cbn.net.id]
Sent: Tuesday, August 29, 2000 6:00 AM
To: Multiple recipients of list ORACLE-L
Subject: Backup also ?


Dear lister,

We are using Oracle v8.0.5 and Windows NT 4.0. The database is 24x7.
In the Oracle documentation (Backu & Recovery Guide) it is said that 'we should
backup controlfile after making a structural modification'.
1. We are using hot backup and only backup all the datafile. The question: is it
necessary to backup also controlfile each time we do hot backup ? And init file
and parameter file ? If I see the documentation, and paper, only dafafiles is
'backup'-ed when doing hot backup.

Thank you for the answer.

Regards,

Slamet Fusianto


--
Author: Slamet Fusianto
  INET: yangken@cbn.net.id

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@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).