民生证券rman升级迁移内控30数据库20160621(672)

方案目标
相同平台：Linux 10gR2数据库升级+迁移到11g R2 数据库中。

源端（生产端）
服务器：Linux 4.8
数据库：Oracle 10g R2 10205
数据量：1.5T
磁盘剩余空间：230G
目标端
服务器：linux 6.5 x64
数据库：Oracle 11g R2 11204
磁盘空间：5T
迁移时间记录
开始采用dblink和datapump方式，由于数据库中hsman中有几张表数据量太大，一直出现锁表现象，老是出现失败报错，后采用rman方式
Rman压缩备份5个小时 1.5T压缩成为209G
rman还原2个小时
数据升级11g 30分钟
迁移准备
移动硬盘：1块2T
网络：局域网
备份方式：rman
升级：10g升级11g
实施流程
源端：
1．升级脚本@?/rdbms/admin/utlu112i.sql 11g的脚本
2．开启归档；并启动到mount状态；
3．挂载移动硬盘mount /mnt /dev/sdb1
4．Rman备份vi rman.sh
export ORACLE_SID= msnkdb
rman target / log='/tmp/rman_full.log' append <<EOF
run
{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;
allocate channel c5 type disk;
allocate channel c6 type disk;
allocate channel c7 type disk;
allocate channel c8 type disk;
allocate channel c9 type disk;
allocate channel c10 type disk;
allocate channel c11 type disk;
allocate channel c12 type disk;
backup as compressed backupset filesperset 8 database format '/mnt/full_%d_%T_%s_%p';
backup current controlfile format '/mnt/ctl_%d_%T_%s_%p';
}
5．执行sh rman.sh &
6. 拷贝密码文件
目标端
1．参数文件添加参数*.compatible=10.2.0.5 启动数据库到nomount的状态
2．还原控制文件restore controlfile from '/mnt/ctl_MSNKDB_20160619_66_1'; 启动到mount状态；3．恢复数据文件sh rman_new.sh &
vi rman_new.sh
rman target / log='/tmp/rman_full.log' append <<EOF
run
{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;
allocate channel c5 type disk;
allocate channel c6 type disk;
allocate channel c7 type disk;
allocate channel c8 type disk;
allocate channel c9 type disk;
allocate channel c10 type disk;
allocate channel c11 type disk;
allocate channel c12 type disk;
allocate channel c13 type disk;
allocate channel c14 type disk;
allocate channel c15 type disk;
allocate channel c16 type disk;
allocate channel c17 type disk;
allocate channel c18 type disk;
restore database;
recover database;
}
EOF
4．清除redo日志
alter database clear unarchived logfile group 1 ;
alter database clear unarchived logfile group 2 ;
alter database clear unarchived logfile group 3 ;
alter database clear unarchived logfile group 4 ;
alter database clear unarchived logfile group 5 ;
alter database clear unarchived logfile group 6 ;
alter database clear unarchived logfile group 7 ;
alter database clear unarchived logfile group 8 ;
5．升级模式打开数据库
alter database open upgrade;
6．升级数据库
SPOOL upgrade.log
@?/rdbms/admin/catupgrd.sql
STARTUP
@?/rdbms/admin/utlu112s.sql
@?/rdbms/admin/catuppst.sql
@?/rdbms/admin/utlrp.sql
SQL> SELECT count(*) FROM dba_invalid_objects;
SQL> SELECT distinct object_name FROM dba_invalid_objects;
后续记录
1.更改新服务器物理IP地址
2.统计信息收集exec dbms_stats.gather_schema_stats(ownname=>'HSMAN',force=>true);
3.临时表空间添加
alter TEMPORARY tablespace TEMP
add datafile'/u01/app/oracle/oradata/msnkdb/temp05.dbf'size16G
autoextend on;
问题记录
1.数据文件创建不规则恢复报错
创建数据文件, 文件号= 206 名称= /u01/app/oracle/product/10.2.0/db/dbs/raw_data01.dbf
RMAN-03002: restore 命令(在06/18/2016 17:47:27 上) 失败
ORA-01119: 创建数据库文件'/u01/app/oracle/product/10.2.0/db/dbs/raw_data01.dbf' 时出错
ORA-27040: 文件创建错误, 无法创建文件
Linux-x86_64 Error: 2: No such file or directory Additional information: 1
RMAN-06956:
创建数据文件失败; 请在从操作系统中删除/u01/app/oracle/product/10.2.0/db/dbs/raw_data01.dbf 后重试2.10g生产库备份之前必须打11g的utlu112i.sql脚本，否则还原后，升级无法完成；。