[討論] 請問Oracle data guard換機該怎麼設定?

看板Database (資料庫)作者chings22 (chings22)時間3年前 (2021/06/30 23:49)推噓1(1推 0噓 1→)

留言2則, 2人參與討論串1/2 (看更多)

有一台Oracle 10g DB有設定data guard, 最近有換機器,並升級到Oracle 11g 若沒移除備庫,在主庫備份會無法刪除archive log RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process RMAN-08515: archived log file name=/u01/arch/xxxx_792839116_1_206182.arc thread=1 sequence=206182 請問原本的data guard 解除設定,在新版DB重新設定data guard的大概步驟網路上有相關做法嗎? 謝謝 -- ※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 36.226.152.131 (臺灣) ※ 文章網址: https://www.ptt.cc/bbs/Database/M.1625068191.A.B03.html

推

bij831

07/03 12:28, 3年前 , 1^F

07/03 12:28, 1^F

因為是前人建置,我還沒處理過,是有google了一些文件,預計下週開始做若有人願意稍微提示會遇到什麼問題,也謝謝您 ※ 編輯: chings22 (36.226.156.94 臺灣), 07/04/2021 00:05:42 10g upgrade到11g 我是參考這文 https://samadhandba.wordpress.com/2011/02/24/step-by-step-upgrading-oracle-10g-to-oracle-11g/ @?/rdbms/admin/catupgrd.sql ==>這段是主sql,只花10分鐘 @?/rdbms/admin/utlu112s.sql @?/rdbms/admin/catuppst.sql @?/rdbms/admin/utlrp.sql ---------- 移除DG,在MOS看到這文 How to remove a Data Guard Configuration from Primary Database (Doc ID 733794.1) 步驟如下,我還沒做 1.On the Primary database, put the Database in Maximum Performance Mode (if not already): ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE; 2. Remove Data Guard Broker Configuration ==>沒設定 3. Unset Data Guard-specific Initialization Parameters LOG_ARCHIVE_CONFIG DB_FILE_NAME_CONVERT LOG_FILE_NAME_CONVERT LOG_ARCHIVE_DEST_n pointing to the Standby Database and valid for STANDBY_LOGFILES LOG_ARCHIVE_DEST_STATE_n DG_BROKER_START DG_BROKER_CONFIG_FILE1 DG_BROKER_CONFIG_FILE2 STANDBY_ARCHIVE_DEST STANDBY_FILE_MANAGEMENT FAL_SERVER FAL_CLIENT alter system set log_archive_dest_2='' scope=both; alter system set dg_broker_config_file1='' scope=both; alter system set dg_broker_config_file2='' scope=both; alter system set standby_archive_dest='' scope=both; alter system set standby_file_management='' scope=both; alter system set fal_server='' scope=both; alter system set fal_client='' scope=both; 4. Drop Standby Redologs from the Primary Database SELECT GROUP# FROM V$STANDBY_LOG; GROUP# ---------- 11 12 13 14 15 16 17 18 19 20 SQL> ALTER DATABASE DROP STANDBY LOGFILE GROUP <GROUP_NUMBER>; e.g. SQL> alter database drop standby logfile group 3; 5. Drop the Data Guard Broker Configuration Files if used. DG_BROKER_CONFIG_FILE1 and DG_BROKER_CONFIG_FILE2 Parameters define the Name and Location of the Data Guard Broker Configuration Files. ==>沒設定 ※ 編輯: chings22 (36.226.156.94 臺灣), 07/06/2021 00:04:45

→

glaylaruku

07/06 10:08, 3年前 , 2^F

07/06 10:08, 2^F

我是先升級,備份遇到這error,這週要刪standby DB,再重建standby DB RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process Duplicate 還沒試過 ※ 編輯: chings22 (220.129.26.73 臺灣), 07/07/2021 09:21:19 只有做步驟3跟4,然後備份就把archive log都刪完了 ※ 編輯: chings22 (220.129.26.73 臺灣), 07/07/2021 22:09:25