某政府部门ORACLE数据库系统数据迁移实施报告

由天下分享时间：2024/6/30 0:32:32 加入收藏我要投稿点赞

~专业好文档为您搜集整理~谢谢使用~

set newname for datafile 84 to '/database2/9i/oradata/orcl1/ntiis_index_12_3.ora';

set newname for datafile 85 to '/database2/9i/oradata/orcl1/P_NEW_DATA4.ora'; set newname for datafile 86 to '/database2/9i/oradata/orcl1/ntiis_12_8.ora'; restore database; switch datafile all; release channel c1; release channel c2; release channel c3; release channel c4; release channel c5; release channel c6; release channel c7; release channel c8; }

alter database open; 服务器应该能够正常启动。 4. 创建临时表空间

alter database tempfile '/database1/temp01.dbf' drop; alter database tempfile '/database1/temp02.dbf' drop; alter database tempfile '/database1/orcl/ntiis_temp.ora' drop; alter database tempfile '/database1/orcl/ntiis_temp_12_1.ora' drop; alter database tempfile '/database1/orcl/IV_TEMP.ora' drop; ALTER

TABLESPACE

TEMP

ADD

TEMPFILE

~专业好文档为您搜集整理~谢谢使用~

'/database2/9i/oradata/orcl1/temp01.dbf' size 2047m;

ALTER

TABLESPACE

TEMP

ADD

TEMPFILE

'/database2/9i/oradata/orcl1/temp02.dbf' size 1000m;

ALTER

TABLESPACE

NTIIS_TEMP

ADD

TEMPFILE

'/database2/9i/oradata/orcl1/ntiis_temp.ora' size 1020m;

ALTER

TABLESPACE

NTIIS_TEMP_12

ADD

TEMPFILE

'/database2/9i/oradata/orcl1/ntiis_temp_12_1.ora' size 100m;

ALTER

TABLESPACE

IV_TEMP

ADD

TEMPFILE

'/database2/9i/oradata/orcl1/IV_TEMP.ora' size 500m;

alter database datafile '/database2/9i/oradata/orcl1/system01.dbf' resize 2048m;

3.2.4. 升级数据库至9.2.0.8

1. 升级数据库 cd /home/oracle/ startup nomount

alter system set \shutdown abort STARTUP MIGRATE SPOOL patch-9208.log @?/rdbms/admin/catpatch.sql SPOOL OFF

2. 检查升级是否成功

查看/home/oracle/patch-9208.log是否有错误。ORA- select comp_name,version,status from dba_registry;

~专业好文档为您搜集整理~谢谢使用~

@?/rdbms/admin/utlrp.sql

3. 升级成功后进行备份

mkdir -p /database2/before_upgrade10g startup mount; rman target / 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; backup

incremental level=0

format='/database2/before_upgrade10g/%U.bak' tag='before_upgrade10g' database

include current controlfile; release channel c1; release channel c2;

~专业好文档为您搜集整理~谢谢使用~

release channel c3; release channel c4; release channel c5; release channel c6; release channel c7; release channel c8; }

shutdown immediate

cp /database1/* /database2/before_upgrade10g

3.2.5. 升级数据库至10.2.0.5

1. 升级前的检查 su - oracle

cp /oracle/product/10.2.0/db_1/rdbms/admin/utlu102i.sql /database2

设置环境变量

export ORACLE_BASE=/database2/9i export ORACLE_HOME=$ORACLE_BASE/db_1 export PATH=$ORACLE_HOME/bin:$PATH export ORACLE_SID=orcl1

@/database2/utlu102i.sql 2. 创建sysaux表空间

~专业好文档为您搜集整理~谢谢使用~

CREATE TABLESPACE sysaux DATAFILE '/database2/9i/oradata/orcl1/sysaux.dbf' SIZE 500M REUSE

EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE; 3. 修改相关参数

alter system set session_max_open_files=20 scope=spfile;

###alter database datafile '/database2/9i/oradata/orcl1/system01.dbf' resize 2048m; 4. 查看connect权限

SELECT grantee FROM dba_role_privs WHERE granted_role = 'CONNECT' and grantee NOT IN (

'SYS', 'OUTLN', 'SYSTEM', 'CTXSYS', 'DBSNMP', 'LOGSTDBY_ADMINISTRATOR', 'ORDSYS',

'ORDPLUGINS', 'OEM_MONITOR', 'WKSYS', 'WKPROXY', 'WK_TEST', 'WKUSER', 'MDSYS', 'LBACSYS', 'DMSYS', 'WMSYS', 'OLAPDBA', 'OLAPSVR', 'OLAP_USER', 'OLAPSYS', 'EXFSYS', 'SYSMAN', 'MDDATA', 'SI_INFORMTN_SCHEMA', 'XDB', 'ODM'); SELECT

GRANTEE,PRIVILEGE

FROM

DBA_SYS_PRIVS

WHERE

GRANTEE='CONNECT'

5. 查看db link

~专业好文档为您搜集整理~谢谢使用~