Automated copy from live database to read/write DB overnight
I need to be able to completely overwrite a "standby" database overnight form a live DB. The standby needs to be read/write once refreshed and the process must be able to be rerun manually if required.
The DB's are will both be on Linux, 10GR2, the Live DB is in archivelog mode and will remain around the 8-10Gb mark, it also runs ASM disk areas.
Could you suggest the best method please.
Many thanks, Steve