This will be ridiculous to hardcode this kind of information. So if my
system crashed and I had to import a full export into a new machine, it's
not going to work?!!
I do not believe this could be true.
Waleed
Any views or opinions presented in this email are solely those of the
author and do not necessarily represent those of the company
-----Original Message-----
Sent: Wednesday, March 27, 2002 7:43 PM
To: Multiple recipients of list ORACLE-L
Hi,
Does anyone know whether I could duplicate the Oracle HRMS Applications
using the same methods as described ? I understand that some of the Oracle
Applications tables hardcode the server name etc. Has anyone done it before
? I need to migrate my production Oracle HRMS Apps database to a more
powerful machine.
TIA
Regds,
New Bee
-----Original Message-----
From: Marc Cure [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 4:16 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: How to duplicate production database
onto development box
Is there any need to create a standby database in this case?
My procedure
for copying production to development is:
1. alter database backup controlfile to trace; (in
production)
2. Restore a production backup (either hot or cold) to the
development
server
3. Update database name and filenames in the controlfile
script from step 1,
as required
4. Run script from step 3 on development server to create
new controlfiles
5. Recover new development database up to desired point in
time using
archived redo from production
6. Open the new development database with resetlogs
This approach allows me to rename the database and the
datafiles (if the
datafiles need to be placed differently on the development
server than in
production, for example) in one step, rather than manually
renaming 50+
datafiles in a standby database, and then recovering,
activating, and
renaming that database.
Marc Cure
Oracle DBA, OCP
-----Original Message-----
Sent: Tuesday, March 26, 2002 11:59 AM
To: Multiple recipients of list ORACLE-L
I use a hot backup to create a standby database then apply
logs to the point
I want to get a copy of production of a specific time.
Then you can rename the database if you want to.
-----Original Message-----
Sent: Tuesday, March 26, 2002 9:18 AM
To: Multiple recipients of list ORACLE-L
Just copy the files over and recreate the control file.
Abraham
-----Original Message-----
Sent: Tuesday, March 26, 2002 7:48 AM
To: Multiple recipients of list ORACLE-L
Hi!
We want to put an exact copy of our production database
(approx. 200 GB)
onto a development box. What would be the best way to
achieve this?
Export/import would take kinda long... ;)
Would transportable tablespaces be the way to go?
This is 8.1.7 on Sun Solaris.
Thanks,
Helmut
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Marc Cure
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051
San Diego, California -- Public Internet access /
Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail
message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).
You may
also send the HELP command for other information (like
subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: CHAN Chor Ling Catherine (CSC)
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Khedr, Waleed
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
