单实例迁移rac.txt
《单实例迁移rac.txt》由会员分享,可在线阅读,更多相关《单实例迁移rac.txt(6页珍藏版)》请在冰点文库上搜索。
���ݿ�Ǩ�Ʋ���
���ݿ�����
10.1.0.4.2������10.2.0.2
1�����crs
2���������ݿ�
SQL>STARTUPUPGRADE
SQL>SPOOLpatch.log
SQL>@?
/rdbms/admin/catupgrd.sql
SQL>SPOOLOFF
3���������ݿ⣬������Ч����
SQL>SHUTDOWN
SQL>STARTUP
SQL>@?
/rdbms/admin/utlrp.sql
selectowner,object_namefromdba_objectswherestatus='INVALID'
selectownerfromdba_objectswherestatus='INVALID'orderbyowner
selectcount(*)fromdba_objectswherestatus='INVALID'
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'SIZE10M,
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:
mhdb02
Listenerisrunningonnode:
mhdb02
ONSdaemonisrunningonnode:
mhdb02
����tns
LISTENERS_ORCL=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=mhdb01vip)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=mhdb02vip)(PORT=1521))
)
LISTENERS_ORCL1=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=mhdb01vip)(PORT=1521))
)
LISTENERS_ORCL2=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=mhdb02vip)(PORT=1521))
)
ORCL2=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=mhdb02vip)(PORT=1521))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=)
(INSTANCE_NAME=orcl2)
)
)
ORCL1=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=mhdb01vip)(PORT=1521))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=)
(INSTANCE_NAME=orcl1)
)
)
ORCL=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=mhdb01vip)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=mhdb02vip)(PORT=1521))
(LOAD_BALANCE=yes)
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=)
(FAILOVER_MODE=
(TYPE=SELECT)
(METHOD=BASIC)
(RETRIES=200)
(DELAY=5)
)
)
)
����undo
createundotablespaceUNDOTBS1datafile'/oracle/oradata/orcl/undotbs01.dbf'size1000m;
createundotablespaceUNDOTBS2datafile'/oracle/oradata/orcl/undotbs02.dbf'size1000m;
����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')size10M;
alterdatabaseaddlogfilethread2group6('/oracle/oradata/orcl/redo23.log')size10M;
alterdatabaseenablethread2;