设为首页 加入收藏

TOP

Oracle 使用RMAN 将 DB 从10g 直接 Restore 到11g 示例(二)
2014-11-24 18:52:38 】 浏览:8565
Tags:Oracle 使用 RMAN 10g 直接 Restore 11g 示例
***************************


--> background_dump_dest 11.1 DEPRECATED replaced by "diagnostic_dest"


--> user_dump_dest 11.1 DEPRECATED replaced by "diagnostic_dest"


.



**********************************************************************


Components: [The following databasecomponents will be upgraded or installed]


**********************************************************************


--> Oracle Catalog Views [upgrade] VALID


--> Oracle Packages and Types [upgrade] VALID


--> JServer JAVA Virtual Machine[upgrade] VALID


--> Oracle XDK for Java [upgrade] VALID


--> Oracle Workspace Manager [upgrade] VALID


--> OLAP Analytic Workspace [upgrade] VALID


--> OLAP Catalog [upgrade] VALID


--> EM Repository [upgrade] VALID


--> Oracle Text [upgrade] VALID


--> Oracle XML Database [upgrade] VALID


--> Oracle Java Packages [upgrade] VALID


--> Oracle interMedia [upgrade] VALID


--> Spatial [upgrade] VALID


--> Data Mining [upgrade] VALID


--> Expression Filter [upgrade] VALID


--> Rule Manager [upgrade] VALID


--> Oracle OLAP API [upgrade] VALID


.


**********************************************************************


Miscellaneous Warnings


**********************************************************************


WARNING: --> Database is using atimezone file older than version 14.


.... After the release migration, it isrecommended that DBMS_DST package


.... be used to upgrade the 10.2.0.5.0database timezone version


.... to the latest version which comes withthe new release.


WARNING: --> EM Database ControlRepository exists in the database.


.... Direct downgrade of EM DatabaseControl is not supported. Refer to the


.... Upgrade Guide for instructions to savethe EM data prior to upgrade.


WARNING: --> Your recycle bin is turnedon and currently contains no objects.


.... Because it is REQUIRED that therecycle bin be empty prior to upgrading


.... and your recycle bin is turned on, youmay need to execute the command:


PURGE DBA_RECYCLEBIN


.... prior to executing your upgrade toconfirm the recycle bin is empty.


.


**********************************************************************


Recommendations


**********************************************************************


Oracle recommends gathering dictionarystatistics prior to


upgrading the database.


To gather dictionary statistics execute thefollowing command


while connected as SYSDBA:



EXECUTE dbms_stats.gather_dictionary_stats;



**********************************************************************


Oracle recommends reviewing any definedevents prior to upgrading.



To view existing non-default events executethe following commands


while connected AS SYSDBA:


Events:


SELECT (translate(value,chr(13)||chr(10),' ')) FROM sys.v$parameter2


WHERE UPPER(name) ='EVENT'AND isdefault='FALSE'



Trace Events:


SELECT (translate(value,chr(13)||chr(10),' ')) from sys.v$parameter2


WHERE UPPER(name) = '_TRACE_EVENTS' AND isdefault='FALSE'



Changes will need to be made in theinit.ora or spfile.



**********************************************************************


SQL>



如果直接在11g上执行这个脚本,那么会报如下错误:


SQL> @ /rdbms/admin/utlu112

首页 上一页 1 2 3 下一页 尾页 2/3/3
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
上一篇64位 Linux平台下Oracle安装文档 下一篇SQLite3判断Token类型(Keyword)

最新文章

热门文章

Hot 文章

Python

C 语言

C++基础

大数据基础

linux编程基础

C/C++面试题目