資源描述：
《oracle_data_guard安裝配置與操作維護使用指南》由會員上傳分享，免費在線閱讀，更多相關內(nèi)容在工程資料-天天文庫。
1、準備工作主機Hosts表要添加兩臺數(shù)據(jù)庫的主機名和IP地址；主機是primary,配置兩機監(jiān)聽備機是standby,配置兩機監(jiān)聽啟動關閉命名dbstartdbshutlsnrctlstartlsnrctlstoptnspingprimarytnspingstandby安裝數(shù)據(jù)庫配置監(jiān)聽器主數(shù)據(jù)庫配置SQL>alterdatabaseforcelogging;SQL>shutdownimmediateSQL>startupmountSQL>alterdatabasearchivelog;SQL>archiveloglis
2、t$sqlplus/nologSQL*Plus:Release10.2.0.1.0一ProductiononMonMay3010:06:472011Copyright(c)1982,2005,Oracle?AHrightsreserved.SQL>conn/assysdbaConnected.SQL>alterdatabaseforcelogging;Databasealtered?SQL>shutdownimmediateDatabaseclosed.Databasedismounted?ORACLEinstance
3、shutdown.SQL>startupmountORACLEinstancestarted?TotalSystemGlobalFixedSizeVariableSizeDatabaseBuffersRedoBuffersDatabasemounted.Area364904448bytes1219424bytes92275872bytes264241152bytes7168000bytesArchiveModeEnabledSQL>alterdatabasearchivelog;Databasealtered?SQL>
4、archiveloglistDatabaselogmodeAutomaticarchivalArchivedestination/opt/oracle/oradata/primary/archiveOldestonlinelogsequence1Nextlogsequencetoarchive2Currentlogsequence2主拷貝數(shù)據(jù)庫文件SQL>selectnamefromv$datafile;SQL>shutdownimmediate;SQL>selectnamefromv$datafile;NAME/op
5、t/oracle/oradata/primary/systemOl?dbf/opt/oracle/oradata/primary/undotbsOl?dbf/opt/oracle/oradata/primary/sysauxOl?dbf/opt/oracle/oradata/primary/usersOl?dbfSQL>shutdownimmediate;ORA-01109:databasenotopenDatabasedismounted?ORACLEinstanceshutdown.主創(chuàng)建控制文件SQL>start
6、upmountSQL>alterdatabasecreatestandbycontrolfileas1$ORACLE_BASE/oradata/primary/standby.ctl1;SQL>startupmountORACLEinstancestarted?TotalSystemGlobalFixedSizeVariableSizeDatabaseBuffersRedoBuffersDatabasemounted.Area364904448bytes1219424bytes92275872bytes26424115
7、2bytes7168000bytesSQL>alterdatabasecreatestandbycontrolfileas1/opt/oracle/oradata/primmry/stmndby?ct11;Databasealtered?主創(chuàng)建密碼文件copy（主）$ORACLE_HOME/dbs/orapwprimary修改名稱為orapwstandbycopy（備）$ORACLE_HOME/dbs下如果沒有創(chuàng)建一$rm$ORACLE_HOME/dbs/orapwprimary$orapwdfile=1$ORACLE
8、_HOME/dbs/orapwprimary1password=sysentries=5主創(chuàng)建初始化參數(shù)SQL>createpfile=1$ORACLE_HOME/dbs/initprimary.ora1fromspfile;SQL>createpfile=*$ORACLE_HOME/dbs/initstandby.ora*fro
