standy to be created from backup that has been opened read only

From: Massa Batheli <mngong_at_gmail.com>
Date: 29 Oct 2006 11:20:59 -0800
Message-ID: <1162149659.723234.266410@h48g2000cwc.googlegroups.com>

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 Sun Oct 29 2006 - 13:20:59 CST