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