Thanks. It is helpful.
Regards,
Omega Li
-Original Message-
From: ddussie ddus...@aol.com
Sent: 17/04/2015 02:14
To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG
Subject: Re: AR System Database Replication
We are on Oracle 11g, looking to go to 12g on AIX.
We do dataguard replication
Please share the exact name of the oracle product with version, please.
Many thanks,
Omega
-Original Message-
From: Jamie jamie.bo...@transamerica.com
Sent: 16/04/2015 22:46
To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG
Subject: Re: AR System Database Replication
What database
What database are you using? We have Oracle and utilize archive log shipping
to replicate our data to our reporting database. We also use Oracle Active
Data Guard on our reporting database so that we can query it while data is
being replicated to it.
We are on Oracle 11g, looking to go to 12g on AIX.
We do dataguard replication (shipping logs frequently to remote site)
- I vaguely remember to DBA, saying either 11g or dataguard has feature that
allows the Db to remain in standby read-only mode; so based on how often you
replicate (shipping
Hi List,
We are planning to have AR System Database Replication for Reporting purpose.
Replication will be for real time transactional Data Exchange i.e immediate
synchronization. Please let me know what are the things to be conidered and
tested in the Scenario.
Thanks
Madhu
Hello Madhu,
Please check the below given BMC published KA link regarding info on DB
Replication.
*Knowledge Article ID:* KA317702
https://kb.bmc.com/infocenter/index?page=contentid=KA317702actp=searchviewlocale=en_USsearchid=1429027171548
Also you will find below note in DB reference guide
Thank you Munesh :)
On Tue, Apr 14, 2015 at 9:45 PM, munesh konda munesh.ko...@gmail.com
wrote:
**
Hello Madhu,
Please check the below given BMC published KA link regarding info on DB
Replication.
*Knowledge Article ID:* KA317702
https://kb.bmc.com/infocenter/index?page=contentid
Hello List,
SRDF = Symmetrix Remote Data Facility
DR = Disaster Recovery
I asked this questions maybe 2 years ago, but I presume no one at the time was
doing SRDF.
So, here I am again.
We current DataGuard Replication between or production and DR ARSystem
environment on UNIX with Oracle DB
Mike,
Two possible strategies:
1) Do as you are doing now and as others have indicated, use archgid to change
the
schema ID after create to match the ID on the production system and then turn
on replication for that table.
2) Just replicate the ENTIRE database. Don't worry about table
: Tuesday, March 04, 2014 11:18 AM
To: arslist@ARSLIST.ORG
Subject: Re: Database replication to reporting server
Mike,
Two possible strategies:
1) Do as you are doing now and as others have indicated, use archgid to change
the
schema ID after create to match the ID on the production system
Thank you, Doug and Jason.
This should work.
Mike
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug
Sent: Tuesday, March 04, 2014 12:18 PM
To: arslist@ARSLIST.ORG
Subject: Re: Database replication
Hi List,
We have the table-based replication of the SQL production database to reporting
server.
Our DBAs require to provide them the T.. H.. and B.. table information along to
the schema name. This works fine for the existing schemas. Replication is the
real-time.
We have issues with the new
...@tdameritrade.comwrote:
Hi List,
We have the table-based replication of the SQL production database to
reporting server.
Our DBAs require to provide them the T.. H.. and B.. table information
along to the schema name. This works fine for the existing schemas.
Replication is the real-time.
We
_
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller
Sent: Monday, March 03, 2014 9:50 PM
To: arslist@ARSLIST.ORG
Subject: Re: Database replication to reporting server
**
You can use archgid to chance the Schema ID (form ID
Hello Everyone!
We got a requirement to upgrade the database and due to this we need to change
the replication database.
Has anybody ever fell in such situation ? Any steps or guidance would be
appreciated
Thanks Folks...
There were a few issues to address witht the DBA, but once we were
both on the same page - we got everything up and running.
It was at least comforting to know that others had been successful at
this endeavour; therefore, all that was needed was a little BST (Blood
Sweat and
Sorry forgot to add the following:
Lessons Learned:
1) Restoring a 2005 SQL database to a 2008 SQL database may have been
the culprit.
2) Even if your 2008 database is running in 2005 Mode - this will
cause unusual problems.
3) ar.cfg needs to be updated.
4) For some reason the ARAdmin User gets
We have a complete automated solution utilizing SSIS Scripts which will:
1. 7zip the complete last night full backup of production
2. FTP the compressed file to the target system (test / dev / etc)
3. Uncompress the remote file
4. shutdown remedy processes
5. restore the database
) Production
5) Reporting/Archiving (to be deployed).
What we need to do is the following:
1) Update the Staging and Development environments with data from
production
2) Replicate the Production database to our new Reporting/Archiving
environment.
Options being considered:
A) Database Replication.
B
: SQL Database Replication
Hi Folks...
I am going to ask this question again - because I have never seen a
definitive answer.
Here is what we have:
1) Independent SQL Database Tier (2005).
2) ARSystem Application Tier (7.5 Patch 2).
3) Mid-tier (7.5 Patch 2).
Environments:
1) Sandbox
2
list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Elry
Sent: Thursday, July 15, 2010 7:47 AM
To: arsl...@arslist.org
Subject: SQL Database Replication
Hi Folks...
I am going to ask this question again - because I have never seen a
definitive answer.
Here is what we have:
1
...@gmail.com]
Sent: Thursday, July 15, 2010 8:46 AM
To: arslist@ARSLIST.ORG
Subject: SQL Database Replication
Hi Folks...
I am going to ask this question again - because I have never seen a
definitive answer.
Here is what we have:
1) Independent SQL Database Tier (2005).
2) ARSystem Application Tier (7.5
From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on
behalf of Elry [elryal...@gmail.com]
Sent: Thursday, July 15, 2010 8:46 AM
To: arsl...@arslist.org
Subject: SQL Database Replication
Hi Folks...
I am going to ask this question again - because I have never seen
ssion list(ARSList) [arsl...@arslist.org] on behalf of Elry [elryal...@gmail.com] Sent: Thursday, July 15, 2010 8:46 AM To: arsl...@arslist.org Subject: SQL Database Replication Hi Folks... I am going to ask this question again - because I have never seen a definitive answer. Here is what we have: 1) I
Thanks Terry...
Just spoke to the DBA - what he actually did was:
1) Made a backup copy of Production.
2) Restored the backup copy to the Sandbox.
This appears to be quite different from replication - could this be
the source of the problem.
On Jul 15, 11:30 am, Terry Bootsma tboot
the backup copy to the Sandbox.This appears to be quite different from replication - could this bethe source of the problem.On Jul 15, 11:30am, Terry Bootsma tboot...@objectpath.com wrote: ** Elry: One thing to consider is that when you replicate from server A to server B, the replicated database may
Guillaume
From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on
behalf of Elry [elryal...@gmail.com]
Sent: Thursday, July 15, 2010 11:36 AM
To: arslist@ARSLIST.ORG
Subject: Re: SQL Database Replication
Thanks Terry...
Just spoke
file, make sure you point that file to the right
database server, or you might end up having a test server point to production...
Joe
From: Elry elryal...@gmail.com
To: arslist@ARSLIST.ORG
Sent: Thu, July 15, 2010 8:46:57 AM
Subject: SQL Database Replication
15, 2010 11:44 AM
To: arslist@ARSLIST.ORG
Subject: Re: SQL Database Replication
**
Elry,
One of the reasons answers differ and vary is the configuration. All depends on
what applications you are using. Does the application have configuration data
that hard codes server names like AIE would
From: Elry elryal...@gmail.com
To: arsl...@arslist.org
Sent: Thu, July 15, 2010 8:46:57 AM
Subject: SQL Database Replication
Hi Folks...
I am going to ask this question again - because I have never seen a definitive
answer.
Here is what we have:
1) Independent
:36 AM
To: arslist@ARSLIST.ORG
Subject: Re: SQL Database Replication
Thanks Terry...
Just spoke to the DBA - what he actually did was:
1) Made a backup copy of Production.
2) Restored the backup copy to the Sandbox.
This appears to be quite different from replication - could this be
the source
just fine.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Elry
Sent: Thursday, July 15, 2010 9:36 AM
To: arsl...@arslist.org
Subject: Re: SQL Database Replication
Thanks Terry...
Just spoke to the DBA - what he
application, that function works just fine.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Elry
Sent: Thursday, July 15, 2010 9:36 AM
To: arsl...@arslist.org
Subject: Re: SQL Database Replication
Thanks Terry
address instead
of @ in the database.
Joe
From: Elry elryal...@gmail.com
To: arslist@ARSLIST.ORG
Sent: Thu, July 15, 2010 11:50:26 AM
Subject: Re: SQL Database Replication
Thanks Joe...
The application that we are using is not ITSM. It is a custom application
From: Elry elryal...@gmail.com
To: arsl...@arslist.org
Sent: Thu, July 15, 2010 11:50:26 AM
Subject: Re: SQL Database Replication
Thanks Joe...
The application that we are using is not ITSM. It is a custom application
that
we have built.
All the developers were warned
desktop apps that hooked into our production server (every PC in our
environment connects to Remedy db to get config data when it boots) to point
to our new server by the time we were going live. We used MS SQL db
replication (2008 - 2005) to keep a few tables in the old db synchronized
real time. I
Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Elry
Sent: Thursday, July 15, 2010 1:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: SQL Database Replication
Well...
We were able to get the system up and running, but I noticed
list(ARSList) [mailto:
arsl...@arslist.org] On Behalf Of Elry
Sent: Thursday, July 15, 2010 1:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: SQL Database Replication
Well...
We were able to get the system up and running, but I noticed that
there are some odd things:
1) All structures and data
From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on
behalf of Elry [elryal...@gmail.com]
Sent: Thursday, July 15, 2010 2:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: SQL Database Replication
Well...
We were able to get the system up and running, but I
] On Behalf Of Guillaume Rheault
Sent: Thursday, July 15, 2010 12:14 PM
To: arslist@ARSLIST.ORG
Subject: Re: SQL Database Replication
Hey Elry,
One more thing that I forgot to mention to you, that is a new feature with ARS
7.5, I believe.
As you may know, AR Server license keys are stored
it will be smoother.
Guillaume
From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on
behalf of Elry [elryal...@gmail.com]
Sent: Thursday, July 15, 2010 2:12 PM
To: arsl...@arslist.org
Subject: Re: SQL Database Replication
Well...
We
++
Please Read The Disclaimer At The Bottom Of This Email
++
HI,
We have DB replication enabled on SQL2005 and it has to be turned off
before making any changes to forms in Remedy.
Moving
Hi,
we had many problems with database-replication as well (one point was that
we lost data after we modified forms with ARAdmin). We are using the DB-copy
for Reporting issues only, so we moved over to simple Logshipping instead.
This method of replicating a DB does not influence the source
All,
We have windows 2003 with sql 2005, ARS 7.1.0, ITSM 7.0.3. Our database
engineer set up SQL replication for our production sql server to our
backup sql server. The problem is that when he does the SQL replication
set up the remedy system does not agree with it. We get errors when
have windows 2003 with sql 2005, ARS 7.1.0, ITSM 7.0.3. Our database
engineer set up SQL replication for our production sql server to our backup
sql server. The problem is that when he does the SQL replication set up the
remedy system does not agree with it. We get errors when someone modifies
Brandi,
I have replicated databases on MS-SQL, Oracle and other databases successfully
and not have Remedy throw up on the users..
What method of replication did the dba use?
Does the ARAdmin user that owns the ARSystem database have the same rights and
privileges as the ARAdmin user
Brandi,
We have been using SQL replication for several years. While I am not a
DBA here is what I can remember:
* Tables created by Remedy in ARSYSTEM really does not declare C1
as a primary key (at least in SQL 2000).
* I believe this is done manually by the DBA.
* When
Joe,
We are trying to use SQL Transactional Replication.
If ARAdmin is not the owner of the table could that cause these issues? We
were not having issues before the replication was put in place.
Joe DeSouza [EMAIL PROTECTED]
Sent by: Action Request System discussion list(ARSList
', 'ARAdmin';
Joe
- Original Message
From: Brandi Barbour [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Thursday, October 16, 2008 2:49:02 PM
Subject: Re: Replication
**
Joe,
We are trying to use SQL Transactional
Replication.
If ARAdmin is not the owner of the table
could
Also remember if you are on 7.1, that the licenses are now keept on the
database and check the CAI application Registry form to make sure its
pointed to the correct server.
Howard
On 6/17/08, Run4Life Win [EMAIL PROTECTED] wrote:
Yes you should keep your ARS down till the time replication
Hi,
We are copying production to QA - via a database replication.? Should we shut
down the application server when this is in progress?
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor
Yes you should keep your ARS down till the time replication is taking place
Regards
Himanshu Kohli
On 6/17/08, Koyb P. Liabt [EMAIL PROTECTED] wrote:
Hi,
We are copying production to QA - via a database replication.? Should we
shut down the application server when this is in progress
Chris:
What kind of replication did your DBA set up? We have a customer looking at
this type of configuration in order to create a reporting server. They're
deciding between either transactional replication with a read-only consumer or
a mirrored database with snapshots.
BTW, we did some
Chris,
We have been using transactional replication with SQL for about 4 years
now. It works like a charm. Of course we are still on SQL 2000. There
are some challenges.
From a SQL standpoint Remedy really does not declare a primary key on
the tables. We all know that it is C1
IT Center
http://itsm.unt.edu/ http://itsm.unt.edu/
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger
Sent: Friday, June 06, 2008 2:03 PM
To: arslist@ARSLIST.ORG
Subject: Re: Cautionary tale? SQL Replication service and Remedy
, Roger
Sent: Friday, June 06, 2008 1:03 PM
To: arslist@ARSLIST.ORG
Subject: Re: Cautionary tale? SQL Replication service and Remedy
**
Chris,
We have been using transactional replication with SQL for about 4 years now.
It works like a charm. Of course we are still on SQL 2000. There are some
PROTECTED] *On Behalf Of *Phil Murnane
*Sent:* Friday, June 06, 2008 9:29 AM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: Cautionary tale? SQL Replication service and Remedy
Chris:
What kind of replication did your DBA set up? We have a customer looking
at this type of configuration in order
There is a limit on the number of columns that can be replicated. Most
people would suggest to break up you form if possible. The nice thing
about replication is you do not have to replicate everything. Try to
only replicate what is needed.
Thanks,
Roger A. Nall
Manager, OSSNMS Remedy
We are running snapshot replication on a non-Remedy database and it works
great. Since I have an understanding of how that works and how Remedy works,
I may be able to offer some suggestions:
First, as you all know, the way remedy works, forms are data. That is not
the case with all database
Hey everyone-
Has anyone had any experience using the SQL replication ability built into
2005? I don't know much about it- apparently it's a function which looks at
transaction logs and uses them to create and maintain a separate instance of a
DB. Our DBA was planning to use it to create
have some detailed docs on how to set this up and
perform role reversals and failovers.
I hope to use transactional replication to feed our reporting server
some day down the road. Remedy supports this starting with version 7,
but I'm on 6.3. Currently I use DSO to feed my reporting server but it
has
Hi All,
Environment:
ARS 7.0.x
Windows 2003
ITSM 7.0.x
Mid-Tier 7.0.x
All on the same server.
On an MS SQL Server 2000 or 2005, what are the pros and cons of using
the following Replication methods for failover/disaster recover
o Log Shipping
o Snapshot Replication - may not cope with full
Classification: UNCLASSIFIED
Caveats: NONE
What vehicles are currently utilized for Data Replication on most Remedy
Systems? How does everyone do mirroring of Remedy data and objects?
We are a Unix/Oracle shop.
Thanks up front,
Gordon M. Frank
Lockheed Martin
Classification: UNCLASSIFIED
63 matches
Mail list logo