OraFAQ Forum: RAC & Failsafe » Backups before Patch

Home » Server Options » RAC & Failsafe » Backups before Patch

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Backups before Patch [message #214167]

Mon, 15 January 2007 04:26

lokeshonline
Messages: 29
Registered: April 2006

Junior Member

We have Oracle database 9.2.0.1 with 9.2.0.4 patch installed on it. Now we are installing 9.2.0.8 on it. Is cold backup is must before installing patch? What is the risk if we take hot backup. If we disconnect all the users and keeping only sys user and take hot backup will it be helpful. Kinldy advise.

Report message to a moderator

Re: Backups before Patch [message #214178 is a reply to message #214167]

Mon, 15 January 2007 05:20

orausern
Messages: 826
Registered: December 2005

Senior Member

Yes it is better to keep a cold backup. This is for safety. if things go bad then you may have to restore.anyway applying the patch requires oracle to be shutdown so better keep a cold backup.

Report message to a moderator

Re: Backups before Patch [message #214191 is a reply to message #214167]

Mon, 15 January 2007 06:30

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

And just to add, you should also consider doing a "cold backup" on the ORACLE_HOME (backup the software directory with oracle shutdown).

Report message to a moderator

Previous Topic:	DB migration from VxFS to Veritas CFS For RAC and/Or Raw Volume
Next Topic:	adding listener using srvctl ?? 1g RAC

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 05 08:02:06 CST 2025