oracle dbua 升级,dbua升级oracle 10.2.0.1 0 到11.2.0.4 失败后还原过程

一 升级时候勾选bakcup

database

二 假设升级中出现问题

这里可以是意外升级中断，机器down机器等

三 找到当初备份目录

我这里的环境是这样

[/darin/admin/ora10g/backup]ls

control01.ctl  control03.ctl

ora10g_restore.sh  redo02.log  shutdown_ora10g.sql  sysaux01.dbf

temp01.dbf     users01.dbf

control02.ctl  example01.dbf

redo01.log         redo03.log  startup_ora10g.sql   system01.dbf

undotbs01.dbf

可以发现

有一个 ora10g_restore.sh文件，我们打开看看

#!/bin/sh

# -- Run this Script to Restore Oracle

Database Instance ora10g

echo -- Bringing down the database from the

new oracle home

ORACLE_HOME=/darin/product/11.2.0.4; export

ORACLE_HOME

ORACLE_SID=ora10g; export ORACLE_SID

ORACLE_UNQNAME=ora10g; export

ORACLE_UNQNAME

/darin/product/11.2.0.4/bin/emctl stop

dbconsole

/darin/product/11.2.0.4/bin/sqlplus /nolog

@/darin/admin/ora10g/backup/shutdown_ora10g.sql

echo You should Remove this entry from the

/etc/oratab: ora10g:/darin/product/11.2.0.4:Y

echo -- Copying Datafiles....

/bin/cp

/darin/admin/ora10g/backup/example01.dbf /darin/oradata/ora10g/example01.dbf

/bin/cp /darin/admin/ora10g/backup/redo01.log

/darin/oradata/ora10g/redo01.log

/bin/cp

/darin/admin/ora10g/backup/redo02.log /darin/oradata/ora10g/redo02.log

/bin/cp

/darin/admin/ora10g/backup/redo03.log /darin/oradata/ora10g/redo03.log

/bin/cp

/darin/admin/ora10g/backup/sysaux01.dbf /darin/oradata/ora10g/sysaux01.dbf

/bin/cp

/darin/admin/ora10g/backup/system01.dbf /darin/oradata/ora10g/system01.dbf

/bin/cp

/darin/admin/ora10g/backup/temp01.dbf /darin/oradata/ora10g/temp01.dbf

/bin/cp

/darin/admin/ora10g/backup/undotbs01.dbf /darin/oradata/ora10g/undotbs01.dbf

/bin/cp

/darin/admin/ora10g/backup/users01.dbf /darin/oradata/ora10g/users01.dbf

/bin/cp

/darin/admin/ora10g/backup/control01.ctl /darin/oradata/ora10g/control01.ctl

/bin/cp

/darin/admin/ora10g/backup/control02.ctl /darin/oradata/ora10g/control02.ctl

/bin/cp

/darin/admin/ora10g/backup/control03.ctl /darin/oradata/ora10g/control03.ctl

echo -- Bringing up the database from the

source oracle home

ORACLE_HOME=/darin/product/10.2.0; export

ORACLE_HOME

ORACLE_SID=ora10g; export ORACLE_SID

unset LD_LIBRARY_PATH; unset

LD_LIBRARY_PATH_64; unset SHLIB_PATH; unset LIB_PATH

echo You should Add this entry in the

/etc/oratab: ora10g:/darin/product/10.2.0:Y

cd /darin/product/10.2.0

/darin/product/10.2.0/bin/sqlplus /nolog

@/darin/admin/ora10g/backup/startup_ora10g.sql

/darin/product/11.2.0.4/bin/emca -restore

db -silent -DB_UNIQUE_NAME ora10g -PORT 1521 -LISTENER LISTENER  -SID ora10g -ORACLE_HOME

/darin/product/11.2.0.4 -

HOST darin -LISTENER_OH

/darin/product/11.2.0.4 -LOG_FILE

/darin/cfgtoollogs/dbua/ora10g/upgrade3/restoreEmConfig.log -SRC_OH

/darin/product/10.2.0

#Performed EM Restore Config Changes.

