topic Re: rsync and Oracle database files in Operating System - HP-UX

rsync and Oracle database files

Kevin Liquori_1 — Tue, 29 Nov 2005 10:30:08 GMT

Does anyone know if rsync can be used to refresh Oracle database files? Say I want to refresh my development environment with the data from production.

thanks

...Kevin

Re: rsync and Oracle database files

Jeff_Traigle — Tue, 29 Nov 2005 10:45:09 GMT

I would say it can only if the database was down when the sync occurred. It wouldn't be any different than using cp or any other method of copying the files at the OS level for a cold backup and restoring from those. Control files and all would need to be replaced.

Re: rsync and Oracle database files

Geoff Wild — Tue, 29 Nov 2005 10:52:10 GMT

DB would have to be down - on both ends.

It would be better to refresh DEV from your tape backups - that way you kill 2 birds with 1 stone.

1 - refresh DEV
2 - test your backup/restore procedure

Rgds...Geoff

Re: rsync and Oracle database files

A. Clay Stephenson — Tue, 29 Nov 2005 10:54:30 GMT

If you have OnlineJFS then I would do it this way:

1) Shutdown the production database.
2) Create snapshot vxfs mounts of all the Oracle filesystems. (This takes only seconds per filesystem).
3) Restart the production database
4) Rsync your files.
5) Unmount the snapshot mounts.

You will probably need to rename your directories on the test environment to their production counterparts (e.g. /snap_u01 becomes /u01).

In any event your database will need to be down when the rsync is done but doing a snapshot mount means that you can do this with as little as 2 minutes of production downtime. This does assume that you have already created the snapshot buffer raw volumes for each filesystem before downing the database.

Re: rsync and Oracle database files

Jean-Luc Oudart — Tue, 29 Nov 2005 11:12:17 GMT

Kevin,

if the database can be shutdown (for cold backup, etc...) I believe you can use this method.

Otherwise, you must use RMAN.

cf. http://www.oracle.com/technology/deploy/availability/htdocs/RMAN_Overview.htm

Regards
Jean-Luc

Re: rsync and Oracle database files

Indira Aramandla — Tue, 29 Nov 2005 21:47:23 GMT

Hi Kevin,

As others mentioned, if you can afford to have down time for the database then use this method.

But if you have tape backups or disk backup on a different location, then you can just copy from the disk backup or restore from the tape backup to your DEV server.

This will test your backup/restore procedures as Geoff mentioned.

The third oprion for you DEV database refresh is if your database is not very large, then use the logical export and then inport into you dev database. This will tkae more time then the obove options.

IA

Re: rsync and Oracle database files

Mikael Sandström_1 — Wed, 30 Nov 2005 04:02:05 GMT

If the goal is to refresh dev/test environments with prod data, I'd use RMAN and use the duplicate database functionality.

hth
/M