n_name: backup set complete, elapsed time: 00:01:25
channel chan_name: starting full datafile backup set
channel chan_name: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel chan_name: starting piece 1 at 20-NOV-14
channel chan_name: finished piece 1 at 20-NOV-14
piece handle=/DBBackup/Phycal/WOO0bpo2atp_1_1.bak tag=BEFORE_UPGRADE comment=NONE
channel chan_name: backup set complete, elapsed time: 00:00:01
Finished backup at 20-NOV-14
Starting backup at 20-NOV-14
channel chan_name: starting full datafile backup set
channel chan_name: specifying datafile(s) in backup set
including current control file in backup set
channel chan_name: starting piece 1 at 20-NOV-14
channel chan_name: finished piece 1 at 20-NOV-14
piece handle=/DBSoft/fast_recovery_area/WOO/backupset/2014_11_20/o1_mf_ncnnf_TAG20141120T044237_b6t05y5x_.bkp tag=TAG20141120T044237 comment=NONE
channel chan_name: backup set complete, elapsed time: 00:00:01
Finished backup at 20-NOV-14
released channel: chan_name
RMAN> list backupset;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
9 Full 1.20G DISK 00:01:24 20-NOV-14
BP Key: 9 Status: AVAILABLE Compressed: NO Tag: BEFORE_UPGRADE
Piece Name: /DBBackup/Phycal/WOO0apo2ar4_1_1.bak
List of Datafiles in backup set 9
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 3242521 20-NOV-14 /DBData/woo/woo/system01.dbf
2 Full 3242521 20-NOV-14 /DBData/woo/woo/sysaux01.dbf
3 Full 3242521 20-NOV-14 /DBData/woo/woo/undotbs01.dbf
4 Full 3242521 20-NOV-14 /DBData/woo/woo/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
10 Full 9.64M DISK 00:00:02 20-NOV-14
BP Key: 10 Status: AVAILABLE Compressed: NO Tag: BEFORE_UPGRADE
Piece Name: /DBBackup/Phycal/WOO0bpo2atp_1_1.bak
SPFILE Included: Modification time: 12-NOV-14
SPFILE db_unique_name: WOO
Control File Included: Ckp SCN: 3242657 Ckp time: 20-NOV-14
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11 Full 9.61M DISK 00:00:01 20-NOV-14
BP Key: 11 Status: AVAILABLE Compressed: NO Tag: TAG20141120T044237
Piece Name: /DBSoft/fast_recovery_area/WOO/backupset/2014_11_20/o1_mf_ncnnf_TAG20141120T044237_b6t05y5x_.bkp
Control File Included: Ckp SCN: 3242671 Ckp time: 20-NOV-14
四、执行预升级脚本:
4.1 根据Metalink ID:1503653 step 3中提到的到Metalink ID:556610.1下载预升级脚本preupgrd.sql检查是否满足升级条件。
[oracle@db01 ~]$ sqlplus / as sysdba @preupgrd.sql
SQL*Plus: Release 11.2.0.4.0 Production on Thu Nov 20 05:18:26 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Loading Pre-Upgrade Package...
Executing Pre-Upgrade Checks...
Pre-Upgrade Checks Complete.
************************************************************
Results of the checks are located at:
/DBSoft/cfgtoollogs/woo/preupgrade/preupgrade.log
Pre-Upgrade Fixup Script (run in source database environment):
/DBSoft/cfgtoollogs