Thinking Out Loud

July 3, 2013

Restore 12c Upgrade

Filed under: Blogroll,oracle — mdinh @ 2:09 am

Did you finished reading my post on 12c upgrade?

Power of rot, obscuring truth, what once was old restore to youth – http://en.wikipedia.org/wiki/Visionaries:_Knights_of_the_Magical_Light

Just like that – my database is back to 11.2.0.3

[oracle@lax:db01]/u01/app/oracle/cfgtoollogs/dbua/lax_db01/upgrade1
$ ls *restore*
db01_restore.sh
[oracle@lax:db01]/u01/app/oracle/cfgtoollogs/dbua/lax_db01/upgrade1
$ ./db01_restore.sh
-- Bringing down the database from the new oracle home

SQL*Plus: Release 12.1.0.1.0 Production on Tue Jul 2 18:53:14 2013

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected.
ORACLE instance shut down.
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
You should Remove this entry from the /etc/oratab: db01:/u01/app/oracle/product/12.1.0/dbhome_1:Y
-- Bringing up the database from the source oracle home
You should Add this entry in the /etc/oratab: db01:/u01/app/oracle/product/11.2.0.3/db_1:Y
-- Removing /u01/app/oracle/cfgtoollogs/dbua/logs/Welcome_db01.txt file

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jul 2 18:53:17 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

File created.

Disconnected

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jul 2 18:53:18 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.
ORACLE instance started.

Total System Global Area  534462464 bytes
Fixed Size                  2230072 bytes
Variable Size             167774408 bytes
Database Buffers          360710144 bytes
Redo Buffers                3747840 bytes
Database mounted.

Flashback complete.

Database altered.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@lax:db01]/u01/app/oracle/cfgtoollogs/dbua/lax_db01/upgrade1
$ vi /etc/oratab
[oracle@lax:db01]/u01/app/oracle/cfgtoollogs/dbua/lax_db01/upgrade1
$ . ~/.bash_profile
[oracle@lax:db01]/u01/app/oracle/cfgtoollogs/dbua/lax_db01/upgrade1
$ db01
The Oracle base remains unchanged with value /u01/app/oracle

IPC Resources for ORACLE_SID "db01" :
Shared Memory:
ID              KEY
26116100        0x00000000
26148869        0x00000000
26181638        0xc1f92260
Semaphores:
ID              KEY
2228226         0x7632ce48
Oracle Instance alive for sid "db01"
[oracle@lax:db01]/u01/app/oracle/cfgtoollogs/dbua/lax_db01/upgrade1
$ sqlplus "/ as sysdba"

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jul 2 19:00:44 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

LAX:(SYS@db01)> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@lax:db01]/u01/app/oracle/cfgtoollogs/dbua/lax_db01/upgrade1
$ lsnrctl status listener_db01

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 02-JUL-2013 19:00:56

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=lax.localdomain)(PORT=1531)(SEND_BUF_SIZE=32767)(RECV_BUF_SIZE=32767)))
STATUS of the LISTENER
------------------------
Alias                     listener_db01
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                02-JUL-2013 06:39:35
Uptime                    0 days 12 hr. 21 min. 22 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0.3/db_1/network/admin/listener.ora
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lax)(PORT=1531)))
Services Summary...
Service "lax_db01" has 1 instance(s).
  Instance "db01", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@lax:db01]/u01/app/oracle/cfgtoollogs/dbua/lax_db01/upgrade1
$
About these ads

2 Comments »

  1. Cool stuff Michael but why would You go back from great 12c ?:)
    Regards
    Greg

    Comment by Greg — July 3, 2013 @ 6:28 am | Reply

    • Not necessarily going back definitely. Testing the how seamless and automated the restore process is. In addition, now get to practice upgrade again trying different options. May be a manual upgrade? Hell to the NO.

      Comment by mdinh — July 3, 2013 @ 12:57 pm | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Rubric Theme. Create a free website or blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 314 other followers

%d bloggers like this: