Re: Hot backups

The order doesn't matter much as long as they are done at roughly the sane time. If you are backing up the database hot (which you should) back up the database first, and capture the last archive log as soon as the file system backups are complete. You will the have a complete backup that includes all database changes up to the completion of your file system backups.
Hot backups will require you to create the database and perform an incomplete recovery (either manually or via RMAN). This is not very difficult and gives you more control over what point in time your clone represents.
One note: It's rarely necessary to clone the RDBMS_ORACLE_HOME, IAS_ORACLE_HOME, and 8.0.6_ORACLE_HOME; These file systems do not change much and application patches do not affect them. You should back them up, but there isn't usually a reason to re-copy them to downstream environments every time you clone unless something has changed (e.g. you applied an RDBMS patch, a new Developer 6i patchset etc.) 

Chuck Edwards
Blue Gecko, Inc.
http://www.bluegecko.net/oracle-apps-dba



On Feb 19, 2009, at 1:06 AM, Dwyer, Brian wrote:


***************************************************************************
Internet email is not to be treated as a secure means of communication.
North Yorkshire Police monitors all internet email activity and content. 

This communication is intended for the addressee(s) only.

Please notify the sender if received in error. Unauthorised use or

disclosure of the content may be unlawful. Opinions expressed in this

document may not be official policy. Thank you for your co-operation.

***************************************************************************


Hello
Looking at implementing hot backups on our 11.5.9 system running on Solaris.
Do you backups the APPL_TOP / COMMON_TOP/ IAS_ORACLE_HOME / 8.0.6_ORACLE_HOME / RDBMS_ORACLE_HOME before you backup the database files or do you do it the other way? 

And how does a hot backup affect the way that you do a clone?

Cheers

Brian




__________________________

Other related posts: