RE: Backup also ?

Hi

I think you have the option recover ....... using backup controlfile for this scenario

jack

Rajesh Dayal <Rajesh_at_ohitelecom.com>@fatcity.com on 08/29/2000 03:35:59 PM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:
Subject: 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-----
Sent: Tuesday, August 29, 2000 5:06 PM
To: Multiple recipients of list ORACLE-L

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).
--
Author: Rajesh Dayal
  INET: Rajesh_at_ohitelecom.com

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





===================================================================
De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor
de geadresseerde. Gebruik van deze informatie door anderen dan de
geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding
en/of verstrekking van deze informatie aan derden is niet toegestaan.
Ernst & Young staat niet in voor de juiste en volledige overbrenging van de
inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.
===================================================================
The information contained in this communication is confidential and may be
legally privileged. It is intended solely for the use of the individual or
entity to whom it is addressed and others authorised to receive it. If you
are not the intended recipient you are hereby notified that any disclosure,
copying,  distribution or taking any action in reliance on the contents of
this information is strictly prohibited and may be unlawful. Ernst &
Young is neither liable  for the proper and complete transmission of the
information contained in this communication nor for any delay in its