dataguard gap 检查 已经切换 non sys用户传输log
创始人
2024-11-16 06:37:37
0

How to Setup non SYS user for Data Guard REDO Transport (Doc ID 3003590.1)

Oracle Database - Enterprise Edition - Version 19.22.0.0.0 and later
Information in this document applies to any platform.

GOAL

The article explains step by step method to setup the DATA GUARD REDO transport with the non SYS user using the parameter REDO_TRANSPORT_USER.
 

SOLUTION

1. Create user for the REDO transport on Primary/PROD,

SQL> create user identified by manager;
SQL> grant connect,sysoper to ;

2. Grants necessary Privilege,

The value of this parameter is case sensitive and must exactly match the value of the USERNAME column of a row in the V$PWFILE_USERS view. The value of the SYSOPER column of the row must also be TRUE.

If this parameter is not specified, then the paswd verifier of the SYS user will be used when a remote paswd file is used for redo transport authentication.

SQL> col username format a22
SQL> select USERNAME, SYSDBA, SYSOPER, SYSBACKUP, SYSDG, SYSKM from V$PWFILE_USERS where USERNAME = '';

3. Assign the created user for REDO transport,

SQL> alter system set redo_transport_user='';

4. Check the REDO transport,

The following select will show any errors.If ERROR is blank and status is VALID then no issue on REDO transport.

SQL> SELECT thread#, dest_id, gvad.status, error, fail_sequence FROM gv$archive_dest gvad, gv$instance gvi WHERE gvad.inst_id = gvi.inst_id AND destination is NOT NULL ORDER BY thread#, dest_id;

SQL> SELECT gvi.thread#, timestamp, message FROM gv$dataguard_status gvds, gv$instance gvi WHERE gvds.inst_id = gvi.inst_id AND severity in ('Error','Fatal') ORDER BY timestamp, thread#;

The following query will determine the current sequence number and the last sequence archived.
If you are remotely archiving using the LGWR process then the archived sequence should be one higher than the current sequence.
If remotely archiving using the ARCH process then the archived sequence should be equal to the current sequence.
The applied sequence information is updated at log switch time. The "Last Applied" value should be checked with the actual last log applied at the standby, only the standby is guaranteed to be correct.

SQL> SELECT cu.thread#, cu.dest_id, la.lastarchived "Last Archived", cu.currentsequence "Current Sequence", appl.lastapplied "Last Applied" FROM (select gvi.thread#, gvd.dest_id, MAX(gvd.log_sequence) currentsequence FROM gv$archive_dest gvd, gv$instance gvi WHERE gvd.status = 'VALID' AND gvi.inst_id = gvd.inst_id GROUP BY thread#, dest_id) cu, (SELECT thread#, dest_id, MAX(sequence#) lastarchived FROM gv$archived_log WHERE resetlogs_change# = (SELECT resetlogs_change# FROM v$database) AND archived = 'YES' GROUP BY thread#, dest_id) la, (SELECT thread#, dest_id, MAX(sequence#) lastapplied FROM gv$archived_log WHERE resetlogs_change# = (SELECT resetlogs_change# FROM v$database) AND applied = 'YES' GROUP BY thread#, dest_id) appl WHERE cu.thread# = la.thread# AND cu.thread# = appl.thread# AND cu.dest_id = la.dest_id AND cu.dest_id = appl.dest_id ORDER BY 1, 2;

相关内容

热门资讯

4分钟发现!微信雀神广东麻将提... 4分钟发现!微信雀神广东麻将提高胜率技巧,阿拉斗牛介绍切实真的有挂,靠谱教程(有挂攻略);1、首先打...
四分钟技巧!福建老友棋牌有挂吗... 四分钟技巧!福建老友棋牌有挂吗,海浪手游有挂吗(其实有辅助挂);1、每一步都需要思考,不同水平的挑战...
科技揭秘!老友游戏辅助器怎么下... 科技揭秘!老友游戏辅助器怎么下载(辅助)原来真的有挂(2024已更新)(哔哩哔哩)1)老友游戏辅助器...
重大来袭!微信小程序白金岛辅助... 重大来袭!微信小程序白金岛辅助器(透明挂)外挂透明挂辅助挂(2023已更新)(哔哩哔哩)1、微信小程...
九分钟发现!福建兄弟十三水ap... 九分钟发现!福建兄弟十三水app有挂吗,广西老友麻将总是真的有挂,详细教程(有挂黑科技);1、打开软...
8分钟揭秘!佳友互娱有辅助吗,... 8分钟揭秘!佳友互娱有辅助吗,决战卡五星的(竟然存在有挂)8分钟揭秘!佳友互娱有辅助吗,决战卡五星的...
盘点十款!浙江游戏大厅麻将有挂... 盘点十款!浙江游戏大厅麻将有挂吗(辅助)果然真的有挂(2020已更新)(哔哩哔哩);一、浙江游戏大厅...
科技揭秘!广西乐友麻将有挂的吗... 科技揭秘!广西乐友麻将有挂的吗(辅助挂)外挂透明挂辅助软件(2020已更新)(哔哩哔哩);一、广西乐...
8分钟科普!同乡游麻将,快玩炸... 8分钟科普!同乡游麻将,快玩炸翻天辅助器真是是有挂,2025新版教程(有挂科普);1、快玩炸翻天辅助...
2分钟攻略!胡乐麻将专用赢牌工... 2分钟攻略!胡乐麻将专用赢牌工具,大赢家跑得快机制(真是是有挂)1、胡乐麻将专用赢牌工具系统规律教程...