这个脚本是数据库还原脚本

1 首先是切换环境变量到11g

2 然后停止em

3 关闭db

4 移除/etc/oratab: ora10g:/darin/product/11.2.0.4:Y条目

5 Copy文件到你的原来的数据库文件目录

6 切换到10g的环境变量

7 启动数据库

8 还原监听

下面我们来运行一下这个脚本(我现在是升级成功的环境)

darin[/darin/admin/ora10g/backup]./ora10g_restore.sh

-- Bringing down the database from the new

oracle home

Oracle Enterprise Manager 11g Database

Control Release 11.2.0.4.0

Copyright (c) 1996, 2013 Oracle

Corporation.  All rights reserved.

Stopping Oracle Enterprise Manager 11g

Database Control ...

...

Stopped.

SQL*Plus: Release 11.2.0.4.0 Production on

Sat Aug 23 20:57:44 2014

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

Connected.

ORACLE instance shut down.

Disconnected from Oracle Database 11g

Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining

and Real Application Testing options

You should Remove this entry from the

/etc/oratab: ora10g:/darin/product/11.2.0.4:Y

-- Copying Datafiles....

-- Bringing up the database from the source

oracle home

You should Add this entry in the

/etc/oratab: ora10g:/darin/product/10.2.0:Y

SQL*Plus: Release 10.2.0.2.0 - Production

on Sat Aug 23 21:00:28 2014

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

Connected to an idle instance.

ORACLE instance started.

Total System Global Area  281018368 bytes

Fixed Size                  2070552 bytes

Variable Size             100665320 bytes

Database Buffers          171966464 bytes

Redo Buffers                6316032 bytes

Database mounted.

Database opened.

Disconnected from Oracle Database 10g

Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning, OLAP and Data Mining

options

STARTED EMCA at Aug 23, 2014 9:01:07 PM

EM Configuration Assistant, Version

11.2.0.3.0 Production

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

Aug 23, 2014 9:01:12 PM

oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at

/darin/cfgtoollogs/dbua/ora10g/upgrade3/restoreEmConfig.log.

Aug 23, 2014 9:01:14 PM

oracle.sysman.emcp.util.DBControlUtil stopOMS

INFO: Stopping Database Control (this may

take a while) ...

Aug 23, 2014 9:01:26 PM

oracle.sysman.emcp.util.DBControlUtil startOMS

INFO: Starting Database Control (this may

take a while) ...

Aug 23, 2014 9:03:12 PM

oracle.sysman.emcp.EMDBPostConfig performRestore

INFO: Database Control started successfully

Aug 23, 2014 9:03:12 PM

oracle.sysman.emcp.EMDBPostConfig performRestore

INFO:

>>>>>>>>>>> The Database Control URL is

<<<<<<<<<<<

Enterprise Manager configuration completed

successfully

FINISHED EMCA at Aug 23, 2014 9:03:12 PM

还原完成

这里我们还要在 /etc/oratab增加条目

ora10g:/darin/product/10.2.0:Y

查看监听正常

darin[/home/oracle]lsnrctl status

LSNRCTL for Linux: Version 10.2.0.2.0 -

Production on 23-AUG-2014 21:07:13

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

Connecting to

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=darin)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version

10.2.0.2.0 - Production

Start Date                23-AUG-2014 21:06:33

Uptime                    0 days 0 hr. 0 min. 40 sec

Trace Level               off

Security

ON: Local OS

Authentication

SNMP                      OFF

Listener Parameter File

/darin/product/10.2.0/network/admin/listener.ora

Listener Log File

/darin/product/10.2.0/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=darin)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

Services Summary...

Service "PLSExtProc" has 1

instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for

this service...

Service "ora10g" has 1

instance(s).

Instance "ora10g", status READY, has 1 handler(s) for this

service...

Service "ora10gXDB" has 1

instance(s).

Instance "ora10g", status READY, has 1 handler(s) for this

service...

Service "ora10g_XPT" has 1

instance(s).

Instance "ora10g", status READY, has 1 handler(s) for this service

至此，还原结束。