TOP

Oracle 使用RMAN 将 DB 从10g 直接 Restore 到11g 示例(二)
2014-11-24 18:52:38 】 浏览:8673次 本网站的内容取自网络,仅供学习参考之用,绝无侵犯任何人知识产权之意。如有侵犯请您及时与本人取得联系,万分感谢。
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

请关注公众号获取更多资料


Oracle 使用RMAN 将 DB 从10g 直接 Restore 到11g 示例(二) https://www.cppentry.com/bencandy.php?fid=57&id=87781

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

评论

验 证 码:
表  情:
内  容: