Re: About restore from 11g

  • From: Tim Gorman <tim.evdbt@xxxxxxxxx>
  • To: angelolistas@xxxxxxxxx, Andrew Kerber <andrew.kerber@xxxxxxxxx>
  • Date: Wed, 12 Apr 2017 17:05:28 -0600

My US$0.02...

Upgrade the $ORACLE_HOME from 11.2.0.3 to 11.2.0.4, don't downgrade the database.

Why would anyone choose to go back to the bug-ridden cesspool of 11.2.0.3?




On 4/12/17 09:24, angelo wrote:

Andrew

yep, I could imagine.. the right thing would be have Oracle updated, but... they didnĀ“t the homework..
So, I will negotiate with my users if I can make a expdp/impdp instead to avoid these issues... just for restoring a few schemas and tables, from a production to a devel machine



On 12 April 2017 at 12:01, Andrew Kerber <andrew.kerber@xxxxxxxxx <mailto:andrew.kerber@xxxxxxxxx>> wrote:

    yes, all kinds of problems.  At the very least, you will need to
    open the database resetlogs upgrade and run catupgrade after the
    restore.

    On Wed, Apr 12, 2017 at 9:57 AM, angelo <angelolistas@xxxxxxxxx
    <mailto:angelolistas@xxxxxxxxx>> wrote:

        Hello,

        Is there any big issue about restoring an oracle 11.2.0.4
        backup to 11.2.0.3 server ?

        I will do it on this afternoon attending a request


        regards,

        Angelo




-- Andrew W. Kerber

    'If at first you dont succeed, dont take up skydiving.'



Other related posts: