Re: Backup also ?

And, of course, backup to trace.

Saves you from headaches and helps a lot. ----- 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 3:05 PM
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:11:02 CDT