| R12 backup with Minimal downtime [message #477658] |
Sun, 03 October 2010 03:13  |
paradoxkhan
Messages: 92
Registered: April 2008
Location: Pakistan
|
Member |
|
|
HI,
We have 24*7 critical single node Production environment EBS R12(12.0.4) running on RHEL5. Often we have to apply patches, and for this downtime is required for backup which takes 3 hours to complete(cold app/db binaries). Please clarify
1) Can we take application binaries backup while services are running?
2) Can we take db binaries+datafiles backup after " alter database begin backup" ?
3) Or we should take backup of binaries(app/db)after stopping all the services?
Please help as this really bothering. Thanks
|
|
|
|
|
|
| Re: R12 backup with Minimal downtime [message #477725 is a reply to message #477669] |
Mon, 04 October 2010 02:17  |
paradoxkhan
Messages: 92
Registered: April 2008
Location: Pakistan
|
Member |
|
|
Thank you very much. John can you provide me any metalink note or link covering the same scenario.
Also i would like to know incase of patch goes wrong and we need to restore the previous backup. Which tops from application(APPL,COMON etc)
and from db we need to restore? Any note on this.
|
|
|
|
| Re: R12 backup with Minimal downtime [message #478250 is a reply to message #477725] |
Thu, 07 October 2010 08:41 |
 |
Alien
Messages: 292
Registered: June 1999
|
Senior Member |
|
|
Hi,
In case a patch fails, it would be best to try and fix the problem with the patch. After all, there is a reason for applying the patch in the first place.
If you want to restore a backup, you'll most likely need to restore the database, appl_top, comn_top/html comn_top/java.
Preferably you'll remove the logfiles from the inst_top.
To be sure about the impact of a patch, you can apply it first with apply=no, and review the log to see exactly which files the patch will update.
I don't think there is any note on rolling back patches. But best practices are in MOS: 225165.1
Regards,
Arian
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
