Shulou(Shulou.com)06/01 Report--

Catalogue

I. database upgrade route

2. Full RMAN backup of Source database

2.1 execute utlu112i.sql script before backup

2.2 full backup of Source database

Third, the Target end performs off-machine operations

3.1 restore Spfile

3.2 restore control files

3.3 restore archived Fil

3.4 restore data files

3.5 upgrade Open Database

3.6 execute the upgrade script catupgrd.sql

3.7 execute script utlu112s.sql

3.8 execute script catuppsd.sql

3.9 compiling invalid objects

3.10 check component status

3.11 Summary

Experimental environment:

Original end of ◆ (Source):

Operating system: RedHat6.4 64-bit database: Oracle 10.2.0.5 archive mode

Hostname:seiang10g.comsys.com IP:10.1.1.47 SID:seiang

◆ destination (Target):

Operating system: CentOS7.3 64-bit database: Oracle 11.2.0.4 archive mode

Hostname:seiang11g.comsys.com IP:10.1.1.46 SID:seiang11g

Link to this blog:

Http://blog.itpub.net/31015730/viewspace-2142135/

Author: SEian.G (hard practice changes in 72, but it is difficult to laugh at 81)

ITPUB: http://blog.itpub.net/31015730/

51CTO: http://seiang.blog.51cto.com/

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.