Re: Database recovery

Yes. After I done the backup of datafile, I issued the switch logfile and then do the copy of archive log

In article <38353b5f.10356019_at_news.freeserve.net>,   alex_at_alenda.freeserve.co.uk (Alex Hudghton) wrote:
> Are you doing the switch logfile after you have taken the tablespaces
> out of hot backup mode ??
>
> Alex
>
> On Fri, 19 Nov 1999 01:44:53 GMT, akkha_at_my-deja.com wrote:
>
> >Hi,
> >
> >I am trying out my database recovery procedure. I have
> >done a hot backup of the whole database , then switch log
> >and backup the archive log. THen I do a backup of the control
> >file using oracle svrmgrl.
> >
> >After this I erase the whole database and copy back
> >all my datafile. I have also copied the control file
> >as well. When I try to start the database, it gives
> >following:
> >
> > recover database using backup controlfile
> >
> >ORA-00279: Change 16341 generated at 11/18/99 22:53:43 needed for
thread
> >1
> >ORA-00289: Suggestion : /ora05/oradata/TEMS/arch/arch1_32.dbf
> >ORA-00280: Change 16341 for thread 1 is in sequence #32
> >Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
> >
> >
> >However, I do not have seq 32. What could have gone wrong?
> >I have applied seq 31 though as suggestef by Oracle.
> >
> >Thanks for any hint?
> >
> >Anthony
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 19 1999 - 11:40:48 CST