【文章內(nèi)容簡(jiǎn)介】 ediatestartup nomountalter database mount standby database。在prod庫(kù)上執(zhí)行:select sequence, applied from v$archived_log where applied=39。YES39。 order by sequence。select switchover_status from v$database。alter database mit to switchover to primary。select status from v$instance。查看一下數(shù)據(jù)庫(kù)狀態(tài)shutdown immediatestartup在standby庫(kù)上執(zhí)行:alter database recover managed standby database using current logfile disconnect from session。在prod庫(kù)上執(zhí)行:conn scott/tigerinsert into t values(3)。mit。conn / as sysdbaalter system switch logfile。在standby庫(kù)上執(zhí)行:alter database recover managed standby database cancel。alter database open。conn scott/tigerselect * from t。conn / as sysdbaalter database recover managed standby database using current logfile disconnect from session。select open_mode from v$database?；謴?fù)到了原來(lái)的狀態(tài),即prod是主庫(kù)，standby是備庫(kù)第三章 搭建邏輯備庫(kù)配置邏輯備庫(kù) 邏輯備庫(kù)是在物理備庫(kù)的基礎(chǔ)上配置的，所以要搭建邏輯備庫(kù)先要?jiǎng)?chuàng)建好物理備庫(kù)才行在standby庫(kù)上執(zhí)行:停止備庫(kù)的applyalter database recover managed standby database cancel。注意:一定要先停止日志應(yīng)用，不然下面build的時(shí)候會(huì)有問(wèn)題在prod庫(kù)上執(zhí)行:創(chuàng)建prod庫(kù)作為邏輯備庫(kù)時(shí)的在線日志歸檔路徑exitmkdir p /u01/oradata/prod/lgarchivels l /u01/oradata/prod修改log_archive_dest_3參數(shù)，當(dāng)prod切換成備庫(kù)時(shí)起作用，即在線日志歸檔的路徑sqlplus / as sysdbaalter system set log_archive_dest_3=39。location=/u01/oradata/prod/lgarchive valid_for=(standby_logfiles,standby_role) db_unique_name=prod39。alter system set log_archive_dest_state_3=enable。 然后執(zhí)行execute 。在standby庫(kù)上執(zhí)行:創(chuàng)建standby庫(kù)作為邏輯備庫(kù)時(shí)的在線日志歸檔路徑exitmkdir p /u01/oradata/standby/lgarchivels l /u01/oradata/standbysqlplus / as sysdbaalter system set log_archive_dest_3=39。location=/u01/oradata/standby/lgarchive valid_for=(standby_logfiles,standby_role) db_unique_name=standby39。alter system set log_archive_dest_state_3=enable。 檢查standby庫(kù)的臨時(shí)表空間數(shù)據(jù)文件select * from v$tempfile。有臨時(shí)文件信息，如果沒(méi)有，要添加臨時(shí)文件alter tablespace temp add tempfile xxxxxx..select status from v$instance。查看一下數(shù)據(jù)庫(kù)角色select database_role from v$database。startup mount forcealter database recover to logical standby standby。把備庫(kù)轉(zhuǎn)換成邏輯備庫(kù)，后一個(gè)standby是備庫(kù)名select status from v$instance。startup mount forceselect database_role from v$database。alter database open resetlogs。show parameter db_name此時(shí)備庫(kù)的db_name已經(jīng)改成standby是一個(gè)新庫(kù)了稍等片刻后在prod庫(kù)上執(zhí)行:alter system switch logfile。查看prod庫(kù)的alert信息查看standby的alert信息在standby庫(kù)上執(zhí)行:查看歸檔日志是否傳輸?shù)絺鋷?kù)exitls l /u01/oradata/standby/archivelog啟用實(shí)時(shí)日志應(yīng)用sqlplus / as sysdbaalter database start logical standby apply immediate。此時(shí)standby庫(kù)的alert日志里會(huì)產(chǎn)生大量信息prod庫(kù)的alert日志信息:配置完成，開(kāi)始驗(yàn)證在prod庫(kù)上執(zhí)行:conn scott/tigercreate table a(a varchar2(10))。insert into a values(39。a39。)。mit。在standby庫(kù)上執(zhí)行:conn scott/tigerselect * from a。邏輯備庫(kù)配置成功！切換邏輯備庫(kù) 先把prod庫(kù)和standby庫(kù)的undo_retention參數(shù)都設(shè)置成3600conn / as sysdbaalter system set undo_retention=3600。開(kāi)始切換邏輯備庫(kù)在prod庫(kù)上執(zhí)行:select switchover_status from v$database。alter database prepare to switchover to logical standby。select switchover_status from v$database。在standby庫(kù)上執(zhí)行:select switchover_status from v$database。alter database prepare to switchover to primary。select switchover_status from v$database。在prod庫(kù)上執(zhí)行:這個(gè)時(shí)候觀察prod庫(kù)的switchover_status會(huì)發(fā)現(xiàn)select switchover_status from v$database。如果上述查詢的返回結(jié)果不是TO LOGICAL STANDBY 的話，你可能就需要取消此次轉(zhuǎn)換，檢查原因，然后再重新操作了取消轉(zhuǎn)換的命令為:alter database prepare to switchover cancel。prod庫(kù)繼續(xù)執(zhí)行alter database mit to switchover to logical standby。在standby庫(kù)上執(zhí)行:再檢查standby庫(kù)的switchover_status會(huì)發(fā)現(xiàn)select switchover_status from v$database。alter database mit to switchover to primary。在prod庫(kù)上執(zhí)行:alter database start logical standby apply immediate。在standby庫(kù)上執(zhí)行:conn scott/tigerinsert into a values(39。b39。)。mit。conn / as sysdba在prod庫(kù)上執(zhí)行:conn scott/tigerselect * from a。conn / as sysdba邏輯備庫(kù)切換成功！再切換回去在standby庫(kù)上執(zhí)行:select switchover_status from v$database。alter database prepare to switchover to logical standby。select switchover_status from v$database。在prod庫(kù)上執(zhí)行:select switchover_status from v$database。alter database prepare to switchover to primary。select switchover_status from v$database。在standby庫(kù)上執(zhí)行:select switchover_status from v$database。alter database mit to switchover to logical standby。select switchover_status from v$database。在prod庫(kù)上執(zhí)行:select switchover_status from v$database。alter database mit to switchover to primary。select switchover_status from v$database。在standby庫(kù)上執(zhí)行:alter database start logical standby apply immediate。開(kāi)始實(shí)時(shí)應(yīng)用日志在prod庫(kù)上執(zhí)行:conn scott/tigerinsert into a values(39。c39。)。mit。conn / as sysdba在standby庫(kù)上執(zhí)行:conn scott/tigerselect * from a。conn / as sysdba恭喜又一次轉(zhuǎn)換成功！如果數(shù)據(jù)沒(méi)有同步要稍等會(huì)，大概在10秒鐘，起決于機(jī)器的性能第四章 使用邏輯備庫(kù)滾動(dòng)升級(jí)升級(jí)邏輯備庫(kù)到10204把10204和11201的數(shù)據(jù)庫(kù)軟件傳輸?shù)絪tandby的/u01目錄用root用戶執(zhí)行cd /u01ls lrtchown oracle:oinstall *ls lrtsu oraclecd /u01ls lrt解壓10204升級(jí)包軟件unzip ……ls lrt刪除軟件壓縮包，節(jié)省空間