ORACLE10G RAC 环境搭建物理 DATA GUARD.docx
- 文档编号:23299352
- 上传时间:2023-05-16
- 格式:DOCX
- 页数:12
- 大小:18.31KB
ORACLE10G RAC 环境搭建物理 DATA GUARD.docx
《ORACLE10G RAC 环境搭建物理 DATA GUARD.docx》由会员分享,可在线阅读,更多相关《ORACLE10G RAC 环境搭建物理 DATA GUARD.docx(12页珍藏版)》请在冰豆网上搜索。
ORACLE10GRAC环境搭建物理DATAGUARD
ORACLE10G RAC 环境搭建物理 DATA GUARD
一.检查数据库要处于归档模式.
SQL>archiveloglist;
Databaselogmode NoArchiveMode
Automaticarchival Disabled
Archivedestination USE_DB_RECOVERY_FILE_DEST
Oldestonlinelogsequence 11
Currentlogsequence 12
SQL>
1>修改数据库为归档模式(RAC环境)
1.停止数据库
srvctlstopdatabase-dracdb
2.第一个实例启动到mount状态.
srvctlstartinstance-dracdb-iracdb1
shutdownimmediate;
startupmount;
SQL>archiveloglist
Databaselogmode NoArchiveMode
Automaticarchival Disabled
Archivedestination USE_DB_RECOVERY_FILE_DEST
Oldestonlinelogsequence 11
Currentlogsequence 12
SQL>shutdownimmediate;
Databaseclosed.
Databasedismounted.
ORACLEinstanceshutdown.
SQL>startupmount
ORACLEinstancestarted.
TotalSystemGlobalArea1224736768bytes
FixedSize 2072352bytes
VariableSize 285212896bytes
DatabaseBuffers 922746880bytes
RedoBuffers 14704640bytes
Databasemounted.
SQL>alterdatabasearchivelog;
Databasealtered.
SQL>alterdatabaseopen;
Databasealtered.
3.启动第二个实例
[oracle@rac1~]$srvctlstartinstance-dracdb-iracdb2
[oracle@rac1~]$srvctlstartservice-dracdb-stestdb
[oracle@rac1~]$crs_stat-t
二:
检查是否为forcelogging.
1.
SQL>selectinst_id,force_loggingfromgv$database;
INST_IDFOR
-------------
1NO
2NO
2.修改数据库为forcelogging
SQL>alterdatabaseforcelogging;
Databasealtered.
note:
只需要在一个instance执行即可.
三:
1>rmanfullbackup
RMAN>backupfulldatabase tag'dbfull'format'/app/temp/dbfull_%u_%s_%p';
Startingbackupat30-JUN-08
allocatedchannel:
ORA_DISK_1
channelORA_DISK_1:
sid=519instance=racdb1devtype=DISK
channelORA_DISK_1:
startingfulldatafilebackupset
channelORA_DISK_1:
specifyingdatafile(s)inbackupset
inputdatafilefno=00003name=+DG1/racdb/datafile/sysaux.257.657295195
inputdatafilefno=00004name=+DG1/racdb/datafile/users.259.657295199
inputdatafilefno=00001name=+DG1/racdb/datafile/system.256.657295195
inputdatafilefno=00002name=+DG1/racdb/datafile/undotbs1.258.657295197
inputdatafilefno=00005name=+DG1/racdb/datafile/undotbs2.264.657295475
inputdatafilefno=00006name=+DG1/racdb/datafile/tbs_test.268.658242359
channelORA_DISK_1:
startingpiece1at30-JUN-08
channelORA_DISK_1:
finishedpiece1at30-JUN-08
piecehandle=/app/temp/dbfull_01jk7rjj_1_1tag=DBFULLcomment=NONE
channelORA_DISK_1:
backupsetcomplete,elapsedtime:
00:
00:
55
channelORA_DISK_1:
startingfulldatafilebackupset
channelORA_DISK_1:
specifyingdatafile(s)inbackupset
includingcurrentcontrolfileinbackupset
includingcurrentSPFILEinbackupset
channelORA_DISK_1:
startingpiece1at30-JUN-08
channelORA_DISK_1:
finishedpiece1at30-JUN-08
piecehandle=/app/temp/dbfull_02jk7rla_2_1tag=DBFULLcomment=NONE
channelORA_DISK_1:
backupsetcomplete,elapsedtime:
00:
00:
15
Finishedbackupat30-JUN-08
2>
--修改主库的初始化参数
ALTERSYSTEMSETDB_UNIQUE_NAME=racdbscope=spfile;
ALTERSYSTEMSETLOG_ARCHIVE_CONFIG='DG_CONFIG=(racdb,oradb)'scope=spfile;
ALTERSYSTEMSETLOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DESTVALID_FOR=(ALL_LOGFILES,ALL_ROLES)DB_UNIQUE_NAME=racdb'scope=spfile;
ALTERSYSTEMSETLOG_ARCHIVE_DEST_2='SERVICE=oradbLGWRASYNCVALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)DB_UNIQUE_NAME=oradb'scope=spfile;
ALTERSYSTEMSETLOG_ARCHIVE_DEST_STATE_1=ENABLEscope=spfile;
ALTERSYSTEMSETLOG_ARCHIVE_DEST_STATE_2=ENABLEscope=spfile;
ALTERSYSTEMSETLOG_ARCHIVE_FORMAT='%t_%s_%r.arc'scope=spfile;
ALTERSYSTEMSETLOG_ARCHIVE_MAX_PROCESSES=4scope=spfile;
ALTERSYSTEMSETFAL_CLIENT=testdbSCOPE=SPFILE;
ALTERSYSTEMSETFAL_SERVER=oradbSCOPE=SPFILE;
ALTERSYSTEMSETSTANDBY_FILE_MANAGEMENT=AUTOSCOPE=SPFILE;
ALTERSYSTEMSETDB_FILE_NAME_CONVERT='+DG1/racdb/datafile/','/app/oracle/oradata/'SCOPE=SPFILE;
ALTERSYSTEMSETLOG_FILE_NAME_CONVERT='+DG1/racdb/onlinelog/','/app/oracle/oradata/','+RECOVERYDEST/racdb/onlinelog/','/app/oracle/flash_recovery_area/ORADB/onlinelog'SCOPE=SPFILE;
note:
重新启动2个实例.
四. 创建备库的参数文件和控制文件.
SQL>createpfile='/app/oracle/admin/racdb/pfile/standby.pfile'fromspfile;
Filecreated.
SQL>ALTERDATABASECREATESTANDBYCONTROLFILEAS'/app/temp/standby.ctl';
Databasealtered.
把pfile,ctrontlfile 拷贝到备份数据库上.(在备份数据库上修改参数文件.去掉rac的参数.)
五.
standby上创建密码文件.
[oracle@oradbdbs]$orapwdfile=/app/oracle/product/10.2.0/db_1/dbs/orapworadbpassword=sysentries=5;
[oracle@oradbdbs]$ls
[oracle@oradbpfile]$sqlplus"/assysdba"
SQL*Plus:
Release10.2.0.3.0-ProductiononTueJul113:
03:
122008
Copyright(c)1982,2006,Oracle. AllRightsReserved.
Connectedtoanidleinstance.
SQL>startupnomountpfile='/app/oracle/admin/oradb/pfile/standby.pfile';
ORACLEinstancestarted.
TotalSystemGlobalArea 213909504bytes
FixedSize 1260984bytes
VariableSize 79692360bytes
DatabaseBuffers 130023424bytes
RedoBuffers 2932736bytes
SQL>
进行rman进行恢复
[oracle@oradb~]$rmantarget/
RecoveryManager:
Release10.2.0.3.0-ProductiononTueJul113:
03:
572008
Copyright(c)1982,2005,Oracle. Allrightsreserved.
connectedtotargetdatabase:
RACDB(DBID=654912098,notopen)
RMAN>restoredatabase;
Startingrestoreat01-JUL-08
Startingimplicitcrosscheckbackupat01-JUL-08
usingtargetdatabasecontrolfileinsteadofrecoverycatalog
allocatedchannel:
ORA_DISK_1
channelORA_DISK_1:
sid=536devtype=DISK
Crosschecked2objects
Finishedimplicitcrosscheckbackupat01-JUL-08
Startingimplicitcrosscheckcopyat01-JUL-08
usingchannelORA_DISK_1
Finishedimplicitcrosscheckcopyat01-JUL-08
searchingforallfilesintherecoveryarea
catalogingfiles...
nofilescataloged
usingchannelORA_DISK_1
channelORA_DISK_1:
startingdatafilebackupsetrestore
channelORA_DISK_1:
specifyingdatafile(s)torestorefrombackupset
restoringdatafile00001to+DG1/racdb/datafile/system.256.657295195
restoringdatafile00002to+DG1/racdb/datafile/undotbs1.258.657295197
restoringdatafile00003to+DG1/racdb/datafile/sysaux.257.657295195
restoringdatafile00004to+DG1/racdb/datafile/users.259.657295199
restoringdatafile00005to+DG1/racdb/datafile/undotbs2.264.657295475
restoringdatafile00006to+DG1/racdb/datafile/o1_mf_tbs_test_46mjwd9n_.dbf
channelORA_DISK_1:
readingfrombackuppiece/app/temp/dbfull_01jk7rjj_1_1
channelORA_DISK_1:
restoredbackuppiece1
piecehandle=/app/temp/dbfull_01jk7rjj_1_1tag=DBFULL
channelORA_DISK_1:
restorecomplete,elapsedtime:
00:
01:
56
Finishedrestoreat01-JUL-08
--MOUNTSTANDBYDB
SQL>alterdatabasemountstandbydatabase;
Databasealtered.
SQL>ALTERDATABASERECOVERMANAGEDSTANDBYDATABASEDISCONNECTFROMSESSION;
Databasealtered.
备用数据库添加standbylogfile
SQL>ALTERDATABASERECOVERMANAGEDSTANDBYDATABASECANCEL;
Databasealtered.
ALTERDATABASEADDSTANDBYLOGFILETHREAD1group5('/app/oracle/oradata/ORADB/onlinelog/slog1.ora')SIZE104857600;
ALTERDATABASEADDSTANDBYLOGFILETHREAD1group6('/app/oracle/oradata/ORADB/onlinelog/slog2.ora')SIZE104857600;
ALTERDATABASEADDSTANDBYLOGFILETHREAD1group7('/app/oracle/oradata/ORADB/onlinelog/slog3.ora')SIZE104857600;
ALTERDATABASEADDSTANDBYLOGFILETHREAD2group8('/app/oracle/oradata/ORADB/onlinelog/slog4.ora')SIZE104857600;
ALTERDATABASEADDSTANDBYLOGFILETHREAD2group9('/app/oracle/oradata/ORADB/onlinelog/slog5.ora')SIZE104857600;
ALTERDATABASEADDSTANDBYLOGFILETHREAD2group10('/app/oracle/oradata/ORADB/onlinelog/slog6.ora')SIZE104857600;
--检查standby日志应用情况.
SQL>SELECTSEQUENCE#,APPLIEDFROMV$ARCHIVED_LOGORDERBYSEQUENCE#;
SEQUENCE#APP
-------------
14YES
15YES
16YES
17YES
18YES
18YES
19YES
19NO
20YES
21YES
22YES
错误处理:
1.
SQL>alterdatabasemountstandbydatabase;
alterdatabasemountstandbydatabase
*
ERRORatline1:
ORA-01103:
databasename'RACDB'incontrolfileisnot'ORADB'
解决:
是由于备库的初始化参数文件db_name和主库配置的不一样.主备数据库的db_name要一致.实例名称可以不一致.
2.
=====================
TueJul 113:
42:
272008
Errorsinfile/app/oracle/admin/oradb/bdump/oradb_mrp0_6850.trc:
ORA-00313:
openfailedformembersofloggroup1ofthread1
ORA-00312:
onlinelog1thread1:
'+RECOVERYDEST/racdb/onlinelog/group_1.257.657295339'
ORA-17503:
ksfdopn:
2Failedtoopenfile+RECOVERYDEST/racdb/onlinelog/group_1.257.657295339
ORA-15001:
diskgroup"RECOVERYDEST"doesnotexistorisnotmounted
ORA-15077:
couldnotlocateASMinstanceservingarequireddiskgroup
ORA-29701:
unabletoconnecttoClusterManager
ORA-00312:
onlinelog1thread1:
'+DG1/racdb/onlinelog/group_1.261.657295335'
ORA-17503:
ksfdopn:
2Failedtoopenfile+DG1/racdb/onlinelog/group_1.261.657295335
ORA-15001:
diskgroup"DG1"doesnotexistorisnotmounted
ORA-15077:
couldnotlocateASMinstanceservingarequireddiskgroup
ORA-29701:
unabletoconnecttoClusterManager
TueJul 113:
42:
272008
说明:
第一次出现这个错误是正常的.因为standbydb没有primary的onlinelog,db会自动处理把parimaydb的onlinelogcopy到standby机器上面.
附录:
primarydbinit.ora
racdb1.__db_cache_size=922746880
racdb2.__db_cache_size=889192448
racdb1.__java_pool_size=16777216
racdb2.__java_pool_size=16777216
racdb1.__large_pool_size=16777216
racdb2.__large_pool_size=16777216
racdb1.__shared_pool_size=251658240
racdb2.__shared_pool_size=285212672
racdb1.__streams_pool_size=0
racdb2.__streams_pool_size=0
*.audit_file_dest='/app/
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- ORACLE10G RAC 环境搭建物理 DATA GUARD 环境 搭建 物理