Your post calls for the proverbial crystal ball, as you don't specify
what *exact* steps you have taken.
It very much looks like by opening the database you have switched the
log file. In your previous post you specified you also manually switch
a log file.
Consequently, your target/standby database is ahead of the primary
database.
If that is correct, the question is not why it fails, but why it
succeeded previously.
--
Sybrand Bakker
Senior Oracle DBA
On Oct 30, 4:19 pm, "Massa Batheli" <mng..._at_gmail.com> wrote:
> Let me rephrase and could be lucky get a response.
>
> There are three servers.
> 1)Production
> 2)Standby
> 3)Backup
> A backup is taken from production server to backup server.
> Recovered and opened read only to acertain the validity of backup.
> This is then moved to standby server and ready for logs to be applied
> Is there any problem with this?
> The standby fails consistently and there have been suggestions that you
> do not have to recover.
>
>
>
> Massa Batheli wrote:
> > Oracle 9.2.05 on hp unix 64bit no clusters no rac
>
> > To make sure backups are good they database files are saved to a server
> > ,opened readonly shut down and then backed up to tape.
> > Bcv sync / split are done to get the backups
>
> > This copy of tested good backup is used to create a standby database.
> > The standby control file is created after I have made sure the backup
> > is good(i.e has been opened
> > read only) and copied from a live production after switching a log file
>
> > These have been working for a while but suddenly I get ORA-1152 even
> > if the database is requested to recover till the current time which
> > means it will be way ahead of the backup.The error seems to indicate
> > the datafile(system) for the most part has an scn older than the
> > control file
> > Not sure what is going on ,Metalink advices that more archived log
> > files be applied but that does not work either
>
> > Your input is appreciated ..- Hide quoted text -- Show quoted text -
Received on Mon Oct 30 2006 - 09:45:54 CST
