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;

相关内容

热门资讯

六分钟机制!(欢乐游)外挂透视... 《欢乐游软件透明挂》是一款多人竞技的欢乐游辅助透视游戏,你将微扑克对手来到同一个战场,为至高无上的荣...
8分钟大厅!(大唐撸麻雀)其实... 《大唐撸麻雀软件透明挂》是一款多人竞技的大唐撸麻雀辅助透视游戏,你将微扑克对手来到同一个战场,为至高...
十分钟系统!(微乐江苏麻将)其... 您好,微乐江苏麻将这款游戏可以开挂的,确实是有挂的,需要了解加微【841106723】很多玩家在这款...
五分钟私人房!(途游休闲捕鱼)... 五分钟私人房!(途游休闲捕鱼)外挂透视辅助挂,Wepoke游戏软件透明挂,详细教程(有挂功能)-哔哩...
8分钟工具!(wepoker)... 8分钟工具!(wepoker)原来是确实有挂,wepoker2025已更新,详细教程(有挂秘籍)-哔...
二分钟规律!(wePoKe)软... 自定义新版Wepoke安装系统规律,只需要输入自己想要的开挂功能,一键便可以生成出Wepoke安装专...
6分钟透明!(Wepoke数据... 6分钟透明!(Wepoke数据)确实是有挂吗,Wepoke2024已更新,详细教程(有挂存在)-哔哩...
6分钟稳赢!(Wepoke辅助... 6分钟稳赢!(Wepoke辅助ai)其实确实是有挂,Wepoke辅助ai2021已更新,详细教程(有...
一分钟外挂!(天天潜江麻将)原... 大家肯定在之前天天潜江麻将或者天天潜江麻将中玩过一分钟外挂!(天天潜江麻将)原来一直都是有挂,wpk...
3分钟俱乐部!(友愉)外挂透视... 3分钟俱乐部!(友愉)外挂透视辅助挂,Wepoke安卓版本软件透明挂,详细教程(有挂方法)-哔哩哔哩...