If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

I had attended a training in backup and recovery, we configured a standby database on the same machine, the standby database is offline and the primary db is up and running, we transact to the primary db and shutdown it, then we applied the logs to the standby db, and then startup it up.

2. copy this generated controlfile to directory where you intend to place
the standby database

3. Make a copy of the init.ora file to be used by the standby database
and include the appropriate initialization parameters to point to
where where the primary database files reside, followed by the
directory path where the (test) standby database will reside:

6. If you shut the primary database down, the command succeeds but then
you get the same error when trying to open the primary database.

7. Deleting the lk file made no difference - but maybe that was
because it was not really deleted as it was being held open by some
process.

Problem Explanation:
====================
The failure is because shared memory has already been
created for this ORACLE SID, and you are attempting to create the same
shared memory for the same ORACLE SID.