\u8868\u7ea7\u65e5\u5fd7\u6a21\u5f0f\u5bf9\u6bd4
\n\u8be5\u6587\u6863\u6d4b\u8bd5\u6570\u636e\u5e93\u5f00\u542f\u8868\u7ea7\u65e5\u5fd7\u6a21\u5f0f\u548c\u6ca1\u6709\u5f00\u542f\u65f6\uff0c\u5728\u5bf9\u8868update\u64cd\u4f5c\u65f6\u4ea7\u751f\u7684redo\u65e5\u5fd7\u8bb0\u5f55\u7684\u4e0d\u540c
\n\u80cc\u666f\uff1a\u7531\u4e8e\u4e00\u4e2a\u540c\u4e8b\u5728\u4e4b\u524d\u914d\u7f6eogg\u65f6\u6ca1\u6709\u5f00\u542f\u6e90\u7aef\u8868\u7ea7\u65e5\u5fd7\u6a21\u5f0f\uff0c\u5bfc\u81f4\u4ece\u6e90\u7aef\u4f20\u8fc7\u6765\u7684\u548cupdate\u76f8\u5173\u64cd\u4f5c\u7684\u8bb0\u5f55\u6e90\u7aef\u548c\u5bf9\u7aef\u4e0d\u4e00\u81f4\u3002<\/p>\n
\u4e0b\u8fb9\u662fOGG\u5bf9\u6570\u636e\u5e93\u7ea7\u65e5\u5fd7\u6a21\u5f0f\u548c\u8868\u7ea7\u65e5\u5fd7\u6a21\u5f0f\u7684\u8bf4\u660e<\/p>\n
\u9996\u5148\u662f\u6570\u636e\u5e93\u7ea7\u7684\u8bf4\u660e\uff1a<\/p>\n
\r\nWhen replicating from Oracle databases, you need to enable database-level supplemental logging on the\r\nsource database. Remember that if you\u2019re using bidirectional replication, you need to enable\r\nsupplemental logging on both the source and the target databases. The supplemental logging is required\r\nto ensure that Oracle adds additional information to the redo logs that is required by GoldenGate.\r\n\r\nFor Oracle 9i, SUPPLEMENTAL_LOG_DATA_MIN must be YES. For Oracle 10g and later, SUPPLEMENTAL_LOG_DATA \r\nmust be YES or IMPLICIT. Now that you\u2019ve verified that database-level supplemental logging\r\nisn\u2019t currently enabled, you can enter the commands to make it enabled.\r\n<\/pre>\n\u4e0b\u8fb9\u662f\u5173\u4e8e\u8868\u7ea7\u65e5\u5fd7\u6a21\u5f0f\u7684\u8bf4\u660e\uff1a<\/p>\n
\r\nNormally, databases such as Oracle, DB2, and SQL Server don\u2019t log enough data in the transaction logs\r\nfor GoldenGate to be able to successfully replicate the change to the target database. GoldenGate\r\nrequires the key values in addition to the changed data in order for the GoldenGate Replicat to apply the\r\nchanged data to the target database. Adding supplemental logging to the source database tables ensures\r\nthat the database logs the key values that GoldenGate needs in order to properly apply the updates on\r\nthe target database.\r\n\r\nYou can use the GoldenGate ADD TRANDATA command to force the database to log primary-key\r\ncolumns for all updates on your source database. You don\u2019t need to enable supplemental logging on the\r\ntarget database for one-way replication.\r\n<\/pre>\n\u53c2\u8003\u6587\u6863\uff1a
\n\u4e34\u5371\u4e0d\u60e7\uff1aoracle 11g \u6570\u636e\u5e93\u6062\u590d\u6280\u672f \u5305\u5149\u78ca
\nExport Oracle GoldenGate<\/p>\n\u4e0b\u8fb9\u662f\u8be6\u7ec6\u7684\u6bd4\u5bf9\u8fc7\u7a0b\uff1a
\n\u9996\u5148\u662f\u6ca1\u6709\u5f00\u542f\u8868\u7ea7\u65e5\u5fd7\u8bb0\u5f55\u7684\u60c5\u51b5\uff1a<\/strong><\/p>\n\r\nSQL> sho user\r\nUSER is "SYS"\r\nSQL> select SUPPLEMENTAL_LOG_DATA_MIN,SUPPLEMENTAL_LOG_DATA_PK,SUPPLEMENTAL_LOG_DATA_UI,SUPPLEMENTAL_LOG_DATA_PL,SUPPLEMENTAL_LOG_DATA_FK,SUPPLEMENTAL_LOG_DATA_ALL,LOG_MODE from v$database;\r\n\r\nSUPPLEME SUP SUP SUP SUP SUP LOG_MODE\r\n-------- --- --- --- --- --- ------------\r\nNO NO NO NO NO NO ARCHIVELOG\r\n\r\nSQL> alter system flush BUFFER_CACHE;\r\n\r\nSystem altered.\r\n\r\nSQL> col member for a50\r\nSQL> select a.GROUP#,THREAD#,SEQUENCE#,a.STATUS,b.MEMBER from v$log a,v$logfile b where a.GROUP# =b.GROUP# ;\r\n\r\n GROUP# THREAD# SEQUENCE# STATUS MEMBER\r\n---------- ---------- ---------- ---------------- --------------------------------------------------\r\n 1 1 97 INACTIVE \/u01\/app\/oracle\/oradata\/ora11gr2\/redo01.log\r\n 2 1 98 INACTIVE \/u01\/app\/oracle\/oradata\/ora11gr2\/redo02.log\r\n 3 1 99 CURRENT \/u01\/app\/oracle\/oradata\/ora11gr2\/redo03.log\r\n\r\nSQL> sho user\r\nUSER is "YALLONKING"\r\nSQL> select rowid,t.* from yallonking t;\r\n\r\nROWID ID NAME MY_DATE AGE\r\n------------------ ---------- -------------------- --------- ----------\r\nAAARciAAFAAAACHAAA 1 yallonking 22-JUL-13 26\r\nAAARciAAFAAAACHAAB 2 oraking 22-JUL-13 26\r\nAAARciAAFAAAACHAAC 3 xiaolong 22-JUL-13 26\r\n\r\nSQL> update yallonking set age=25 where id=1;\r\n\r\n1 row updated.\r\n\r\nSQL> commit;\r\n\r\nCommit complete.\r\n\r\nSQL> sho user\r\nUSER is "SYS"\r\nSQL> select a.GROUP#,THREAD#,SEQUENCE#,a.STATUS,b.MEMBER from v$log a,v$logfile b where a.GROUP# =b.GROUP# ;\r\n\r\n GROUP# THREAD# SEQUENCE# STATUS MEMBER\r\n---------- ---------- ---------- ---------------- --------------------------------------------------\r\n 1 1 97 INACTIVE \/u01\/app\/oracle\/oradata\/ora11gr2\/redo01.log\r\n 2 1 98 INACTIVE \/u01\/app\/oracle\/oradata\/ora11gr2\/redo02.log\r\n 3 1 99 CURRENT \/u01\/app\/oracle\/oradata\/ora11gr2\/redo03.log\r\n\r\nSQL> select get_rowid('AAARciAAFAAAACHAAA') from dual;\r\n\r\nGET_ROWID('AAARCIAAFAAAACHAAA')\r\n--------------------------------------------------------------------------------\r\nRow_id type is :1\r\nObject# is :71458\r\nRelative_fno is :5\r\nBlock number is :135\r\nRow number is :0\r\n\r\nSQL> alter session set tracefile_identifier='wyl';\r\n\r\nSession altered.\r\n\r\nSQL> alter system dump logfile '\/u01\/app\/oracle\/oradata\/ora11gr2\/redo03.log' dba min 5 135 dba max 5 300;\r\n\r\nSystem altered.\r\n<\/pre>\n\u4ee5\u4e0b\u4e3a\u5b8c\u5168\u7684trace\u6587\u4ef6<\/p>\n
\r\n[oracle@rhl6 trace]$ pwd;cat ora11gr2_ora_2114_wyl.trc\r\n\/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\r\nTrace file \/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_ora_2114_wyl.trc\r\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\nORACLE_HOME = \/u01\/app\/oracle\/product\/11.2.0\/db_1\r\nSystem name: Linux\r\nNode name: rhl6.0x64\r\nRelease: 2.6.32-71.el6.x86_64\r\nVersion: #1 SMP Wed Sep 1 01:33:01 EDT 2010\r\nMachine: x86_64\r\nVM name: VMWare Version: 6\r\nInstance name: ora11gr2\r\nRedo thread mounted by this instance: 1\r\nOracle process number: 30\r\nUnix process pid: 2114, image: oracle@rhl6.0x64 (TNS V1-V3)\r\n\r\n\r\n*** 2013-08-28 13:42:11.532\r\n*** SESSION ID:(41.25) 2013-08-28 13:42:11.532\r\n*** CLIENT ID:() 2013-08-28 13:42:11.532\r\n*** SERVICE NAME:(SYS$USERS) 2013-08-28 13:42:11.532\r\n*** MODULE NAME:(sqlplus@rhl6.0x64 (TNS V1-V3)) 2013-08-28 13:42:11.532\r\n*** ACTION NAME:() 2013-08-28 13:42:11.532\r\n \r\n\r\n*** TRACE CONTINUED FROM FILE \/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_ora_2114.trc ***\r\n\r\nInitial buffer sizes: read 1024K, overflow 832K, change 805K\r\nLog read is SYNCHRONOUS though disk_asynch_io is enabled!\r\n \r\nDUMP OF REDO FROM FILE '\/u01\/app\/oracle\/oradata\/ora11gr2\/redo03.log'\r\n Opcodes *.*\r\n DBAs: (file # 5, block # 135) thru (file # 5, block # 300)\r\n RBAs: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff\r\n SCNs: scn: 0x0000.00000000 thru scn: 0xffff.ffffffff\r\n Times: creation thru eternity\r\n FILE HEADER:\r\n Compatibility Vsn = 186646528=0xb200000\r\n Db ID=119524391=0x71fcc27, Db Name='ORA11GR2'\r\n Activation ID=119541799=0x7201027\r\n Control Seq=992=0x3e0, File size=102400=0x19000\r\n File Number=3, Blksiz=512, File Type=2 LOG\r\n descrip:"Thread 0001, Seq# 0000000099, SCN 0x0000000c03e2-0xffffffffffff"\r\n thread: 1 nab: 0xffffffff seq: 0x00000063 hws: 0x1 eot: 1 dis: 0\r\n resetlogs count: 0x2fdc16a7 scn: 0x0000.00000001 (1)\r\n prev resetlogs count: 0x0 scn: 0x0000.00000000\r\n Low scn: 0x0000.000c03e2 (787426) 08\/28\/2013 13:29:28\r\n Next scn: 0xffff.ffffffff 01\/01\/1988 00:00:00\r\n Enabled scn: 0x0000.00000001 (1) 12\/25\/2012 10:28:49\r\n Thread closed scn: 0x0000.000c03e2 (787426) 08\/28\/2013 13:29:28\r\n Disk cksum: 0x85f2 Calc cksum: 0x85f2\r\n Terminal recovery stop scn: 0x0000.00000000\r\n Terminal recovery 01\/01\/1988 00:00:00\r\n Most recent redo scn: 0x0000.00000000\r\n Largest LWN: 0 blocks\r\n End-of-redo stream : No\r\n Unprotected mode\r\n Miscellaneous flags: 0x800000\r\n Thread internal enable indicator: thr: 0, seq: 0 scn: 0x0000.00000000\r\n Zero blocks: 0\r\n Format ID is 2\r\n redo log key is 6ba8b4cb653aab92bc9bcc4bcff4c7\r\n redo log key flag is 5\r\n Enabled redo threads: 1 \r\n \r\nREDO RECORD - Thread:1 RBA: 0x000063.00000ac8.0010 LEN: 0x0278 VLD: 0x0d\r\nSCN: 0x0000.000c06de SUBSCN: 1 08\/28\/2013 13:37:01\r\n(LWN RBA: 0x000063.00000ac8.0010 LEN: 0002 NST: 0001 SCN: 0x0000.000c06dc)\r\nCHANGE #1 TYP:2 CLS:1 AFN:5 DBA:0x01400087 OBJ:71458 SCN:0x0000.000c03a8 SEQ:4 OP:11.19 ENC:0 RBL:0\r\nKTB Redo \r\nop: 0x11 ver: 0x01 \r\ncompat bit: 4 (post-11) padding: 1\r\nop: F xid: 0x0006.010.00000367 uba: 0x00c000df.00b0.1f\r\nBlock cleanout record, scn: 0x0000.000c06dd ver: 0x01 opt: 0x02, entries follow...\r\n itli: 2 flg: 2 scn: 0x0000.000c03a8\r\nArray Update of 1 rows: \r\ntabn: 0 slot: 0(0x0) flag: 0x2c lock: 1 ckix: 9\t\t\/\/\u7b2c\u4e00\u884c[slot: 0(0x0)]\r\nncol: 4 nnew: 1 size: 0\r\nKDO Op code: 21 row dependencies Disabled\r\n xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01400087 hdba: 0x01400082\r\nitli: 1 ispac: 0 maxfr: 4858\r\nvect = 22\r\ncol 3: [ 2] c1 1a\t\t\t\/\/\u4fee\u6539\u540e\u503c:\u7b2c4\u5217\u7684\u503c\uff0c\u957f\u5ea6\u4e3a2\uff1ac11a(\u5341\u8fdb\u5236\uff1a25)\r\nCHANGE #2 TYP:0 CLS:27 AFN:3 DBA:0x00c000d0 OBJ:4294967295 SCN:0x0000.000c06c0 SEQ:1 OP:5.2 ENC:0 RBL:0\r\nktudh redo: slt: 0x0010 sqn: 0x00000367 flg: 0x0012 siz: 188 fbi: 0\r\n uba: 0x00c000df.00b0.1f pxid: 0x0000.000.00000000\r\nCHANGE #3 TYP:0 CLS:27 AFN:3 DBA:0x00c000d0 OBJ:4294967295 SCN:0x0000.000c06de SEQ:1 OP:5.4 ENC:0 RBL:0\r\nktucm redo: slt: 0x0010 sqn: 0x00000367 srt: 0 sta: 9 flg: 0x12 ktucf redo: uba: 0x00c000df.00b0.1f ext: 1 spc: 3576 fbi: 0 \r\nCHANGE #4 TYP:0 CLS:28 AFN:3 DBA:0x00c000df OBJ:4294967295 SCN:0x0000.000c06bf SEQ:1 OP:5.1 ENC:0 RBL:0\r\nktudb redo: siz: 188 spc: 3766 flg: 0x0012 seq: 0x00b0 rec: 0x1f\r\n xid: 0x0006.010.00000367 \r\nktubl redo: slt: 16 rci: 0 opc: 11.1 [objn: 71458 objd: 71458 tsn: 5]\r\nUndo type: Regular undo Begin trans Last buffer split: No \r\nTemp Object: No \r\nTablespace Undo: No \r\n 0x00000000 prev ctl uba: 0x00c000df.00b0.1e \r\nprev ctl max cmt scn: 0x0000.000c04c2 prev tx cmt scn: 0x0000.000c04d6 \r\ntxn start scn: 0x0000.000c03a8 logon user: 80 prev brb: 12583134 prev bcl: 0 BuExt idx: 0 flg2: 0\r\nKDO undo record:\r\nKTB Redo \r\nop: 0x04 ver: 0x01 \r\ncompat bit: 4 (post-11) padding: 1\r\nop: L itl: xid: 0x0005.015.000002a9 uba: 0x00c0342c.0097.25\r\n flg: C--- lkc: 0 scn: 0x0000.000b9935\r\nArray Update of 1 rows: \r\ntabn: 0 slot: 0(0x0) flag: 0x2c lock: 0 ckix: 9\t\t\/\/\u7b2c\u4e00\u884c[slot: 0(0x0)]\r\nncol: 4 nnew: 1 size: 0\r\nKDO Op code: 21 row dependencies Disabled\r\n xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01400087 hdba: 0x01400082\r\nitli: 1 ispac: 0 maxfr: 4858\r\nvect = 22\r\ncol 3: [ 2] c1 1b\t\t\t\/\/\u4fee\u6539\u524d\u503c:\u7b2c4\u5217\u7684\u503c,\u957f\u5ea6\u4e3a2\uff1ac11a(\u5341\u8fdb\u5236\uff1a26)\r\n \r\nREDO RECORD - Thread:1 RBA: 0x000063.00000aed.0010 LEN: 0x0070 VLD: 0x06\r\nSCN: 0x0000.000c0753 SUBSCN: 1 08\/28\/2013 13:42:04\r\n(LWN RBA: 0x000063.00000aed.0010 LEN: 0001 NST: 0001 SCN: 0x0000.000c0753)\r\nCHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:23.1 ENC:0\r\n Block Written - afn: 5 rdba: 0x01400087 BFT:(1024,20971655) non-BFT:(5,135)\r\n scn: 0x0000.000c06de seq: 0x02 flg:0x06\r\nEND OF REDO DUMP\r\n----- Redo read statistics for thread 1 -----\r\nRead rate (SYNC): 1398Kb in 0.01s => 136.52 Mb\/sec\r\nTotal redo bytes: 2047Kb Longest record: 12Kb, moves: 1\/2348 moved: 0Mb (0%)\r\nLongest LWN: 444Kb, reads: 218 \r\nLast redo scn: 0x0000.000c0753 (788307)\r\nChange vector header moves = 310\/4558 (6%)\r\n----------------------------------------------\r\n<\/pre>\n\u4e0b\u8fb9\u662f\u5f00\u542f\u8868\u7ea7\u65e5\u5fd7\u8bb0\u5f55\u7684\u6a21\u5f0f\uff1a<\/strong><\/p>\n
\r\nSQL> sho user\r\nUSER is "SYS"\r\n\r\nSQL> select * from yallonking.yallonking;\r\n\r\n ID NAME MY_DATE AGE\r\n---------- -------------------- --------- ----------\r\n 1 yallonking 22-JUL-13 25\r\n 2 oraking 22-JUL-13 26\r\n 3 xiaolong 22-JUL-13 26\r\n\r\nSQL> alter system archive log current;\r\n\r\nSystem altered.\r\n\r\nSQL> alter system switch logfile;\r\n\r\nSystem altered.\r\n\r\nSQL> alter database add supplemental log data;\r\n\r\nDatabase altered.\r\n\r\nSQL> alter table yallonking.yallonking add supplemental log data (all) columns;\r\n\r\nTable altered.\r\n\r\nSQL> select * from dba_log_groups;\r\n\r\nOWNER LOG_GROUP_NAME TABLE_NAME LOG_GROUP_TYPE ALWAYS GENERATED\r\n---------- ------------------------------ -------------------- ---------------------------- ----------- --------------\r\nSYS ENC$_LOG_GRP ENC$ USER LOG GROUP ALWAYS USER NAME\r\nYALLONKING SYS_C008080 YALLONKING ALL COLUMN LOGGING ALWAYS GENERATED NAME\r\n\r\n\r\nSQL> sho user\r\nUSER is "YALLONKING"\r\nSQL> select * from yallonking;\r\n\r\n ID NAME MY_DATE AGE\r\n---------- -------------------- --------- ----------\r\n 1 yallonking 22-JUL-13 25\r\n 2 oraking 22-JUL-13 26\r\n 3 xiaolong 22-JUL-13 26\r\n\r\nSQL> update yallonking set age=28 where id=3;\r\n\r\n1 row updated.\r\n\r\nSQL> commit;\r\n\r\nCommit complete.\r\n\r\nSQL> select rowid,t.* from yallonking t;\r\n\r\nROWID ID NAME MY_DATE AGE\r\n------------------ ---------- -------------------- --------- ----------\r\nAAARciAAFAAAACHAAA 1 yallonking 22-JUL-13 25\r\nAAARciAAFAAAACHAAB 2 oraking 22-JUL-13 26\r\nAAARciAAFAAAACHAAC 3 xiaolong 22-JUL-13 28\r\n\r\nSQL> sho user\r\nUSER is "SYS"\r\nSQL> select a.GROUP#,THREAD#,SEQUENCE#,a.STATUS,b.MEMBER from v$log a,v$logfile b where a.GROUP# =b.GROUP# ;\r\n\r\n GROUP# THREAD# SEQUENCE# STATUS MEMBER\r\n---------- ---------- ---------- ---------------- --------------------------------------------------\r\n 1 1 100 INACTIVE \/u01\/app\/oracle\/oradata\/ora11gr2\/redo01.log\r\n 2 1 101 CURRENT \/u01\/app\/oracle\/oradata\/ora11gr2\/redo02.log\r\n 3 1 99 INACTIVE \/u01\/app\/oracle\/oradata\/ora11gr2\/redo03.log\r\n\t\t \r\nSQL> select get_rowid('AAARciAAFAAAACHAAC') from dual;\r\n\r\nGET_ROWID('AAARCIAAFAAAACHAAC')\r\n--------------------------------------------------------------------------------\r\nRow_id type is :1\r\nObject# is :71458\r\nRelative_fno is :5\r\nBlock number is :135\r\nRow number is :2\r\n\r\nSQL> alter session set tracefile_identifier='wyl2';\r\n\r\nSession altered.\r\n\r\nSQL> alter system dump logfile '\/u01\/app\/oracle\/oradata\/ora11gr2\/redo02.log' dba min 5 135 dba max 5 300;\r\n\r\nSystem altered.\t\t \r\n<\/pre>\n\u4ee5\u4e0b\u4e3atrace\u6587\u4ef6<\/p>\n
\r\n[oracle@rhl6 trace]$ pwd;cat ora11gr2_ora_2373_wyl2.trc\r\n\/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\r\nTrace file \/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_ora_2373_wyl2.trc\r\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\nORACLE_HOME = \/u01\/app\/oracle\/product\/11.2.0\/db_1\r\nSystem name: Linux\r\nNode name: rhl6.0x64\r\nRelease: 2.6.32-71.el6.x86_64\r\nVersion: #1 SMP Wed Sep 1 01:33:01 EDT 2010\r\nMachine: x86_64\r\nVM name: VMWare Version: 6\r\nInstance name: ora11gr2\r\nRedo thread mounted by this instance: 1\r\nOracle process number: 30\r\nUnix process pid: 2373, image: oracle@rhl6.0x64 (TNS V1-V3)\r\n\r\n\r\n*** 2013-08-28 14:35:36.072\r\n*** SESSION ID:(33.35) 2013-08-28 14:35:36.072\r\n*** CLIENT ID:() 2013-08-28 14:35:36.072\r\n*** SERVICE NAME:(SYS$USERS) 2013-08-28 14:35:36.072\r\n*** MODULE NAME:(sqlplus@rhl6.0x64 (TNS V1-V3)) 2013-08-28 14:35:36.072\r\n*** ACTION NAME:() 2013-08-28 14:35:36.072\r\n \r\nInitial buffer sizes: read 1024K, overflow 832K, change 805K\r\nLog read is SYNCHRONOUS though disk_asynch_io is enabled!\r\n \r\nDUMP OF REDO FROM FILE '\/u01\/app\/oracle\/oradata\/ora11gr2\/redo02.log'\r\n Opcodes *.*\r\n DBAs: (file # 5, block # 135) thru (file # 5, block # 300)\r\n RBAs: 0x000000.00000000.0000 thru 0xffffffff.ffffffff.ffff\r\n SCNs: scn: 0x0000.00000000 thru scn: 0xffff.ffffffff\r\n Times: creation thru eternity\r\n FILE HEADER:\r\n Compatibility Vsn = 186646528=0xb200000\r\n Db ID=119524391=0x71fcc27, Db Name='ORA11GR2'\r\n Activation ID=119541799=0x7201027\r\n Control Seq=1003=0x3eb, File size=102400=0x19000\r\n File Number=2, Blksiz=512, File Type=2 LOG\r\n descrip:"Thread 0001, Seq# 0000000101, SCN 0x0000000c0bb3-0xffffffffffff"\r\n thread: 1 nab: 0xffffffff seq: 0x00000065 hws: 0x1 eot: 1 dis: 0\r\n resetlogs count: 0x2fdc16a7 scn: 0x0000.00000001 (1)\r\n prev resetlogs count: 0x0 scn: 0x0000.00000000\r\n Low scn: 0x0000.000c0bb3 (789427) 08\/28\/2013 14:18:33\r\n Next scn: 0xffff.ffffffff 01\/01\/1988 00:00:00\r\n Enabled scn: 0x0000.00000001 (1) 12\/25\/2012 10:28:49\r\n Thread closed scn: 0x0000.000c0bb3 (789427) 08\/28\/2013 14:18:33\r\n Disk cksum: 0x3c9 Calc cksum: 0x3c9\r\n Terminal recovery stop scn: 0x0000.00000000\r\n Terminal recovery 01\/01\/1988 00:00:00\r\n Most recent redo scn: 0x0000.00000000\r\n Largest LWN: 0 blocks\r\n End-of-redo stream : No\r\n Unprotected mode\r\n Miscellaneous flags: 0x800000\r\n Thread internal enable indicator: thr: 0, seq: 0 scn: 0x0000.00000000\r\n Zero blocks: 0\r\n Format ID is 2\r\n redo log key is 90877f587bf45259f1f7b6e97f6d48a\r\n redo log key flag is 5\r\n Enabled redo threads: 1 \r\n \r\nREDO RECORD - Thread:1 RBA: 0x000065.000002ac.0010 LEN: 0x0298 VLD: 0x05\r\nSCN: 0x0000.000c0ecc SUBSCN: 1 08\/28\/2013 14:32:29\r\n(LWN RBA: 0x000065.000002ac.0010 LEN: 0002 NST: 0001 SCN: 0x0000.000c0ecb)\r\nCHANGE #1 TYP:0 CLS:17 AFN:3 DBA:0x00c00080 OBJ:4294967295 SCN:0x0000.000c0e28 SEQ:1 OP:5.2 ENC:0 RBL:0\r\nktudh redo: slt: 0x0011 sqn: 0x000002be flg: 0x0012 siz: 228 fbi: 0\r\n uba: 0x00c036f6.0092.37 pxid: 0x0000.000.00000000\r\nCHANGE #2 TYP:0 CLS:18 AFN:3 DBA:0x00c036f6 OBJ:4294967295 SCN:0x0000.000c0e27 SEQ:2 OP:5.1 ENC:0 RBL:0\r\nktudb redo: siz: 228 spc: 1890 flg: 0x0012 seq: 0x0092 rec: 0x37\r\n xid: 0x0001.011.000002be \r\nktubl redo: slt: 17 rci: 0 opc: 11.1 [objn: 71458 objd: 71458 tsn: 5]\r\nUndo type: Regular undo Begin trans Last buffer split: No \r\nTemp Object: No \r\nTablespace Undo: No \r\n 0x00000000 prev ctl uba: 0x00c036f6.0092.35 \r\nprev ctl max cmt scn: 0x0000.000c08ee prev tx cmt scn: 0x0000.000c08f8 \r\ntxn start scn: 0xffff.ffffffff logon user: 80 prev brb: 12596981 prev bcl: 0 BuExt idx: 0 flg2: 0\r\nKDO undo record:\r\nKTB Redo \r\nop: 0x04 ver: 0x01 \r\ncompat bit: 4 (post-11) padding: 1\r\nop: L itl: xid: 0x000a.00d.000002a9 uba: 0x00c001cd.00ba.2d\r\n flg: C--- lkc: 0 scn: 0x0000.000c03a8\r\nKDO Op code: URP row dependencies Disabled\r\n xtype: XA flags: 0x00000000 bdba: 0x01400087 hdba: 0x01400082\r\nitli: 2 ispac: 0 maxfr: 4858\r\ntabn: 0 slot: 2(0x2) flag: 0x2c lock: 0 ckix: 0\t\t\/\/\u7b2c3\u884c[slot: 2(0x2)]\r\nncol: 4 nnew: 1 size: 0\r\ncol 3: [ 2] c1 1b\t\t\/\/\u4fee\u6539\u524d\u503c\uff1a\u7b2c4\u5217\uff1ac11b(\u5341\u8fdb\u5236\u768426)\r\nCHANGE #3 TYP:2 CLS:1 AFN:5 DBA:0x01400087 OBJ:71458 SCN:0x0000.000c06de SEQ:2 OP:11.5 ENC:0 RBL:0\r\nKTB Redo \r\nop: 0x01 ver: 0x01 \r\ncompat bit: 4 (post-11) padding: 1\r\nop: F xid: 0x0001.011.000002be uba: 0x00c036f6.0092.37\r\nKDO Op code: URP row dependencies Disabled\r\n xtype: XA flags: 0x00000000 bdba: 0x01400087 hdba: 0x01400082\r\nitli: 2 ispac: 0 maxfr: 4858\r\ntabn: 0 slot: 2(0x2) flag: 0x2c lock: 2 ckix: 0\t\t\/\/\u7b2c3\u884c[slot: 2(0x2)]\r\nncol: 4 nnew: 1 size: 0\r\ncol 3: [ 2] c1 1d\t\t\/\/\u4fee\u6539\u540e\u503c\uff1a\u7b2c4\u5217\uff1ac11d(\u5341\u8fdb\u5236\u768428)\r\nCHANGE #4 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:5.19 ENC:0\t\t\/\/\u4ee5\u4e0b\u4f1a\u8bb0\u5f55\u6bd4\u8f83\u8be6\u7ec6\u7684\u4fee\u6539\u8005\u7684\u4fe1\u606f\u3002\r\nsession number = 1\r\nserial number = 21\r\ncurrent username = YALLONKING\r\nlogin username = YALLONKING\r\nclient info = \r\nOS username = oracle\r\nMachine name = rhl6.0x64\r\nOS terminal = pts\/1\r\nOS process id = 1769\r\nOS program name = sqlplus@rhl6.0x64 (TNS V1-V3)\r\ntransaction name = \r\nversion 186647296\r\naudit sessionid 50038\r\nClient Id = \r\nEND OF REDO DUMP\r\n----- Redo read statistics for thread 1 -----\r\nRead rate (SYNC): 344Kb in 0.01s => 33.64 Mb\/sec\r\nTotal redo bytes: 1023Kb Longest record: 8Kb, moves: 0\/1135 moved: 0Mb (0%)\r\nLongest LWN: 77Kb, reads: 88 \r\nLast redo scn: 0x0000.000c0efb (790267)\r\nChange vector header moves = 147\/2201 (6%)\r\n----------------------------------------------\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"\u8868\u7ea7\u65e5\u5fd7\u6a21\u5f0f\u5bf9\u6bd4 \u8be5\u6587\u6863\u6d4b\u8bd5\u6570\u636e\u5e93\u5f00\u542f\u8868\u7ea7\u65e5\u5fd7\u6a21\u5f0f\u548c\u6ca1\u6709\u5f00\u542f\u65f6\uff0c\u5728\u5bf9\u8868update\u64cd\u4f5c\u65f6\u4ea7\u751f\u7684redo\u65e5\u5fd7\u8bb0\u5f55 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[35],"tags":[238,239],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1117"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1117"}],"version-history":[{"count":7,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1117\/revisions"}],"predecessor-version":[{"id":1125,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1117\/revisions\/1125"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1117"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1117"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}