{"id":1116,"date":"2012-08-18T23:24:56","date_gmt":"2012-08-18T15:24:56","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=1116"},"modified":"2012-09-09T23:29:58","modified_gmt":"2012-09-09T15:29:58","slug":"ora-700kcbl2vfyfh_action%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=1116","title":{"rendered":"ORA-700(kcbl2vfyfh_action)\u9519\u8bef"},"content":{"rendered":"<p>ORA-600\u548cORA-7445\u7684\u9519\u8bef\u5df2\u7ecf\u53f8\u7a7a\u89c1\u60ef\u4e86\uff0c\u800cOracle\u7684ORA-700\u9519\u8bef\u8fd8\u662f\u7b2c\u4e00\u6b21\u770b\u5230\uff0c\u800c\u770b\u5230\u8fd9\u4e2a\u9519\u8bef\uff0c\u8fd8\u662f\u5728ODA\u73af\u5883\u4e2d\u770b\u5230\u7684\u3002<br \/>\n\u6570\u636e\u5e93\u73af\u5883\u4e3aODA\uff0c\u5728\u5c1d\u8bd5\u914d\u7f6eFLASH_CACHE\uff1a<\/p>\n<pre lang='SQL'>SQL> show parameter flash_\r\nNAME                                 TYPE        VALUE\r\n------------------------------------ ----------- ------------------------------\r\ndb_flash_cache_file                  string\r\ndb_flash_cache_size big              integer     0\r\ndb_flashback_retention_target        integer     1440\r\nSQL> alter system set db_flash_cache_size = 60G scope = spfile;\r\nSystem altered.\r\nSQL> alter system set db_flash_cache_file= '+REDO' scope = spfile;\r\nSystem altered.<\/pre>\n<p>\u91cd\u65b0\u542f\u52a8\u6570\u636e\u5e93\u540e\uff0c\u53d1\u73b0\u4e86\u8fd9\u4e2a\u9519\u8bef\uff1a<\/p>\n<pre lang='SQL'>Tue Aug 14 02:37:13 2012\r\nEncounter problem verifying flash cache +REDO\/flash\/abc.flash. Disable flash cache and issue an ORA-700 for diagnostics\r\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/odaenmo\/odaenmo1\/trace\/odaenmo1_gen0_25557.trc (incident=195241):\r\nORA-00700: \u8f6f\u5185\u90e8\u9519\u8bef, \u53c2\u6570: [kcbl2vfyfh_action], [db_flash_cache_file integrity check failed], [], [], [], [], [], [], [], [], [], []\r\nIncident details in: \/u01\/app\/oracle\/diag\/rdbms\/odaenmo\/odaenmo1\/incident\/incdir_195241\/odaenmo1_gen0_25557_i195241.trc\r\nTue Aug 14 02:37:14 2012\r\nTue Aug 14 02:37:14 2012<\/pre>\n<p>\u8fd9\u662f\u5b9e\u4f8b1\u4e0a\u9ad8\u7ea7\u65e5\u5fd7\u7684\u9519\u8bef\uff0c\u4e0b\u9762\u662f\u8be6\u7ec6\u7684TRACE\u4fe1\u606f\uff1a<\/p>\n<pre lang='SQL'>Dump file \/u01\/app\/oracle\/diag\/rdbms\/odaenmo\/odaenmo1\/incident\/incdir_195241\/odaenmo1_gen0_25557_i195241.trc\r\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\r\nData Mining and Real Application Testing options\r\nORACLE_HOME = \/u01\/app\/oracle\/product\/11.2.0.3\/dbhome_1\r\nSystem name:    Linux\r\nNode name:      odaenmo1\r\nRelease:        2.6.32-300.11.1.el5uek\r\nVersion:        #1 SMP Wed Mar 7 09:55:50 EST 2012\r\nMachine:        x86_64\r\nInstance name: odaenmo1\r\nRedo thread mounted by this instance: 1\r\nOracle process number: 5\r\nUnix process pid: 25557, image: oracle@odaenmo1 (GEN0)\r\n*** 2012-08-14 02:37:13.532\r\n*** SESSION ID:(3131.1) 2012-08-14 02:37:13.532\r\n*** CLIENT ID:() 2012-08-14 02:37:13.532\r\n*** SERVICE NAME:(SYS$BACKGROUND) 2012-08-14 02:37:13.532\r\n*** MODULE NAME:() 2012-08-14 02:37:13.532\r\n*** ACTION NAME:() 2012-08-14 02:37:13.532\r\nDump continued from file: \/u01\/app\/oracle\/diag\/rdbms\/odaenmo\/odaenmo1\/trace\/odaenmo1_gen0_25557.trc\r\nORA-00700: \u8f6f\u5185\u90e8\u9519\u8bef, \u53c2\u6570: [kcbl2vfyfh_action], [db_flash_cache_file integrity check failed], [], [], [], [], [], [], [], [], [], []\r\n========= Dump for incident 195241 (ORA 700 [kcbl2vfyfh_action]) ========\r\n----- Beginning of Customized Incident Dump(s) -----\r\nFlash cache parameter expected: db_unique_name odaenmo, dbid 196211168 inst_id 1, bpid 3, bsz 8192\r\nFile header db_unique_name odaenmo, dbid 196211168, inst_id 1, bpid 3, bsz 8192 filetype_str \"Oracle RDBMS Flash Cache File\"\r\n----- End of Customized Incident Dump(s) -----\r\n*** 2012-08-14 02:37:13.568\r\ndbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)\r\n----- SQL Statement (None) -----\r\nCurrent SQL information unavailable - no cursor.\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\nskdstdst()+36        call     kgdsdst()            000000000 ? 000000000 ?\r\n                                                   7FFF491BA3C8 ? 000000001 ?\r\n                                                   000000001 ? 000000002 ?\r\nksedst1()+98         call     skdstdst()           000000000 ? 000000000 ?\r\n                                                   7FFF491BA3C8 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\nksedst()+34          call     ksedst1()            000000000 ? 000000001 ?\r\n                                                   7FFF491BA3C8 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\ndbkedDefDump()+2741  call     ksedst()             000000000 ? 000000001 ?\r\n                                                   7FFF491BA3C8 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\nksedmp()+36          call     dbkedDefDump()       000000003 ? 000000002 ?\r\n                                                   7FFF491BA3C8 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\nksfdmp()+64          call     ksedmp()             000000003 ? 000000002 ?\r\n                                                   7FFF491BA3C8 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\ndbgexPhaseII()+1764  call     ksfdmp()             000000003 ? 000000002 ?\r\n                                                   7FFF491BA3C8 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\ndbgexExplicitEndInc  call     dbgexPhaseII()       7F3C50D2E710 ? 7F3C50D398C0 ?\r\n()+750                                             7FFF491C5F00 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\ndbgeEndDDEInvocatio  call     dbgexExplicitEndInc  7F3C50D2E710 ? 7F3C50D398C0 ?\r\nnImpl()+767                   ()                   7FFF491C5F00 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\ndbgeEndDDEInvocatio  call     dbgeEndDDEInvocatio  7F3C50D2E710 ? 7F3C50D398C0 ?\r\nn()+47                        nImpl()              7FFF491C5F00 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\nkcbl2vfyfh_action()  call     dbgeEndDDEInvocatio  7F3C50D2E710 ? 7F3C50D398C0 ?\r\n+3373                         n()                  7FFF491C5F00 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\nksbabs()+771         call     kcbl2vfyfh_action()  7FFF491C7738 ? 000000018 ?\r\n                                                   7FFF491C5F00 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\nksbrdp()+971         call     ksbabs()             7FFF491C7738 ? 000000018 ?\r\n                                                   7FFF491C5F00 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\nopirip()+618         call     ksbrdp()             7FFF491C7738 ? 000000018 ?\r\n                                                   7FFF491C5F00 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\nopidrv()+598         call     opirip()             000000032 ? 000000004 ?\r\n                                                   7FFF491C88F8 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\nsou2o()+98           call     opidrv()             000000032 ? 000000004 ?\r\n                                                   7FFF491C88F8 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\nopimai_real()+261    call     sou2o()              7FFF491C88D0 ? 000000032 ?\r\n                                                   000000004 ? 7FFF491C88F8 ?\r\n                                                   000000000 ? 000000002 ?\r\nssthrdmain()+252     call     opimai_real()        000000000 ? 7FFF491C8AC0 ?\r\n                                                   000000004 ? 7FFF491C88F8 ?\r\n                                                   000000000 ? 000000002 ?\r\nmain()+196           call     ssthrdmain()         000000003 ? 7FFF491C8AC0 ?\r\n                                                   000000001 ? 000000000 ?\r\n                                                   000000000 ? 000000002 ?\r\n__libc_start_main()  call     main()               000000003 ? 7FFF491C8C60 ?\r\n+244                                               000000001 ? 000000000 ?\r\n                                                   000000000 ? 000000002 ?\r\n_start()+36          call     __libc_start_main()  000A0B188 ? 000000001 ?\r\n                                                   7FFF491C8C58 ? 000000000 ?\r\n                                                   000000000 ? 000000003 ?\r\n--------------------- Binary Stack Dump ---------------------<\/pre>\n<p>\u524d\u9762\u63d0\u5230\u4e86ORA-600\u548cORA-7445\u8fd9\u79cd\u5185\u90e8\u9519\u8bef\u5f88\u5e38\u89c1\uff0c\u800c\u8fd9\u79cd\u8f6f\u5185\u90e8\u9519\u8bef\u7684ORA-700\u9519\u8bef\u8fd8\u662f\u7b2c\u4e00\u6b21\u770b\u5230\u3002<br \/>\n\u4e0b\u9762\u662f\u8282\u70b92\u4e0a\u7684\u544a\u8b66\uff1a<\/p>\n<pre lang='SQL'>2012-08-14 02:37:13.192000 +08:00\r\nEncounter problem verifying flash cache +REDO\/flash\/abc.flash. Disable flash cache and issue an ORA-700 for diagnostics\r\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/odaenmo\/odaenmo2\/trace\/odaenmo2_gen0_16906.trc (incident=416041):\r\nORA-00700: \u8f6f\u5185\u90e8\u9519\u8bef, \u53c2\u6570: [kcbl2vfyfh_action], [db_flash_cache_file integrity check failed], [], [], [], [], [], [], [], [], [], []\r\nIncident details in: \/u01\/app\/oracle\/diag\/rdbms\/odaenmo\/odaenmo2\/incident\/incdir_416041\/odaenmo2_gen0_16906_i416041.trc\r\nL2 cache disabled for dbwr 1\r\nL2 cache disabled for dbwr 2\r\nL2 cache file closed by dbwr 0\r\nL2 cache disabled for dbwr 0\r\nDumping diagnostic data in directory=[cdmp_20120814023714], requested by (instance=2, osid=16906 (GEN0)), summary=[incident=416041].\r\n2012-08-14 02:37:18.880000 +08:00\r\nDumping diagnostic data in directory=[cdmp_20120814023714], requested by (instance=1, osid=25557 (GEN0)), summary=[incident=195241].\r\n2012-08-14 02:37:55.075000 +08:00\r\nSweep [inc][416041]: completed\r\nSweep [inc2][416041]: completed<\/pre>\n<p>\u5bf9\u5e94\u7684\u8be6\u7ec6TRACE\u6587\u4ef6\u4e3a\uff1a<\/p>\n<pre lang='SQL'>Dump file \/u01\/app\/oracle\/diag\/rdbms\/odaenmo\/odaenmo2\/incident\/incdir_416041\/odaenmo2_gen0_16906_i416041.trc\r\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\r\nData Mining and Real Application Testing options\r\nORACLE_HOME = \/u01\/app\/oracle\/product\/11.2.0.3\/dbhome_1\r\nSystem name:    Linux\r\nNode name:      odaenmo2\r\nRelease:        2.6.32-300.11.1.el5uek\r\nVersion:        #1 SMP Wed Mar 7 09:55:50 EST 2012\r\nMachine:        x86_64\r\nInstance name: odaenmo2\r\nRedo thread mounted by this instance: 2\r\nOracle process number: 5\r\nUnix process pid: 16906, image: oracle@odaenmo2 (GEN0)\r\n*** 2012-08-14 02:37:13.249\r\n*** SESSION ID:(3131.1) 2012-08-14 02:37:13.249\r\n*** CLIENT ID:() 2012-08-14 02:37:13.249\r\n*** SERVICE NAME:(SYS$BACKGROUND) 2012-08-14 02:37:13.249\r\n*** MODULE NAME:() 2012-08-14 02:37:13.249\r\n*** ACTION NAME:() 2012-08-14 02:37:13.249\r\nDump continued from file: \/u01\/app\/oracle\/diag\/rdbms\/odaenmo\/odaenmo2\/trace\/odaenmo2_gen0_16906.trc\r\nORA-00700: \u8f6f\u5185\u90e8\u9519\u8bef, \u53c2\u6570: [kcbl2vfyfh_action], [db_flash_cache_file integrity check failed], [], [], [], [], [], [], [], [], [], []\r\n========= Dump for incident 416041 (ORA 700 [kcbl2vfyfh_action]) ========\r\n----- Beginning of Customized Incident Dump(s) -----\r\nFlash cache parameter expected: db_unique_name odaenmo, dbid 196211168 inst_id 2, bpid 3, bsz 8192\r\nFile header db_unique_name odaenmo, dbid 196211168, inst_id 1, bpid 3, bsz 8192 filetype_str \"Oracle RDBMS Flash Cache File\"\r\n----- End of Customized Incident Dump(s) -----\r\n*** 2012-08-14 02:37:13.284\r\ndbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)\r\n----- SQL Statement (None) -----\r\nCurrent SQL information unavailable - no cursor.\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\nskdstdst()+36        call     kgdsdst()            000000000 ? 000000000 ?\r\n                                                   7FFF7312DDF8 ? 000000001 ?\r\n                                                   000000001 ? 000000002 ?\r\nksedst1()+98         call     skdstdst()           000000000 ? 000000000 ?\r\n                                                   7FFF7312DDF8 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\nksedst()+34          call     ksedst1()            000000000 ? 000000001 ?\r\n                                                   7FFF7312DDF8 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\ndbkedDefDump()+2741  call     ksedst()             000000000 ? 000000001 ?\r\n                                                   7FFF7312DDF8 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\nksedmp()+36          call     dbkedDefDump()       000000003 ? 000000002 ?\r\n                                                   7FFF7312DDF8 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\nksfdmp()+64          call     ksedmp()             000000003 ? 000000002 ?\r\n                                                   7FFF7312DDF8 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\ndbgexPhaseII()+1764  call     ksfdmp()             000000003 ? 000000002 ?\r\n                                                   7FFF7312DDF8 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\ndbgexExplicitEndInc  call     dbgexPhaseII()       7F6850206710 ? 7F68502118C0 ?\r\n()+750                                             7FFF73139930 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\ndbgeEndDDEInvocatio  call     dbgexExplicitEndInc  7F6850206710 ? 7F68502118C0 ?\r\nnImpl()+767                   ()                   7FFF73139930 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\ndbgeEndDDEInvocatio  call     dbgeEndDDEInvocatio  7F6850206710 ? 7F68502118C0 ?\r\nn()+47                        nImpl()              7FFF73139930 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\nkcbl2vfyfh_action()  call     dbgeEndDDEInvocatio  7F6850206710 ? 7F68502118C0 ?\r\n+3373                         n()                  7FFF73139930 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\nksbabs()+771         call     kcbl2vfyfh_action()  7FFF7313B168 ? 000000018 ?\r\n                                                   7FFF73139930 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\nksbrdp()+971         call     ksbabs()             7FFF7313B168 ? 000000018 ?\r\n                                                   7FFF73139930 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\nopirip()+618         call     ksbrdp()             7FFF7313B168 ? 000000018 ?\r\n                                                   7FFF73139930 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\nopidrv()+598         call     opirip()             000000032 ? 000000004 ?\r\n                                                   7FFF7313C328 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\nsou2o()+98           call     opidrv()             000000032 ? 000000004 ?\r\n                                                   7FFF7313C328 ? 000000001 ?\r\n                                                   000000000 ? 000000002 ?\r\nopimai_real()+261    call     sou2o()              7FFF7313C300 ? 000000032 ?\r\n                                                   000000004 ? 7FFF7313C328 ?\r\n                                                   000000000 ? 000000002 ?\r\nssthrdmain()+252     call     opimai_real()        000000000 ? 7FFF7313C4F0 ?\r\n                                                   000000004 ? 7FFF7313C328 ?\r\n                                                   000000000 ? 000000002 ?\r\nmain()+196           call     ssthrdmain()         000000003 ? 7FFF7313C4F0 ?\r\n                                                   000000001 ? 000000000 ?\r\n                                                   000000000 ? 000000002 ?\r\n__libc_start_main()  call     main()               000000003 ? 7FFF7313C690 ?\r\n+244                                               000000001 ? 000000000 ?\r\n                                                   000000000 ? 000000002 ?\r\n_start()+36          call     __libc_start_main()  000A0B188 ? 000000001 ?\r\n                                                   7FFF7313C688 ? 000000000 ?\r\n                                                   000000000 ? 000000003 ?\r\n--------------------- Binary Stack Dump ---------------------<\/pre>\n<p>\u4ece\u5b9e\u4f8b2\u4e0a\u7684\u8be6\u7ec6TRACE\u6587\u4ef6\uff0c\u53ef\u4ee5\u5f88\u8f7b\u6613\u7684\u5206\u6790\u51fa\u5bfc\u81f4\u8fd9\u4e2a\u9519\u8bef\u7684\u539f\u56e0\u3002FLASH CACHE\u53c2\u6570\u671f\u671b\u5f53\u524d\u662f\u5b9e\u4f8b2\uff0c\u4f46\u662f\u4eceFLASH CACHE\u914d\u7f6e\u7684\u6587\u4ef6\u8bfb\u53d6\uff0c\u53d1\u73b0\u6587\u4ef6\u4e2d\u8bb0\u5f55\u7684\u662f\u5b9e\u4f8b1\uff0c\u5bfc\u81f4\u8fd9\u4e2a\u9519\u8bef\u7684\u539f\u56e0\u5728\u4e8eFLASH CACHE\u914d\u7f6e\u7684\u6587\u4ef6\u662f\u5404\u4e2a\u5b9e\u4f8b\u72ec\u7acb\u7684\uff0c\u56e0\u6b64\u4e0d\u80fd\u914d\u7f6e\u4e00\u4e2a\u5171\u4eab\u7684\u6587\u4ef6\u7ed9\u4e24\u4e2a\u5b9e\u4f8b\u540c\u65f6\u4f7f\u7528\u3002<br \/>\n\u8fd9\u4e2a\u95ee\u9898\u8fd8\u53ef\u4ee5\u901a\u8fc7\u68c0\u67e5FLASH CACHE\u7684\u7edf\u8ba1\u4fe1\u606f\u53d1\u73b0\uff1a<\/p>\n<pre lang='SQL'>SQL> select * from v$sysstat where name like '%flash cache eviction%';\r\nSTATISTIC# NAME                                         CLASS      VALUE    STAT_ID\r\n---------- --------------------------------------- ---------- ---------- ----------\r\n        97 flash cache eviction: invalidated                8          1 3647825193\r\n        98 flash cache eviction: buffer pinned              8          0 3134415242\r\n        99 flash cache eviction: aged out                   8          0 3307935113<\/pre>\n<p>\u5c06FLASH CACHE\u7684\u914d\u7f6e\u4fee\u6539\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>SQL> show parameter flash\r\nNAME                                 TYPE        VALUE\r\n------------------------------------ ----------- ------------------------------\r\ndb_flash_cache_file                  string      +REDO\/flash\/abc.flash\r\ndb_flash_cache_size                  big integer 60G\r\ndb_flashback_retention_target        integer     1440\r\nSQL> alter system set db_flash_cache_size = 30g scope = spfile;\r\nSystem altered.\r\nSQL> alter system set db_flash_cache_file = '+REDO\/flash\/odademo1.flash' scope = spfile sid = 'odaenmo1';\r\nSystem altered.\r\nSQL> alter system set db_flash_cache_file = '+REDO\/flash\/odademo2.flash' scope = spfile sid = 'odaenmo2';\r\nSystem altered.<\/pre>\n<p>\u8bbe\u7f6e\u6b63\u786e\u7684FLASH CACHE\u540e\uff0c\u91cd\u542f\u6570\u636e\u5e93\uff0cORA-700\u7684\u9519\u8bef\u4e0d\u518d\u51fa\u73b0\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>ORA-600\u548cORA-7445\u7684\u9519\u8bef\u5df2\u7ecf\u53f8\u7a7a\u89c1\u60ef\u4e86\uff0c\u800cOracle\u7684ORA-700\u9519\u8bef\u8fd8\u662f\u7b2c\u4e00\u6b21\u770b\u5230\uff0c\u800c\u770b\u5230\u8fd9\u4e2a\u9519\u8bef\uff0c\u8fd8\u662f\u5728ODA\u73af\u5883\u4e2d\u770b\u5230\u7684\u3002 \u6570\u636e\u5e93\u73af\u5883\u4e3aODA\uff0c\u5728\u5c1d\u8bd5\u914d\u7f6eFLASH_CACHE\uff1a SQL> show parameter flash_ NAME TYPE VALUE &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; &#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; db_flash_cache_file string db_flash_cache_size big integer 0 db_flashback_retention_target integer 1440 SQL> alter system set db_flash_cache_size = 60G scope = spfile; System altered. SQL> alter system set db_flash_cache_file= &#8216;+REDO&#8217; scope &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=1116\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[953,978,954,952,975,976,974,180,977],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-i0","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1116"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1116"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1116\/revisions"}],"predecessor-version":[{"id":1117,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1116\/revisions\/1117"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1116"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}