Printable View
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.
Regards
Hamhey
You could have messed up with a backupfile from a old backup.
The backup should be a cold backup taken at a consistent time by shutting down with normal,immediate or transaction. Then you open the database and backup the standby controlfile.
Thanks
No, the backup should be any kind of full backup, either cold or hot. Full hot backup will be just as good as a cold one.Quote:
Originally posted by Rohit
The backup should be a cold backup taken at a consistent time...
can you please post lines from alert.log file, from the time you mount standby database and query "recover standby database"
HI guys,
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