http://iotn.co.kr 연락처: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / 日本政府は日本軍の性的奴隷?牲者に謝罪すべき. ]

사용자

ID:
PW:

INDEX
01.게시판
게시판 [67]
02.File Book
File 자료실 [95]
Site Link [16]
개인폴더 [193]
03.Field Book
Altibase [19]
Tibero [29]
MS-SQL [18]
MySQL [38]
DB2 [77]
ORACLE [2683]
PostgreSQL [88]
기타정보 [146]
운영체제 [563]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [1]

기념일
Search
LINK
+ 가족 Hompy
+ DNSEver
IOTN :: Field Book :: ORACLE

 회원가입

ogg send pause [ 관련 옵션이 없다.] kill -STOP / -CONT
최길호 [LIST]   2021-06-10 21:36:27, 조회 : 24


GGSCI (19c) 6> info r1

REPLICAT   R1        Last Started 2021-06-07 21:55   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:01 ago)
Process ID           9272 ============== PID
Log Read Checkpoint  File ./dirdat/12000086
                     2021-06-10 21:26:06.174023  RBA 15494309

[ygmc_dev:oracle@19c ~]$ ps -ef | grep 9272 ============== PID
oracle    7394  7281  0 21:28 pts/26   00:00:00 grep 9272
oracle    9272     1  0 Jun07 ?        00:07:39 /oracle/ogg/19/replicat PARAMFILE /oracle/ogg/19/dirprm/r1.prm REPORTFILE /oracle/ogg/19/dirrpt/R1.rpt PROCESSID R1
oracle    9283  9272  0 Jun07 ?        00:36:23 oracledb12 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

kill -STOP 9272 ============== PID

GGSCI (19c) 6> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                          
REPLICAT    RUNNING     R1          00:00:00      00:01:09  !!!! wait

GGSCI (19c) 7> info r1 detail

REPLICAT   R1        Last Started 2021-06-07 21:55   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:01:13 ago)  !!!! wait
Process ID           9272
Log Read Checkpoint  File ./dirdat/12000086
                     2021-06-10 21:28:24.145418  RBA 15758167

kill -CONT 9272 ============== PID

GGSCI (19c) 9> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                          
REPLICAT    RUNNING     R1          00:00:00      00:00:01

급한데로 stop 하지 않고 일시 정지 하고 작업
18.204.2.146


  LIST

제목 작성자 작성일 조회
Admin  진행중.    최길호 2008/11/26 108
Admin  [ 필요 하신게 있으시면 Login 하시고 쪽지 또는 gilho.kr@gmail.com 메일 주세요~ ]    최길호 2006/07/14 129
Admin  10g to 19c    최길호 2021/06/24 5
Troubleshoot  Error ORA-235 occurred during an un-locked control file    최길호 2021/06/21 29
Troubleshoot  OGG-02028 Failed to attach to logmining server / ORA-24347: Warning of a NULL column in an aggregate function.    최길호 2021/06/21 17
Oracle GoldenGate  ORA-16014 [ STANDBY_LOGFILE case ]    최길호 2021/06/20 25
Troubleshoot  ACFS RAC DB tempfile ORA-01157: cannot identify/lock data file 201    최길호 2021/06/19 26
Troubleshoot  SecuveTOS 관련 오류 [ node (1), waittime / node(1) is down. rcfg(6) / connect failed, rc 9 ] lv:9   최길호 2021/06/18 17
Admin  Oracle Solaris , Oracle Database compatibility [    최길호 2021/06/17 24
Admin  Oracle 19c [ Oracle Solaris 11.4 ,11.3 ] [ Oracle Solaris 10 에러 ]    최길호 2021/06/17 30
Troubleshoot  PRVG-11322 INS-30060    최길호 2021/06/17 19
Script  asm rm archivelog / alter diskgroup drop file archivelog / asm archivelog    최길호 2021/06/17 18
Troubleshoot  ORA-16225: Missing LogMiner session name for Capture    최길호 2021/06/16 24
Troubleshoot  ORA-16191: Primary log shipping client not logged on standby    최길호 2021/06/16 22

    목록보기   다음페이지 1 [2][3][4][5][6][7][8][9][10]..[135]   [다음 10개]
       

Copyright 1999-2021 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
2019/05/02
pkg 확인 SELECT * FROM AL...
by 최길호
2018/05/18
Name Type ...
by 최길호
2018/01/07
ORA-00020: maximum number of...
by 최길호
최근 게시물
06/24
[ORACLE]
10g to 19c.
by 최길호
06/21
[ORACLE]
Error ORA-235 occurred during ....
by 최길호
06/02
[운영체제]
lsblk [ disk mount view ].
by 최길호