Standby DB Recover Failure
HI all,
I'm trying to build a standby server. Everything goes just fine until using the recover command from standby database for updating the standby database.
The problem is that I get the error message indicating that the system file is from before resetlogs which is not since I have backuped up the system (opend) after
using resetlogs open of open database commend.
Do you know how to bypass this failure.
The error messages getting from stand database is as follows:
SQL> recover standby database;
ORA-00283: recovery session canceled due to errors
ORA-01190: controlfile or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: '/opt/apps/oracle/product/8.1.5/dbs/oradata/soldb/system01_SOL.dbf'
And the alert file indicating:
ORA-000283 faiure.
Any idea what is wrong. The failure is generate of controlfile or system file. The controlfile has been generated for standby database
Regards
Hamhey