OraFAQ Forum: RAC & Failsafe » Standalone Database

Home » Server Options » RAC & Failsafe » Standalone Database (Oracle 11.2 ,Oracle solaris sparc 11)

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

Standalone Database [message #615240]

Sun, 01 June 2014 06:08

mirasraf
Messages: 52
Registered: June 2006
Location: DHAKA

Member

Hello,

We have installed Oracle RAC Database( 2 NODE) in DC site, we want to create a new database(Standalone) in DR site. Datafile of DC will replicate in DR site and DR Standalone database mount from that datafiles . please help me .

Regards

Asraf

[Updated on: Sun, 01 June 2014 07:36]

Report message to a moderator

Re: Standalone Database [message #615251 is a reply to message #615240]

Sun, 01 June 2014 07:50

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

Are you trying to set up Data Guard? If so, what is the problem?

Report message to a moderator

Re: Standalone Database [message #615252 is a reply to message #615251]

Sun, 01 June 2014 08:30

mirasraf
Messages: 52
Registered: June 2006
Location: DHAKA

Member

Thanks
We have created data guard in DC site ,we want to create another database in DR site that database mount with DC datafiles, If DC site unavailabe than we mount DR site database. SAN (stoarage Area Network) data will replicate from DC (database) to DR(database) site.

Regards
Asraf

Report message to a moderator

Re: Standalone Database [message #615253 is a reply to message #615252]

Sun, 01 June 2014 08:33

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

Senior Member
Account Moderator

Where is the question?

Report message to a moderator

Re: Standalone Database [message #615254 is a reply to message #615252]

Sun, 01 June 2014 08:33

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

I do not understand you. Perhaps someone else does,

Report message to a moderator

Re: Standalone Database [message #615255 is a reply to message #615254]

Sun, 01 June 2014 08:42

mirasraf
Messages: 52
Registered: June 2006
Location: DHAKA

Member

Hello,

We have installed Oracle RAC Database(2 NODE) in DC site. SAN (stoarage Area Network) data will replicate from DC (database) to DR(database) site.
we want to create a new database(Standalone) in DR site. Datafile of DC(RAC DB) will replicate in DR site and DR Standalone database mount from that datafiles. Please help us how to create DR database.

Asraf

Report message to a moderator

Re: Standalone Database [message #615258 is a reply to message #615255]

Sun, 01 June 2014 08:57

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

Senior Member
Account Moderator

So you want to create a standby database or not?

Report message to a moderator

Re: Standalone Database [message #615263 is a reply to message #615258]

Sun, 01 June 2014 09:38

mirasraf
Messages: 52
Registered: June 2006
Location: DHAKA

Member

not stanadby database

Report message to a moderator

Re: Standalone Database [message #615267 is a reply to message #615263]

Sun, 01 June 2014 10:03

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

Senior Member
Account Moderator

What is the difference between a standby database and what you want to do?

Report message to a moderator

Re: Standalone Database [message #615272 is a reply to message #615267]

Sun, 01 June 2014 10:34

mirasraf
Messages: 52
Registered: June 2006
Location: DHAKA

Member

In DC ,we have installed RAC ( 2 NODE) , when DC unavailable , DR database will be Live.

DR database will be $E:\Projects_CBS\DR_database$

Attachment: DR_database.PNG
(Size: 33.34KB, Downloaded 1753 times)

[Updated on: Sun, 01 June 2014 10:42]

Report message to a moderator

Re: Standalone Database [message #615273 is a reply to message #615272]

Sun, 01 June 2014 10:38

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

Sounds like a physical standby database to me. Or are you trying to avoid paying licence fees for the DR site?

Report message to a moderator

Re: Standalone Database [message #615274 is a reply to message #615273]

Sun, 01 June 2014 10:45

mirasraf
Messages: 52
Registered: June 2006
Location: DHAKA

Member

We have purchase Oracle licence for RAC, Data Guard also Cloud control. DR site in standalone database is very much vital for us.

Report message to a moderator

Re: Standalone Database [message #615275 is a reply to message #615272]

Sun, 01 June 2014 10:45

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

Senior Member
Account Moderator

If SAN replication is synchronous, there is nothing to do, just start the DR database when DC is down.

Report message to a moderator

Re: Standalone Database [message #615276 is a reply to message #615274]

Sun, 01 June 2014 10:49

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

mirasraf wrote on Sun, 01 June 2014 16:45

We have purchase Oracle licence for RAC, Data Guard also Cloud control. DR site in standalone database is very much vital for us.

There is no such thing as a licence for Data Guard, it is part of Enterprise Edition. There is no such thing as a licence for Cloud Control, you licence the individual managed resources, not OEM. So, to repeat, have you licensed the DR site? If you have, use Data Guard. If you haven't, you can't start an database instance there.

Report message to a moderator

Re: Standalone Database [message #615277 is a reply to message #615276]

Sun, 01 June 2014 11:02

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

Senior Member
Account Moderator

John, if I understand him correctly this is a SAN replication of all database files. If you cut the SAN link and start the database on the DR site Oracle will think there has been an instance shutdown and will do an instance recovery.

Report message to a moderator

Re: Standalone Database [message #615279 is a reply to message #615277]

Sun, 01 June 2014 11:22

mirasraf
Messages: 52
Registered: June 2006
Location: DHAKA

Member

Yes , Michel Cadot, your are right.. we want this type of DR database, so please help us how to create This system.

Report message to a moderator

Re: Standalone Database [message #615280 is a reply to message #615277]

Sun, 01 June 2014 11:26

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

Michel Cadot wrote on Sun, 01 June 2014 17:02

John, if I understand him correctly this is a SAN replication of all database files. If you cut the SAN link and start the database on the DR site Oracle will think there has been an instance shutdown and will do an instance recovery.

I agree with you on this - but I have never made it work. That will be because I have never had the SAN replication working synchronously. The Sys admins do not understand what is needed.
I'm sure it does work, but I have no confidence in being able to set it up.

Report message to a moderator

Re: Standalone Database [message #615281 is a reply to message #615279]

Sun, 01 June 2014 11:29

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

mirasraf wrote on Sun, 01 June 2014 17:22

Yes , Michel Cadot, your are right.. we want this type of DR database, so please help us how to create This system.

You have a specific problem: it is illegal for you to test, if you have not licensed the DR site. As you have repeatedly ignored questions about that, I assume that it is not licensed and that the whole idea is to avoid the need to license it. OK, no problem. But it means that you have get rock-solid guarantee from your SAN vendor and from Oracle that it will work. Because you can't test it.

Report message to a moderator

Re: Standalone Database [message #615283 is a reply to message #615280]

Sun, 01 June 2014 11:33

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

Senior Member
Account Moderator

Quote:

but I have never made it work. That will be because I have never had the SAN replication working synchronously.

I had it (in an investment banking client) and it works. Oracle is really strong.

Report message to a moderator

Re: Standalone Database [message #615284 is a reply to message #615279]

Sun, 01 June 2014 11:34

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

Senior Member
Account Moderator

mirasraf wrote on Sun, 01 June 2014 18:22

Yes , Michel Cadot, your are right.. we want this type of DR database, so please help us how to create This system.

As I said, there is nothing to do at Oracle side.
(Almost) All is made by your storage team.

Report message to a moderator

Re: Standalone Database [message #615293 is a reply to message #615284]

Sun, 01 June 2014 14:13

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Michel and John, per your responses, I have a question. Do you guys mean/agree respectively that data guard licensing is not a part of Oracle Enterprise editiin having all components included? Components for example RAC...

Report message to a moderator

Re: Standalone Database [message #615294 is a reply to message #615293]

Sun, 01 June 2014 14:24

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

Senior Member
Account Moderator

Data Guard is part of EE, but the broker not (at least the last time I checked it but license contents changed so often...).

Report message to a moderator

Re: Standalone Database [message #615295 is a reply to message #615294]

Sun, 01 June 2014 14:43

mirasraf
Messages: 52
Registered: June 2006
Location: DHAKA

Member

Hello,

please help to build database

Report message to a moderator

Re: Standalone Database [message #615296 is a reply to message #615295]

Sun, 01 June 2014 14:45

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

Senior Member
Account Moderator

What didn't you understand to what I said?
I advise you to hire someone and validate to do this, you are not skilled enough.

Report message to a moderator

Re: Standalone Database [message #616344 is a reply to message #615296]

Mon, 16 June 2014 01:15

mirasraf
Messages: 52
Registered: June 2006
Location: DHAKA

Member

Hello,

We open database whose datafiles replicate(SAN 2 SAN) from remote RAC DB datafiles.

Report message to a moderator

Re: Standalone Database [message #618980 is a reply to message #616344]

Thu, 17 July 2014 02:16

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

mirasraf wrote on Mon, 16 June 2014 06:15

Hello,

We open database whose datafiles replicate(SAN 2 SAN) from remote RAC DB datafiles.

How do you open the database normally?
What's difficult thing you or your team or your hire DBA, System Admin face?
The synchronization SAN-to-SAN, even Storage-to-Storage always has got one difficult thing. When you got success synchrony, you must have got it. Tell me what's it?

Report message to a moderator

Previous Topic:	Drop database in mount state
Next Topic:	Drop database in standalone database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 17:35:03 CDT 2025