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

[HK Chang]

Would you please what files I have to copy?

Thanks.
"Ban Spam" <ban-spam@operamail.com> wrote in message
news:Xns92DBB436C5D42SunnySD@68.6.19.6... "HK Chang" <REMOVETHIS_hkchang@bigfoot.com> wrote in news:ask5lc$kv7$1@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.

[Laxman Uchlani]

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" <REMOVETHIS_hkchang@bigfoot.com> wrote in message news:<asp0b3$31du$1@news.hgc.com.hk>... Would you please what files I have to copy? Thanks. "Ban Spam" <ban-spam@operamail.com> wrote in message news:Xns92DBB436C5D42SunnySD@68.6.19.6... "HK Chang" <REMOVETHIS_hkchang@bigfoot.com> wrote in news:ask5lc$kv7$1@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.

[Rauf Sarwar]

> 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