Re: how do we restore in this scenerio?

I'm not exactly clear what you are asking but this is how I understand your situation

1. You have a backup from sometime on 12 December
2. You only have archivelogs from 13 December

Now what you can do depends a little on what type of backup you have for point 1.

If you have a full backup at the 12 December but not from the 13th then the 12th is the latest point in time to which you can recover. I believe that the appropriate command would be recover database until cancel (using ....). You cannot on my understanding of your situation recover until the 13th if that is what you wish to do.

However it might be worth doing some investigation of your backup strategy, in particular why archive logs are missing. For example our production db only keeps archive logs for 7 days. The reasoning being they are stored on tape each night so i will have enough tape backups of the archived logs in the event of a restore being necessary. In other words your missing archive logs might/ought to be on tape somewhere.

regards

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"sp" <sdpant_at_yahoo.com> wrote in message
news:rbWZ5.1381$1%2.61363_at_sjc-read.news.verio.net...


> Ours is Oracle 8.1.5 db in Solaris environment.  Our db got corrupted up

 on


> 12/13.

> We have a back of all the data files and control files from 12/12.  Our

> archivelogs

> somehow got deleted even though we are in archivelog mode.  We tried to

> restore point

> in time with the backup from 12/12 and got the following error:

>

> recover database until time '2000-12-13:11:05:00' using backup

 controlfile;


> ORA-00279: change 859942 generated at 12/12/00 18:23:53 needed for thread

 1


> Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

>

> ORA-00266: name of archived log file needed

> ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error

> below

> ORA-01194: file 1 needs more recovery to be consistent

> ORA-01110: data file 1: '/U04/oradata/gl/gamelink/system01.dbf'

>

> So my question is how do we restore to the point we have full backup i.e.

> 12/12 ?(we don't any archivelog of 12/12) .

>

> Thanx in advance.

>

> SP

>

>

>

>