Re: Backup also ?

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Tue, 29 Aug 2000 08:02:20 -0400
Message-Id: <10603.115717@fatcity.com>

When doing a "HOT" backup you backup the datafiles, switch arch logs, = backup the archivelogs, backup controlfile to a filename and backup the = named controlfile. That way you get the SCN's accociated with the = controlfile and datafiles on the tape. If you did not backup the controlfil= e and "lost" your controlfiles on the system the backup would be difficult = to restore.
Any one else want to jump in?
ROR
>>> yangken_at_cbn.net.id 08/29/00 05:59AM >>>
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

--=20
Author: Slamet Fusianto
  INET: yangken_at_cbn.net.id=20

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 29 2000 - 07:02:20 CDT