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.