OK - simply said - copy all the files from source to target. Once done, run
adcfgclone.pl and answer all questions such as the node name, SID, port you
want for the instance etc.....
If you are running Oracle Apps, then you must run this script twice - once
for the dBTier and also for the AppsTier. This utility will configure all
necessary files and ports.
Good Luck!!
-----Original Message-----
From: Fokkema Ytzen
[mailto:oracledba-ezmlmshield-x87194821.[Email address protected]
Sent: Thursday, February 01, 2007 4:52 AM
To: LazyDBA Discussion
Subject: RE: Database clonning.
Hi,
Your question is very generic and therefore hard to answer specifically.
I'll give it a try:
If you are using unix and do a full restore on a standalone server, it
should work.
If you are using windows and do a full restore on a standalone server,
it should work.
In most cases you are in a network, which means unique ip addresses and
servernames, and you don't do full restores but install a server with a
OS and after that you install the oracle software.
On Unix you should look at /etc/oratab, listener.ora and tnsnames.ora,
pfile/spfile; on windows you should look at pfile/spfile, listener.ora
and tnsnames.ora, and create the services using oradim
May be you better ask somenone with more experience to help you.
Regards,
Ytzen
-----Original Message-----
From: Kanitkar Vinit
[mailto:oracledba-ezmlmshield-x9255694.[Email address protected]
Sent: woensdag 31 januari 2007 05:55
To: LazyDBA Discussion
Subject: Database clonning.
Hi,
I have a whole filesystem dump of a database 10.2.0.2
How can I recreate the database on the new server.
What will be the updates and other steps to be taken.
Regards,
Vinit Kanitkar
[Email Address Removed] Bangalore
M: 9901358764
---- Disclaimer ----
This is a confidential email. Tesco may monitor and record all emails.
The views expressed in this email are those of the sender and not Tesco.
Tesco Stores Limited
Company Number: 519500
Registered in England
Registered Office: Tesco House, Delamare Road, Cheshunt, Hertfordshire
EN8 9SL
VAT Registration Number: GB 220 4302 31
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
This e-mail and any attachment is for authorised use by the intended
recipient(s) only. It may contain proprietary material, confidential
information and/or be subject to legal privilege. It should not be copied,
disclosed to, retained or used by, any other party. If you are not an
intended recipient then please promptly delete this e-mail and any
attachment and all copies and inform the sender. Thank you.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page