471,306 Members | 836 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,306 software developers and data experts.

Re: How to duplicate whole database from one machine to another machine in Windows 2000?

Would you please what files I have to copy?

Thanks.
"Ban Spam" <ba******@operamail.comwrote in message
news:Xn*********************@68.6.19.6...
"HK Chang" <RE****************@bigfoot.comwrote in
news:as**********@news.hgc.com.hk:
Dear All,

Do you know how I can duplicate the whole database from one Windows 2000
machine to another Windows 2000 machine?

Thanks.

Regards,
HK Chang

I'd just use COPY when the database is shut down.

Jun 27 '08 #1
2 1060
If you are using a version of Oracle that is less than 8i, you could
follow the following steps..

1. Shut down the database services,
2. Copy the "dbs" and "database" folders within oracle installation
directory,
3. Re-start the services.

Remember the machine to be copied to should also have its services
shut down

Ideally, you have to copy only selected files from "dbs" and
"database", but I am not an expert at that and can just say that
copying all the files in the 2 folders - "dbs" and "database" used to
work for me.
If the database is very big ( approx 200MB) you will have to export
it though.

Laxman
"HK Chang" <RE****************@bigfoot.comwrote in message news:<as***********@news.hgc.com.hk>...
Would you please what files I have to copy?

Thanks.
"Ban Spam" <ba******@operamail.comwrote in message
news:Xn*********************@68.6.19.6...
"HK Chang" <RE****************@bigfoot.comwrote in
news:as**********@news.hgc.com.hk:
Dear All,
>
Do you know how I can duplicate the whole database from one Windows 2000
machine to another Windows 2000 machine?
>
Thanks.
>
Regards,
HK Chang
>
>
I'd just use COPY when the database is shut down.
Jun 27 '08 #2
I should have mentioned it explicitly, but my technique was meant if
we want to hand over the task to a person not exposed to databases at
all, and we do not want to give him/her the SYS password also.
A few extra minutes spent copying for that person is sometimes better
than teaching him the intricacies.
Hi Laxman,

Handing over database migration tasks to someone who has not been
exposed to databases at all is asking for a *BIG* trouble. Practicing
Oracle on a home machine is much different then working with a
production instance in the real world.

If it is just a practice on a home machine...then no harm done, *BUT*
if it is a real world scenario...then let the DBA handle these kind of
tasks.

Regards
/Rauf Sarwar
Jun 27 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Pawel Banys | last post: by
1 post views Thread by Saravanakumar | last post: by
1 post views Thread by Dave | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.