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;

相关内容

热门资讯

一分钟识别!(德普)软件透明挂... 您好,微扑克这款游戏可以开挂的,确实是有挂的,需要了解加微【136704302】很多玩家在这款游戏中...
4分钟挂!(德扑之星)其实有挂... 您好,德扑之星这款游戏可以开挂的,确实是有挂的,需要了解加微【485275054】很多玩家在这款游戏...
4分钟识别!(WPK模拟器)是... 亲,wpk安卓版这款游戏可以开挂的,确实是有挂的,很多玩家在这款游戏中打牌都会发现很多用户的牌特别好...
七分钟猫腻!(麻辣竞技)外挂透... 七分钟猫腻!(麻辣竞技)外挂透视辅助挂,WPK玄学软件透明挂,详细教程(有挂秘笈)-哔哩哔哩;人气非...
七分钟德州版!(Wepoke玄... 您好,Wepoke玄学这款游戏可以开挂的,确实是有挂的,需要了解加微【757446909】很多玩家在...
六分钟玄学!(皖南三加一)外挂... 六分钟玄学!(皖南三加一)外挂透视辅助挂,WPK透视挂其实果真是有挂的详细教程(确实有挂)-哔哩哔哩...
5分钟最新款!(WPK程序)一... 5分钟最新款!(WPK程序)一直都是有挂吗,wEpoke原来是确实有挂,详细教程(果真有挂)-哔哩哔...
1分钟私人房!(新超圣)原来是... 1分钟私人房!(新超圣)原来是确实有挂,新超圣2023已更新,详细教程(有挂秘籍)-哔哩哔哩;小薇(...
九分钟德州版!(aa扑克)原来... 亲,WPK科技这款游戏可以开挂的,确实是有挂的,很多玩家在这款游戏中打牌都会发现很多用户的牌特别好,...
4分钟苹果版!(17好友麻将)... 自定义新版17好友麻将系统规律,只需要输入自己想要的开挂功能,一键便可以生成出17好友麻将专用辅助器...