Stanby cannot be moved forward

From: Massa Batheli <mngong_at_gmail.com>
Date: 30 Oct 2006 07:19:20 -0800
Message-ID: <1162221560.412299.142980@b28g2000cwb.googlegroups.com>

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 ..
Received on Mon Oct 30 2006 - 09:19:20 CST