Re: Backup also ?

Also, if you want to go back in time you need the old controlfiles to do a point-in-time recovery.
RBG
----- Original Message -----
From: Ron Rogers <RROGERS_at_galottery.org> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Tuesday, August 29, 2000 9:05 AM
Subject: Re: Backup also ?

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 controlfile 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

--
Author: Slamet Fusianto
  INET: yangken_at_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_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).


--
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

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