Schedule Hot backup via OEM
644720Sep 5 2008 — edited Sep 5 2008Hello all,
We have a realtively small system running Oracle 10G on Windows 2003 O/S. I've scheduled a full offiline (cold) backup of the whole db to run once weekly via OEM. Every night we run a script to do a 'logical' backup by EXPORTing the 2 main schemas in the DB out to .DMP files. However this now may not be enough to satisfy DB recovery requirements.
Is there an easy way to schedule a 'Hot' backup via OEM, that could replace the EXPORT scripts mentioned above, or would we have to write an RMAN script to do this ?? The requirement is really to allow the database to be updateable whilst any daily backup is running. I realise that the DB needs to be in ARCHIVELOG mode for anything like this to work.
Any advice would be greatly appreciated.
Thanks,
Shaun.