[QUOTE][i]Originally posted by rotem_fo [/i]
[B]1. shutdown Oracle (use dbshut)
2. use: tar -cvf /$ORACLE_HOME/oradata /dev/nrmt0h
3. startup oracle.

you can add ">> report.log" at the end of the tar line to create a log file.

[/B][/QUOTE]

Dear rotem_fo,

Thanks for the info. However, my db files are located at different places. How do I tar all this files at once and in your opinoin how long will the tar process if my db is about 23GB in size?.

Cheers
:))