实战：Oracle10.2.0.4异机迁移并升级到Oracle11.2.0.4 - 数据库编程

rcl/system01.dbf. Elapsed time: 0:04:38 checkpoint is 645792 last deallocation scn is 637323 Thu Dec 11 17:36:53 2014 db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup. RMAN> recover database; Starting recover at 11-DEC-14 using channel ORA_DISK_1 starting media recovery unable to find archived log archived log thread=1 sequence=4 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 12/11/2014 17:38:01 RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 4 and starting SCN of 645792

====需要指定具体的序列号，同时把源库的归档备份注册进来。

RMAN> CATALOG BACKUPPIECE '/home/oracle/bak/03pq0dg5_1_1';

cataloged backup piece
backup piece handle=/home/oracle/bak/03pq0dg5_1_1 RECID=2 STAMP=866051762

RMAN> run {
set until scn 645792;
recover database;
}2> 3> 4>

executing command: SET until clause

Starting recover at 11-DEC-14
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:02

Finished recover at 11-DEC-14

RMAN>

RMAN>

RMAN>

===如果有数据库连的话，要提前生成SQL语句，恢复完成后，在新库上重建一下。

SELECT
'create '||DECODE(U.NAME,'PUBLIC','public ')||'database link '||CHR(10)
||DECODE(U.NAME,'PUBLIC',Null, U.NAME||'.')|| L.NAME||chr(10)
||'connect to ' || L.USERID || ' identified by '''
||L.PASSWORD||''' using ''' || L.host || ''''
||chr(10)||';' TEXT
FROM sys.link$ L,
sys.user$ U
WHERE L.OWNER# = U.USER# ;

####升级

SQL> alter database open resetlogs upgrade;

Database altered.

SQL>
SQL> spool upgrade.log
SQL> @catupgrd.sql

=====这个时间比较长，需要耐心等待

#### 完成后

SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP
运行以下检查再次进行检查
SQL> @$ORACLE_HOME/rdbms/admin/utlu112s.sql
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql

####下面是相关DST版本

SQL> l
1 SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
2 FROM DATABASE_PROPERTIES
3 WHERE PROPERTY_NAME LIKE 'DST_%'
4* ORDER BY PROPERTY_NAME
SQL> /

PROPERTY_NAME VALUE
------------------------------ ------------------------------------------------------------
DST_PRIMARY_TT_VERSION 4
DST_SECONDARY_TT_VERSION 0
DST_UPGRADE_STATE NONE

####具体升级DST，可以分手工和自动，我是通过自动方式升级的，请参考以下文档。
Updating the RDBMS DST version in 11g Release 2 (11.2.0.1 and up) using DBMS_DST (Doc ID 977512.1)

下面是相关日志：

[oracle@ora11 ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 12 11:38:12 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

SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME LIKE 'DST_%'
ORDER BY PROPERTY_NAME; 2 3 4

PROPERTY_NAME
------------------------------
VALUE
--------------------------------------

实战：Oracle10.2.0.4异机迁移并升级到Oracle11.2.0.4(八)