-
Recovry failure- Standby db
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
Success Consists of Getting Up Just One More Time Than You've Fallen Down
Be Blessed
-
Originally posted by Rohit
The backup should be a cold backup taken at a consistent time...
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.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
can you please post lines from alert.log file, from the time you mount standby database and query "recover standby database"
Moe M Haroon
-
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
Last edited by hamhey; 04-26-2003 at 01:58 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|