Re: Recover datafile error - cannot find spec seqence # in archive log

From: <schang7_at_my-deja.com>
Date: Thu, 16 Dec 1999 00:30:28 GMT
Message-ID: <839br5$tai$1@nnrp1.deja.com>

Thanks for your input. I try and it shows Media recovery complete. Then, I open the database with 'alter database open noresetlogs' But I still cannot access to that data file.

svrmgr>select count(*) from history.bk_sn_err; count(*)

---

ora-00376: file 5 cannot be read at this time ora-01110: data file 5: 'f:\history\history.ora'

From the storage manager the file is still in recover status. Does the file been recovered at all?

In article <8376qn$o78$1_at_news2.tor.accglobal.net>,   "John Chiu" <johnymc_at_netscape.net> wrote:
> It seems it is looking for the scn 525082216 in sequence 252904 which
is not
> found in the archived log orcl25290.001. Do you have a full set of
archived
> log files before you perform the recovery? How about perform an
incomplete
> recovery until scn = 525082215 and check if it prompts error.
>
> John Chiu
>
> <schang7_at_my-deja.com> wrote in message
news:836etv$p7d$1_at_nnrp1.deja.com...
> > Hi,
> > The list below were the errors I got when trying to recover a
datafile
> >
> > SVRMGR> recover datafile 'f:\history\history.ora';
> > ORA-00279: Change 525082216 generated at 12/08/99 16:24:02 needed
for
> > thread 1
> > ORA-00289: Suggestion : d:\ORANT\RDBMS73\%ORACLE_SID%25290.001
> > ORA-00280: Change 525082216 for thread 1 is in sequence #252904
> > Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
> > ORA-00310: archived log contains sequence 252909; sequence 252904
> > required
> > ORA-00334: archived log: 'D:\ORANT\RDBMS73\ORCL25290.001'
> >
> > I try auto, <RET> and event the suggested log file orcl25290.001 and
> > still could not recover the datafile. It seems the recover program
> > cannot find the specific sequence # in the log file! Any suggestion?
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 15 1999 - 18:30:28 CST