Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Backup also ?

RE: Backup also ?

From: Rajesh Dayal <Rajesh_at_ohitelecom.com>
Date: Tue, 29 Aug 2000 16:36:45 +0400
Message-Id: <10603.115722@fatcity.com>


Just a small doubt...

Can I recover my DB with a complete COLD Backup (DATA FILES, CONTROL FILES) and all archived log files of next five days without having the current control file(i.e. with five day's old control file)???

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Ron Rogers Sent: Tuesday, August 29, 2000 5:06 PM
To: Multiple recipients of list ORACLE-L 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).
Received on Tue Aug 29 2000 - 07:36:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US