共计 21274 个字符，预计需要花费 54 分钟才能阅读完成。
可以还原使用旧版本 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-17
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=497 RECID=1044 STAMP=964006170
input archived log thread=2 sequence=540 RECID=1045 STAMP=964006171
channel ORA_DISK_1: starting piece 1 at 29-DEC-17
channel ORA_DISK_1: finished piece 1 at 29-DEC-17
piece handle=/acfs1/rman_back/arch_JYRAC_20171229_0isnb48r_1_1 tag=TAG20171229T112931 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 29-DEC-17
Starting backup at 29-DEC-17
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00012 name=+DATADG/jyrac/datafile/ldjc01
input datafile file number=00002 name=+DATADG/jyrac/datafile/sysaux.258.930413055
input datafile file number=00011 name=+DATADG/jyrac/datafile/cdzj01
input datafile file number=00001 name=+DATADG/jyrac/datafile/system.259.930413057
input datafile file number=00003 name=+DATADG/jyrac/datafile/undotbs1.262.930413057
input datafile file number=00008 name=+DATADG/jyrac/datafile/sales_test_01.dbf
input datafile file number=00005 name=+DATADG/jyrac/datafile/example.260.930413057
input datafile file number=00006 name=+DATADG/jyrac/datafile/undotbs2.261.930413057
input datafile file number=00007 name=+DATADG/jyrac/datafile/test01.dbf
input datafile file number=00009 name=+DATADG/jyrac/datafile/emp_test_01.dbf
input datafile file number=00010 name=+DATADG/jyrac/datafile/orders_test_01.dbf
input datafile file number=00004 name=+DATADG/jyrac/datafile/users.263.930413057
channel ORA_DISK_1: starting piece 1 at 29-DEC-17
channel ORA_DISK_1: finished piece 1 at 29-DEC-17
piece handle=/acfs1/rman_back/jyrac_0jsnb48u_JYRAC_964006174_19_1 tag=TAG20171229T112933 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:09:06
Finished backup at 29-DEC-17
Starting backup at 29-DEC-17
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=498 RECID=1046 STAMP=964006723
input archived log thread=2 sequence=541 RECID=1047 STAMP=964006720
channel ORA_DISK_1: starting piece 1 at 29-DEC-17
channel ORA_DISK_1: finished piece 1 at 29-DEC-17
piece handle=/acfs1/rman_back/arch_JYRAC_20171229_0ksnb4q5_1_1 tag=TAG20171229T113845 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 29-DEC-17
Starting Control File and SPFILE Autobackup at 29-DEC-17
piece handle=/acfs1/rman_back/c-2655496871-20171229-00 comment=NONE
Finished Control File and SPFILE Autobackup at 29-DEC-17
RMAN> 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-17
BS 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/ldjc01
BS 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-17
BS 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 -lrt
total 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)? yes
Warning: 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 -lrt
total 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/ nocatalog
Recovery Manager: Release 12.2.0.1.0 – Production on Sat Dec 30 02:06:59 2017
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
6. 设置 DBID，该值为源数据库的 DBID
RMAN> set DBID 2655496871
executing command: SET DBID
7. 启动目标数据库到 nomount 状态
RMAN> startup nomount
startup failed: ORA-01078: failure in processing system parameters
LRM-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 spfile
Oracle instance started
Total System Global Area 1073741824 bytes
Fixed Size 8628936 bytes
Variable Size 293602616 bytes
Database Buffers 763363328 bytes
Redo 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> run
2> {
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 FORMAT
Starting restore at 30-DEC-17
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=6 device type=DISK
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20171230
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20171229
channel ORA_DISK_1: AUTOBACKUP found: /ora_xtts/rman/c-2655496871-20171229-00
channel ORA_DISK_1: restoring spfile from AUTOBACKUP /ora_xtts/rman/c-2655496871-20171229-00
channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete
Finished restore at 30-DEC-17
Oracle 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=2510290944
jyrac2.thread=2
jyrac1.thread=1
jyrac1.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 started
Total System Global Area 2516582400 bytes
Fixed Size 8623832 bytes
Variable Size 637536552 bytes
Database Buffers 1862270976 bytes
Redo Buffers 8151040 bytes
11. 从控制文件自动备份文件中还原控制文件并将目标数据库启动到 mount 状态, 为了还原非缺省格式的自动备份，需要执行 set controlfile autobackup format 命令来指定格式。
RMAN> run
2> {
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 FORMAT
Starting restore at 30-DEC-17
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=6 device type=DISK
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20171230
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20171229
channel ORA_DISK_1: AUTOBACKUP found: /ora_xtts/rman/c-2655496871-20171229-00
channel ORA_DISK_1: restoring control file from AUTOBACKUP /ora_xtts/rman/c-2655496871-20171229-00
channel ORA_DISK_1: control file restore from AUTOBACKUP complete
output file name=+DATA/JYRAC/CONTROLFILE/current.329.964063767
Finished restore at 30-DEC-17
Statement processed
released 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_1
File Name: /ora_xtts/rman/arch_JYRAC_20171229_0ksnb4q5_1_1
File Name: /ora_xtts/rman/c-2655496871-20171229-00
File Name: /ora_xtts/rman/jyrac_0jsnb48u_JYRAC_964006174_19_1
Do you really want to catalog the above files (enter YES or NO)? YES
cataloging files…
cataloging done
List of Cataloged Files
=======================
File Name: /ora_xtts/rman/arch_JYRAC_20171229_0isnb48r_1_1
File Name: /ora_xtts/rman/arch_JYRAC_20171229_0ksnb4q5_1_1
File Name: /ora_xtts/rman/c-2655496871-20171229-00
File 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> run
2> {
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 NEWNAME
Statement processed
Statement processed
Statement processed
Statement processed
executing command: SET until clause
Starting restore at 30-DEC-17
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=93 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to +data/jyrac/datafile/data_D-JYRAC_TS-SYSTEM_FNO-1
channel ORA_DISK_1: restoring datafile 00002 to +data/jyrac/datafile/data_D-JYRAC_TS-SYSAUX_FNO-2
channel ORA_DISK_1: restoring datafile 00003 to +data/jyrac/datafile/data_D-JYRAC_TS-UNDOTBS1_FNO-3
channel ORA_DISK_1: restoring datafile 00004 to +data/jyrac/datafile/data_D-JYRAC_TS-USERS_FNO-4
channel ORA_DISK_1: restoring datafile 00005 to +data/jyrac/datafile/data_D-JYRAC_TS-EXAMPLE_FNO-5
channel ORA_DISK_1: restoring datafile 00006 to +data/jyrac/datafile/data_D-JYRAC_TS-UNDOTBS2_FNO-6
channel ORA_DISK_1: restoring datafile 00007 to +data/jyrac/datafile/data_D-JYRAC_TS-TEST_FNO-7
channel ORA_DISK_1: restoring datafile 00008 to +data/jyrac/datafile/data_D-JYRAC_TS-SALES_TEST_FNO-8
channel ORA_DISK_1: restoring datafile 00009 to +data/jyrac/datafile/data_D-JYRAC_TS-EMP_TEST_FNO-9
channel ORA_DISK_1: restoring datafile 00010 to +data/jyrac/datafile/data_D-JYRAC_TS-ORDERS_TEST_FNO-10
channel ORA_DISK_1: restoring datafile 00011 to +data/jyrac/datafile/data_D-JYRAC_TS-CDZJ_FNO-11
channel ORA_DISK_1: restoring datafile 00012 to +data/jyrac/datafile/data_D-JYRAC_TS-LDJC_FNO-12
channel ORA_DISK_1: reading from backup piece /acfs1/rman_back/jyrac_0jsnb48u_JYRAC_964006174_19_1
channel ORA_DISK_1: errors found reading piece handle=/acfs1/rman_back/jyrac_0jsnb48u_JYRAC_964006174_19_1
channel ORA_DISK_1: failover to piece handle=/ora_xtts/rman/jyrac_0jsnb48u_JYRAC_964006174_19_1 tag=TAG20171229T112933
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:09:55
Finished restore at 30-DEC-17
datafile 1 switched to datafile copy
input datafile copy RECID=14 STAMP=964064400 file name=+DATA/jyrac/datafile/data_d-jyrac_ts-system_fno-1
datafile 2 switched to datafile copy
input datafile copy RECID=15 STAMP=964064401 file name=+DATA/jyrac/datafile/data_d-jyrac_ts-sysaux_fno-2
datafile 3 switched to datafile copy
input datafile copy RECID=16 STAMP=964064401 file name=+DATA/jyrac/datafile/data_d-jyrac_ts-undotbs1_fno-3
datafile 4 switched to datafile copy
input datafile copy RECID=17 STAMP=964064401 file name=+DATA/jyrac/datafile/data_d-jyrac_ts-users_fno-4
datafile 5 switched to datafile copy
input datafile copy RECID=18 STAMP=964064402 file name=+DATA/jyrac/datafile/data_d-jyrac_ts-example_fno-5
datafile 6 switched to datafile copy
input datafile copy RECID=19 STAMP=964064402 file name=+DATA/jyrac/datafile/data_d-jyrac_ts-undotbs2_fno-6
datafile 7 switched to datafile copy
input datafile copy RECID=20 STAMP=964064402 file name=+DATA/jyrac/datafile/data_d-jyrac_ts-test_fno-7
datafile 8 switched to datafile copy
input datafile copy RECID=21 STAMP=964064403 file name=+DATA/jyrac/datafile/data_d-jyrac_ts-sales_test_fno-8
datafile 9 switched to datafile copy
input datafile copy RECID=22 STAMP=964064403 file name=+DATA/jyrac/datafile/data_d-jyrac_ts-emp_test_fno-9
datafile 10 switched to datafile copy
input datafile copy RECID=23 STAMP=964064403 file name=+DATA/jyrac/datafile/data_d-jyrac_ts-orders_test_fno-10
datafile 11 switched to datafile copy
input datafile copy RECID=24 STAMP=964064404 file name=+DATA/jyrac/datafile/data_d-jyrac_ts-cdzj_fno-11
datafile 12 switched to datafile copy
input datafile copy RECID=25 STAMP=964064404 file name=+DATA/jyrac/datafile/data_d-jyrac_ts-ldjc_fno-12
Starting recover at 30-DEC-17
using channel ORA_DISK_1
starting media recovery
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=498
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=541
channel ORA_DISK_1: reading from backup piece /acfs1/rman_back/arch_JYRAC_20171229_0ksnb4q5_1_1
channel ORA_DISK_1: errors found reading piece handle=/acfs1/rman_back/arch_JYRAC_20171229_0ksnb4q5_1_1
channel ORA_DISK_1: failover to piece handle=/ora_xtts/rman/arch_JYRAC_20171229_0ksnb4q5_1_1 tag=TAG20171229T113845
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=+DATA/arch/jyrac/1_498_930413221.dbf thread=1 sequence=498
archived log file name=+DATA/arch/jyrac/2_541_930413221.dbf thread=2 sequence=541
media recovery complete, elapsed time: 00:00:02
Finished recover at 30-DEC-17
14. 使用 resetlogs 与 upgrade 选项来打开数据库
RMAN> alter database open resetlogs upgrade;
Statement processed
RMAN-06900: warning: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row
RMAN-06901: warning: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows
ORACLE error from target database:
ORA-04023: Object SYS.STANDARD could not be validated or authorized
错误信息是由于数据库相关 plsql 包作为升级处理需要被重新验证。
15. 退出 RMAN
RMAN> exit
Recovery Manager complete.
16. 对还原后的目标数据库升级
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 2516582400 bytes
Fixed Size 8623832 bytes
Variable Size 637536552 bytes
Database Buffers 1862270976 bytes
Redo Buffers 8151040 bytes
Database mounted.
Database opened.
SQL> @$ORACLE_HOME/rdbms/admin/catupgrd.sql
DOC>######################################################################
DOC>######################################################################
DOC> ERROR
DOC>
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/admin
DOC> catctl
DOC>
DOC> or
DOC>
DOC> cd $ORACLE_HOME/rdbms/admin
DOC> $ORACLE_HOME/perl/bin/perl catctl.pl catupgrd.sql
DOC>
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.sql
Argument list for [catctl.pl]
Run in c = 0
Do not run in C = 0
Input Directory d = 0
Echo OFF e = 1
Simulate E = 0
Forced cleanup F = 0
Log Id i = 0
Child Process I = 0
Log Dir l = 0
Priority List Name L = 0
Upgrade Mode active M = 0
SQL Process Count n = 0
SQL PDB Process Count N = 0
Open Mode Normal o = 0
Start Phase p = 0
End Phase P = 0
Reverse Order r = 0
AutoUpgrade Resume R = 0
Script s = 0
Serial Run S = 0
RO User Tablespaces T = 0
Display Phases y = 0
Debug catcon.pm z = 0
Debug catctl.pl Z = 0
catctl.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.sql
Log 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 scripts
catcon: See [/tmp/cfgtoollogs/upgrade20171230035616/catupgrd_*.lst] files for spool files, if any
Number of Cpus = 6
Database Name = jyrac
DataBase Version = 11.2.0.4.0
catcon: 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 scripts
catcon: See [/u01/app/oracle/product/12.2.0/db/cfgtoollogs/jyrac/upgrade20171230035617/catupgrd_*.lst] files for spool files, if any
Log file directory = [/u01/app/oracle/product/12.2.0/db/cfgtoollogs/jyrac/upgrade20171230035617]
Parallel SQL Process Count = 4
Components 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]
…. 省略 ….
更多 Oracle 相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12
本文永久更新链接地址：http://www.linuxidc.com/Linux/2018-01/15030.htm
