I got this error when I first set up my standby database. If you generate a
log switch, and then recover again you will not see the problem. If I
recall correctly, the issue arises when the redo log that was active when
you created your standby control file has not been archived. If you issue a
Janet,
I have found that on NT a shutdown immediate can still lead to recovery being required
when the database is started back up.
That is, maybe you didn't really have a consistent cold backup of your primary.
I have instead opted for a shutdown immediate, startup, shutdown normal sequence to
Title: Standby Database Problem
Hussain,
As long as none of your datafiles were corrupted by
what I assume was the crash of your Standby Instance, you can reinstall 8i and
bring up the Standby just as you describe. The datafiles don't care at all
where Oracle Home is.
I recently had to r