Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: flashback database.. problem!
On 13 Apr, 12:27, "sybrandb" <sybra..._at_gmail.com> wrote:
> On Apr 13, 12:19 pm, "Andrea" <netsecur..._at_tiscali.it> wrote:
>
> > I have to try flashback entire database on 10g and after that i open
> > it with resetlogs, but it shows me this error:
>
> > alter database open resetlogs
> > *
> > ORA-01152: file 2 was not restored from a sufficiently old backup
> > ORA-01110: data file 2: '/u01/oradata/tst01/system.dbf'
>
> > :(
>
> > this db is only for developer testing, but i don't want reinstall
> > all.. help!
>
> > thanks
>
> What did you do *exactly*? Exact statements, exact error messages?
> You didn't look up error 1152 in the documentation, didn't you? Why?
> This very much looks like you had a logfile switch after your opened
> the database.
> There is only one solution for that:
> recover databas using backup controlfile until cancel and
> type cancel right away.
> But one would need to see what you did *exactly* to make sure the
> advice is adequate.
>
> If you continue in this fashion, you'll probably notice all your
> queries remain unresponded, you are evolving in a real nuisance, so
> probably next time you would need to reinstall, and you deserve it. It
> is an adequate punishment for people not reading the documentation.
>
sorry, unfortunately i'm impulsive too and i have to reading much more
before post.
Altough i already studing on "Oracle 10G Complete Guide" book, but it
isn't NOT really "complete guide"
Received on Fri Apr 13 2007 - 05:51:02 CDT