作者chings22 (chings22)
看板Database
标题[讨论] 请问Oracle data guard换机该怎麽设定?
时间Wed Jun 30 23:49:49 2021
有一台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://webptt.com/cn.aspx?n=bbs/Database/M.1625068191.A.B03.html
1F：推 bij831: 网路上一票建置文，是遇到什问题了？ 07/03 12:28
因为是前人建置,我还没处理过,是有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
2F：→ glaylaruku: 移除stbyDB,升级11g後再duplicate stbyDB有试过吗 07/06 10:08
我是先升级,备份遇到这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