If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

How to auto backup and restore oracle database?

I want to use "at" command at solaris platform.I want to backup oracle database in 10.11.31.2 at 2:00am everyday. And I ftped the backup file to 10.11.31.4, I want to restore the oracle databse at 10.11.31.4,how to do?
when I use exp command export a use (cjgroup) data at 10.11.31.2 and use imp command to import the data to 10.11.31.4 oracle,but because of some objects(like tables,views,packages,etc) are already exists at oracle,so imp will no export these objects.
and I want to backup and restore automaticlly,this can use a command line do,and no interact.so I can use "at" command to do automaticlly.

When starting a script via crontab the environment variables must be explicitly set in your script (i.e. Do not depend upon the variables in .profile). A script the runs fine when executed from the interactive shell account will not function properly from cron unless the variables are set in the script prior to execution.