how to copy a database? 
Author Message
 how to copy a database?

My goal is to move everything to new disks. Data chunks are on raw logical
volumes (HP-UX 10.20, IDS 7.31). Will it work if I just create new volumes
of exactly the same size, copy data using dd (while the database server is
down), and mount the new volumes on the same paths as the old ones? Is it at
all advisable to do it this way? Or should I just unload everything,
reconfigure the dbspaces, and load the data? I think dd will be much faster
(even 10 times), but I've never tried to copy a large database this way,
should I expect any problems?

Regards
Pawel



Sun, 06 Jun 2004 01:14:25 GMT
 how to copy a database?

I forgot to mention, that chunks are configured as symbolic links to logical
volumes, so there is no problem with paths, I can easily reconfigure them.

Pawel



Sun, 06 Jun 2004 01:19:16 GMT
 how to copy a database?

Quote:

> My goal is to move everything to new disks. Data chunks are on raw logical
> volumes (HP-UX 10.20, IDS 7.31). Will it work if I just create new volumes
> of exactly the same size, copy data using dd (while the database server is
> down), and mount the new volumes on the same paths as the old ones?

Yes, dd is OK.
Here are some alternatives:
1.    Use Informix mirroring to establish mirrors on your new volumes.  Shut
down the database server, and switch the symbolic links so that the primary
chunks are now on the new the LVs, and the mirrors on the old.  Then start
up the server and drop the mirrors.  It's done!

2.    Take a level 0 archive.  Stop the server.  Remove the symbolic links
and re-create them pointing to the new chunks.  Do a restore.

Personally, I prefer alternative 1 to dd or alternative 2, since it requires
just a couple of minutes' downtime.  Plus the fact it is created in my own
image - elegant and beautiful.



Sun, 06 Jun 2004 01:46:06 GMT
 how to copy a database?


Quote:
>1.    Use Informix mirroring to establish mirrors on your new volumes.  Shut
>down the database server, and switch the symbolic links so that the primary
>chunks are now on the new the LVs, and the mirrors on the old.  Then start
>up the server and drop the mirrors.  It's done!

That's what I will do, thanks a lot.

Pawel



Sun, 06 Jun 2004 02:00:14 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. SQL Table Copy from Database to Database

2. How to protect from making copies of database

3. I need a working and developemental copy of database

4. quick n dirty - copying a database

5. help with copying a database

6. Bulk copy of database in suspect mode?

7. How to connect to a copied SQL database

8. moving (actually copying) a database to another server

9. how to copy a database from SQL server6.5 to SQL server7.0

10. Getting the following error when trying to copy a database from one server to

11. Using DTS to copy a database to external SQL server

12. How can I copy a database to a file


 
Powered by phpBB® Forum Software