Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to duplicate whole database from one machine to another machine in Windows 2000?
laxmanuchlani_at_yahoo.com (Laxman Uchlani) wrote in message news:<99249aa6.0212261944.33a6793_at_posting.google.com>...
> If you are using a version of Oracle that is less than 8i, you could
> follow the following steps..
This has got nothing to do with which version you are on.
>
> 1. Shut down the database services,
> 2. Copy the "dbs" and "database" folders within oracle installation
> directory,
> 3. Re-start the services.
Copying the entire folders is completely unnecessary. Only files that need to be copied are backed up create controlfile script, init.ora file and all datafiles.
>
> Remember the machine to be copied to should also have its services
> shut down
What services?
>
> 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.
BTW...In Oracle a very big (Or VLDB Very Large DataBase) is > 100GB. 200MB database in Oracle is a very small database.
Assuming Oracle version/patchset is same on both machines and since Windoze 2K are same platforms and thus have same Oracle binaries, you can recreate the database on 2nd machine by only copying the init.ora and the datafiles.
Regards
/Rauf Sarwar
Received on Fri Dec 27 2002 - 12:49:33 CST