I don’t do it on Windows but on UNIX/Linux there are a few options:
1)
Oracle Recovery Manager (RMAN) – Requires NBU Oracle client – This essentially puts RMAN in charge of the backups
– fairly complicated setup requiring an RMAN repository and backup/restore scripts for RMAN. We only do this for a couple of small DBs that are on Oracle ASM so require it.
2)
Cold backup. We stop the Database and backup the filesystems on which the data files live.
3)
Hot backup. This is a special mode you can put Oracle in that prevents it from committing changes (it logs them
instead) while the backup is running so it is a point in time. After the backup completes you take the DB out of this mode and it commits the changes it previously logged.
For large databases with lots of activity this can be a problem. One work around many people do is disk mirroring built into many disk arrays (different names – e.g. BCV/SRDF on EMC, Shadow Image on Hitachi etc…) One can establish the mirror before the time
of hot backup then put DB in hot backup mode just to split the mirrors. One then mounts the mirrors in another location and does a backup of the data files.
4)
Dump the data and backup the dumped data. Not pretty.
From:
veritas-bu-bounces AT mailman.eng.auburn DOT edu [mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu]
On Behalf Of WEAVER, Simon (external)
Sent: Monday, September 26, 2011 1:33 PM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] Question on DB online backups
Hi, this is really for anyone doing online Oracle Backups?
Trying to create a new policy for this. Got agent installed (licensed). Environment all Windows 2003.
All I want is to do an online Oracle Backup. But I am struggling with this, as I have no DB Support.
Being told that backing up Oracle is huge excercise and needs time. Trouble is, I wasnt expecting this sort of response.
Does anyone have advise or a script or something I could try and use to perform an Oracle Backup?
At the moment, I stop services, then do backup & start services. But Im not sure that is good practice. while Oracle Down, application is down. Hence,
no one works!!!
Any input appreciated. I have and am still using Admin guide, but I wanted real world advice here. I got a sample Hot Oracle DB Backup from the goodies
directory, but not sure if this is right way to do it.
Goal is to get a backup while application online. I do tons of online SQL, and no issues with backups..... Yet apparantly Oracle is more complex !!!
News to me... But feedback welcome
Thanks
Regards
Simon
Athena®, Created for the Cause™
Making a Difference in the Fight Against Breast Cancer
---------------------------------
CONFIDENTIALITY NOTICE: This e-mail may contain privileged or confidential information and is for the sole use of the intended recipient(s). If you are not the intended recipient, any disclosure, copying, distribution, or use of the contents of this information
is prohibited and may be unlawful. If you have received this electronic transmission in error, please reply immediately to the sender that you have received the message in error, and delete it. Thank you.
----------------------------------
| 