topic how to copy database in Operating System - HP-UX

how to copy database

Ramana.Sv — Wed, 01 Aug 2007 04:53:08 GMT

Hi,iam new to this topic, how to copy database from one server to another i have two servers ServerA and ServerB. please tell me the procedure for this.

Thank you,
Ramana.Sv

Re: how to copy database

Torsten. — Wed, 01 Aug 2007 07:02:16 GMT

It depends on the database engine/vendor.

Each has some tools to export/import the data out/in.
You can transfer the exported data from one server to another.

But there are many different db's and tools ...

Re: how to copy database

spex — Wed, 01 Aug 2007 07:25:55 GMT

Hello,

I assume you have an Oracle RDBMS. The easiest way is to first create a plaintext export of your control files (ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS '...'). Then shutdown the database and copy the generated script, configuration files, and datafiles using your preferred method (e.g. NFS, CIFS, NFS, tape). Arrange the datafiles as you see fit, and modify the script to reflect their new locations. Create necessary directory structures and place configuration files appropriately. Then make additional changes to the script as outlined here:

http://www.dba-oracle.com/oracle_tips_db_copy.htm

Don't forget to modify your init.ora file, if you also brought this over. The beauty of doing a cold backup is your database is consistent, so there are no archivelogs to apply after you do a startup.

PCS

Re: how to copy database

Yogeeraj_1 — Wed, 01 Aug 2007 07:38:24 GMT

hi,

Method 1.
Shutdown the database and copy the files from server A to server B. Startup database on Server A and startup database on B. Assumptions, the filesystems are identical and the installation of the Oracle Software is the same.

Method 2.
Export the database using the EXP or EXPDP utility on server A and import in a clean database on server B.

if you need further assistance, please let us know

kind regards
yogeeraj

Re: how to copy database

A. Clay Stephenson — Wed, 01 Aug 2007 09:38:40 GMT

... and it can even be trivially easy if you can shutdown the database and do a cold backup. Shutdown the database and take a conventional backup using the utility of your choice (tar, cpio, fbackup, pax, Data Protector, ...). On the target system, create identical mount points/directories and restore the file files. The database copy should start right up (assuming you have also installed the executables and libraries). About the only thing you will need to do is change any database networking to reflect the new hostname. Since you didn't even bother to identify the database or OS, it's difficult to be very specific.