Re: pros/cons of setting COMPATIBLE parameter 11.2.0 or 22.214.171.124.4
Date: Mon, 13 Feb 2012 22:30:55 +0530
Yes, once you set the compatible parameter to 11g, you cannot downgrade it back to 10g as control files get updated, i had the same issue hence had to do a complete restore as application team wanted to downgrade the database after upgrade.
On Mon, Feb 13, 2012 at 10:12 PM, Michael Dinh <mdinh_at_xifin.com> wrote:
> From my understanding, once you set compatible, there's no undo.
> Hence, if you have multiple databases, I would think setting compatible to the lowest version.
> If you are 110% sure the database will be isolated, then safe to set compatible to 126.96.36.199.4
> Michael Dinh
> Disparity Breaks Automation (DBA)
> Great minds discuss ideas; average minds discuss events; small minds discuss people - Eleanor Roosevelt
> Confidence comes not from always being right but from not fearing to be wrong - Peter T Mcintyre
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Syed Jaffar Hussain
> Sent: Sunday, February 12, 2012 11:06 PM
> To: Oracle-L Freelists
> Subject: pros/cons of setting COMPATIBLE parameter 11.2.0 or 188.8.131.52.4
> Good day list,
> Very recently we have upgraded our 10gR2 (10.2.0.4) databases to 11gr2 and
> applied latest PSU patch (184.108.40.206.4). However, for some concerns, the
> COMPATIBLE parameter value was kept to 10.2.0.4. Now we need to change the
> COMPATIBLE parameter value reflecting to 11gR2. Therefore, I need an advice
> over setting the parameter to 11.2.0 OR 220.127.116.11.4? What are the pros and
> cons do you foresee.
> Thanks in advance.
> Best Regards,
> Syed Jaffar Hussain
> Oracle ACE Director
> Oracle Certified Master
> Co-author Oracle 11gR1/R2 RAC Essentials <http://link.packtpub.com/yNZicz>
> *Oracle Magazine DBA of year (2011)*
> OCP 8i,9i,10g & 11g DBA
> RAC Certified Expert
> ITIL V3 foundation certified
> Oracle RAC SIG Representative for Saudi Arabian
> Advisory & Governance Council for
> I blog at : http://jaffardba.blogspot.com/
> LinkedIn : http://www.linkedin.com/in/sjaffarhussain
> Follow me on twitter : http://twitter.com/#!/sjaffarhussain
> "Winners don't do different things. They do things differently."
-- Thanks & Regards Nilesh Oracle DBA (sqlplus "/as sysdba" is my world) "As our circle of knowledge expands, so does the circumference of darkness surrounding it."--Einstein "All men die, few men ever truly live" -- Braveheart "You can get help from teachers, but you are going to have to learn a lot by yourself, sitting alone in a room." --Dr. Seuss "Know me for what I do and for not what I am. Judge me for what I can do and not for what I have done."-Unknown "Don't walk in front of me, I may not follow. Don't walk behind me, I may not lead. Just walk beside me and be my friend."- Albert Camus "Never argue with an idiot. They drag you down to their level and then beat you with experience." - Unknown -- http://www.freelists.org/webpage/oracle-lReceived on Mon Feb 13 2012 - 11:00:55 CST