Home » Server Options » Data Guard » Creating Standby database in same HOST (SUN )
Creating Standby database in same HOST (SUN ) [message #56816] Mon, 28 April 2003 05:35 Go to next message
Supar
Messages: 9
Registered: January 2003
Junior Member
Hai can any one help me , explain my problem bellow !

How i create Standby Database in Same HOST, we using SUN OS 5.8.

I read form Oracle DOC that i can create Standby Database in Same HOST and follow the tutorial , but when i try to mount standby database using ALTER DATABASE MOUNT STANDBY DATABASE EXCLUSIVE; i got a error message ORA-01102: cannot mount database in EXCLUSIVE mode

thank A lot ...
Re: Creating Standby database in same HOST (SUN ) [message #56818 is a reply to message #56816] Mon, 28 April 2003 06:04 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
What version of oracle?

MHE
Re: Creating Standby database in same HOST (SUN ) [message #56821 is a reply to message #56818] Mon, 28 April 2003 19:36 Go to previous messageGo to next message
Supar
Messages: 9
Registered: January 2003
Junior Member
we using oracle 8.1.7 and we only have 1 Oracle Home
Re: Creating Standby database in same HOST (SUN ) [message #56824 is a reply to message #56816] Tue, 29 April 2003 00:12 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
ORA-01102 cannot mount database in EXCLUSIVE mode
Cause:    Some other instance has the database mounted exclusive or shared.
Action:    Shut down the other instance or mount in a compatible mode.

----------------------------------------------------------------------

Another interesting suggestion found:
- LOCK_NAME_SPACE should be set to something other than the db_name for the
Standby Database's "init.ora". This will allow us to have two databases
on the same machine with the same db_name setting. Without this setting,
"ORA-1102: cannot mount database in exclusive mode" will be signalled when
the second database is mounted.

Make sure all other instances are down before trying to mount the standby (at least when not running Parallel Server). When I look at some docs, it seems that in $ORACLE_HOME/dbs there's a file named "LK<db_name>" when a DB is mounted. Make sure none of these files stayed there as some sort of leftover of the other instance.

And here's what Tom Kyte has to say about it:
You are running into this since you are trying to have a standby on the same 
machine with the real database.  The SGA's are bumping into eachother:

1. Shutdown the standby database

2. Starting with Oracle Release 7.3.3:
   add _standby_lock_name_space=<new_name> in the init.ora of 
   standby database

   Starting with Oracle Release 8.0.X:
   add lock_name_space=<new_name> in the init.ora of standby 
   database

   where <new_name> is a name other than the primary's database 
   name, up to 8 characters long

   You can use a naming convention like:  
   If Primary db_name = DB1
   set lock_name_space = DB1s

3. startup nomount standby database

4. alter database mount standby database
 

The above solution works for TESTING standby databases on the
same machine as the Primary Database.

Do not, however, use the same machine to keep an actual standby
database.  This defeats the purpose of a standby if your entire
machine were to crash.

HTH,
MHE
Re: Creating Standby database in same HOST (SUN ) [message #56825 is a reply to message #56824] Tue, 29 April 2003 00:15 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
HTML swallowed some of my text.

----------------------------------------------------------------------
Make sure all other instances are down before trying to mount the standby (at least when not running Parallel Server). When I look at some docs, it seems that in $ORACLE_HOME/dbs there's a file named "LK< DB_NAME >" when a DB is mounted. Make sure none of these files stayed there as some sort of leftover of the other instance.

----------------------------------------------------------------------

MHE
Re: Creating Standby database in same HOST (SUN ) [message #56826 is a reply to message #56824] Tue, 29 April 2003 03:02 Go to previous messageGo to next message
Supar
Messages: 9
Registered: January 2003
Junior Member
Ok Thank Mr/Mrs Maaher, your suggest is right
i miss LOCK_NAME_SPACE in my standby database parameter file. My standby database is working right now ..

Thank's you very much
Re: Creating Standby database in same HOST (SUN ) [message #463187 is a reply to message #56826] Wed, 30 June 2010 02:24 Go to previous message
dba4oracle
Messages: 100
Registered: June 2010
Senior Member
I have 11g db
i set LOCK_NAME_SPACE in standby init.ora
What if this test is done with oracle 11g where
ORA-32006: LOCK_NAME_SPACE initialization parameter has been deprecated

Still
ORA-01102: cannot mount database in EXCLUSIVE mode

Any suggestions friend

Thanks
Previous Topic: Problem with Dataguard -- ORA-01102: cannot mount database in EXCLUSIVE mode
Next Topic: shutdown down in primary database in Data guard environment
Goto Forum:
  


Current Time: Thu Mar 28 14:29:38 CDT 2024