OraFAQ Forum: Data Guard » Creating Standby database in same HOST (SUN )

Home » Server Options » Data Guard » Creating Standby database in same HOST (SUN )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Creating Standby database in same HOST (SUN ) [message #56816]

Mon, 28 April 2003 05:35

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 ...

Report message to a moderator

Re: Creating Standby database in same HOST (SUN ) [message #56818 is a reply to message #56816]

Mon, 28 April 2003 06:04

Maaher
Messages: 7065
Registered: December 2001

Senior Member

What version of oracle?

MHE

Report message to a moderator

Re: Creating Standby database in same HOST (SUN ) [message #56821 is a reply to message #56818]

Mon, 28 April 2003 19:36

Supar
Messages: 9
Registered: January 2003

Junior Member

we using oracle 8.1.7 and we only have 1 Oracle Home

Report message to a moderator

Re: Creating Standby database in same HOST (SUN ) [message #56824 is a reply to message #56816]

Tue, 29 April 2003 00:12

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

Report message to a moderator

Re: Creating Standby database in same HOST (SUN ) [message #56825 is a reply to message #56824]

Tue, 29 April 2003 00:15

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

Report message to a moderator

Re: Creating Standby database in same HOST (SUN ) [message #56826 is a reply to message #56824]

Tue, 29 April 2003 03:02

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

Report message to a moderator

Re: Creating Standby database in same HOST (SUN ) [message #463187 is a reply to message #56826]

Wed, 30 June 2010 02:24

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 14:43:54 CST 2025