切换到窄版

运维联盟俱乐部

 找回密码
 立即注册
运维联盟俱乐部»论坛 › 数据库 › oracle › 11.2.0.4用rman恢复到19.7进行升级
返回列表 发新帖
查看: 3032|回复: 0

[补丁升级] 11.2.0.4用rman恢复到19.7进行升级

[复制链接]
admin
  • TA的每日心情
    开心
    2023-8-9 11:05
    		•
    发表于 2020-7-12 19:46:52 | 显示全部楼层 |阅读模式
    1，11g库做准备
    1. [root@vm1 ~]# su - oracle
    2. Last login: Sun Jul 12 17:57:01 CST 2020
    3. [oracle@vm1 ~]$ source ora11
    4. [oracle@vm1 ~]$ sqlplus / as sysdba

    6. SQL*Plus: Release 11.2.0.4.0 Production on Sun Jul 12 18:01:55 2020

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

    10. Connected to an idle instance.

    12. SQL> startup
    13. ORACLE instance started.

    15. Total System Global Area 3206836224 bytes
    16. Fixed Size                  2257520 bytes
    17. Variable Size             721423760 bytes
    18. Database Buffers         2466250752 bytes
    19. Redo Buffers               16904192 bytes
    20. Database mounted.
    21. Database opened.
    22. SQL> select name from v$datafile;

    24. NAME
    25. --------------------------------------------------------------------------------
    26. /app/oracle/db/oradata/ora11/system01.dbf
    27. /app/oracle/db/oradata/ora11/sysaux01.dbf
    28. /app/oracle/db/oradata/ora11/undotbs01.dbf
    29. /app/oracle/db/oradata/ora11/users01.dbf
    30. /app/oracle/db/oradata/ora11/audlog1.dbf

    32. SQL> create tablespace zhyu datafile '/app/oracle/db/oradata/ora11/zhyu.dbf' size 50m;

    34. Tablespace created.

    36. SQL> create user zhyu identified by zhyu default tablespace zhyu;

    38. User created.

    40. SQL> grant connect,resource to zhyu;

    42. Grant succeeded.

    44. SQL> grant select_catalog_role to zhyu;

    46. Grant succeeded.

    48. SQL> conn zhyu/zhyu
    49. Connected.
    50. SQL> create table obs as select * from dba_objects;
    复制代码
    2.11g开归档
    1. SQL> startup mount
    2. ORACLE instance started.

    4. Total System Global Area 3206836224 bytes
    5. Fixed Size                  2257520 bytes
    6. Variable Size             721423760 bytes
    7. Database Buffers         2466250752 bytes
    8. Redo Buffers               16904192 bytes
    9. Database mounted.
    10. SQL> alter database archivelog;

    12. Database altered.

    14. SQL> alter database open;

    16. Database altered.
    复制代码


    3.11g备份
    1. RMAN> backup database format '/app/oracle/db/rman/full_%U.bak' plus archivelog;


    4. Starting backup at 12-JUL-20
    5. current log archived
    6. using target database control file instead of recovery catalog
    7. allocated channel: ORA_DISK_1
    8. channel ORA_DISK_1: SID=36 device type=DISK
    9. channel ORA_DISK_1: starting archived log backup set
    10. channel ORA_DISK_1: specifying archived log(s) in backup set
    11. input archived log thread=1 sequence=11 RECID=1 STAMP=1045591867
    12. channel ORA_DISK_1: starting piece 1 at 12-JUL-20
    13. channel ORA_DISK_1: finished piece 1 at 12-JUL-20
    14. piece handle=/app/oracle/db/11.2.0.4/home1/dbs/01v54tpr_1_1 tag=TAG20200712T181107 comment=NONE
    15. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
    16. Finished backup at 12-JUL-20

    18. Starting backup at 12-JUL-20
    19. using channel ORA_DISK_1
    20. channel ORA_DISK_1: starting full datafile backup set
    21. channel ORA_DISK_1: specifying datafile(s) in backup set
    22. input datafile file number=00001 name=/app/oracle/db/oradata/ora11/system01.dbf
    23. input datafile file number=00002 name=/app/oracle/db/oradata/ora11/sysaux01.dbf
    24. input datafile file number=00003 name=/app/oracle/db/oradata/ora11/undotbs01.dbf
    25. input datafile file number=00005 name=/app/oracle/db/oradata/ora11/audlog1.dbf
    26. input datafile file number=00006 name=/app/oracle/db/oradata/ora11/zhyu.dbf
    27. input datafile file number=00004 name=/app/oracle/db/oradata/ora11/users01.dbf
    28. channel ORA_DISK_1: starting piece 1 at 12-JUL-20
    29. channel ORA_DISK_1: finished piece 1 at 12-JUL-20
    30. piece handle=/app/oracle/db/rman/full_02v54tps_1_1.bak tag=TAG20200712T181108 comment=NONE
    31. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
    32. channel ORA_DISK_1: starting full datafile backup set
    33. channel ORA_DISK_1: specifying datafile(s) in backup set
    34. including current control file in backup set
    35. including current SPFILE in backup set
    36. channel ORA_DISK_1: starting piece 1 at 12-JUL-20
    37. channel ORA_DISK_1: finished piece 1 at 12-JUL-20
    38. piece handle=/app/oracle/db/rman/full_03v54tqb_1_1.bak tag=TAG20200712T181108 comment=NONE
    39. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
    40. Finished backup at 12-JUL-20

    42. Starting backup at 12-JUL-20
    43. current log archived
    44. using channel ORA_DISK_1
    45. channel ORA_DISK_1: starting archived log backup set
    46. channel ORA_DISK_1: specifying archived log(s) in backup set
    47. input archived log thread=1 sequence=12 RECID=2 STAMP=1045591886
    48. channel ORA_DISK_1: starting piece 1 at 12-JUL-20
    49. channel ORA_DISK_1: finished piece 1 at 12-JUL-20
    50. piece handle=/app/oracle/db/11.2.0.4/home1/dbs/04v54tqe_1_1 tag=TAG20200712T181126 comment=NONE
    51. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
    52. Finished backup at 12-JUL-20

    54. RMAN> list backup;


    57. List of Backup Sets
    58. ===================


    61. BS Key  Size       Device Type Elapsed Time Completion Time
    62. ------- ---------- ----------- ------------ ---------------
    63. 1       21.43M     DISK        00:00:00     12-JUL-20      
    64.         BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20200712T181107
    65.         Piece Name: /app/oracle/db/11.2.0.4/home1/dbs/01v54tpr_1_1

    67.   List of Archived Logs in backup set 1
    68.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
    69.   ---- ------- ---------- --------- ---------- ---------
    70.   1    11      1115503    08-JUL-20 1121716    12-JUL-20

    72. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    73. ------- ---- -- ---------- ----------- ------------ ---------------
    74. 2       Full    1.04G      DISK        00:00:09     12-JUL-20      
    75.         BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20200712T181108
    76.         Piece Name: /app/oracle/db/rman/full_02v54tps_1_1.bak
    77.   List of Datafiles in backup set 2
    78.   File LV Type Ckp SCN    Ckp Time  Name
    79.   ---- -- ---- ---------- --------- ----
    80.   1       Full 1121725    12-JUL-20 /app/oracle/db/oradata/ora11/system01.dbf
    81.   2       Full 1121725    12-JUL-20 /app/oracle/db/oradata/ora11/sysaux01.dbf
    82.   3       Full 1121725    12-JUL-20 /app/oracle/db/oradata/ora11/undotbs01.dbf
    83.   4       Full 1121725    12-JUL-20 /app/oracle/db/oradata/ora11/users01.dbf
    84.   5       Full 1121725    12-JUL-20 /app/oracle/db/oradata/ora11/audlog1.dbf
    85.   6       Full 1121725    12-JUL-20 /app/oracle/db/oradata/ora11/zhyu.dbf

    87. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    88. ------- ---- -- ---------- ----------- ------------ ---------------
    89. 3       Full    9.36M      DISK        00:00:02     12-JUL-20      
    90.         BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20200712T181108
    91.         Piece Name: /app/oracle/db/rman/full_03v54tqb_1_1.bak
    92.   SPFILE Included: Modification time: 12-JUL-20
    93.   SPFILE db_unique_name: ORA11
    94.   Control File Included: Ckp SCN: 1121730      Ckp time: 12-JUL-20

    96. BS Key  Size       Device Type Elapsed Time Completion Time
    97. ------- ---------- ----------- ------------ ---------------
    98. 4       3.00K      DISK        00:00:00     12-JUL-20      
    99.         BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20200712T181126
    100.         Piece Name: /app/oracle/db/11.2.0.4/home1/dbs/04v54tqe_1_1

    102.   List of Archived Logs in backup set 4
    103.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
    104.   ---- ------- ---------- --------- ---------- ---------
    105.   1    12      1121716    12-JUL-20 1121735    12-JUL-20

    107. RMAN> exit
    复制代码
    4.19c准备恢复
    1. ora11.__db_cache_size=2516582400
    2. ora11.__java_pool_size=16777216
    3. ora11.__large_pool_size=33554432
    4. ora11.__oracle_base='/app/oracle/db'#ORACLE_BASE set from environment
    5. ora11.__pga_aggregate_target=838860800
    6. ora11.__sga_target=3221225472
    7. ora11.__shared_io_pool_size=0
    8. ora11.__shared_pool_size=620756992
    9. ora11.__streams_pool_size=0
    10. *.audit_file_dest='/app/oracle/db/admin/ora11/adump'
    11. *.audit_trail='db'
    12. *.compatible='11.2.0.4.0'
    13. *.control_files='/app/oracle/db/oradata/ora11/control01.ctl'
    14. ,'/app/oracle/db/oradata/ora11/control02.ctl'
    15. *.db_block_size=8192
    16. *.db_domain=''
    17. *.db_name='ora11'
    18. *.diagnostic_dest='/app/oracle/db'
    19. *.dispatchers='(PROTOCOL=TCP) (SERVICE=ora11XDB)'
    20. *.log_archive_dest_1='location=/app/oracle/db/arc/ora11g'
    21. *.log_archive_format='%t_%s_%r.arc'
    22. *.open_cursors=300
    23. *.pga_aggregate_target=836763648
    24. *.processes=150
    25. *.remote_login_passwordfile='EXCLUSIVE'
    26. *.sga_max_size=3221225472
    27. *.sga_target=3221225472
    28. *.undo_tablespace='UNDOTBS1'
    复制代码

    5.19c恢复数据库
    6.19c打开数据库
    7.跑脚本
    1. SQL> startup upgrade pfile='/tmp/ora11.ora'
    2. ORACLE instance started.

    4. Total System Global Area 3221222464 bytes
    5. Fixed Size                  8901696 bytes
    6. Variable Size             671088640 bytes
    7. Database Buffers         2533359616 bytes
    8. Redo Buffers                7872512 bytes
    9. Database mounted.
    10. Database opened.
    11. SQL> @?/rdbms/admin/catupgrd.sql
    12. DOC>######################################################################
    13. DOC>######################################################################
    14. DOC>                                 ERROR
    15. DOC>
    16. DOC>
    17. DOC>    As of 12.2, customers must use the parallel upgrade utility, catctl.pl,
    18. DOC>    to invoke catupgrd.sql when upgrading the database dictionary.
    19. DOC>    Running catupgrd.sql directly from SQL*Plus is no longer supported.
    20. DOC>
    21. DOC>    For Example:
    22. DOC>
    23. DOC>          cd $ORACLE_HOME/rdbms/admin
    24. DOC>          catctl
    25. DOC>
    26. DOC>          or
    27. DOC>
    28. DOC>          cd $ORACLE_HOME/rdbms/admin
    29. DOC>          $ORACLE_HOME/perl/bin/perl catctl.pl catupgrd.sql
    30. DOC>
    31. DOC>    Refer to the Oracle Database Upgrade Guide for more information.
    32. DOC>
    33. DOC>
    34. DOC>######################################################################
    35. DOC>######################################################################
    36. DOC>#
    37. Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
    38. Version 19.7.0.0.0
    39. [oracle@vm1 tmp]$ cd  $ORACLE_HOME/rdbms/admin
    40. [oracle@vm1 admin]$ catctl
    41. -bash: catctl: command not found
    42. [oracle@vm1 admin]$ $ORACLE_HOME/perl/bin/perl catctl.pl catupgrd.sql

    44. Argument list for [catctl.pl]
    45. For Oracle internal use only A = 0
    46. Run in                       c = 0
    47. Do not run in                C = 0
    48. Input Directory              d = 0
    49. Echo OFF                     e = 1
    50. Simulate                     E = 0
    51. Forced cleanup               F = 0
    52. Log Id                       i = 0
    53. Child Process                I = 0
    54. Log Dir                      l = 0
    55. Priority List Name           L = 0
    56. Upgrade Mode active          M = 0
    57. SQL Process Count            n = 0
    58. SQL PDB Process Count        N = 0
    59. Open Mode Normal             o = 0
    60. Start Phase                  p = 0
    61. End Phase                    P = 0
    62. Reverse Order                r = 0
    63. AutoUpgrade Resume           R = 0
    64. Script                       s = 0
    65. Serial Run                   S = 0
    66. RO User Tablespaces          T = 0
    67. Display Phases               y = 0
    68. Debug catcon.pm              z = 0
    69. Debug catctl.pl              Z = 0

    71. catctl.pl VERSION: [19.0.0.0.0]
    72.            STATUS: [Production]
    73.             BUILD: [RDBMS_19.7.0.0.0DBRU_LINUX.X64_200403]


    76. /app/oracle/db/19.3.0/home1/rdbms/admin/orahome = [/app/oracle/db/19.3.0/home1]
    77. /app/oracle/db/19.3.0/home1/bin/orabasehome = [/app/oracle/db/19.3.0/home1]
    78. catctlGetOraBaseLogDir = [/app/oracle/db/19.3.0/home1]

    80. Analyzing file /app/oracle/db/19.3.0/home1/rdbms/admin/catupgrd.sql

    82. Log file directory = [/tmp/cfgtoollogs/upgrade20200712183308]

    84. catcon::set_log_file_base_path: ALL catcon-related output will be written to [/tmp/cfgtoollogs/upgrade20200712183308/catupgrd_catcon_5176.lst]

    86. catcon::set_log_file_base_path: catcon: See [/tmp/cfgtoollogs/upgrade20200712183308/catupgrd*.log] files for output generated by scripts

    88. catcon::set_log_file_base_path: catcon: See [/tmp/cfgtoollogs/upgrade20200712183308/catupgrd_*.lst] files for spool files, if any


    91. Number of Cpus        = 1
    92. Database Name         = ora11
    93. DataBase Version      = 11.2.0.4.0
    94. catcon::set_log_file_base_path: ALL catcon-related output will be written to [/app/oracle/db/19.3.0/home1/cfgtoollogs/ora11/upgrade20200712183318/catupgrd_catcon_5176.lst]

    96. catcon::set_log_file_base_path: catcon: See [/app/oracle/db/19.3.0/home1/cfgtoollogs/ora11/upgrade20200712183318/catupgrd*.log] files for output generated by scripts

    98. catcon::set_log_file_base_path: catcon: See [/app/oracle/db/19.3.0/home1/cfgtoollogs/ora11/upgrade20200712183318/catupgrd_*.lst] files for spool files, if any


    101. Log file directory = [/app/oracle/db/19.3.0/home1/cfgtoollogs/ora11/upgrade20200712183318]

    103. Parallel SQL Process Count            = 4
    104. Components in [ora11]
    105.     Installed [APEX APS CATALOG CATJAVA CATPROC CONTEXT EM JAVAVM ORDIM OWM SDO XDB XML XOQ]
    106. Not Installed [DV MGW ODM OLS RAC WK]
    107. DataBase Version      = 11.2.0.4.0

    109. ------------------------------------------------------
    110. Phases [0-107]         Start Time:[2020_07_12 18:33:31]
    111. ------------------------------------------------------
    112. ***********   Executing Change Scripts   ***********
    113. Serial   Phase #:0    [ora11] Files:1    Time: 48s
    114. ***************   Catalog Core SQL   ***************
    115. Serial   Phase #:1    [ora11] Files:5    Time: 30s
    116. Restart  Phase #:2    [ora11] Files:1    Time: 1s
    117. ***********   Catalog Tables and Views   ***********
    118. Parallel Phase #:3    [ora11] Files:19   Time: 17s
    119. Restart  Phase #:4    [ora11] Files:1    Time: 1s
    120. *************   Catalog Final Scripts   ************
    121. Serial   Phase #:5    [ora11] Files:7    Time: 13s
    122. *****************   Catproc Start   ****************
    123. Serial   Phase #:6    [ora11] Files:1    Time: 12s
    124. *****************   Catproc Types   ****************
    125. Serial   Phase #:7    [ora11] Files:2    Time: 7s
    126. Restart  Phase #:8    [ora11] Files:1    Time: 1s
    127. ****************   Catproc Tables   ****************
    128. Parallel Phase #:9    [ora11] Files:67   Time: 34s
    129. Restart  Phase #:10   [ora11] Files:1    Time: 0s
    130. *************   Catproc Package Specs   ************
    131. Serial   Phase #:11   [ora11] Files:1    Time: 44s
    132. Restart  Phase #:12   [ora11] Files:1    Time: 1s
    133. **************   Catproc Procedures   **************
    134. Parallel Phase #:13   [ora11] Files:94   Time: 11s
    135. Restart  Phase #:14   [ora11] Files:1    Time: 1s
    136. Parallel Phase #:15   [ora11] Files:121  Time: 18s
    137. Restart  Phase #:16   [ora11] Files:1    Time: 1s
    138. Serial   Phase #:17   [ora11] Files:22   Time: 3s
    139. Restart  Phase #:18   [ora11] Files:1    Time: 1s
    140. *****************   Catproc Views   ****************
    141. Parallel Phase #:19   [ora11] Files:32   Time: 23s
    142. Restart  Phase #:20   [ora11] Files:1    Time: 1s
    143. Serial   Phase #:21   [ora11] Files:3    Time: 10s
    144. Restart  Phase #:22   [ora11] Files:1    Time: 1s
    145. Parallel Phase #:23   [ora11] Files:25   Time: 124s
    146. Restart  Phase #:24   [ora11] Files:1    Time: 1s
    147. Parallel Phase #:25   [ora11] Files:12   Time: 84s
    148. Restart  Phase #:26   [ora11] Files:1    Time: 1s
    149. Serial   Phase #:27   [ora11] Files:1    Time: 0s
    150. Serial   Phase #:28   [ora11] Files:3    Time: 4s
    151. Serial   Phase #:29   [ora11] Files:1    Time: 0s
    152. Restart  Phase #:30   [ora11] Files:1    Time: 0s
    153. ***************   Catproc CDB Views   **************
    154. Serial   Phase #:31   [ora11] Files:1    Time: 2s
    155. Restart  Phase #:32   [ora11] Files:1    Time: 1s
    156. Serial   Phase #:34   [ora11] Files:1    Time: 0s
    157. *****************   Catproc PLBs   *****************
    158. Serial   Phase #:35   [ora11] Files:294  Time: 14s
    159. Serial   Phase #:36   [ora11] Files:1    Time: 0s
    160. Restart  Phase #:37   [ora11] Files:1    Time: 1s
    161. Serial   Phase #:38   [ora11] Files:6    Time: 5s
    162. Restart  Phase #:39   [ora11] Files:1    Time: 2s
    163. ***************   Catproc DataPump   ***************
    164. Serial   Phase #:40   [ora11] Files:3    Time: 46s
    165. Restart  Phase #:41   [ora11] Files:1    Time: 1s
    166. ******************   Catproc SQL   *****************
    167. Parallel Phase #:42   [ora11] Files:13   Time: 91s
    168. Restart  Phase #:43   [ora11] Files:1    Time: 1s
    169. Parallel Phase #:44   [ora11] Files:11   Time: 17s
    170. Restart  Phase #:45   [ora11] Files:1    Time: 0s
    171. Parallel Phase #:46   [ora11] Files:3    Time: 3s
    172. Restart  Phase #:47   [ora11] Files:1    Time: 1s
    173. *************   Final Catproc scripts   ************
    174. Serial   Phase #:48   [ora11] Files:1    Time: 7s
    175. Restart  Phase #:49   [ora11] Files:1    Time: 1s
    176. **************   Final RDBMS scripts   *************
    177. Serial   Phase #:50   [ora11] Files:1    Time: 16s
    178. ************   Upgrade Component Start   ***********
    179. Serial   Phase #:51   [ora11] Files:1    Time: 2s
    180. Restart  Phase #:52   [ora11] Files:1    Time: 1s
    181. **********   Upgrading Java and non-Java   *********
    182. Serial   Phase #:53   [ora11] Files:2    Time: 373s
    183. *****************   Upgrading XDB   ****************
    184. Restart  Phase #:54   [ora11] Files:1    Time: 2s
    185. Serial   Phase #:56   [ora11] Files:3    Time: 27s
    186. Serial   Phase #:57   [ora11] Files:3    Time: 5s
    187. Parallel Phase #:58   [ora11] Files:10   Time: 6s
    188. Parallel Phase #:59   [ora11] Files:25   Time: 7s
    189. Serial   Phase #:60   [ora11] Files:4    Time: 9s
    190. Serial   Phase #:61   [ora11] Files:1    Time: 0s
    191. Serial   Phase #:62   [ora11] Files:32   Time: 5s
    192. Serial   Phase #:63   [ora11] Files:1    Time: 0s
    193. Parallel Phase #:64   [ora11] Files:6    Time: 9s
    194. Serial   Phase #:65   [ora11] Files:2    Time: 18s
    195. Serial   Phase #:66   [ora11] Files:3    Time: 63s
    196. ****************   Upgrading ORDIM   ***************
    197. Restart  Phase #:67   [ora11] Files:1    Time: 1s
    198. Serial   Phase #:69   [ora11] Files:1    Time: 4s
    199. Parallel Phase #:70   [ora11] Files:2    Time: 40s
    200. Restart  Phase #:71   [ora11] Files:1    Time: 0s
    201. Parallel Phase #:72   [ora11] Files:2    Time: 4s
    202. Serial   Phase #:73   [ora11] Files:2    Time: 5s
    203. *****************   Upgrading SDO   ****************
    204. Restart  Phase #:74   [ora11] Files:1    Time: 0s
    205. Serial   Phase #:76   [ora11] Files:1    Time: 29s
    206. Serial   Phase #:77   [ora11] Files:2    Time: 5s
    207. Restart  Phase #:78   [ora11] Files:1    Time: 1s
    208. Serial   Phase #:79   [ora11] Files:1    Time: 19s
    209. Restart  Phase #:80   [ora11] Files:1    Time: 1s
    210. Parallel Phase #:81   [ora11] Files:3    Time: 58s
    211. Restart  Phase #:82   [ora11] Files:1    Time: 1s
    212. Serial   Phase #:83   [ora11] Files:1    Time: 7s
    213. Restart  Phase #:84   [ora11] Files:1    Time: 1s
    214. Serial   Phase #:85   [ora11] Files:1    Time: 10s
    215. Restart  Phase #:86   [ora11] Files:1    Time: 1s
    216. Parallel Phase #:87   [ora11] Files:4    Time: 113s
    217. Restart  Phase #:88   [ora11] Files:1    Time: 1s
    218. Serial   Phase #:89   [ora11] Files:1    Time: 4s
    219. Restart  Phase #:90   [ora11] Files:1    Time: 1s
    220. Serial   Phase #:91   [ora11] Files:2    Time: 11s
    221. Restart  Phase #:92   [ora11] Files:1    Time: 1s
    222. Serial   Phase #:93   [ora11] Files:1    Time: 2s
    223. Restart  Phase #:94   [ora11] Files:1    Time: 1s
    224. *******   Upgrading ODM, WK, EXF, RUL, XOQ   *******
    225. Serial   Phase #:95   [ora11] Files:1    Time: 22s
    226. Restart  Phase #:96   [ora11] Files:1    Time: 0s
    227. ***********   Final Component scripts    ***********
    228. Serial   Phase #:97   [ora11] Files:1    Time: 3s
    229. *************   Final Upgrade scripts   ************
    230. Serial   Phase #:98   [ora11] Files:1    Time: 376s
    231. *******************   Migration   ******************
    232. Serial   Phase #:99   [ora11] Files:1    Time: 32s
    233. ***   End PDB Application Upgrade Pre-Shutdown   ***
    234. Serial   Phase #:100  [ora11] Files:1    Time: 2s
    235. Serial   Phase #:101  [ora11] Files:1    Time: 0s
    236. Serial   Phase #:102  [ora11] Files:1    Time: 34s
    237. *****************   Post Upgrade   *****************
    238. Serial   Phase #:103  [ora11] Files:1    Time: 31s
    239. ****************   Summary report   ****************
    240. Serial   Phase #:104  [ora11] Files:1    Time: 3s
    241. ***   End PDB Application Upgrade Post-Shutdown   **
    242. Serial   Phase #:105  [ora11] Files:1    Time: 2s
    243. Serial   Phase #:106  [ora11] Files:1    Time: 0s
    244. Serial   Phase #:107  [ora11] Files:1     Time: 24s

    246. ------------------------------------------------------
    247. Phases [0-107]         End Time:[2020_07_12 19:08:10]
    248. ------------------------------------------------------

    250. Grand Total Time: 2081s

    252. LOG FILES: (/app/oracle/db/19.3.0/home1/cfgtoollogs/ora11/upgrade20200712183318/catupgrd*.log)

    254. Upgrade Summary Report Located in:
    255. /app/oracle/db/19.3.0/home1/cfgtoollogs/ora11/upgrade20200712183318/upg_summary.log

    257. Grand Total Upgrade Time:    [0d:0h:34m:41s]
    复制代码
    8.检查
    1. SQL> startup pfile='/tmp/ora11.ora'
    2. ORACLE instance started.

    4. Total System Global Area 3221222464 bytes
    5. Fixed Size                  8901696 bytes
    6. Variable Size             671088640 bytes
    7. Database Buffers         2533359616 bytes
    8. Redo Buffers                7872512 bytes
    9. Database mounted.
    10. Database opened.
    11. SQL> select * from v$version;

    13. BANNER
    14. --------------------------------------------------------------------------------
    15. BANNER_FULL
    16. --------------------------------------------------------------------------------
    17. BANNER_LEGACY
    18. --------------------------------------------------------------------------------
    19.     CON_ID
    20. ----------
    21. Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
    22. Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
    23. Version 19.7.0.0.0
    24. Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
    25.          0

    27. BANNER
    28. --------------------------------------------------------------------------------
    29. BANNER_FULL
    30. --------------------------------------------------------------------------------
    31. BANNER_LEGACY
    32. --------------------------------------------------------------------------------
    33.     CON_ID
    34. ----------
    复制代码






    回复

    使用道具 举报

    返回列表 发新帖
    高级模式
    B Color Image Link Quote Code Smilies
    您需要登录后才可以回帖 登录 | 立即注册

    本版积分规则

    运维联盟俱乐部 ( 冀ICP备19036648号 )

    GMT+8, 2024-4-20 07:52 , Processed in 0.050161 second(s), 21 queries , Gzip On.

    Powered by Discuz! X3.4

    © 2001-2023 Discuz! Team.

    快速回复 返回顶部 返回列表