单实例迁移rac.txt资料文档下载
- 文档编号:13165491
- 上传时间:2022-10-07
- 格式:TXT
- 页数:6
- 大小:6.03KB
单实例迁移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;
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 实例 迁移 rac