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

**Laxman Uchlani** · Jun 27 '08, 04:50 PM

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

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_hkc hang@bigfoot.co mwrote in message news:<asp0b3$31 du$1@news.hgc.c om.hk>...

Would you please what files I have to copy?
>
Thanks.
"Ban Spam" <ban-spam@operamail. comwrote in message
news:Xns92DBB43 6C5D42SunnySD@6 8.6.19.6...

"HK Chang" <REMOVETHIS_hkc hang@bigfoot.co mwrote 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** · Jun 27 '08, 04:50 PM

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

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

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

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

Comment

Comment