Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Backup also ?
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