单实例迁移rac.txt资料文档下载

单实例迁移rac.txt资料文档下载

《单实例迁移rac.txt资料文档下载》由会员分享，可在线阅读，更多相关《单实例迁移rac.txt资料文档下载（6页珍藏版）》请在冰豆网上搜索。

orderbyowner

selectcount（*）fromdba_objectswherestatus='

4��ȡ���鵵

startupmount

alterdatabasenoarchivelog

��ʵ��ת��RAC

5���������ļ�Ǩ�Ƶ�����洢��Ŀ¼

Ϊ/oracle/oradata

6������dumpĿ¼

mkdir-p/u01/oracle/db/admin/orcl

mkdirbdumpcdumpcreatepfileudump

7������initorcl�ļ���listener��tns�ļ�

8���ؽ������ļ�

alterdatabasebackupcontrolfiletotrace;

�༭���ļ�

STARTUPNOMOUNT

CREATECONTROLFILEREUSEDATABASE"

ORCL"

NORESETLOGSNOARCHIVELOG

MAXLOGFILES16

MAXLOGMEMBERS3

MAXDATAFILES100

MAXINSTANCES8

MAXLOGHISTORY2726

LOGFILE

GROUP1'

/oracle/oradata/orcl/redo01.log'

SIZE10M,

GROUP2'

/oracle/oradata/orcl/redo02.log'

GROUP3'

/oracle/oradata/orcl/redo03.log'

SIZE10M

--STANDBYLOGFILE

DATAFILE

'

/oracle/oradata/orcl/system01.dbf'

/oracle/oradata/orcl/ORCL/datafile/o1_mf_content__50zb3ksw_.dbf'

/oracle/oradata/orcl/sysaux01.dbf'

/oracle/oradata/orcl/users01.dbf'

/oracle/oradata/orcl/portal.dbf'

/oracle/oradata/orcl/ptldoc.dbf'

/oracle/oradata/orcl/ptlidx.dbf'

/oracle/oradata/orcl/ptllog.dbf'

/oracle/oradata/orcl/ias_meta01.dbf'

/oracle/oradata/orcl/discopltm1.dbf'

/oracle/oradata/orcl/discopltc1.dbf'

/oracle/oradata/orcl/dcm.dbf'

/oracle/oradata/orcl/oss_sys01.dbf'

/oracle/oradata/orcl/wcrsys01.dbf'

/oracle/oradata/orcl/b2b_rt.dbf'

/oracle/oradata/orcl/b2b_dt.dbf'

/oracle/oradata/orcl/b2b_idx.dbf'

/oracle/oradata/orcl/b2b_lob.dbf'

/oracle/oradata/orcl/orabpel.dbf'

/oracle/oradata/orcl/bam.dbf'

/oracle/oradata/orcl/oca.dbf'

/oracle/oradata/orcl/uddisys01.dbf'

/oracle/oradata/orcl/attrs1_oid.dbf'

/oracle/oradata/orcl/battrs1_oid.dbf'

/oracle/oradata/orcl/gcats1_oid.dbf'

/oracle/oradata/orcl/gdefault1_oid.dbf'

/oracle/oradata/orcl/svrmg1_oid.dbf'

/oracle/oradata/orcl/undotbs.dbf'

/oracle/oradata/orcl/ORCL/datafile/o1_mf_content__50zb3ln5_.dbf'

/oracle/oradata/orcl/ORCL/datafile/o1_mf_content__50zb3nvj_.dbf'

/oracle/oradata/orcl/ORCL/datafile/o1_mf_content__50zb3q89_.dbf'

/oracle/oradata/orcl/ORCL/datafile/o1_mf_content__50zb3qny_.dbf'

/oracle/oradata/orcl/ORCL/datafile/o1_mf_content__50zb3r2g_.dbf'

/oracle/oradata/orcl/ORCL/datafile/o1_mf_content__50zb3rj9_.dbf'

/oracle/oradata/orcl/ORCL/datafile/o1_mf_workflow_50zb3stz_.dbf'

/oracle/oradata/orcl/orabpel1.dbf'

/oracle/oradata/orcl/TURBOCMS.dbf'

/oracle/oradata/orcl/xzp.dbf'

/oracle/oradata/orcl/xzapps.dbf'

/oracle/oradata/orcl/xzworkflow.dbf'

/oracle/oradata/orcl/standard.dbf'

/oracle/oradata/orcl/exe.dbf'

CHARACTERSETAL32UTF8

;

RECOVERDATABASE

ALTERDATABASEOPEN;

ALTERTABLESPACETEMPADDTEMPFILE'

/oracle/oradata/orcl/temp01.dbf'

SIZE1607MREUSEAUTOEXTENDONNEXT655360MAXSIZE32767M;

9������rac����

����listener

netca

ѡ��Listenerconfiguration��

ѡ��NamingMethodsconfiguration��

ѡ��LocalNaming��

��֤�����״̬��

srvctlstatusnodeapps-nmhdb01

VIPisrunningonnode:

mhdb02

GSDisrunningonnode:

Listenerisrunningonnode:

ONSdaemonisrunningonnode:

����tns

LISTENERS_ORCL=

（ADDRESS_LIST=

（ADDRESS=（PROTOCOL=TCP）（HOST=mhdb01vip）（PORT=1521））

（ADDRESS=（PROTOCOL=TCP）（HOST=mhdb02vip）（PORT=1521））

）

LISTENERS_ORCL1=

LISTENERS_ORCL2=

ORCL2=

（DESCRIPTION=

（CONNECT_DATA=

（SERVER=DEDICATED）

（SERVICE_NAME=）

（INSTANCE_NAME=orcl2）

）

ORCL1=

（INSTANCE_NAME=orcl1）

ORCL=

（LOAD_BALANCE=yes）

（FAILOVER_MODE=

（TYPE=SELECT）

（METHOD=BASIC）

（RETRIES=200）

（DELAY=5）

）

����undo

createundotablespaceUNDOTBS1datafile'

/oracle/oradata/orcl/undotbs01.dbf'

size1000m;

createundotablespaceUNDOTBS2datafile'

/oracle/oradata/orcl/undotbs02.dbf'

����rac��ͼ

$ORACLE_HOME/rdbms/admin/catclust.sql

��pfile�����RAC�ض�����

*.cluster_database_instances=2

*.cluster_database=true

orcl1.cluster_interconnects='

192.168.130.1'

orcl2.cluster_interconnects='

192.168.130.2'

orcl2.instance_number=2

orcl1.instance_number=1

orcl1.local_listener='

LISTENERS_ORCL1'

orcl2.local_listener='

LISTENERS_ORCL2'

*.remote_listener='

LISTENERS_ORCL'

orcl2.thread=2

orcl1.thread=1

orcl2.undo_tablespace='

UNDOTBS2'

orcl1.undo_tablespace='

UNDOTBS1'

crsע��ʵ��

srvctladddatabase-dorcl-o$ORACLE_HOME

srvctladdinstance-dorcl-iorcl1-nmhdb01

srvctladdinstance-dorcl-iorcl2-nmhdb02

srvctlstartinstance-dorcl-iorcl1

���log�ڵ㡣

alterdatabaseaddlogfilethread2group4（'

/oracle/oradata/orcl/redo21.log'

）size10M;

alterdatabaseaddlogfilethread2group5（'

/oracle/oradata/orcl/redo22.log'

alterdatabaseaddlogfilethread2group6（'

/oracle/oradata/orcl/redo23.log'

alterdatabaseenablethread2;