探索Oracle之数据库升级三回退升级操作(11.2.0.4Downgrade 11.2.0.3)

浏览数：22 / 时间：2015年06月12日

探索Oracle之数据库升级三

回退升级操作(11.2.0.4Downgrade 11.2.0.3)

我们可以选择2种回退办法：

1. 通过restore point还原到11.2.0.1的数据库

2. 执行catdwgrd.sql降级数据字典

第一种方法:

[oracle@db01 dbs]$ sqlplus /as sysdba
SQL*Plus: Release 11.2.0.4.0Production on Sat Oct 4 04:53:22 2014
Copyright (c) 1982, 2013,Oracle. All rights reserved.
Connected to:
Oracle Database 11gEnterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP,Data Mining and Real Application Testing options
SQL> select * fromv$restore_point;
SCN DATABASE_INCARNATION# GUASTORAGE_SIZE
------------------------------- --- ------------
TIME
---------------------------------------------------------------------------
RESTORE_POINT_TIME PRE
------------------------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
1187867 2 YES 629145600
04-OCT-14 02.41.43.000000000AM
YES
MACLEAN_ROLLBACK
SQL>flashback database torestore point MACLEAN_ROLLBACK;
Flashback complete
SQL> alter database openresetlogs;
Database altered.