Toad World® Forums

Regularly moving transactions from SE1 to SE. Can TOAD help?

Ahoy!

If you mateys can pardon me for being a bit of a bilge rat today and
posting a (mostly) off-topic question, I need some advice. One of my
clients has a need to move transactions from a 11.1.0.7 SE1 server to
11.1.0.6 SE server. Oracle replication does this smartly, but only in
EE I think and they cannot afford to upgrade to EE. The idea here is
to keep a development database reasonably in sync with their
production system and also used for DR if needed. It doesn’t have to
be real-time, but they don’t want to lose many transactions if the
primary site were to be overrun by other pirates or scalawags and
totally unavailable to them.

Any ideas or suggestions as to how I can help them accomplish this?
Anything in TOAD that could help?

John

We have a product that will do that, and it won’t require EE or SE1
– it’s called Shareplex for Oracle.

Another solution is to copy all log files to the other server and read thema in.
The only things is that you can’t use that database for development because
it must be in standby mode.

Op 19 aug. 2011 19:02 schreef “Jeff Smith” het
volgende:

We have a product that will do that, and it won’t require EE or SE1 -
it’s called Shareplex for Oracle.

Hi Wim,

Another solution is to copy all log files to the other server and read
thema in. The only things is that you can’t use that database for
development because it must be in standby mode.
New features in 11g (11.1) is the ability to open a standby database in
a manner that allows reporting etc to take place. It’s read only
(obviously) but it is much better than having the thing sitting there
doing nothing.


Cheers,
Norm. [TeamT]

Sounds familiar. Is that not available in earlier versions??? Or am I confused
with SQLSERVER where this exists a long time ago…

Groetjes,
Wim

On Sat, Aug 20, 2011 at 20:27, Norman Dunbar wrote:

Hi Wim,

Another solution is to copy all log files to the other server and read
thema in. The only things is that you can’t use that database for
development because it must be in standby mode.

New features in 11g (11.1) is the ability to open a standby database in
a manner that allows reporting etc to take place. It's read only
(obviously) but it is much better than having the thing sitting there
doing nothing.

--
Cheers,
Norm. [TeamT]

Morning Wim,

Sounds familiar. Is that not available in earlier
versions???
Not 100% sure to be honest. I know in 9i you left it in recovery mode.
(The standby I mean.) I think 10g allowed it to be something slightly
better than in recovery mode only, 11g allows reporting etc from a read
only database.

I get confused at times with what each version allowed or didn’t! :wink:

Or am I confused with SQLSERVER where this
exists a long time ago…
I don’t know anything about SQL Server - other than not to use it (!) -
so I don’t know if that’s what you are confusing or not! :wink:

Cheers,
Norm [TeamT]

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk