RE: Hot backups

I would think taking database hot backup ( at the end  or ) slightly
later  than the apps stack backups would be better as  the   concurrent
jobs' logfile and outfile details would be  in the database this way.
Otherwise the  logfile and outfiles would be in the apps stack backups
but the corresponding  table entries will not be in the database backup.

 

       Thanks, 

         Jay

 

________________________________

From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of Chuck Edwards
Sent: Thursday, February 19, 2009 9:38 AM
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: 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: