您的位置: 首页  >  文章  >  OGG-00446  Opening file +ARCHDG/1_8600_986573398.dbf in DBLOGREADER mode:

OGG-00446  Opening file +ARCHDG/1_8600_986573398.dbf in DBLOGREADER mode:

分类: 文章 • 2024-12-18 20:02:22

2019-05-23 12:26:06  INFO    OGG-01513  Positioning to (Thread 1) Sequence 8600, RBA 1248584720, SCN 3665.3268383914 (15744323523754).

Source Context :
  SourceModule            : [gglib.ggdatasource.DataSource]
  SourceID                : [/scratch/jkrath/view_storage/jkrath_soncustvew/oggcore/OpenSys/src/gglib/ggdatasource/DataSource.cpp]
  SourceFunction          : [establishStartPoint]
  SourceLine              : [175]
  ThreadBacktrace         : [11] elements
                          : [/ogg/12c/libgglog.so(CMessageContext::AddThreadContext()+0x1b) [0x7fc12df6120b]]
                          : [/ogg/12c/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x134) [0x7fc12df5bd74]]
                          : [/ogg/12c/libgglog.so(_MSG_ERR_CHECKPOINT_GENERIC(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x30) [0x7fc12df31634]]
                          : [/ogg/12c/extract(ggs::gglib::ggdatasource::DataSource::establishStartPoint(time_elt_def&, time_elt_def&)+0xef) [0x87fe4f]]
                          : [/ogg/12c/extract() [0x6ef0e1]]
                          : [/ogg/12c/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x60) [0x752c80]]
                          : [/ogg/12c/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x14d) [0x753d5d]]
                          : [/ogg/12c/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0xb1) [0x753e41]]
                          : [/ogg/12c/extract(main+0x3b) [0x6eff1b]]
                          : [/lib64/libc.so.6(__libc_start_main+0xfd) [0x3396a1ed1d]]
                          : [/ogg/12c/extract() [0x69aed1]]

2019-05-23 12:27:21  ERROR   OGG-00446  Opening file +ARCHDG/1_8600_986573398.dbf in DBLOGREADER mode: (308) ORA-00308: cannot open archived log '+ARCHDG/1_8600_986573398.dbf'
ORA-17503: ksfdopn:2 Failed to open file +ARCHDG/1_8600_986573398.dbf
ORA-15173: entry '1_8600_986573398.dbf' does not exist in directory '/'
Not able to establish initial position for sequence 8600, rba 1248584720.

2019-05-23 12:27:21  ERROR   OGG-01668  PROCESS ABENDING.
 

 

OGG-00446  Opening file +ARCHDG/1_8600_986573398.dbf in DBLOGREADER mode:

OGG-00446  Opening file +ARCHDG/1_8600_986573398.dbf in DBLOGREADER mode:

RUN {
allocate channel D1 type 'sbt_tape' parms 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
allocate channel D2 type 'sbt_tape' parms 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
send 'NB_ORA_SERV=nbuserver,NB_ORA_CLIENT=rac2';
restore archivelog from logseq 8599 until logseq 8600 thread 1;
restore archivelog from logseq 6657 until logseq 6658 thread 2;
RELEASE CHANNEL D1;
RELEASE CHANNEL D2;
}

重新启动ogg


GGSCI (racj1) 2> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     STOPPED     GDCQ        00:00:01      00:15:51    
EXTRACT     RUNNING     T180        00:00:00      00:00:04    
EXTRACT     RUNNING     T245        00:00:00      00:00:04    
EXTRACT     RUNNING     T247        00:00:00      00:00:04    


GGSCI (racj1) 3> info gdcq

