【正文】 tnsping standby配置prod庫參數sqlplus / as sysdbaalter system set log_archive_config=39。alter system set log_archive_dest_1=39。alter system set log_archive_dest_2=39。alter system set log_archive_dest_state_1=enable。alter system set log_archive_max_processes=10。alter system set fal_client=prod。還有三需要重啟才生效的參數也設置一下alter system set db_unique_name=39。scope=spfile。/u01/oracle/standby39。/u01/oracle/prod39。alter system set log_file_name_convert=39。,39。 scope=spfile。/u01/backupset/%U39。release channel d1。duplicate target database for standby nofilenamecheck。}還原了standby庫！配置standby數據庫查詢standby庫狀態(tài)select status from v$instance。/u01/oradata/standby/39。alter database add standby logfile (39。) size 50m。/u01/oradata/standby/39。alter database add standby logfile (39。) size 50m。在standby庫查看一下是否有歸檔日志了exitls l /u01/oradata/standby/archivelog日志可以傳輸了就ok！備庫執(zhí)行日志應用同步語句，開始運行物理DGsqlplus / as sysdbaalter database recover managed standby database using current logfile disconnect from session。YES39。yes說明日志同步了在prod庫上執(zhí)行:conn scott/tigercreate table t(i int)。mit。在standby庫上執(zhí)行:alter database recover managed standby database cancel。conn scott/tigerselect * from t。注意：物理備庫open是默認read only模式的alter database recover managed standby database using current logfile disconnect from session。啟動數據同步語句后，數據庫又變?yōu)閙ounted狀態(tài)注意：在測試數據同步的時候請不要用sys用戶，不然可能同步不了，這里測試都是用scott用戶切換物理備庫在prod庫上執(zhí)行:select switchover_status from v$database。這個命令要執(zhí)行蠻長時間，請耐心等待注意:上面switchover_status的值如果是TO STANDBY，可以直接switchover，如果是sessions active，則需要在switchover的命令后面加上with session shutdown，比如alter database mit to switchover to physical standby with session shutdown。檢查一下數據庫狀態(tài)shutdown immediatestartup nomountalter database mount standby database。YES39。已經和剛才的主庫同步完日志select switchover_status from v$database。這條命令就是把備庫切成主庫select status from v$instance。/u01/oradata/prod/39。alter database add standby logfile (39。) size 50m。/u01/oradata/prod/39。alter database add standby logfile (39。) size 50m。select sequence, applied from v$archived_log where applied=39。order by sequence。mit。在prod庫上執(zhí)行:alter database recover managed standby database cancel。conn scott/tigerselect * from t。alter database recover managed standby database using current logfile disconnect from session?；謴统赏侥Ｊ皆偾袚Q一次，切換來原來的狀態(tài)，步驟是一樣的這里只是為了驗證是否ok在standby庫上執(zhí)行:select switchover_status from v$database。shutdown immediatestartup nomountalter database mount standby database。YES39。select switchover_status from v$database。select status from v$instance。在prod庫上執(zhí)行:conn scott/tigerinsert into t values(3)。conn / as sysdbaalter system switch logfile。alter database open。conn / as sysdbaalter database recover managed standby database using current logfile disconnect from session?；謴偷搅嗽瓉淼臓顟B(tài),即prod是主庫，standby是備庫第三章 搭建邏輯備庫配置邏輯備庫 邏輯備庫是在物理備庫的基礎上配置的，所以要搭建邏輯備庫先要創(chuàng)建好物理備庫才行在standby庫上執(zhí)行:停止備庫的applyalter database recover managed standby database cancel。location=/u01/oradata/prod/lgarchive valid_for=(standby_logfiles,standby_role) db_unique_name=prod39。 然后執(zhí)行execute 。location=/u01/oradata/standby/lgarchive valid_for=(standby_logfiles,standby_role) db_unique_name=standby39。 檢查standby庫的臨時表空間數據文件select * from v$tempfile。查看一下數據庫角色select database_role from v$database。把備庫轉換成邏輯備庫，后一個standby是備庫名select status from v$instance。alter database open resetlogs。查看prod庫的alert信息查看standby的alert信息在standby庫上執(zhí)行:查看歸檔日志是否傳輸到備庫exitls l /u01/oradata/standby/archivelog啟用實時日志應用sqlplus / as sysdbaalter database start logical standby apply immediate。insert into a values(39。)。在standby庫上執(zhí)行:conn scott/tigerselect * from a。開始切換邏輯備庫在prod庫上執(zhí)行:select switchover_status from v$database。select switchover_status from v$database。alter database prepare to switchover to primary。在prod庫上執(zhí)行:這個時候觀察prod庫的switchover_status會發(fā)現select switchover_status from v$database。prod庫繼續(xù)執(zhí)行alter database mit to switchover to logical standby。alter database mit to switchover to primary。在standby庫上執(zhí)行:conn scott/tigerinsert into a values(39。)。conn / as sysdba在prod庫上執(zhí)行:conn scott/tigerselect * from a。alter database prepare to switchover to logical standby。在prod庫上執(zhí)行:select switchover_status from v$database。select switchover_status from v$database。alter database mit to switchover to logical standby。在prod庫上執(zhí)行:select switchover_status from v$database。select switchover_status from v$database。開始實時應用日志在prod庫上執(zhí)行:conn scott/tigerinsert into a values(39。)。conn / as sysdba在standby庫上執(zhí)行:conn scott/tigerselect * from a。修改一下數據庫的SGA大小為512M，不然可能在升級過程中一直會報4031錯誤說內存不夠，這個記錄報錯信息的trc文件會把磁盤撐滿導致升級失敗alter system set sga_max_size=512M scope=spfile。關閉數據庫shutdown immediate升級數據庫軟件在standby庫上執(zhí)行exitcd /u01/Disk1./runInstaller另開一個會話把listener關了su oraclelsnrctl stop