{"id":1290,"date":"2014-08-01T11:11:55","date_gmt":"2014-08-01T03:11:55","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=1290"},"modified":"2014-08-01T11:11:55","modified_gmt":"2014-08-01T03:11:55","slug":"%e6%b5%85%e6%9e%90scn","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=1290","title":{"rendered":"\u6d45\u6790scn"},"content":{"rendered":"<p>1.\u4ec0\u4e48\u662fscn<br \/>\n\u7cfb\u7edf\u66f4\u6539\u53f7\uff08system change number\uff09\uff0c\u6709\u7684\u53eb\u505a system commit number\uff0c\u8fd9\u4e2a\u53eb\u6cd5\u5176\u5b9e\u5e76\u4e0d\u51c6\u786e\u3002scn\u662foracle\u7684\u5185\u90e8\u5355\u8c03\u9012\u589e\u7684\u5e8f\u5217\u65f6\u949f\uff1bscn\u786e\u4fdd\u4e8b\u52a1\u7684acid\u3010\u539f\u5b50\u6027\uff08Atomicity\uff09\u3001\u4e00\u81f4\u6027\uff08Consistency\uff09\u3001\u9694\u79bb\u6027\uff08Isolation\uff09\u3001\u6301\u4e45\u6027\uff08Durability\uff09\u3011\u6027\u8d28\uff1bscn\u5728\u5b9e\u4f8b\u6062\u590d\u4e2d\u53ef\u4ee5\u5254\u9664\u6389\u65e0\u7528\u7684\u65e5\u5fd7\uff0c\u53ef\u4ee5\u7075\u6d3b\u901a\u8fc7scn\u8fdb\u884c\u4e0d\u5b8c\u5168\u6062\u590d\uff1b\u6bcf\u4e2a\u4e8b\u52a1\u90fd\u542b\u6709scn\u3002<br \/>\n2.scn\u5206\u51e0\u7c7b<br \/>\n2.1 \u4ee5\u4e0bscn\u8bb0\u5f55\u5728\u63a7\u5236\u6587\u4ef6\u4e2d<br \/>\n2.1.1 \u6570\u636e\u5e93scn<br \/>\n\u5728\u63a7\u5236\u6587\u4ef6\u4e2d\u8bb0\u5f55\u7684\u6700\u8fd1\u4e00\u6b21\u7684\u5168\u91cfcheckpoint\u7684scn<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nsys@ora11gr2&gt; alter system checkpoint;\r\n\r\nSystem altered.\r\n\r\nsys@ora11gr2&gt; select CHECKPOINT_CHANGE# from v$database;\r\n\r\nCHECKPOINT_CHANGE#\r\n------------------\r\n           1320426\r\n\r\n1 row selected.\r\n<\/pre>\n<p>dump\u63a7\u5236\u6587\u4ef6\u5934<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nsys@ora11gr2&gt; @dump_ctl_hdrs_scn_by_dd 8192 \/u01\/app\/oracle\/oradata\/ora11gr2\/control01.ctl\r\n001425ea\r\n\r\nsys@ora11gr2&gt; select conversion_api.to_dec(&#039;001425ea&#039;) from dual;\r\n\r\nCONVERSION_API.TO_DEC(&#039;001425EA&#039;)\r\n---------------------------------\r\n                          1320426\r\n\r\n1 row selected.\r\n\r\nsys@ora11gr2&gt; @dump_ctl 2\r\nold   1: ALTER SESSION SET EVENTS &#039;IMMEDIATE TRACE NAME CONTROLF LEVEL &amp;&amp;1&#039;\r\nnew   1: ALTER SESSION SET EVENTS &#039;IMMEDIATE TRACE NAME CONTROLF LEVEL 2&#039;\r\n\r\nSession altered.\r\n\r\n\r\nTRACE_FILE_NAME\r\n----------------------------------------------------------------------------------------------------\r\n\/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_ora_12275.trc\r\n\r\n1 row selected.\r\n\r\nDisconnected from Oracle 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\n[oracle@rhl6 dba_scripts]$ more \/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_ora_12275.trc \r\n... ...\r\n***************************************************************************\r\nDATABASE ENTRY\r\n***************************************************************************\r\n (size = 316, compat size = 316, section max = 1, section in-use = 1,\r\n  last-recid= 0, old-recno = 0, last-recno = 0)\r\n (extent = 1, blkno = 1, numrecs = 1)\r\n 12\/25\/2012 10:27:51\r\n DB Name &quot;ORA11GR2&quot;\r\n Database flags = 0x00404001 0x00001200\r\n Controlfile Creation Timestamp  12\/25\/2012 10:27:56\r\n Incmplt recovery scn: 0x0000.00000000\r\n Resetlogs scn: 0x0000.00000001 Resetlogs Timestamp  12\/25\/2012 10:27:51\r\n Prior resetlogs scn: 0x0000.00000000 Prior resetlogs Timestamp  01\/01\/1988 00:00:00\r\n Redo Version: compatible=0xb200000\r\n #Data files = 5, #Online files = 5\r\n Database checkpoint: Thread=1 scn: 0x0000.001425ea\t\t\t\/\/1320426\r\n Threads: #Enabled=1, #Open=1, Head=1, Tail=1\t\t\t\t\r\n... ...\r\n\r\n<\/pre>\n<p>2.1.2 \u6570\u636e\u6587\u4ef6\u5934scn<br \/>\n\u8fd9\u4e2ascn\u5c31\u662f\u5224\u65ad\u63a7\u5236\u6587\u4ef6\u548c\u6570\u636e\u6587\u4ef6\u662f\u5426\u4e00\u81f4\u7684\u6807\u51c6\u4e4b\u4e00\u3002<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nsys@ora11gr2&gt; col name for a50\r\nsys@ora11gr2&gt; select FILE#,CHECKPOINT_CHANGE#,name from v$datafile order by 1;\r\n\r\n     FILE# CHECKPOINT_CHANGE# NAME\r\n---------- ------------------ --------------------------------------------------\r\n         1            1320426 \/u01\/app\/oracle\/oradata\/ora11gr2\/system01.dbf\r\n         2            1320426 \/u01\/app\/oracle\/oradata\/ora11gr2\/sysaux01.dbf\r\n         3            1320426 \/u01\/app\/oracle\/oradata\/ora11gr2\/undotbs01.dbf\r\n         4            1320426 \/u01\/app\/oracle\/oradata\/ora11gr2\/users01.dbf\r\n         5            1320426 \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf\r\n\r\n5 rows selected.\r\n\r\nsys@ora11gr2&gt; select FILE#,CHECKPOINT_CHANGE# from v$datafile_header order by 1;\r\n\r\n     FILE# CHECKPOINT_CHANGE#\r\n---------- ------------------\r\n         1            1320426\r\n         2            1320426\r\n         3            1320426\r\n         4            1320426\r\n         5            1320426\r\n\r\n5 rows selected.\r\n\r\nsys@ora11gr2&gt; @dump_ctl 3\r\nold   1: ALTER SESSION SET EVENTS &#039;IMMEDIATE TRACE NAME CONTROLF LEVEL &amp;&amp;1&#039;\r\nnew   1: ALTER SESSION SET EVENTS &#039;IMMEDIATE TRACE NAME CONTROLF LEVEL 3&#039;\r\n\r\nSession altered.\r\n\r\n\r\nTRACE_FILE_NAME\r\n----------------------------------------------------------------------------------------------------\r\n\/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_ora_12302.trc\r\n\r\n1 row selected.\r\n\r\n***************************************************************************\r\nDATA FILE RECORDS\r\n***************************************************************************\r\n (size = 520, compat size = 520, section max = 100, section in-use = 5,\r\n  last-recid= 28, old-recno = 0, last-recno = 0)\r\n (extent = 1, blkno = 11, numrecs = 100)\r\nDATA FILE #1: \r\n  name #4: \/u01\/app\/oracle\/oradata\/ora11gr2\/system01.dbf\r\ncreation size=89600 block size=8192 status=0xe head=4 tail=4 dup=1\r\n tablespace 0, index=1 krfil=1 prev_file=0\r\n unrecoverable scn: 0x0000.00000000 01\/01\/1988 00:00:00\r\n Checkpoint cnt:319 scn: 0x0000.001425ea 07\/15\/2014 09:51:01\t\t\/\/1320426\r\n Stop scn: 0xffff.ffffffff 07\/15\/2014 09:04:41\r\n Creation Checkpointed at scn:  0x0000.00000029 12\/25\/2012 10:30:40\r\n thread:1 rba:(0x1.3.10)\r\n ... ...\r\nDATA FILE #5: \r\n  name #9: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf\r\ncreation size=128 block size=8192 status=0xe head=9 tail=9 dup=1\r\n tablespace 5, index=6 krfil=5 prev_file=0\r\n unrecoverable scn: 0x0000.00000000 01\/01\/1988 00:00:00\r\n Checkpoint cnt:246 scn: 0x0000.001425ea 07\/15\/2014 09:51:01\t\t\/\/1320426\r\n Stop scn: 0xffff.ffffffff 07\/15\/2014 09:04:41\r\n Creation Checkpointed at scn:  0x0000.000bbca7 12\/17\/2013 14:44:15\r\n thread:1 rba:(0x44.b23a.10)\r\n<\/pre>\n<p>\u4e0b\u8fb92\u4e2a\u662f\u4ece\u6570\u636e\u6587\u4ef6\u5934\u4e2d\u63d0\u53d6scn <\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nsys@ora11gr2&gt; @dump_datafile_hdrs_scn_by_dd 8192 \/u01\/app\/oracle\/oradata\/ora11gr2\/system01.dbf\r\n001425ea\r\n\r\nsys@ora11gr2&gt; @dump_datafile_hdrs_scn_by_dd 8192 \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf\r\n001425ea\r\n\r\nsys@ora11gr2&gt; @dump_datafile_hdrs\r\n\r\nSystem altered.\r\n\r\n\r\nTRACE_FILE_NAME\r\n----------------------------------------------------------------------------------------------------\r\n\/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_ora_12447.trc\r\n\r\n1 row selected.\r\n\r\n[oracle@rhl6 dba_scripts]$ more \/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_ora_12447.trc\r\n... ... \r\nDUMP OF DATA FILES: 5 files in database\r\n \r\nDATA FILE #1: \r\n  name #4: \/u01\/app\/oracle\/oradata\/ora11gr2\/system01.dbf\r\ncreation size=89600 block size=8192 status=0xe head=4 tail=4 dup=1\r\n tablespace 0, index=1 krfil=1 prev_file=0\r\n unrecoverable scn: 0x0000.00000000 01\/01\/1988 00:00:00\r\n Checkpoint cnt:319 scn: 0x0000.001425ea 07\/15\/2014 09:51:01\t\t\/\/1320426\r\n Stop scn: 0xffff.ffffffff 07\/15\/2014 09:04:41\r\n Creation Checkpointed at scn:  0x0000.00000029 12\/25\/2012 10:30:40\r\n thread:1 rba:(0x1.3.10) \r\n... ...\r\nDATA FILE #5: \r\n  name #9: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf\r\ncreation size=128 block size=8192 status=0xe head=9 tail=9 dup=1\r\n tablespace 5, index=6 krfil=5 prev_file=0\r\n unrecoverable scn: 0x0000.00000000 01\/01\/1988 00:00:00\r\n Checkpoint cnt:246 scn: 0x0000.001425ea 07\/15\/2014 09:51:01\t\t\/\/1320426\r\n Stop scn: 0xffff.ffffffff 07\/15\/2014 09:04:41\r\n Creation Checkpointed at scn:  0x0000.000bbca7 12\/17\/2013 14:44:15\r\n thread:1 rba:(0x44.b23a.10)\r\n ... ...\r\n \r\n\r\nBBED&gt; d \/v dba 1,1 offset 484 count 4\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/system01.dbf (1)\r\n Block: 1       Offsets:  484 to  487  Dba:0x00400001\r\n-------------------------------------------------------\r\n ea251400                            l \u00ea%..\t\t\t\t\t\t\t\/\/001425ea=1320426\r\n &lt;16 bytes per line&gt;\r\n\r\nBBED&gt; d \/v dba 5,1 offset 484 count 4\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/yallonking01.dbf (5)\r\n Block: 1       Offsets:  484 to  487  Dba:0x01400001\r\n-------------------------------------------------------\r\n ea251400                            l \u00ea%..\t\t\t\t\t\t\t\/\/001425ea=1320426\r\n\r\n &lt;16 bytes per line&gt; \r\n \r\nsys@ora11gr2&gt; select FHFNO,FHSCN from x$kcvfh order by 1;\r\n\r\n     FHFNO FHSCN\r\n---------- ----------------\r\n         1 1320426\r\n         2 1320426\r\n         3 1320426\r\n         4 1320426\r\n         5 1320426\r\n\r\n5 rows selected.\r\n\r\n<\/pre>\n<p>2.1.3 checkpoint\u8bb0\u5f55\u7684\u6700\u65b0\u7684scn<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nsys@ora11gr2&gt; @dump_ctl 3\r\nold   1: ALTER SESSION SET EVENTS &#039;IMMEDIATE TRACE NAME CONTROLF LEVEL &amp;&amp;1&#039;\r\nnew   1: ALTER SESSION SET EVENTS &#039;IMMEDIATE TRACE NAME CONTROLF LEVEL 3&#039;\r\n\r\nSession altered.\r\n\r\n\r\nTRACE_FILE_NAME\r\n----------------------------------------------------------------------------------------------------\r\n\/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_ora_12403.trc\r\n\r\n1 row selected.\r\n[oracle@rhl6 dba_scripts]$ more \/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_ora_12403.trc\r\n... ...\r\n***************************************************************************\r\nCHECKPOINT PROGRESS RECORDS\r\n***************************************************************************\r\n (size = 8180, compat size = 8180, section max = 11, section in-use = 0,\r\n  last-recid= 0, old-recno = 0, last-recno = 0)\r\n (extent = 1, blkno = 2, numrecs = 11)\r\nTHREAD #1 - status:0x2 flags:0x0 dirty:32\r\nlow cache rba:(0xde.7b9.0) on disk rba:(0xde.937.0)\r\non disk scn: 0x0000.00142929 07\/15\/2014 10:11:49\r\n... ...\r\n\r\nsys@ora11gr2&gt; select conversion_api.to_dec(&#039;00142929&#039;) from dual;\r\n\r\nCONVERSION_API.TO_DEC(&#039;00142929&#039;)\r\n---------------------------------\r\n                          1321257\r\n\t\t\t\t\t\t  \r\nsys@ora11gr2&gt; select CHECKPOINT_CHANGE# from v$database;\r\n\r\nCHECKPOINT_CHANGE#\r\n------------------\r\n           1320426\r\n\r\n1 row selected.\t\t\t\t\t\t  \r\n\r\n<\/pre>\n<p>2.2 \u6570\u636e\u5757\u53d8\u5316\u65f6\u7684scn<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nsys@ora11gr2&gt; desc yallonking\r\n Name                                                  Null?    Type\r\n ----------------------------------------------------- -------- ------------------------------------\r\n ID                                                             NUMBER\r\n NAME                                                           VARCHAR2(20)\r\n\r\nsys@ora11gr2&gt; select * from yallonking;\r\n\r\nno rows selected\r\n\r\nsys@ora11gr2&gt; insert into yallonking values(1,&#039;yallonking&#039;);\r\n\r\n1 row created.\r\n\r\nsys@ora11gr2&gt; commit;\r\n\r\nCommit complete.\r\n\r\nsys@ora11gr2&gt; select t.rowid,t.* from yallonking t;\r\n\r\nROWID                      ID NAME\r\n------------------ ---------- --------------------\r\nAAARgJAABAAATipAAB          1 yallonking\r\n\r\n1 row selected.\r\n\r\nsys@ora11gr2&gt; select get_rowid(&#039;AAARgJAABAAATipAAB&#039;) from dual;\r\n\r\nGET_ROWID(&#039;AAARGJAABAAATIPAAB&#039;)\r\n----------------------------------------------------------------------------------------------------\r\nRow_id type is  :1\r\nObject# is      :71689\r\nRelative_fno is :1\r\nBlock number is :80041\r\nRow number is   :1\r\n\r\n\r\n1 row selected.\r\n\r\n\r\nBBED&gt; d \/v dba 1,80041 offset 8 count 6\r\n File: \/u01\/app\/oracle\/oradata\/ora11gr2\/system01.dbf (1)\r\n Block: 80041   Offsets:    8 to   13  Dba:0x004138a9\r\n-------------------------------------------------------\r\n 727c1100 0000                       l r|....\t\t\t\/\/00117c72\r\n\r\n &lt;16 bytes per line&gt;\r\n\r\n \r\nsys@ora11gr2&gt; @dump_file_by_block 1 80041\r\nold   1: alter system dump datafile &amp;&amp;1 block &amp;&amp;2\r\nnew   1: alter system dump datafile 1 block 80041\r\n\r\nSystem altered.\r\n\r\n\r\nTRACE_FILE_NAME\r\n----------------------------------------------------------------------------------------------------\r\n\/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_ora_12526.trc\r\n\r\n1 row selected.\r\n[oracle@rhl6 dba_scripts]$ more \/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_ora_12526.trc\r\n... ...\r\nStart dump data blocks tsn: 0 file#:1 minblk 80041 maxblk 80041\r\nBlock dump from cache:\r\nDump of buffer cache at level 4 for tsn=0 rdba=4274345\r\nBH (0x88be1a78) file#: 1 rdba: 0x004138a9 (1\/80041) class: 1 ba: 0x88906000\r\n  set: 3 pool: 3 bsz: 8192 bsi: 0 sflg: 2 pwc: 405,28\r\n  dbwrid: 0 obj: 71689 objn: 71689 tsn: 0 afn: 1 hint: f\r\n  hash: [0x968d0e20,0x968d0e20] lru: [0x88be1c90,0x88be1a30]\r\n  obj-flags: object_ckpt_list\r\n  ckptq: [0x8d3f25a8,0x96b03520] fileq: [0x96b03540,0x96b03540] objq: [0x9315ccf0,0x9315ccf0] objaq: [0x88be1cc8,0x9315ccd0]\r\n  st: XCURRENT md: NULL fpin: &#039;kdswh01: kdstgr&#039; tch: 4\r\n  flags: buffer_dirty redo_since_read\r\n  LRBA: [0xde.9a9.0] LSCN: [0x0.142b84] HSCN: [0x0.142b84] HSUB: [1]\r\nBlock dump from disk:\r\nbuffer tsn: 0 rdba: 0x004138a9 (1\/80041)\r\nscn: 0x0000.00117c72 seq: 0x02 flg: 0x06 tail: 0x7c720602\t\/\/00117c72\t\t\t\r\n... ...\r\n<\/pre>\n<p>2.3 \u65e5\u5fd7\u6587\u4ef6\u5934\u4e2d\u7684scn<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nsys@ora11gr2&gt; select FIRST_CHANGE#,NEXT_CHANGE# from v$log where GROUP#=1;\r\n\r\nFIRST_CHANGE# NEXT_CHANGE#\r\n------------- ------------\r\n      1270429      1290688\r\n\r\n1 row selected.\r\n\r\n\r\nsys@ora11gr2&gt; @dump_logfile_hdrs\r\n\r\nSession altered.\r\n\r\n\r\nTRACE_FILE_NAME\r\n----------------------------------------------------------------------------------------------------\r\n\/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_ora_12681.trc\r\n\r\n1 row selected.\r\n\r\n[oracle@rhl6 dba_scripts]$ more \/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_ora_12681.trc\r\n... ...\r\nDUMP OF LOG FILES: 3 logs in database\r\nLOG FILE #1: \r\n  name #1: \/u01\/app\/oracle\/oradata\/ora11gr2\/redo01.log\r\n Thread 1 redo log links: forward: 2 backward: 0\r\n siz: 0x19000 seq: 0x000000dc hws: 0x8 bsz: 512 nab: 0x55 flg: 0x1 dup: 1\r\n Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.0013629a\r\n Low scn: 0x0000.0013629d 07\/14\/2014 16:40:36\t\t\t\/\/FIRST_CHANGE#(1270429)\t\t\t\r\n Next scn: 0x0000.0013b1c0 07\/14\/2014 17:55:18\t\t\t\/\/NEXT_CHANGE#(1290688)\r\n FILE HEADER:\r\n        Compatibility Vsn = 186646528=0xb200000\r\n        Db ID=119524391=0x71fcc27, Db Name=&#039;ORA11GR2&#039;\r\n        Activation ID=119541799=0x7201027\r\n        Control Seq=4139=0x102b, File size=102400=0x19000\r\n        File Number=1, Blksiz=512, File Type=2 LOG\r\n... ...\r\n<\/pre>\n<p>2.4 \u4e8b\u52a1scn<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nyallonking@ora11gr2&gt; show user\r\nUSER is &quot;YALLONKING&quot;\r\nyallonking@ora11gr2&gt; select * from yallonking;\r\n\r\n        ID NAME\r\n---------- --------------------\r\n         1 yallonking\r\n\r\n1 row selected.\r\n\r\nyallonking@ora11gr2&gt; update yallonking set name =&#039;oraking&#039; where id=1;\r\n\r\n1 row updated.\r\n\r\nyallonking@ora11gr2&gt; select * from yallonking;\r\n\r\n        ID NAME\r\n---------- --------------------\r\n         1 oraking\r\n\t\t \r\n\r\n\t\t \r\n\t\t \r\nsys@ora11gr2&gt; select ADDR,XIDUSN,XIDSLOT,XIDSQN,UBAFIL,UBABLK,UBASQN,UBAREC,STATUS,START_SCN from v$transaction;\r\n\r\nADDR                 XIDUSN    XIDSLOT     XIDSQN     UBAFIL     UBABLK     UBASQN     UBAREC STATUS            START_SCN\r\n---------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------------- ----------\r\n0000000095A45B30          8         23        809          3       1064        270         29 ACTIVE              1322847\t\t\/\/scn:00142f5f\r\n\r\n1 row selected.\r\n\r\nsys@ora11gr2&gt; select * from V$ROLLNAME where USN=8;\r\n\r\n       USN NAME\r\n---------- ------------------------------\r\n         8 _SYSSMU8_1994096333$\r\n\r\n1 row selected.\r\n\r\nsys@ora11gr2&gt; oradebug setmypid\r\nStatement processed.\r\nsys@ora11gr2&gt; alter system dump undo header &#039;_SYSSMU8_1994096333$&#039;;\r\n\r\nSystem altered.\r\n\r\nsys@ora11gr2&gt; oradebug tracefile_name\r\n\/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_ora_12714.trc\r\n\r\n\r\n[oracle@rhl6 dba_scripts]$ more \/u01\/app\/oracle\/diag\/rdbms\/ora11gr2\/ora11gr2\/trace\/ora11gr2_ora_12714.trc\r\n... ...\r\n  index  state cflags  wrap#    uel         scn            dba            parent-xid    nub     stmt_num    cmt\r\n  ------------------------------------------------------------------------------------------------\r\n   0x17   10    0x80  0x0329  0x0002  0x0000.00142f5f  0x00c00428  0x0000.000.00000000  0x00000001   0x00000000  0\r\n... ...\r\n<\/pre>\n<p>2.5 \u5185\u5b58\u4e2d\u7684scn<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nsys@ora11gr2&gt; select current_scn from v$database;\r\n\r\nCURRENT_SCN\r\n-----------\r\n    1323873\r\n\r\n1 row selected.\r\n\r\n<\/pre>\n<p>3.scn\u4f8b\u5b50<br \/>\n\u8fd9\u4e2a\u4f8b\u5b50\u662f\u901a\u8fc7\u4fee\u6539scn\u8df3\u8fc7\u7f3a\u5931\u7684\u5f52\u6863\u65e5\u5fd7\u6062\u590d\u6570\u636e\u5e93\u3002<br \/>\nhttp:\/\/www.yallonking.com\/?p=1032<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1.\u4ec0\u4e48\u662fscn \u7cfb\u7edf\u66f4\u6539\u53f7\uff08system change number\uff09\uff0c\u6709\u7684\u53eb\u505a system commit [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[87],"tags":[],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1290"}],"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=1290"}],"version-history":[{"count":2,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1290\/revisions"}],"predecessor-version":[{"id":1292,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1290\/revisions\/1292"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1290"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1290"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1290"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}