EXTRACT    GDCQ      Last Started 2019-04-25 10:40   Status STOPPED
Checkpoint Lag       00:00:01 (updated 00:15:56 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2019-05-23 12:25:30  Thread 1, Seqno 8605, RBA 8787968
                     SCN 3665.3275908919 (15744331048759)
Log Read Checkpoint  Oracle Redo Logs
                     2019-05-23 12:25:29  Thread 2, Seqno 6661, RBA 1802134720
                     SCN 3665.3275908396 (15744331048236)

GGSCI (racj1) 4> info gdcq,showch

EXTRACT    GDCQ      Last Started 2019-04-25 10:40   Status STOPPED
Checkpoint Lag       00:00:01 (updated 00:16:27 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2019-05-23 12:25:30  Thread 1, Seqno 8605, RBA 8787968
                     SCN 3665.3275908919 (15744331048759)
Log Read Checkpoint  Oracle Redo Logs
                     2019-05-23 12:25:29  Thread 2, Seqno 6661, RBA 1802134720
                     SCN 3665.3275908396 (15744331048236)


Current Checkpoint Detail:

Read Checkpoint #1

  Oracle Threaded Redo Log

  Startup Checkpoint (starting position in the data source):
    Thread #: 1
    Sequence #: 1502
    RBA: 774553616
    Timestamp: 2018-12-20 20:29:53.000000
    SCN: 3663.2300224544 (15734765429792)
    Redo File: +DATADG/gddb/onlinelog/group_2.280.986638897

  Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
    Thread #: 1
    Sequence #: 8600
    RBA: 1248584720
    Timestamp: 2019-05-23 09:49:30.000000
    SCN: 3665.3268383914 (15744323523754)
    Redo File: Not Available

  Current Checkpoint (position of last record read in the data source):
    Thread #: 1
    Sequence #: 8605
    RBA: 8787968
    Timestamp: 2019-05-23 12:25:30.000000
    SCN: 3665.3275908919 (15744331048759)
    Redo File: +DATADG/gddb/onlinelog/group_3.283.986639037

  BR Previous Recovery Checkpoint:
    Thread #: 1
    Sequence #: 7405
    RBA: 824907792
    Timestamp: 2019-04-25 07:45:16.000000
    SCN: 3665.853644984 (15741908784824)
    Redo File: 

  BR Begin Recovery Checkpoint:
    Thread #: 1
    Sequence #: 8597
    RBA: 414644752
    Timestamp: 2019-05-23 08:05:58.000000
    SCN: 3665.3264423494 (15744319563334)
    Redo File: 

  BR End Recovery Checkpoint:
    Thread #: 1
    Sequence #: 8602
    RBA: 852460544
    Timestamp: 2019-05-23 10:54:48.000000
    SCN: 3665.3271588561 (15744326728401)
    Redo File: 

Read Checkpoint #2

  Oracle Threaded Redo Log

  Startup Checkpoint (starting position in the data source):
    Thread #: 2
    Sequence #: 26
    RBA: 27651088
    Timestamp: 2018-12-20 20:28:48.000000
    SCN: 3663.2300224543 (15734765429791)
    Redo File: +DATADG/gddb/onlinelog/group_9.278.986638859

  Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
    Thread #: 2
    Sequence #: 6660
    RBA: 1787930128
    Timestamp: 2019-05-23 12:05:35.000000
    SCN: 3665.3275178717 (15744330318557)
    Redo File: Not Available

  Current Checkpoint (position of last record read in the data source):
    Thread #: 2
    Sequence #: 6661
    RBA: 1802134720
    Timestamp: 2019-05-23 12:25:29.000000
    SCN: 3665.3275908396 (15744331048236)
    Redo File: Not Available

  BR Previous Recovery Checkpoint:
    Thread #: 2
    Sequence #: 5183
    RBA: 1626514448
    Timestamp: 2019-04-25 06:04:10.000000
    SCN: 3665.845942702 (15741901082542)
    Redo File: 

  BR Begin Recovery Checkpoint:
    Thread #: 2
    Sequence #: 6659
    RBA: 53605904
    Timestamp: 2019-05-23 10:05:44.000000
    SCN: 3665.3269116842 (15744324256682)
    Redo File: 

  BR End Recovery Checkpoint:
    Thread #: 2
    Sequence #: 6660
    RBA: 579546112
    Timestamp: 2019-05-23 10:54:47.000000
    SCN: 3665.3271587537 (15744326727377)
    Redo File: 

Write Checkpoint #1

  GGS Log Trail

  Current Checkpoint (current write position):
    Sequence #: 6010
    RBA: 4201068
    Timestamp: 2019-05-23 12:25:31.896925
    Extract Trail: ./dirdat/gd
    Seqno Length: 6
    Flip Seqno Length: No
    Trail Type: EXTTRAIL

Header:
  Version = 2
  Record Source = A
  Type = 11
  # Input Checkpoints = 2
  # Output Checkpoints = 1

File Information:
  Block Size = 2048
  Max Blocks = 100
  Record Length = 4096
  Current Offset = 0

Configuration:
  Data Source = 3
  Transaction Integrity = 1
  Task Type = 0

Status:
  Start Time = 2019-04-25 10:40:31
  Last Update Time = 2019-05-23 12:25:31
  Stop Status = G
  Last Result = 0

GGSCI (racj1) 5> 

OGG-00446  Opening file +ARCHDG/1_8600_986573398.dbf in DBLOGREADER mode:

OGG-00446  Opening file +ARCHDG/1_8600_986573398.dbf in DBLOGREADER mode:

OGG-00446  Opening file +ARCHDG/1_8600_986573398.dbf in DBLOGREADER mode:

OGG-00446  Opening file +ARCHDG/1_8600_986573398.dbf in DBLOGREADER mode:

相关推荐