Oracle 10g Hot Backup using IBM Snapshot
We are wanting to implement hot backups for a few of our databases and instead of using RMAN or manually copying files for backup, we will be using a "snapshot" method (IBM AIX).
My question is, has anyone done this before and what steps did you follow?
I am thinking I need to do the following steps, but I have a concern over getting the final controlfile backup after the snapshot. I would like to have that be part of the snapshot.
Any thoughts are appreciated
1) Alter database to begin backup mode
2) SNAPSHOT
3) Alter database to end backup mode