12C还原使用旧版本RMAN所创建的备份

可以还原使用旧版本RMAN所创建的备份，最旧版本为9.2.0.8。在创建备份的数据库版本与还原备份的数据库版本之间必须有支持的升级路径存在。比如，源数据库的版本为11gr2并且配置使用spfile参数文件。数据库启用了归档与快速闪回区。控制文件也被配置为自动备份。对源数据库创建了RMAN备份，并且包含了归档重做日志。要还原这些备份的主机上运行的是Oracle 12cr2的数据库版本。

还原使用旧版本RMAN所创建备份到当前目标数据库版本(12.2)的操作步骤如下:
1.验证创建备份的数据库版本与还原备份的数据库版本之间是否存在升级路径。例如，将Oracle 11.2.0.4所创建的RMAN备份还原到Oracle 12.2，那么必须支持从11.2.0.4升级到12.2，根据Oracle的升级指南，11.2.0.3及以后版本可以直接升级到Oracle 12.2。

2.对源数据库(jyrac为rac数据库)创建RMAN备份

RMAN> backup as compressed backupset database format '/acfs1/rman_back/jyrac_%u_%d_%t_%s_%p'  plus archivelog format '/acfs1/rman_back/arch_%d_%T_%U';Starting backup at 29-DEC-17current log archivedusing channel ORA_DISK_1channel ORA_DISK_1: starting compressed archived log backup setchannel ORA_DISK_1: specifying archived log(s) in backup setinput archived log thread=1 sequence=497 RECID=1044 STAMP=964006170input archived log thread=2 sequence=540 RECID=1045 STAMP=964006171channel ORA_DISK_1: starting piece 1 at 29-DEC-17channel ORA_DISK_1: finished piece 1 at 29-DEC-17piece handle=/acfs1/rman_back/arch_JYRAC_20171229_0isnb48r_1_1 tag=TAG20171229T112931 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01Finished backup at 29-DEC-17Starting backup at 29-DEC-17using channel ORA_DISK_1channel ORA_DISK_1: starting compressed full datafile backup setchannel ORA_DISK_1: specifying datafile(s) in backup setinput datafile file number=00012 name=+DATADG/jyrac/datafile/ldjc01input datafile file number=00002 name=+DATADG/jyrac/datafile/sysaux.258.930413055input datafile file number=00011 name=+DATADG/jyrac/datafile/cdzj01input datafile file number=00001 name=+DATADG/jyrac/datafile/system.259.930413057input datafile file number=00003 name=+DATADG/jyrac/datafile/undotbs1.262.930413057input datafile file number=00008 name=+DATADG/jyrac/datafile/sales_test_01.dbfinput datafile file number=00005 name=+DATADG/jyrac/datafile/example.260.930413057input datafile file number=00006 name=+DATADG/jyrac/datafile/undotbs2.261.930413057input datafile file number=00007 name=+DATADG/jyrac/datafile/test01.dbfinput datafile file number=00009 name=+DATADG/jyrac/datafile/emp_test_01.dbfinput datafile file number=00010 name=+DATADG/jyrac/datafile/orders_test_01.dbfinput datafile file number=00004 name=+DATADG/jyrac/datafile/users.263.930413057channel ORA_DISK_1: starting piece 1 at 29-DEC-17channel ORA_DISK_1: finished piece 1 at 29-DEC-17piece handle=/acfs1/rman_back/jyrac_0jsnb48u_JYRAC_964006174_19_1 tag=TAG20171229T112933 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:09:06Finished backup at 29-DEC-17Starting backup at 29-DEC-17current log archivedusing channel ORA_DISK_1channel ORA_DISK_1: starting compressed archived log backup setchannel ORA_DISK_1: specifying archived log(s) in backup setinput archived log thread=1 sequence=498 RECID=1046 STAMP=964006723input archived log thread=2 sequence=541 RECID=1047 STAMP=964006720channel ORA_DISK_1: starting piece 1 at 29-DEC-17channel ORA_DISK_1: finished piece 1 at 29-DEC-17piece handle=/acfs1/rman_back/arch_JYRAC_20171229_0ksnb4q5_1_1 tag=TAG20171229T113845 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01Finished backup at 29-DEC-17Starting Control File and SPFILE Autobackup at 29-DEC-17piece handle=/acfs1/rman_back/c-2655496871-20171229-00 comment=NONEFinished Control File and SPFILE Autobackup at 29-DEC-17RMAN> list backup;List of Backup Sets===================BS Key  Size       Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------9       24.50K     DISK        00:00:01     29-DEC-17              BP Key: 9   Status: AVAILABLE  Compressed: YES  Tag: TAG20171229T112931        Piece Name: /acfs1/rman_back/arch_JYRAC_20171229_0isnb48r_1_1  List of Archived Logs in backup set 9  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time  ---- ------- ---------- --------- ---------- ---------  1    497     14690299647719 29-DEC-17 14690299647943 29-DEC-17  2    540     14690299647723 29-DEC-17 14690299647960 29-DEC-17BS Key  Type LV Size       Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------10      Full    1.82G      DISK        00:09:05     29-DEC-17              BP Key: 10   Status: AVAILABLE  Compressed: YES  Tag: TAG20171229T112933        Piece Name: /acfs1/rman_back/jyrac_0jsnb48u_JYRAC_964006174_19_1  List of Datafiles in backup set 10  File LV Type Ckp SCN    Ckp Time  Name  ---- -- ---- ---------- --------- ----  1       Full 14690299647966 29-DEC-17 +DATADG/jyrac/datafile/system.259.930413057  2       Full 14690299647966 29-DEC-17 +DATADG/jyrac/datafile/sysaux.258.930413055  3       Full 14690299647966 29-DEC-17 +DATADG/jyrac/datafile/undotbs1.262.930413057  4       Full 14690299647966 29-DEC-17 +DATADG/jyrac/datafile/users.263.930413057  5       Full 14690299647966 29-DEC-17 +DATADG/jyrac/datafile/example.260.930413057  6       Full 14690299647966 29-DEC-17 +DATADG/jyrac/datafile/undotbs2.261.930413057  7       Full 14690299647966 29-DEC-17 +DATADG/jyrac/datafile/test01.dbf  8       Full 14690299647966 29-DEC-17 +DATADG/jyrac/datafile/sales_test_01.dbf  9       Full 14690299647966 29-DEC-17 +DATADG/jyrac/datafile/emp_test_01.dbf  10      Full 14690299647966 29-DEC-17 +DATADG/jyrac/datafile/orders_test_01.dbf  11      Full 14690299647966 29-DEC-17 +DATADG/jyrac/datafile/cdzj01  12      Full 14690299647966 29-DEC-17 +DATADG/jyrac/datafile/ldjc01BS Key  Size       Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------11      92.50K     DISK        00:00:01     29-DEC-17              BP Key: 11   Status: AVAILABLE  Compressed: YES  Tag: TAG20171229T113845        Piece Name: /acfs1/rman_back/arch_JYRAC_20171229_0ksnb4q5_1_1  List of Archived Logs in backup set 11  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time  ---- ------- ---------- --------- ---------- ---------  1    498     14690299647943 29-DEC-17 14690299648779 29-DEC-17  2    541     14690299647960 29-DEC-17 14690299648994 29-DEC-17BS Key  Type LV Size       Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------12      Full    17.89M     DISK        00:00:08     29-DEC-17              BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: TAG20171229T113847        Piece Name: /acfs1/rman_back/c-2655496871-20171229-00  SPFILE Included: Modification time: 29-DEC-17  SPFILE db_unique_name: JYRAC  Control File Included: Ckp SCN: 14690299650469   Ckp time: 29-DEC-17[grid@jyrac1 rman_back]$ ls -lrttotal 1929424-rw-r----- 1 oracle asmadmin      25600 Dec 29 11:29 arch_JYRAC_20171229_0isnb48r_1_1-rw-r----- 1 oracle asmadmin 1951571968 Dec 29 11:38 jyrac_0jsnb48u_JYRAC_964006174_19_1-rw-r----- 1 oracle asmadmin      95232 Dec 29 11:38 arch_JYRAC_20171229_0ksnb4q5_1_1-rw-r----- 1 oracle asmadmin   18776064 Dec 29 11:38 c-2655496871-20171229-00

