| 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 ...
|
|
|
|
|
|
|
|
| Re: Creating Standby database in same HOST (SUN ) [message #56824 is a reply to message #56816] |
Tue, 29 April 2003 00:12  |
Maaher
Messages: 6963
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 |
Maaher
Messages: 6963
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 #463187 is a reply to message #56826] |
Wed, 30 June 2010 02:24 |
dba4oracle
Messages: 3
Registered: June 2010
|
Junior 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
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
