one machine to another? Is it true that machine specific information is
stored in the database? I have some instructions for a MSSQL copy, however,
are there any catches with Oracle?
Here's a procedure written by our DBA to do exactly what you want to
do, but I haven't had time to use/test it as yet. We have used a similiar
procedure for our Remedy 3.2 system.
1. Set up oracle environment variables:
ORACLE_HOME=e:\orant
ORACLE_ADMIN=e:\oracle\admin
Description :
This document should be used as a guideline to copy an existing closed
database from one server to another server.
Procedure :
1) Log in to database that is to be copied.
Svrmgr30
SVRMGR> connect internal
Password:
1) Perform multiple log switches to the existing open database.
SVRMGR> alter system switch logfile;
1) Obtain list of all datafiles of the existing open database.
SVRMGR> spool SVRMGR> select File_Name from dba_tablespaces;
SVRMGR> spool off;
1) Obtain list of all logfiles of the existing open database.
SVRMGR> spool SVRMGR> select Member from v$logfile;
SVRMGR> spool off
1) Shut down database.
SVRMGR> select * from v$database; (verify connection to the proper database)
SVRMGR> shutdown immediate;
1) Map all drives on the remote system that will have files copied to
it.
With an Explorer window from the pull down Menu
Tools Ø Map Network Drive... Ø Ø OK
1) Copy all files associated with the database from the source server.
C:\> xcopy :\:\ /s /e
Sample Copy:
C:\> xcopy E:\oracle J:\oracle /s /e (Copies all files and subdirectories
from E:\Oracle)
C:\> xcopy F:\oracle K:\oracle /s /e (Copies all files and subdirectories
from F:\Oracle)
C:\> xcopy G:\oracle L:\oracle /s /e (Copies all files and subdirectories
from G:\Oracle)
1) Get copy of INIT.ora file from production to the new server.
The file is usually located in the E:\Orant\Database database directory.
2) Startup all Oracle NT services on the new database server.
The way we are passing from production to development and vice versa can help you. Following you have this:
PRODUCTION SERVER
=================
1. Export Oracle database ARS to a file (Example: "PRODUCTION.DMP").
2. Export from ARS all 'ACTIVE LINK', 'FILTER', 'SCALATION' and 'MENU' to a file
(Example: "PRODUCTION.DEF"). Check Server-Independent option.
3. Copy both files to development server.
DEVELOPMENT SERVER
==================
1. Install ARS in development server.
2. Stop ARS.
3. Delete tablespace ARSYSTEM (The default ARS tablespace)
4. Create tablespace ARSYSTEM.
5. Import all from user ARADMIN from file PRODUCTION.DMP:
IMP SYS FILE=PRODUCTION.DMP LOG=IMPORT.LOG FROMUSER=ARADMIN TOUSER=ARADMIN
6. Reboot server.
7. In ARS delete all 'ACTIVE LINK', 'FILTER', 'SCALATION' and 'MENU' (because we have passed the PRODUCTION server name)
8. Import all 'ACTIVE LINK', 'FILTER', 'SCALATION' and 'MENU' from file PRODUCTION.DEF
9. Could be necessary to delete the user cache in Oracle:
TRUNCATE TABLE ARADMIN.USER_CACHE;
Regards,
Domingo del Moral
Ericsson Business Consulting Spain
-----Original Message-----
From: Christine Cambrils [mailto:ccambrils@SILVERBACKTECH.COM]
Sent: Saturday, March 18, 2000 9:27 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Database copy - Oracle
Does anyone have instructions for copying an Oracle AR System database from
one machine to another? Is it true that machine specific information is
stored in the database? I have some instructions for a MSSQL copy, however,
are there any catches with Oracle?
transfer ORACLE data between any 2 environments. See the ORACLE Utilities
manual for syntax.
> -----Original Message-----
> From: Christine Cambrils [SMTP:ccambrils@SILVERBACKTECH.COM]
> Sent: Saturday, March 18, 2000 3:27 PM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Database copy - Oracle
>
> Does anyone have instructions for copying an Oracle AR System database
> from
> one machine to another? Is it true that machine specific information is
> stored in the database? I have some instructions for a MSSQL copy,
> however,
> are there any catches with Oracle?
>
> Thank you,
> Christine
>
>
> Unsubscribe to: Text is: unsubscribe arslist
Thanks
Donna Jo Brown
DBA
J. C. Bradford & Co.
3325 Perimeter Hill Dr.
Nashville, TN 37211
donna.brown@jcbradford.com
-----Original Message-----
From: Christine Cambrils [mailto:ccambrils@SILVERBACKTECH.COM]
Sent: Saturday, March 18, 2000 2:27 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Database copy - Oracle
Does anyone have instructions for copying an Oracle AR System database from
one machine to another? Is it true that machine specific information is
stored in the database? I have some instructions for a MSSQL copy, however,
are there any catches with Oracle?
-----Original Message-----
From: Donna Brown [mailto:DONNA.BROWN@JCBRADFORD.COM]
Sent: Monday, March 20, 2000 6:48 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Database copy - Oracle
Could you post the MSSQL instructions?
Thanks
Donna Jo Brown
DBA
J. C. Bradford & Co.
3325 Perimeter Hill Dr.
Nashville, TN 37211
donna.brown@jcbradford.com
-----Original Message-----
From: Christine Cambrils [mailto:ccambrils@SILVERBACKTECH.COM]
Sent: Saturday, March 18, 2000 2:27 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Database copy - Oracle
Does anyone have instructions for copying an Oracle AR System database from
one machine to another? Is it true that machine specific information is
stored in the database? I have some instructions for a MSSQL copy, however,
are there any catches with Oracle?
and databse files to the same places. make sure you close the database
before copying, and if using FTP, set it to binary.
Neil Anderson
Systems Developer
Halifax plc, UK
Working with the Remedy Action Request System - www.remedy.com
'This message is attributable to the sender and does not necessarily reflect
the view of Halifax Group plc or its subsidiaries'
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Christine Cambrils
Sent: 18 March 2000 20:27
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Database copy - Oracle
Does anyone have instructions for copying an Oracle AR System database from
one machine to another? Is it true that machine specific information is
stored in the database? I have some instructions for a MSSQL copy, however,
are there any catches with Oracle?
1. Instead of deleting the user_cache just change the server_cache to
reflect the new server name.
2. If you have any Table fields then you need to update a field called
tfserver in the "field_table" table.
I would also delete an reimport (server independent) all AL's, Filters,
Menus, Escalations as stated below.
That should do it.
Mike.
Michael Worts
Remedy Consultant
ntl:
michael.worts@ntl.com
-----Original Message-----
From: Domingo Del-Moral-Tornero (ESS)
[mailto:Domingo.Del-Moral-Tornero@ESS.ERICSSON.SE]
Sent: 20 March 2000 11:20
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Database copy - Oracle
Hello,
The way we are passing from production to development and vice versa can
help you. Following you have this:
PRODUCTION SERVER
=================
1. Export Oracle database ARS to a file (Example: "PRODUCTION.DMP").
2. Export from ARS all 'ACTIVE LINK', 'FILTER', 'SCALATION' and 'MENU' to a
file
(Example: "PRODUCTION.DEF"). Check Server-Independent option.
3. Copy both files to development server.
DEVELOPMENT SERVER
==================
1. Install ARS in development server.
2. Stop ARS.
3. Delete tablespace ARSYSTEM (The default ARS tablespace)
4. Create tablespace ARSYSTEM.
5. Import all from user ARADMIN from file PRODUCTION.DMP:
IMP SYS FILE=PRODUCTION.DMP LOG=IMPORT.LOG FROMUSER=ARADMIN
TOUSER=ARADMIN
6. Reboot server.
7. In ARS delete all 'ACTIVE LINK', 'FILTER', 'SCALATION' and 'MENU'
(because we have passed the PRODUCTION server name)
8. Import all 'ACTIVE LINK', 'FILTER', 'SCALATION' and 'MENU' from file
PRODUCTION.DEF
9. Could be necessary to delete the user cache in Oracle:
TRUNCATE TABLE ARADMIN.USER_CACHE;
Regards,
Domingo del Moral
Ericsson Business Consulting Spain
-----Original Message-----
From: Christine Cambrils [mailto:ccambrils@SILVERBACKTECH.COM]
Sent: Saturday, March 18, 2000 9:27 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Database copy - Oracle
Does anyone have instructions for copying an Oracle AR System database from
one machine to another? Is it true that machine specific information is
stored in the database? I have some instructions for a MSSQL copy, however,
are there any catches with Oracle?
there just a few, if any, references to it in the database tables? I thought
I recalled that this was the case (at least in ARS 3.x) and because of this
Remedy did not support copying database tables from one server to another
because it was so messy to change the server references in the database.
Correct me if I am wrong. Thanks.
-----Original Message-----
From: Neil [mailto:disturbed@FREEWEBACCESS.CO.UK]
Sent: Monday, March 20, 2000 6:59 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Database copy - Oracle
Make sure your file structures are the same then just copy the control, log
and databse files to the same places. make sure you close the database
before copying, and if using FTP, set it to binary.
Neil Anderson
Systems Developer
Halifax plc, UK
Working with the Remedy Action Request System - www.remedy.com
'This message is attributable to the sender and does not necessarily reflect
the view of Halifax Group plc or its subsidiaries'
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Christine Cambrils
Sent: 18 March 2000 20:27
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Database copy - Oracle
Does anyone have instructions for copying an Oracle AR System database from
one machine to another? Is it true that machine specific information is
stored in the database? I have some instructions for a MSSQL copy, however,
are there any catches with Oracle?
Remedy stores the server name in only two tables. server_cache and
field_table (v4) only. They are the 2 tables I change if I am doing an
Oracle copy.
Mike.
Michael Worts
Remedy Consultant
ntl:
michael.worts@ntl.com
-----Original Message-----
From: Stilley, Mark [mailto:Mark_Stilley@ATK.COM]
Sent: 20 March 2000 16:06
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Database copy - Oracle
Isn't the server name embedded in various columns in various tables or are
there just a few, if any, references to it in the database tables? I thought
I recalled that this was the case (at least in ARS 3.x) and because of this
Remedy did not support copying database tables from one server to another
because it was so messy to change the server references in the database.
Correct me if I am wrong. Thanks.
-----Original Message-----
From: Neil [mailto:disturbed@FREEWEBACCESS.CO.UK]
Sent: Monday, March 20, 2000 6:59 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Database copy - Oracle
Make sure your file structures are the same then just copy the control, log
and databse files to the same places. make sure you close the database
before copying, and if using FTP, set it to binary.
Neil Anderson
Systems Developer
Halifax plc, UK
Working with the Remedy Action Request System - www.remedy.com
'This message is attributable to the sender and does not necessarily reflect
the view of Halifax Group plc or its subsidiaries'
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Christine Cambrils
Sent: 18 March 2000 20:27
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Database copy - Oracle
Does anyone have instructions for copying an Oracle AR System database from
one machine to another? Is it true that machine specific information is
stored in the database? I have some instructions for a MSSQL copy, however,
are there any catches with Oracle?
Previous Topic
Index