Move database from one unix box to another

[davey23uk]

You can use rsync to copy the files over.

Here is the example rsync syntax to copy the Oracle Home from one server (linux3) to another server (linux4). This process will ensure that all symbolic links and files owned by root get copied over correctly. Login to the source database server (linux3) as the root user account and run the following:

[root@linux3 ~]# rsync -auvzpogl -e ssh /u01/app/oracle/product/10.2.0/db_1/ linux4:/u01/app/oracle/product/10.2.0/db_1/

any decent sysadmin with have the 'r' services turbed off due to them being horribly insecure