STANDBY数据库不用应用日志,请问是什么原因?

bitao

问题如题

下面是LOG的信息,请大家帮忙看看

alter database mount standby database
Sat Sep 30 11:57:11 2006
Successful mount of redo thread 1, with mount id 683601939.
Sat Sep 30 11:57:11 2006
Standby Database mounted.
Completed:  alter database mount standby database
Sat Sep 30 11:58:05 2006
RFS: Possible network disconnect with primary database
Sat Sep 30 12:02:24 2006
alter database recover managed standby database disconnect from session
Sat Sep 30 12:02:24 2006
Attempt to start background Managed Standby Recovery process
MRP0 started with pid=14
MRP0: Background Managed Standby Recovery process started
Starting datafile 1 recovery in thread 1 sequence 3232
Datafile 1: '/opt/oracle/oradata/jxcd/system01.dbf'
Starting datafile 2 recovery in thread 1 sequence 3232
Datafile 2: '/opt/oracle/oradata/jxcd/undotbs01.dbf'
Starting datafile 3 recovery in thread 1 sequence 3232
Datafile 3: '/opt/oracle/oradata/jxcd/drsys01.dbf'
Starting datafile 4 recovery in thread 1 sequence 3232
Datafile 4: '/opt/oracle/oradata/jxcd/indx01.dbf'
Starting datafile 5 recovery in thread 1 sequence 3232
Datafile 5: '/opt/oracle/oradata/jxcd/tools01.dbf'
Starting datafile 6 recovery in thread 1 sequence 3232
Datafile 6: '/opt/oracle/oradata/jxcd/users01.dbf'
Starting datafile 7 recovery in thread 1 sequence 3232
Datafile 7: '/opt/oracle/oradata/jxcd/xdb01.dbf'
Starting datafile 8 recovery in thread 1 sequence 3232
Datafile 8: '/opt/oracle/oradata/jxcd/smartdata01.dbf'
Starting datafile 9 recovery in thread 1 sequence 3232
Datafile 9: '/opt/oracle/oradata/jxcd/smartdata02.dbf'
Starting datafile 10 recovery in thread 1 sequence 3232
Datafile 10: '/opt/oracle/oradata/jxcd/smartdata03.dbf'
Starting datafile 11 recovery in thread 1 sequence 3232
Datafile 11: '/opt/oracle/oradata/jxcd/smartdata04.dbf'
Starting datafile 12 recovery in thread 1 sequence 3232
Datafile 12: '/opt/oracle/oradata/jxcd/smartdata05.dbf'
Starting datafile 13 recovery in thread 1 sequence 3232
Datafile 13: '/opt/oracle/oradata/jxcd/smartdata06.dbf'
Starting datafile 14 recovery in thread 1 sequence 3232
Datafile 14: '/opt/oracle/oradata/jxcd/smartdata_his01.dbf'
Starting datafile 15 recovery in thread 1 sequence 3232
Datafile 15: '/opt/oracle/oradata/jxcd/smartdata_his02.dbf'
Starting datafile 16 recovery in thread 1 sequence 3232
Datafile 16: '/opt/oracle/oradata/jxcd/smartdata_his03.dbf'
Starting datafile 17 recovery in thread 1 sequence 3232
Datafile 17: '/opt/oracle/oradata/jxcd/smartdata_his04.dbf'
Starting datafile 18 recovery in thread 1 sequence 3232
Datafile 18: '/opt/oracle/oradata/jxcd/smartindex_his01.dbf'
Starting datafile 19 recovery in thread 1 sequence 3232
Datafile 19: '/opt/oracle/oradata/jxcd/smartindex_his02.dbf'
Starting datafile 20 recovery in thread 1 sequence 3232
Datafile 20: '/opt/oracle/oradata/jxcd/smartindex01.dbf'
Starting datafile 21 recovery in thread 1 sequence 3232
Datafile 21: '/opt/oracle/oradata/jxcd/smarttemp01.dbf'
Starting datafile 22 recovery in thread 1 sequence 3232
Datafile 22: '/opt/oracle/oradata/jxcd/smartdata07.dbf'
Media Recovery Waiting for thread 1 seq# 3232
Sat Sep 30 12:02:30 2006
Completed: alter database recover managed standby database di
Sat Sep 30 12:03:27 2006
RFS: No standby redo logfiles available
RFS: No standby redo logfiles created
Sat Sep 30 12:03:30 2006
Fetching gap sequence for thread 1, gap sequence 3232-3233
Trying FAL server: dbmain
Media Recovery Log /archfile/oracle/admin/jxcd/arch/JXCD00010001S3232.ARC
Media Recovery Log /archfile/oracle/admin/jxcd/arch/JXCD00010001S3233.ARC
Sat Sep 30 12:03:46 2006
Errors in file /opt/oracle/admin/jxcd/bdump/jxcd_mrp0_18285.trc:
ORA-00600: internal error code, arguments: [3020], [8523345], [1], [3233], [43], [16], [], []
ORA-10567: Redo is inconsistent with data block (file# 2, block# 134737)
ORA-10564: tablespace UNDOTBS1
ORA-01110: data file 2: '/opt/oracle/oradata/jxcd/undotbs01.dbf'
MRP0: Background Media Recovery terminated with error 600
Sat Sep 30 12:03:47 2006
Errors in file /opt/oracle/admin/jxcd/bdump/jxcd_mrp0_18285.trc:
ORA-00600: internal error code, arguments: [3020], [8523345], [1], [3233], [43], [16], [], []
ORA-10567: Redo is inconsistent with data block (file# 2, block# 134737)
ORA-10564: tablespace UNDOTBS1
ORA-01110: data file 2: '/opt/oracle/oradata/jxcd/undotbs01.dbf'
Recovery interrupted.
Recovered data files restored to a consistent state at change 2929421.
MRP0: Background Media Recovery process shutdown
Sat Sep 30 14:50:16 2006

bitao

这个是DUMP文件的部分内容


/opt/oracle/admin/jxcd/bdump/jxcd_mrp0_18285.trc
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
ORACLE_HOME = /opt/oracle/product/9.2.0.4
System name:        Linux
Node name:        ecardstandby
Release:        2.4.21-32.ELsmp
Version:        #1 SMP Fri Apr 15 21:17:59 EDT 2005
Machine:        i686
Instance name: jxcd
Redo thread mounted by this instance: 1
Oracle process number: 14
Unix process pid: 18285, image: oracle@ecardstandby (MRP0)

*** SESSION ID13.1) 2006-09-30 12:02:24.844
Background Managed Standby Recovery process started
*** 2006-09-30 12:02:30.484
Managed Recovery: Active posted.
*** 2006-09-30 12:03:45.624
Media Recovery Log /archfile/oracle/admin/jxcd/arch/JXCD00010001S3232.ARC
Media Recovery Log /archfile/oracle/admin/jxcd/arch/JXCD00010001S3233.ARC
KCOX_FUTURE:  CHANGE IN FUTURE OF BLOCK
*** 2006-09-30 12:03:46.637
RECOVERY OF THREAD 1 STUCK AT BLOCK 134737 OF FILE 2

REDO RECORD - Thread:1 RBA: 0x000ca1.0000002b.0010 LEN: 0x0238 VLD: 0x01
SCN: 0x0000.002cb30e SUBSCN:  1 09/30/2006 00:39:11
CHANGE #2 TYP:0 CLS:32 AFN:2 DBA:0x00820e51 SCN:0x0000.002cad2d SEQ:  4 OP:5.1
buffer tsn: 1 rdba: 0x00820e51 (2/134737)
scn: 0x0000.00000000 seq: 0x01 flg: 0x01 tail: 0x00000001
frmt: 0x02 chkval: 0x0000 type: 0x00=unknown

DUMP OF REDO FROM FILE '/archfile/oracle/admin/jxcd/arch/JXCD00010001S3233.ARC'
Opcodes *.*
DBA's: (file # 2, block # 134737) thru (file # 2, block # 134737)
RBA's: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff
SCN's scn: 0x0000.00000000 thru scn: 0xffff.ffffffff
Times: creation thru eternity
FILE HEADER:
        Software vsn=153092096=0x9200000, Compatibility Vsn=153092096=0x9200000
        Db ID=679870194=0x2885fef2, Db Name='JXCD'
        Activation ID=679817714=0x288531f2
        Control Seq=14224=0x3790, File size=71680=0x11800
        File Number=1, Blksiz=512, File Type=2 LOG
descrip:"Thread 0001, Seq# 0000003233, SCN 0x0000002cb2e3-0x0000002ce6bb"
thread: 1 nab: 0x289 seq: 0x00000ca1 hws: 0x5 eot: 0 dis: 0
reset logs count: 0x23b0f972 scn: 0x0000.00000001
Low scn: 0x0000.002cb2e3 09/30/2006 00:39:02
Next scn: 0x0000.002ce6bb 09/30/2006 11:46:19
Enabled scn: 0x0000.00000001 08/18/2006 13:32:38
Thread closed scn: 0x0000.002ce6ba 09/30/2006 11:45:25
Log format vsn: 0x8000000 Disk cksum: 0x47f Calc cksum: 0x47f
Terminal Recovery Stamp scn: 0x0000.00000000 01/01/1988 00:00:00
Most recent redo scn: 0x0000.00000000
Largest LWN: 0 blocks
End-of-redo stream : No
Unprotected mode
Miscellaneous flags: 0x11

REDO RECORD - Thread:1 RBA: 0x000ca1.0000002b.0010 LEN: 0x0238 VLD: 0x01
SCN: 0x0000.002cb30e SUBSCN:  1 09/30/2006 00:39:11
CHANGE #1 TYP:0 CLS:31 AFN:2 DBA:0x00800079 SCN:0x0000.002cb2c0 SEQ:  1 OP:5.2
ktudh redo: slt: 0x0004 sqn: 0x000002cc flg: 0x0412 siz: 168 fbi: 1
            uba: 0x00820e51.013d.04    pxid:  0x0000.000.00000000
CHANGE #2 TYP:0 CLS:32 AFN:2 DBA:0x00820e51 SCN:0x0000.002cad2d SEQ:  4 OP:5.1
ktudb redo: siz: 168 spc: 7852 flg: 0x0012 seq: 0x013d rec: 0x04
            xid:  0x0008.004.000002cc  
ktubl redo: slt: 4 rci: 0 opc: 11.1 objn: 516 objd: 514 tsn: 0
Undo type:  Regular undo        Begin trans    Last buffer split:  No
Temp Object:  No
Tablespace Undo:  No
             0x00000000  prev ctl uba: 0x00820e50.013d.45
prev ctl max cmt scn:  0x0000.002ca7af  prev tx cmt scn:  0x0000.002ca80e
KDO undo record:
KTB Redo
op: 0x04  ver: 0x01  
op: L  itl: xid:  0x0008.00a.000002ce uba: 0x00820e50.013d.45
                      flg: C---    lkc:  0     scn: 0x0000.002cb2c0
KDO Op code: URP row dependencies Disabled
  xtype: XA  bdba: 0x00400e8e  hdba: 0x00400e89
itli: 2  ispac: 0  maxfr: 4863
tabn: 1 slot: 221(0xdd) flag: 0x6c lock: 0 ckix: 0
ncol: 4 nnew: 4 size: 0
col  0: [ 6]  c5 0c 3c 0a 1f 3d
col  1: [ 7]  78 6a 09 18 13 12 2a
col  2: [ 1]  80
col  3: [ 5]  c4 02 42 35 06
CHANGE #3 TYP:2 CLS: 1 AFN:1 DBA:0x00400e8e SCN:0x0000.002cb2c0 SEQ:  1 OP:11.5
KTB Redo
op: 0x11  ver: 0x01  
op: F  xid:  0x0008.004.000002cc    uba: 0x00820e51.013d.04
Block cleanout record, scn:  0x0000.002cb30e ver: 0x01 opt: 0x02, entries follow...
  itli: 2  flg: 2  scn: 0x0000.002cb2c0
KDO Op code: URP row dependencies Disabled
  xtype: XA  bdba: 0x00400e8e  hdba: 0x00400e89
itli: 2  ispac: 0  maxfr: 4863
tabn: 1 slot: 221(0xdd) flag: 0x6c lock: 2 ckix: 0
ncol: 4 nnew: 4 size: 0
col  0: [ 6]  c5 0c 3c 37 50 34
col  1: [ 7]  78 6a 09 1e 01 28 0c
col  2: [ 1]  80
col  3: [ 5]  c4 03 5d 5f 17
CHANGE #4 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:  0 OP:5.19
session number   = 5
serial  number   = 1
current username = SYS
login   username =
client info      =
OS username      = oracle
Machine name     = oramain
OS terminal      = UNKNOWN
OS process id    = 5569
OS program name  = oracle@oramain (SMON)
transaction name =
Recursive transaction

REDO RECORD - Thread:1 RBA: 0x000ca1.000000f8.0168 LEN: 0x00d4 VLD: 0x01
SCN: 0x0000.002cb34d SUBSCN:  1 09/30/2006 00:39:11
CHANGE #1 TYP:0 CLS:31 AFN:2 DBA:0x00800079 SCN:0x0000.002cb30f SEQ:  1 OP:5.2
ktudh redo: slt: 0x002d sqn: 0x000002cf flg: 0x0411 siz: 52 fbi: 0
            uba: 0x00820e51.013d.05    pxid:  0x0000.000.00000000
CHANGE #2 TYP:0 CLS:32 AFN:2 DBA:0x00820e51 SCN:0x0000.002cb30e SEQ:  1 OP:5.1
ktudb redo: siz: 52 spc: 7682 flg: 0x0012 seq: 0x013d rec: 0x05
            xid:  0x0008.02d.000002cf  
ktubl redo: slt: 45 rci: 0 opc: 5.7 objn: 0 objd: 0 tsn: 0
Undo type:  Regular undo        Begin trans    Last buffer split:  No
Temp Object:  No
Tablespace Undo:  No
             0x00000000  prev ctl uba: 0x00820e51.013d.04
prev ctl max cmt scn:  0x0000.002ca80e  prev tx cmt scn:  0x0000.002ca828
CHANGE #3 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:  0 OP:5.20
session number   = 5
serial  number   = 1
transaction name =
Recursive transaction

REDO RECORD - Thread:1 RBA: 0x000ca1.00000104.0038 LEN: 0x0238 VLD: 0x01
SCN: 0x0000.002cb484 SUBSCN:  1 09/30/2006 00:54:33
CHANGE #1 TYP:0 CLS:31 AFN:2 DBA:0x00800079 SCN:0x0000.002cb484 SEQ:  1 OP:5.2
ktudh redo: slt: 0x0013 sqn: 0x000002cf flg: 0x0412 siz: 168 fbi: 0
            uba: 0x00820e51.013d.06    pxid:  0x0000.000.00000000
CHANGE #2 TYP:0 CLS:32 AFN:2 DBA:0x00820e51 SCN:0x0000.002cb34d SEQ:  1 OP:5.1
ktudb redo: siz: 168 spc: 7628 flg: 0x0012 seq: 0x013d rec: 0x06
            xid:  0x0008.013.000002cf  
ktubl redo: slt: 19 rci: 0 opc: 11.1 objn: 516 objd: 514 tsn: 0
Undo type:  Regular undo        Begin trans    Last buffer split:  No
Temp Object:  No
Tablespace Undo:  No
             0x00000000  prev ctl uba: 0x00820e51.013d.05
prev ctl max cmt scn:  0x0000.002ca828  prev tx cmt scn:  0x0000.002ca84e
KDO undo record:
KTB Redo
op: 0x04  ver: 0x01  
op: L  itl: xid:  0x0001.002.00000218 uba: 0x00820a6a.0216.33
                      flg: C---    lkc:  0     scn: 0x0000.002cb420
KDO Op code: URP row dependencies Disabled
  xtype: XA  bdba: 0x00400e8e  hdba: 0x00400e89
itli: 2  ispac: 0  maxfr: 4863
tabn: 1 slot: 224(0xe0) flag: 0x6c lock: 0 ckix: 0
ncol: 4 nnew: 4 size: 0
col  0: [ 6]  c5 0c 3c 0a 28 52
col  1: [ 7]  78 6a 09 18 13 22 03
col  2: [ 1]  80
col  3: [ 5]  c4 02 42 38 09
CHANGE #3 TYP:2 CLS: 1 AFN:1 DBA:0x00400e8e SCN:0x0000.002cb420 SEQ:  1 OP:11.5
KTB Redo
op: 0x11  ver: 0x01  
op: F  xid:  0x0008.013.000002cf    uba: 0x00820e51.013d.06
Block cleanout record, scn:  0x0000.002cb484 ver: 0x01 opt: 0x02, entries follow...
  itli: 2  flg: 2  scn: 0x0000.002cb420
KDO Op code: URP row dependencies Disabled
  xtype: XA  bdba: 0x00400e8e  hdba: 0x00400e89
itli: 2  ispac: 0  maxfr: 4863
tabn: 1 slot: 224(0xe0) flag: 0x6c lock: 2 ckix: 0
ncol: 4 nnew: 4 size: 0
col  0: [ 6]  c5 0c 3c 37 59 48
col  1: [ 7]  78 6a 09 1e 01 37 22
col  2: [ 1]  80
col  3: [ 5]  c4 03 5d 62 61
CHANGE #4 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:  0 OP:5.19
session number   = 5
serial  number   = 1
current username = SYS
login   username =
client info      =
OS username      = oracle
Machine name     = oramain
OS terminal      = UNKNOWN
OS process id    = 5569
OS program name  = oracle@oramain (SMON)
transaction name =
Recursive transaction

REDO RECORD - Thread:1 RBA: 0x000ca1.0000010d.0010 LEN: 0x0488 VLD: 0x02
SCN: 0x0000.002cb5b6 SUBSCN:  1 09/30/2006 01:10:01
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:  0 OP:23.1
Block Written - afn: 2 rdba: 0x00800079(2,121)
                   scn: 0x0000.002cb485 seq: 0x01 flg:0x04
Block Written - afn: 2 rdba: 0x00820e51(2,134737)
                   scn: 0x0000.002cb484 seq: 0x01 flg:0x04
Block Written - afn: 1 rdba: 0x00400e8e(1,3726)
                   scn: 0x0000.002cb5b4 seq: 0x01 flg:0x06
Block Written - afn: 1 rdba: 0x00400026(1,3
                   scn: 0x0000.002cb33e seq: 0x01 flg:0x06
Block Written - afn: 1 rdba: 0x00400028(1,40)
                   scn: 0x0000.002cb33e seq: 0x01 flg:0x06
Block Written - afn: 1 rdba: 0x00400ca9(1,3241)
                   scn: 0x0000.002cb33e seq: 0x01 flg:0x06
Block Written - afn: 1 rdba: 0x00400cab(1,3243)
                   scn: 0x0000.002cb33e seq: 0x01 flg:0x06
Block Written - afn: 1 rdba: 0x00400cae(1,3246)
                   scn: 0x0000.002cb33e seq: 0x01 flg:0x06
Block Written - afn: 1 rdba: 0x00401362(1,4962)
                   scn: 0x0000.002cb33e seq: 0x01 flg:0x06
Block Written - afn: 1 rdba: 0x0040136a(1,4970)
                   scn: 0x0000.002cb33e seq: 0x01 flg:0x06
Block Written - afn: 1 rdba: 0x00401371(1,4977)
                   scn: 0x0000.002cb33e seq: 0x01 flg:0x06
Block Written - afn: 1 rdba: 0x00401386(1,499
                   scn: 0x0000.002cb33e seq: 0x01 flg:0x06
Block Written - afn: 1 rdba: 0x004031c8(1,12744)
                   scn: 0x0000.002cb33e seq: 0x01 flg:0x06
Block Written - afn: 1 rdba: 0x004031ca(1,12746)
                   scn: 0x0000.002cb33e seq: 0x01 flg:0x06
Block Written - afn: 1 rdba: 0x004031d9(1,12761)
                   scn: 0x0000.002cb33e seq: 0x01 flg:0x06
Block Written - afn: 1 rdba: 0x004031ea(1,1277
                   scn: 0x0000.002cb33e seq: 0x01 flg:0x06
Block Written - afn: 1 rdba: 0x004031f7(1,12791)
                   scn: 0x0000.002cb33e seq: 0x01 flg:0x06
Block Written - afn: 1 rdba: 0x00403201(1,12801)
                   scn: 0x0000.002cb33e seq: 0x01 flg:0x06
Block Written - afn: 2 rdba: 0x0081f44a(2,128074)
                   scn: 0x0000.002cb330 seq: 0x28 flg:0x04
Block Written - afn: 1 rdba: 0x00403207(1,12807)
                   scn: 0x0000.002cb33e seq: 0x01 flg:0x06
Block Written - afn: 1 rdba: 0x00403208(1,1280
                   scn: 0x0000.002cb33e seq: 0x01 flg:0x06

bitao

不好意思,,题目写错了..是STANDBY数据库不能应用日志

txfy

新做环境吗？建个新的undo tbs,drop 旧的，重新做个standby看看

bitao

是新做的环境,undo tbs是冷备份过来的,就没想明白为什么会出问题??