Re: Apply archive logs to previous cold backup

hello rob,

additonally it makes sense to always have a copy and a description of my last controlfile available . note that you should do the following command in each case you modify your database 'physical' structure : (run as system)
alter database backup controlfile to trace ; (now you need to look into that directory for the background_dump_dest - files and see for the latest created trc-file. this is an ascii readable file and shows you the contents of the whole create database command. those informations there go into the contents of a control file. for later use i recommend you to read documentations and so on to describe it here is too costly.
thos control files are one of the most important parts of an Oracle database. you should always keep copies of these distributed over more than one drive for security reason.

best regards

burkhard schneider

Rob Calfee schrieb:
>
> Hey, thanks
>
> I'm going to try that right now! Thanks again!
>
> Rob Calfee
>
> On Mon, 13 Sep 1999 15:07:47 +0100, "Neil C" <btsscrth_at_bt.com> wrote:
>
> >you would basically restore the cold backup datafiles, but maintaining the
> >existing control file (hopefully you have a current controlfile), and
> >recover the database as normal, applying your archive log files. If you have
> >lost all control files then you are in a bit deeper !
> >
> >Rob Calfee wrote in message <37dd0125.249086128_at_news.primenet.com>...
> >>Question:
> >>I was experimenting the other day with backups on a test box.
> >>
> >>What is the correct procedure to apply current archive logs to a
> >>previous cold backup? For example, you have taken a cold backup of a
> >>database on Monday, ran hot backups during the week, and for just
> >>fantasy sake none your database crashes on Saturday and ALL of your
> >>hot backups are lost save for the archive logs.
> >>
> >>How do you apply the archive logs to the cold backup? I can't seem to
> >>get it right on our test box.
> >>
> >>Thanks in advance!
> >>
> >>Rob Calfee
> >>Rob Calfee
> >>DBA
> >>rcalfee_at_incsystem.com
> >
> >
>
> Rob Calfee
> DBA
> rcalfee_at_incsystem.com
Received on Wed Sep 15 1999 - 17:37:12 CDT