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

[chings22 (chings22)]

有一台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: 網路上一票建置文，是遇到什問題了？
因為是前人建置,我還沒處理過,是有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: 移除stbyDB,升級11g後再duplicate stbyDB有試過嗎
我是先升級,備份遇到這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