Rsync help needed...

[Linus Hicks]

Matt McCutchen wrote:
> On Mon, 2006-02-27 at 06:58 -0800, lsk wrote:
>> Could you give an example with syntax for rsync using file
>> option "--files-rom=FILE".
> 
> If my-list in the current directory contains
>                 a
>                 b
>                 b/c
>                 b/d
>                 b/d/e ,
> then the command
>                 rsync -a src/ dest/ --files-from=my-list
> copies
>                 src/a -> dest/a
>                 src/b -> dest/b
>                 src/b/c -> dest/b/c
>                 src/b/d -> dest/b/d
>                 src/b/d/e -> dest/b/d/e .
> Rsync copies just those files and directories, preserving their
> attributes.  It leaves alone any other files that might be in src/b,
> src/b/d, dest/b, or dest/b/d; even if --delete is given, it does not
> delete anything.  Search the man page for --files-from for more
> information:
> 	http://rsync.samba.org/ftp/rsync/nightly/rsync.html

Matt,
Typically with Oracle databases, you will have datafiles residing on different 
mount points starting from the root such as:

/p02/oradata/OSID/redo01.log
/p03/oradata/OSID/redo02.log
/p04/oradata/OSID/redo03.log
/p01/oradata/OSID/system01.dbf
/p04/oradata/OSID/undotbs01.dbf
/p03/oradata/OSID/sysaux01.dbf
/p03/oradata/OSID/users01.dbf
/p03/oradata/OSID/example01.dbf
/p03/oradata/OSID/data01.dbf
/p02/oradata/OSID/index01.dbf
/p01/oradata/OSID/control01.ctl
/p02/oradata/OSID/control02.ctl
/p03/oradata/OSID/control03.ctl
/s01/oracle/product/10.2.0/dbs/initOSID.ora

Requiring a command line something like this:

rsync -a srchost:/ / --files-from=dbf-list

and dbf-list would contain this:

p02/oradata/OSID/redo01.log
p03/oradata/OSID/redo02.log
p04/oradata/OSID/redo03.log
p01/oradata/OSID/system01.dbf
p04/oradata/OSID/undotbs01.dbf
p03/oradata/OSID/sysaux01.dbf
p03/oradata/OSID/users01.dbf
p03/oradata/OSID/example01.dbf
p03/oradata/OSID/data01.dbf
p02/oradata/OSID/index01.dbf
p01/oradata/OSID/control01.ctl
p02/oradata/OSID/control02.ctl
p03/oradata/OSID/control03.ctl
s01/oracle/product/10.2.0/dbs/initOSID.ora

Do you see any problems with this?