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;

相关内容

热门资讯

交流学习经验((闽游麻将))外... 交流学习经验((闽游麻将))外挂辅助代打,太夸张了原来确实真实是有挂(有挂透明挂)(哔哩哔哩)是一款...
重大推荐((小小长牌))外挂辅... 重大推荐((小小长牌))外挂辅助脚本,太离谱了原来确实是有挂(有挂实锤)(哔哩哔哩);1、让任何用户...
六分钟了解!德扑ai自定义设置... 六分钟了解!德扑ai自定义设置数据(WepOke)外挂透明挂辅助透视(2020已更新)(哔哩哔哩)是...
解密关于((和和麻将))外挂辅... 解密关于((和和麻将))外挂辅助插件,太过分了原来确实真的是有挂(有挂总结)(哔哩哔哩);和和麻将是...
玩家必看分享!德扑扑克(微扑克... 玩家必看分享!德扑扑克(微扑克专用)外挂透明挂辅助德州版!(透视)有挂爆料(2022已更新)(哔哩哔...
必备辅助推荐((宝宝吃吃吃))... 必备辅助推荐((宝宝吃吃吃))外挂辅助脚本,太离谱了原来一直都是有挂(有挂秘籍)(哔哩哔哩);宝宝吃...
五分钟了解!德州游戏辅助器(W... 五分钟了解!德州游戏辅助器(Wepoke网页版)外挂透明挂辅助代打(2022已更新)(哔哩哔哩);致...
一分钟了解((名途))外挂辅助... 一分钟了解((名途))外挂辅助插件,太过分了原来确实是有挂(有挂秘笈)(哔哩哔哩);小薇(透视辅助)...
5分钟实测!天天爱掼蛋辅助软件... 5分钟实测!天天爱掼蛋辅助软件(辅助挂)中至景德镇辅助(2020已更新)(哔哩哔哩)是一款可以让一直...
七分钟了解!微扑克(WPK私人... 七分钟了解!微扑克(WPK私人房)外挂透明挂辅助测试!(透视)有挂同胞(2022已更新)(哔哩哔哩)...