3.将步骤2生成的RMAN备份文件拷贝到目标主机相应目录(/ora_xtts/rman)中

[oracle@jytest3 rman]$ scp oracle@10.138.130.151:/acfs1/rman_back/* /ora_xtts/rman/The authenticity of host '10.138.130.151 (10.138.130.151)' can't be established.RSA key fingerprint is 92:b7:e1:f5:a4:99:5a:de:d5:d3:f2:25:f7:98:0a:a1.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added '10.138.130.151' (RSA) to the list of known hosts.oracle@10.138.130.151's password: arch_JYRAC_20171229_0isnb48r_1_1                                                                                                                                                                          100%   25KB  25.0KB/s   00:00    arch_JYRAC_20171229_0ksnb4q5_1_1                                                                                                                                                                          100%   93KB  93.0KB/s   00:00    c-2655496871-20171229-00                                                                                                                                                                                  100%   18MB  17.9MB/s   00:01    jyrac_0jsnb48u_JYRAC_964006174_19_1                                                                                                                                                                       100% 1861MB  38.0MB/s   00:49    [oracle@jytest3 rman]$ ls -lrttotal 1924300-rw-r-----. 1 oracle oinstall      25600 Dec 30 01:48 arch_JYRAC_20171229_0isnb48r_1_1-rw-r-----. 1 oracle oinstall      95232 Dec 30 01:48 arch_JYRAC_20171229_0ksnb4q5_1_1-rw-r-----. 1 oracle oinstall   18776064 Dec 30 01:48 c-2655496871-20171229-00-rw-r-----. 1 oracle oinstall 1951571968 Dec 30 01:49 jyrac_0jsnb48u_JYRAC_964006174_19_1

4.在目标主机上，设置ORACLE_SID为源数据库的SID(jyrac1为单实例数据库)

[oracle@jytest3 ~]$ export ORACLE_SID=jyrac1

5.在目标主机上启动RMAN并连接到目标数据库

[oracle@jytest3 ~]$ rman target/ nocatalogRecovery Manager: Release 12.2.0.1.0 - Production on Sat Dec 30 02:06:59 2017Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.connected to target database (not started)

6.设置DBID，该值为源数据库的DBID

RMAN> set DBID 2655496871executing command: SET DBID

7.启动目标数据库到nomount状态

RMAN> startup nomountstartup failed: ORA-01078: failure in processing system parametersLRM-00109: could not open parameter file '/u01/app/oracle/product/12.2.0/db/dbs/initjyrac1.ora'starting Oracle instance without parameter file for retrieval of spfileOracle instance startedTotal System Global Area    1073741824 bytesFixed Size                     8628936 bytesVariable Size                293602616 bytesDatabase Buffers             763363328 bytesRedo Buffers                   8146944 bytes

RMAN查找spfile参数文件失败，因为它还没有被还原，然而，实例将会使用虚拟参数文件来进行启动。

8.从源数据库的自动备份文件中还原spfile参数文件
因为源数据库启用了控制文件自动备份，所以spfile参数文件会被包含在自动备份文件中。为了还原非缺省格式的自动备份，需要执行set controlfile autobackup format命令来指定格式。下面的命令将设置控制文件自动备份格式，将源数据库的spfile参数文件还原为/u01/app/oracle/product/12.2.0/db/dbs/initjyrac1.ora文件，然后关闭目标数据库。

RMAN> run2> {3> set controlfile autobackup format for device type disk to '/ora_xtts/rman/%F';4> restore spfile to pfile '/u01/app/oracle/product/12.2.0/db/dbs/initjyrac1.ora' from autobackup;5> shutdown abort;6> }executing command: SET CONTROLFILE AUTOBACKUP FORMATStarting restore at 30-DEC-17allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=6 device type=DISKchannel ORA_DISK_1: looking for AUTOBACKUP on day: 20171230channel ORA_DISK_1: looking for AUTOBACKUP on day: 20171229channel ORA_DISK_1: AUTOBACKUP found: /ora_xtts/rman/c-2655496871-20171229-00channel ORA_DISK_1: restoring spfile from AUTOBACKUP /ora_xtts/rman/c-2655496871-20171229-00channel ORA_DISK_1: SPFILE restore from AUTOBACKUP completeFinished restore at 30-DEC-17Oracle instance shut down

9.编辑pfile参数文件并修改所需要的参数。这包括compatible参数，如果目标数据库的compatible参数不同于源数据库的设置，那么在目标数据库版本中这个参数会被弃用。更新以_DEST结尾的参数来反映新的目录结构。

[oracle@jytest3 dbs]$ mv initjyrac1.ora initjyrac1.ora.bak[oracle@jytest3 dbs]$ vi initjyrac1.ora*.audit_file_dest='/u01/app/oracle/admin/jyrac/adump'*.audit_trail='db'*.cluster_database=false*.compatible='11.2.0.4.0'*.control_files='+DATA/jyrac/controlfile/current.257.930412709'*.db_block_size=8192*.db_create_file_dest='+DATA'*.db_domain=''*.db_name='jyrac'*.diagnostic_dest='/u01/app/oracle'*.dispatchers='(PROTOCOL=TCP) (SERVICE=jyracXDB)'jyrac1.dispatchers='(PROTOCOL=TCP) (SERVICE=jyrac1XDB)'jyrac1.instance_number=1*.job_queue_processes=1000*.log_archive_dest_1='location=+data/arch/jyrac'*.open_cursors=300*.pga_aggregate_target=836763648*.processes=150*.remote_login_passwordfile='exclusive'*.sga_target=2510290944jyrac2.thread=2jyrac1.thread=1jyrac1.undo_tablespace='UNDOTBS1'jyrac2.undo_tablespace='UNDOTBS2'

10.使用编辑后的pfile参数文件来启动实例到nomount状态

RMAN> startup force nomount pfile='/u01/app/oracle/product/12.2.0/db/dbs/initjyrac1.ora'Oracle instance startedTotal System Global Area    2516582400 bytesFixed Size                     8623832 bytesVariable Size                637536552 bytesDatabase Buffers            1862270976 bytesRedo Buffers                   8151040 bytes

11.从控制文件自动备份文件中还原控制文件并将目标数据库启动到mount状态,为了还原非缺省格式的自动备份，需要执行set controlfile autobackup format命令来指定格式。

RMAN> run2> {3> set controlfile autobackup format for device type disk to '/ora_xtts/rman/%F';4> restore controlfile from autobackup;5> alter database mount;6> }executing command: SET CONTROLFILE AUTOBACKUP FORMATStarting restore at 30-DEC-17allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=6 device type=DISKchannel ORA_DISK_1: looking for AUTOBACKUP on day: 20171230channel ORA_DISK_1: looking for AUTOBACKUP on day: 20171229channel ORA_DISK_1: AUTOBACKUP found: /ora_xtts/rman/c-2655496871-20171229-00channel ORA_DISK_1: restoring control file from AUTOBACKUP /ora_xtts/rman/c-2655496871-20171229-00channel ORA_DISK_1: control file restore from AUTOBACKUP completeoutput file name=+DATA/JYRAC/CONTROLFILE/current.329.964063767Finished restore at 30-DEC-17Statement processedreleased channel: ORA_DISK_1

控制文件会被还原到pfile参数文件中control_files参数所指定的目录中。

12.在目标主机上将源数据库的备份文件注册到rman档案库中。如果目录中的所有文件有共同的前缀，那么可以使用catalog start with命令。如果想要单独指定文件名来进行注册，那么执行catalog datafilecopy命令。我这里所有的备份文件存储在/ora_xtts/rman目录中，因此使用catalog start with命令进行注册。

RMAN> catalog start with '/ora_xtts/rman/';searching for all files that match the pattern /ora_xtts/rman/List of Files Unknown to the Database=====================================File Name: /ora_xtts/rman/arch_JYRAC_20171229_0isnb48r_1_1File Name: /ora_xtts/rman/arch_JYRAC_20171229_0ksnb4q5_1_1File Name: /ora_xtts/rman/c-2655496871-20171229-00File Name: /ora_xtts/rman/jyrac_0jsnb48u_JYRAC_964006174_19_1Do you really want to catalog the above files (enter YES or NO)? YEScataloging files...cataloging doneList of Cataloged Files=======================File Name: /ora_xtts/rman/arch_JYRAC_20171229_0isnb48r_1_1File Name: /ora_xtts/rman/arch_JYRAC_20171229_0ksnb4q5_1_1File Name: /ora_xtts/rman/c-2655496871-20171229-00File Name: /ora_xtts/rman/jyrac_0jsnb48u_JYRAC_964006174_19_1

13.还原与恢复源数据库
如果数据文件要被还原到目标主机上的目录与源数据库所在的目录不相同，那么必须使用set newname命令来对还原的数据文件指定新的目录路径。如果联机重做日志将创建在与源数据库不相同的目录中，那么必须使用alter database rename file命令来为每个联机重做日志指定新的目录路径，在这里使用set newname for database命令来为所有被还原的数据文件指定新目录，新的联机重做日志文件使用alter database rename file命令来指定，并且指定恢复目标scn。

RMAN> run2> {3> set newname for database to '+data/jyrac/datafile/%U';4> alter database rename file '+DATADG/jyrac/onlinelog/group_1.264.930413221' to '+data/jyrac/onlinelog/redo1.log';5> alter database rename file '+DATADG/jyrac/onlinelog/group_2.265.930413225' to '+data/jyrac/onlinelog/redo2.log';6> alter database rename file '+DATADG/jyrac/onlinelog/group_3.266.930413227' to '+data/jyrac/onlinelog/redo3.log';7> alter database rename file '+DATADG/jyrac/onlinelog/group_4.267.930413231' to '+data/jyrac/onlinelog/redo4.log';8> set until scn 14690299648200;9> restore database;10> switch datafile all;11> recover database;12> }executing command: SET NEWNAMEStatement processedStatement processedStatement processedStatement processedexecuting command: SET until clauseStarting restore at 30-DEC-17allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=93 device type=DISKchannel ORA_DISK_1: starting datafile backup set restorechannel ORA_DISK_1: specifying datafile(s) to restore from backup setchannel ORA_DISK_1: restoring datafile 00001 to +data/jyrac/datafile/data_D-JYRAC_TS-SYSTEM_FNO-1channel ORA_DISK_1: restoring datafile 00002 to +data/jyrac/datafile/data_D-JYRAC_TS-SYSAUX_FNO-2channel ORA_DISK_1: restoring datafile 00003 to +data/jyrac/datafile/data_D-JYRAC_TS-UNDOTBS1_FNO-3channel ORA_DISK_1: restoring datafile 00004 to +data/jyrac/datafile/data_D-JYRAC_TS-USERS_FNO-4channel ORA_DISK_1: restoring datafile 00005 to +data/jyrac/datafile/data_D-JYRAC_TS-EXAMPLE_FNO-5channel ORA_DISK_1: restoring datafile 00006 to +data/jyrac/datafile/data_D-JYRAC_TS-UNDOTBS2_FNO-6channel ORA_DISK_1: restoring datafile 00007 to +data/jyrac/datafile/data_D-JYRAC_TS-TEST_FNO-7channel ORA_DISK_1: restoring datafile 00008 to +data/jyrac/datafile/data_D-JYRAC_TS-SALES_TEST_FNO-8channel ORA_DISK_1: restoring datafile 00009 to +data/jyrac/datafile/data_D-JYRAC_TS-EMP_TEST_FNO-9channel ORA_DISK_1: restoring datafile 00010 to +data/jyrac/datafile/data_D-JYRAC_TS-ORDERS_TEST_FNO-10channel ORA_DISK_1: restoring datafile 00011 to +data/jyrac/datafile/data_D-JYRAC_TS-CDZJ_FNO-11channel ORA_DISK_1: restoring datafile 00012 to +data/jyrac/datafile/data_D-JYRAC_TS-LDJC_FNO-12channel ORA_DISK_1: reading from backup piece /acfs1/rman_back/jyrac_0jsnb48u_JYRAC_964006174_19_1channel ORA_DISK_1: errors found reading piece handle=/acfs1/rman_back/jyrac_0jsnb48u_JYRAC_964006174_19_1channel ORA_DISK_1: failover to piece handle=/ora_xtts/rman/jyrac_0jsnb48u_JYRAC_964006174_19_1 tag=TAG20171229T112933channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:09:55Finished restore at 30-DEC-17datafile 1 switched to datafile copyinput datafile copy RECID=14 STAMP=964064400 file name=+DATA/jyrac/datafile/data_d-jyrac_ts-system_fno-1datafile 2 switched to datafile copyinput datafile copy RECID=15 STAMP=964064401 file name=+DATA/jyrac/datafile/data_d-jyrac_ts-sysaux_fno-2datafile 3 switched to datafile copyinput datafile copy RECID=16 STAMP=964064401 file name=+DATA/jyrac/datafile/data_d-jyrac_ts-undotbs1_fno-3datafile 4 switched to datafile copyinput datafile copy RECID=17 STAMP=964064401 file name=+DATA/jyrac/datafile/data_d-jyrac_ts-users_fno-4datafile 5 switched to datafile copyinput datafile copy RECID=18 STAMP=964064402 file name=+DATA/jyrac/datafile/data_d-jyrac_ts-example_fno-5datafile 6 switched to datafile copyinput datafile copy RECID=19 STAMP=964064402 file name=+DATA/jyrac/datafile/data_d-jyrac_ts-undotbs2_fno-6datafile 7 switched to datafile copyinput datafile copy RECID=20 STAMP=964064402 file name=+DATA/jyrac/datafile/data_d-jyrac_ts-test_fno-7datafile 8 switched to datafile copyinput datafile copy RECID=21 STAMP=964064403 file name=+DATA/jyrac/datafile/data_d-jyrac_ts-sales_test_fno-8datafile 9 switched to datafile copyinput datafile copy RECID=22 STAMP=964064403 file name=+DATA/jyrac/datafile/data_d-jyrac_ts-emp_test_fno-9datafile 10 switched to datafile copyinput datafile copy RECID=23 STAMP=964064403 file name=+DATA/jyrac/datafile/data_d-jyrac_ts-orders_test_fno-10datafile 11 switched to datafile copyinput datafile copy RECID=24 STAMP=964064404 file name=+DATA/jyrac/datafile/data_d-jyrac_ts-cdzj_fno-11datafile 12 switched to datafile copyinput datafile copy RECID=25 STAMP=964064404 file name=+DATA/jyrac/datafile/data_d-jyrac_ts-ldjc_fno-12Starting recover at 30-DEC-17using channel ORA_DISK_1starting media recoverychannel ORA_DISK_1: starting archived log restore to default destinationchannel ORA_DISK_1: restoring archived logarchived log thread=1 sequence=498channel ORA_DISK_1: restoring archived logarchived log thread=2 sequence=541channel ORA_DISK_1: reading from backup piece /acfs1/rman_back/arch_JYRAC_20171229_0ksnb4q5_1_1channel ORA_DISK_1: errors found reading piece handle=/acfs1/rman_back/arch_JYRAC_20171229_0ksnb4q5_1_1channel ORA_DISK_1: failover to piece handle=/ora_xtts/rman/arch_JYRAC_20171229_0ksnb4q5_1_1 tag=TAG20171229T113845channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:00:01archived log file name=+DATA/arch/jyrac/1_498_930413221.dbf thread=1 sequence=498archived log file name=+DATA/arch/jyrac/2_541_930413221.dbf thread=2 sequence=541media recovery complete, elapsed time: 00:00:02Finished recover at 30-DEC-17

14.使用resetlogs与upgrade选项来打开数据库

RMAN> alter database open resetlogs upgrade;Statement processedRMAN-06900: warning: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT rowRMAN-06901: warning: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rowsORACLE error from target database: ORA-04023: Object SYS.STANDARD could not be validated or authorized

错误信息是由于数据库相关plsql包作为升级处理需要被重新验证。

15.退出RMAN

RMAN> exitRecovery Manager complete.

16.对还原后的目标数据库升级

SQL> shutdown abortORACLE instance shut down.SQL> startup upgradeORACLE instance started.Total System Global Area 2516582400 bytesFixed Size                  8623832 bytesVariable Size             637536552 bytesDatabase Buffers         1862270976 bytesRedo Buffers                8151040 bytesDatabase mounted.Database opened.SQL> @$ORACLE_HOME/rdbms/admin/catupgrd.sqlDOC>######################################################################DOC>######################################################################DOC>                                 ERRORDOC>DOC>DOC>    As of 12.2, customers must use the parallel upgrade utility, catctl.pl,DOC>    to invoke catupgrd.sql when upgrading the database dictionary.DOC>    Running catupgrd.sql directly from SQL*Plus is no longer supported.DOC>DOC>    For Example:DOC>DOC>          cd $ORACLE_HOME/rdbms/adminDOC>          catctlDOC>DOC>          orDOC>DOC>          cd $ORACLE_HOME/rdbms/adminDOC>          $ORACLE_HOME/perl/bin/perl catctl.pl catupgrd.sqlDOC>DOC>    Refer to the Oracle Database Upgrade Guide for more information.DOC>DOC>DOC>######################################################################DOC>######################################################################DOC>#Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

12cr2升级方法与之前不同，要执行如下命令:

[oracle@jytest3 admin]$ cd $ORACLE_HOME/rdbms/admin[oracle@jytest3 admin]$ $ORACLE_HOME/perl/bin/perl catctl.pl catupgrd.sqlArgument list for [catctl.pl]Run in                c = 0Do not run in         C = 0Input Directory       d = 0Echo OFF              e = 1Simulate              E = 0Forced cleanup        F = 0Log Id                i = 0Child Process         I = 0Log Dir               l = 0Priority List Name    L = 0Upgrade Mode active   M = 0SQL Process Count     n = 0SQL PDB Process Count N = 0Open Mode Normal      o = 0Start Phase           p = 0End Phase             P = 0Reverse Order         r = 0AutoUpgrade Resume    R = 0Script                s = 0Serial Run            S = 0RO User Tablespaces   T = 0Display Phases        y = 0Debug catcon.pm       z = 0Debug catctl.pl       Z = 0catctl.pl VERSION: [12.2.0.1.0]           STATUS: [production]            BUILD: [RDBMS_12.2.0.1.0_LINUX.X64_170125]/u01/app/oracle/product/12.2.0/db/rdbms/admin/orahome = [/u01/app/oracle/product/12.2.0/db]/u01/app/oracle/product/12.2.0/db/bin/orabasehome = [/u01/app/oracle/product/12.2.0/db]catctlGetOrabase = [/u01/app/oracle/product/12.2.0/db]Analyzing file /u01/app/oracle/product/12.2.0/db/rdbms/admin/catupgrd.sqlLog file directory = [/tmp/cfgtoollogs/upgrade20171230035616]catcon: ALL catcon-related output will be written to [/tmp/cfgtoollogs/upgrade20171230035616/catupgrd_catcon_11460.lst]catcon: See [/tmp/cfgtoollogs/upgrade20171230035616/catupgrd*.log] files for output generated by scriptscatcon: See [/tmp/cfgtoollogs/upgrade20171230035616/catupgrd_*.lst] files for spool files, if anyNumber of Cpus        = 6Database Name         = jyracDataBase Version      = 11.2.0.4.0catcon: ALL catcon-related output will be written to [/u01/app/oracle/product/12.2.0/db/cfgtoollogs/jyrac/upgrade20171230035617/catupgrd_catcon_11460.lst]catcon: See [/u01/app/oracle/product/12.2.0/db/cfgtoollogs/jyrac/upgrade20171230035617/catupgrd*.log] files for output generated by scriptscatcon: See [/u01/app/oracle/product/12.2.0/db/cfgtoollogs/jyrac/upgrade20171230035617/catupgrd_*.lst] files for spool files, if anyLog file directory = [/u01/app/oracle/product/12.2.0/db/cfgtoollogs/jyrac/upgrade20171230035617]Parallel SQL Process Count            = 4Components in [jyrac]    Installed [APEX APS CATALOG CATJAVA CATPROC CONTEXT EM JAVAVM ORDIM OWM RAC SDO XDB XML XOQ]Not Installed [DV MGW ODM OLS WK]....省略....