OraFAQ Forum: Data Guard » Problem with Dataguard -- ORA-01102: cannot mount database in EXCLUSIVE mode

Home » Server Options » Data Guard » Problem with Dataguard -- ORA-01102: cannot mount database in EXCLUSIVE mode (Oracle9i R2)

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

Problem with Dataguard -- ORA-01102: cannot mount database in EXCLUSIVE mode [message #330569]

Mon, 30 June 2008 08:31

Creems
Messages: 70
Registered: July 2007
Location: Johannesburg

Member

Hi,

I'm trying to create a physical standby database on my Oracle9i DB runing on WinXP.

Note: I have both Primary and Standby on the same system.

Actually everything went well .... I did created the standby DB but the problem is I can not start my primary DB if my standby DB is mounted. I get this error:
ORA-01102: cannot mount database in EXCLUSIVE mode

And when I read about the error message I learnt that I should start my DB in compatible mode ... please how do I do that?

Or possibly how can I make this work.

Regards,

Cherish

Report message to a moderator

Re: Problem with Dataguard -- ORA-01102: cannot mount database in EXCLUSIVE mode [message #330572 is a reply to message #330569]

Mon, 30 June 2008 08:43

Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Took your title, put it in search field, get:
http://www.orafaq.com/forum/?SQ=f83f44319c383cee4f5f69a8de2f16b8&t=search&srch=ORA-01102%3A+cannot+mount+database+in+EXCLUSIV E+mode&btn_submit=Search&field=all&forum_limiter=12&search_logic=AND&sort_order=DESC&author=

Check these links.

Regards
Michel

Report message to a moderator

Re: Problem with Dataguard -- ORA-01102: cannot mount database in EXCLUSIVE mode [message #330919 is a reply to message #330569]

Tue, 01 July 2008 15:04

gaperumal
Messages: 8
Registered: June 2008
Location: Chennai India

Junior Member

Hi
Same host, that too in windows, will create the problem like this. Better go for two different hosts. I have tried and failed. I was able to setup in two hosts successfully.

Thanks,
Arangaperumal
Chennai,INDIA

[Updated on: Tue, 01 July 2008 15:05]

Report message to a moderator

Re: Problem with Dataguard -- ORA-01102: cannot mount database in EXCLUSIVE mode [message #331013 is a reply to message #330919]

Wed, 02 July 2008 02:44

Creems
Messages: 70
Registered: July 2007
Location: Johannesburg

Member

Hi,

Actually I thank you for your contribution.

But it finally work on same host maybe you gave up too soon.

Regards,

Cherish

Report message to a moderator

Re: Problem with Dataguard -- ORA-01102: cannot mount database in EXCLUSIVE mode [message #463182 is a reply to message #331013]

Wed, 30 June 2010 02:12

dba4oracle
Messages: 100
Registered: June 2010

Senior Member

Hello
Hello please let me know how your issue is resolved

I am using windows oracle 11g i am trying to implement dataguard on same machine (primary and standby db on same machine)
I follow steps as below:

1)force logging primary
2)shutdown primary copy all datafiles to standby filesystem
3)editing listener and tnsnames for both primary and standby
4)editing init.ora for both primary and standby(for standby
modified and used init.ora of primary so db name etc same,only
parameters as below changed:
Primary:
=======

log_archive_dest_1
log_archive_dest_2
log_archive_dest_state_1
log_archive_dest_state_2
fal_client
fal_server
archive_lag_target
_log_archive_callout
#standby_archive_dest= ## UncDB1ment after switchover ##
#standby_file_management=auto ## UncDB1ment after switchover ##
#log_archive_dest_state_2=DEFER ## UncDB1ment after switchover ##

Standby:
=======
log_archive_dest_1=
log_archive_dest_state_1
log_archive_dest_2=
log_archive_dest_state_2=
standby_archive_dest=
standby_file_management=auto
fal_client=
fal_server=

Am i missing something or doing anything wrong please suggest

thanks

Report message to a moderator

Re: Problem with Dataguard -- ORA-01102: cannot mount database in EXCLUSIVE mode [message #463183 is a reply to message #463182]

Wed, 30 June 2010 02:13

dba4oracle
Messages: 100
Registered: June 2010

Senior Member

sorry i forget to add i also made standby control file and configured on standby

Report message to a moderator

Previous Topic:	fast-start failover in data guard
Next Topic:	Creating Standby database in same HOST (SUN )

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 08:29:15 CDT 2025