Database Administration (MOSC)

MOSC Banner

Downgrade from 12.1.0.2.0. to 11.2.0.4.

edited May 15, 2017 7:01PM in Database Administration (MOSC) 8 commentsAnswered

Hi Guys,

I am downgrading from 12c to 11g.  It was the Developer's request.  Anyway I was just about done.  Reverted everything back but now the DB will not open properly.

Can you guys point me in the right direction? 

Thanks,

Larry

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 2501364897549 generated at 05/10/2017 15:44:01 needed for

thread 1

ORA-00289: suggestion :

/oetscrt/disk01/archivelog/log_OETSPRD_1_1_943631039.arc

ORA-00280: change 2501364897549 for thread 1 is in sequence #1

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

/oetscrt/disk01/redoAodd/redo_1a.log

Log applied.

Media recovery complete.

SQL> ALTER DATABASE OPEN RESETLOGS;

ALTER DATABASE OPEN RESETLOGS

*

ERROR at line 1:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center