{"id":1601,"date":"2018-01-23T18:40:52","date_gmt":"2018-01-23T09:40:52","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1601"},"modified":"2018-01-23T18:48:22","modified_gmt":"2018-01-23T09:48:22","slug":"flashback-versions-query-transaction-query","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1601","title":{"rendered":"Flashback Versions Query & Transaction Query"},"content":{"rendered":"

\"\"\n\t<\/p>\n

Oracle9i\uc758 Flashback Query\ub97c \ud655\uc7a5\ud55c \ub0b4\uc6a9\uc774 Flashback Versions Query<\/span>\uc640 Flashback Transaction Query<\/span>\uc774\ub2e4. Flashback Versions Query\ub294 Select\uc2dc versions between<\/span>\uba85\ub839\uc744 \ub123\uc73c\uba74 \ud574\ub2f9 \uc815\ubcf4\uc758 history \uc815\ubcf4\uac00 \ub098\uc628\ub2e4. Flashback Versions Query\uc640 Flashback Transaction Query\ub294 undo tablespace<\/strong><\/span>\uc758 \uc815\ubcf4\ub97c \uc774\uc6a9\ud558\uae30 \ub54c\ubb38\uc5d0, flashback log\uc640\ub294 \uad00\ub828\uc774 \uc5c6\ub2e4.\n<\/p>\n

\n

Flashback Versions Query Test
\n<\/h3>\n<\/p>\n

\n

\ud14c\uc2a4\ud2b8 \uac1c\uc694
\n<\/h4>\n<\/p>\n

Flashback Version Query\ub294 \ub450 \uac00\uc9c0\ub85c \ub098\ub25c\ub2e4. \ud558\ub098\ub294 System Change Number(SCN)\ub97c \uae30\uc900\uc73c\ub85c \ud558\ub294 \uac83\uacfc \ub2e4\ub978 \ud558\ub098\ub294 timestamp\ub97c \uae30\uc900\uc73c\ub85c \ud558\ub294 \uac83\uc774\ub2e4. \uc5ec\uae30\uc11c\ub294 \ub450 \uac00\uc9c0\ub97c \ub2e4 \ud14c\uc2a4\ud2b8 \ud574\ubcf4\uaca0\ub2e4.\n<\/p>\n

\n

\ud14c\uc2a4\ud2b8 \ud658\uacbd
\n<\/h4>\n<\/p>\n

Undo data\ub97c \uc774\uc6a9\ud558\uc5ec \ud574\ub2f9 \uc815\ubcf4\uc758 history\ub97c \ubcfc \uc218 \uc788\ub294 Flashback Versions Query\ub97c \ud14c\uc2a4\ud2b8 \ud574\ubcf4\uaca0\ub2e4. Undo \uc815\ubcf4\uc758 retention guarantee\ub97c \uc704\ud574\uc11c\ub294 undo tablespace\ub97c retention guarantee\ud574\uc57c \ud55c\ub2e4. \uc774 \ub0b4\uc6a9\uc740 \uc704\uc5d0\uc11c \uc5b8\uae09\ud558\uc600\uc73c\ubbc0\ub85c \uc5ec\uae30\uc11c\ub294 \uc0dd\ub7b5\ud55c\ub2e4.\n<\/p>\n

Flashback Versions Query\ub294 Flashback database\uc640 \uc0c1\uad00\uc5c6\uc74c\uc744 \ud655\uc778\ud574 \ubcf4\uaca0\ub2e4.\n<\/p>\n

\n\n\n<\/colgroup>\n\n\n
\n

SQL> conn \/ as sysdba
\n<\/span><\/span><\/p>\n

Connected.
\n<\/span><\/p>\n

SQL> select flashback_on<\/span> from v$database;<\/span>
\n\t\t\t\t\t\t\t<\/span><\/p>\n

\n\u00a0<\/p>\n

FLASHB
\n<\/span><\/p>\n

——
\n<\/span><\/p>\n

NO
\n<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\n

\ud14c\uc2a4\ud2b8 \uc608\uc81c
\n<\/h4>\n<\/p>\n

\ub450 \uac00\uc9c0 versions query\uc5d0 \ub300\ud574 test\ud574\ubcf4\uaca0\ub2e4.\n<\/p>\n

\n\n\n<\/colgroup>\n\n\n
\n

SQL> conn scott\/tiger<\/span>
\n\t\t\t\t\t\t\t<\/span><\/p>\n

Connected.
\n<\/span><\/p>\n

SQL> select to_char(sysdate, ‘YY-MM-DD HH24:MI:SS’) from dual;<\/span>
\n\t\t\t\t\t\t\t<\/span><\/p>\n

\n\u00a0<\/p>\n

TO_CHAR(SYSDATE,’YY-MM-DDHH24:MI:S
\n<\/span><\/p>\n

———————————-
\n<\/span><\/p>\n

03-10-10 16:06:58
\n<\/span><\/p>\n

\n\u00a0<\/p>\n

SQL> select empno, ename, job, sal, deptno from test_emp;<\/span>
\n\t\t\t\t\t\t\t<\/span><\/p>\n

\n\u00a0<\/p>\n

EMPNO ENAME JOB SAL DEPTNO
\n<\/span><\/p>\n

———- ——————– —————— ———- ———-
\n<\/span><\/p>\n

7782 CLARK MANAGER 2450 10
\n<\/span><\/p>\n

7839 KING PRESIDENT 5000 10
\n<\/span><\/p>\n

7934 MILLER CLERK 1300 10
\n<\/span><\/p>\n

\n\u00a0<\/p>\n

\n\u00a0<\/p>\n

SQL> update test_emp set sal = 1400 where ename =’MILLER’;
\n<\/span><\/span><\/p>\n

\n\u00a0<\/p>\n

1 row updated.
\n<\/span><\/p>\n

\n\u00a0<\/p>\n

\n\u00a0<\/p>\n

SQL> select empno, ename, job, sal, deptno from test_emp
\n<\/span><\/span><\/p>\n

2
\n\t\t\t\t\t\t\t\t\tversions between scn minvalue and maxvalue
\n<\/span><\/span><\/span><\/p>\n

3 where ename=’MILLER’;
\n<\/span><\/span><\/p>\n

\n\u00a0<\/p>\n

EMPNO ENAME JOB SAL DEPTNO
\n<\/span><\/p>\n

———- ——————– —————— ———- ———-
\n<\/span><\/p>\n

7934 MILLER CLERK 1400 10
\n<\/span><\/p>\n

7934 MILLER CLERK 1300 10
\n<\/span><\/p>\n

\n\u00a0<\/p>\n

SQL> select empno, ename, job, sal, deptno from test_emp
\n<\/span><\/span><\/p>\n

2 versions between timestamp
\n<\/span><\/span><\/p>\n

3 to_timestamp(’03-10-10 16:06:58′, ‘YY-MM-DD HH24:MI:SS’) AND
\n<\/span><\/span><\/p>\n

4 to_timestamp(sysdate)
\n<\/span><\/span><\/p>\n

5 where ename =’MILLER’;
\n<\/span><\/span><\/p>\n

select empno, ename, job, sal, deptno from test_emp
\n<\/span><\/p>\n

*
\n<\/span><\/p>\n

ERROR at line 1:
\n<\/span><\/p>\n

ORA-30054: invalid upper limit snapshot expression
\n<\/span><\/p>\n

\n\u00a0<\/p>\n

SQL> select empno, ename, job, sal, deptno from test_emp
\n<\/span><\/span><\/p>\n

2 versions between timestamp
\n<\/span><\/span><\/p>\n


\n\t\t\t\t\t\t\t\t<\/span> 3
\n\t\t\t\t\t\t\t\t<\/span>to_timestamp(’03-10-10 10:06:58′, ‘YY-MM-DD HH24:MI:SS’) AND
\n<\/span><\/span><\/p>\n

4 to_timestamp(sysdate) where ename =’MIILER’;
\n<\/span><\/span><\/p>\n

select empno, ename, job, sal, deptno from test_emp
\n<\/span><\/p>\n

*
\n<\/span><\/p>\n

ERROR at line 1:
\n<\/span><\/p>\n

ORA-30052: invalid lower limit snapshot expression<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

VERSIONS BETWEEN SCN MINVALUE AND MAXVALUE<\/span> \ub294 \ubcc4 \ubb38\uc81c \uc5c6\uc774 \uc218\ud589\ub418\uc5c8\ub2e4. \uadf8\ub7ec\ub098 VERSIONS BETWEEN TIMESTAMP<\/span>\ub294 error\ub97c \ub5a8\uc5b4\ub728\ub838\ub2e4.\n<\/p>\n

ORA-30054: invalid upper limit snapshot expression
\n<\/span><\/p>\n

\uc774<\/span> error<\/span>\ub294<\/span> 4<\/span>\ubc88\uc9f8<\/span>
\n\t\t\t<\/span>\uc904\uc758<\/span> to_timestamp(sysdate)<\/span>\uac00<\/span>
\n\t\t\t<\/span>\uc798\ubabb\ub418\uc5c8\ub2e4\ub294<\/span> error<\/span>\ub85c<\/span>
\n\t\t\t<\/span>\ud604\uc7ac\uc758<\/span> current_scn<\/span>\uc774<\/span>
\n\t\t\t<\/span>\ubbf8\ucc98<\/span>
\n\t\t\t<\/span>\ud604\uc7ac\uc2dc\uac04\uae4c\uc9c0<\/span> update<\/span>\ub418\uc9c0<\/span>
\n\t\t\t<\/span>\uc54a\uc558\uc74c\uc744<\/span>
\n\t\t\t<\/span>\uc758\ubbf8\ud55c\ub2e4<\/span>.
\n<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0ORA-30052: invalid lower limit snapshot expression<\/span><\/span>\n\t<\/p>\n

\ub610\ud55c minscn\ubcf4\ub2e4 \uc774\ub978 \uc2dc\uac04\uc744 \ub123\uc73c\uba74 \uc704\uc640 \uac19\uc740 error\uac00 \uc0dd\uae34\ub2e4.\n<\/p>\n

\uc704\uc640 \uac19\uc740 \ub0b4\uc6a9\uc744 \uc815\ud655\ud788 \ucc98\ub9ac\ud558\uae30 \uc704\ud574\uc11c Oracle Database 10g\ubd80\ud130 \uc0c8\ub85c\uc6b4 pseudocolumn\uc774 \uc0dd\uacbc\ub2e4.\n<\/p>\n

    \n
  • \n
    VERSIONS_STARTTIME
    \n<\/span><\/div>\n<\/li>\n
  • \n
    VERSIONS_STARTSCN
    \n<\/span><\/div>\n<\/li>\n
  • \n
    VERSIONS_ENDTIME
    \n<\/span><\/div>\n<\/li>\n
  • \n
    VERSIONS_ENDSCN
    \n<\/span><\/div>\n<\/li>\n
  • \n
    VERSIONS_XID
    \n<\/span><\/div>\n<\/li>\n
  • \n
    VERSIONS_OPERATION
    \n<\/span><\/div>\n<\/li>\n<\/ul>\n

    \ub610\ud55c scn\uacfc timestamp\uc758 \uad00\uacc4\ub97c \uc54c\uc544\ubcfc \uc218 \uc788\ub294 function \ub450 \uac00\uc9c0\uac00 \ucd94\uac00\ub418\uc5c8\ub2e4.\n<\/p>\n

      \n
    • \n
      SCN_TO_TIMESTAMP
      \n<\/span><\/div>\n<\/li>\n
    • \n
      TIMESTAMP_TO_SCN<\/span>\n\t\t\t<\/div>\n<\/li>\n<\/ul>\n

      \uc704\uc758 pseudocolumn\uc744 \uc774\uc6a9\ud558\uc5ec \ub2e4\uc2dc \uc815\ud655\ud788 query\ub97c \uc218\ud589\ud574 \ubcf4\uaca0\ub2e4.\n<\/p>\n

      \n\n\n<\/colgroup>\n\n\n
      \n

      SQL> update test_emp set sal =1600 where ename =’MILLER’;<\/span>
      \n\t\t\t\t\t\t\t<\/span><\/p>\n

      \n\u00a0<\/p>\n

      1 row updated.
      \n<\/span><\/p>\n

      SQL> COMMIT;
      \n<\/span><\/p>\n

      Commit complete.
      \n<\/span><\/p>\n

      \n\u00a0<\/p>\n

      SQL> select versions_starttime, versions_endtime,<\/span> sal from test_emp
      \n<\/span><\/span><\/p>\n

      2 versions between scn minvalue and maxvalue
      \n<\/span><\/span><\/p>\n

      3 where ename=’MILLER’;
      \n<\/span><\/span><\/p>\n

      \n\u00a0<\/p>\n

      VERSIONS_STARTTIME VERSIONS_ENDTIME SAL
      \n<\/span><\/p>\n

      —————————— —————————— ———-
      \n<\/span><\/p>\n

      10-OCT-03 04.43.55 PM 1600
      \n<\/span><\/p>\n

      10-OCT-03 04.40.38 PM 10-OCT-03 04.43.55 PM 1500
      \n<\/span><\/p>\n

      10-OCT-03 04.40.38 PM 1400<\/span>
      \n\t\t\t\t\t\t\t<\/span><\/p>\n

      SQL> select sal from test_emp
      \n<\/span><\/span><\/p>\n

        \n
      1. versions between timestamp
        \n<\/span><\/li>\n
      2. to_timestamp(‘2003-10-10 16:40:38′,’YYYY-MM-DD HH24:MI:SS’)
        \n<\/span><\/li>\n<\/ol>\n

        4 and to_timestamp(‘2003-10-10 16:43:55’, ‘YYYY-MM-DD HH24:MI:SS’)
        \n<\/span><\/span><\/p>\n

        5 where ename =’MILLER’;
        \n<\/span><\/span><\/p>\n

        \n\u00a0<\/p>\n

        SAL
        \n<\/span><\/p>\n

        ———-
        \n<\/span><\/p>\n

        1500
        \n<\/span><\/p>\n

        1400
        \n<\/span><\/p>\n

        \n\u00a0<\/p>\n

        SQL> select scn_to_timestamp<\/span>(current_scn) from v$database;<\/span>
        \n\t\t\t\t\t\t\t<\/span><\/p>\n

        \n\u00a0<\/p>\n

        SCN_TO_TIMESTAMP(CURRENT_SCN)
        \n<\/span><\/p>\n

        —————————————————————————
        \n<\/span><\/p>\n

        10-OCT-03 04.50.51.000000000 PM
        \n<\/span><\/p>\n

        \n\u00a0<\/p>\n

        SQL> select sal from test_emp
        \n<\/span><\/span><\/p>\n

          \n
        1. versions between timestamp
          \n<\/span><\/li>\n
        2. to_timestamp(‘2003-10-10 16:40:38′,’YYYY-MM-DD HH24:MI:SS’) and
          \n<\/span><\/li>\n
        3. to_timestamp(‘2003-10-10 16:50:51’, ‘YYYY-MM-DD HH24:MI:SS’)
          \n<\/span><\/li>\n
        4. where ename =’MILLER’;
          \n<\/span><\/li>\n<\/ol>\n

          \n\u00a0<\/p>\n

          SAL
          \n<\/span><\/p>\n

          ———-
          \n<\/span><\/p>\n

          1600
          \n<\/span><\/p>\n

          1500
          \n<\/span><\/p>\n

          1400
          \n<\/span><\/p>\n


          \n\t\t\t\t\t\t\t<\/span>\u00a0<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

          \uc704\uc758 \ub0b4\uc6a9\uacfc \uac19\uc774 \ubcc0\uacbd\ub418\uae30 \uc804\uc758 \ub0b4\uc6a9\uc778 sal=1400\uc778 \uc815\ubcf4\ub294 VERSIONS_STARTTIME\uc740 \uc5c6\uace0 VERSIONS_ENDTIME\ub9cc\uc774 \uc788\ub2e4. \ub610\ud55c current_scn\uc5d0 \ub300\ud55c \uc815\ubcf4\uc5d0 \ub300\ud55c timestamp\ub97c \uc9c1\uc811 query\ud558\uc5ec \uc815\ubcf4\ub97c \ub123\uc73c\uba74 \ub9c8\uc9c0\ub9c9 \ubcc0\uacbd \uc0ac\ud56d\uc744 \ubcfc \uc218 \uc788\ub2e4.\n<\/p>\n

          \n

          Flashback Transaction Query Test
          \n<\/h3>\n<\/p>\n

          \n

          \ud14c\uc2a4\ud2b8 \uac1c\uc694
          \n<\/h4>\n<\/p>\n

          \ube44\uad50\uc801 \uac04\ub2e8\ud55c Flashback Transaction Query test\ub97c \ud574\ubcf4\uaca0\ub2e4. \ud14c\uc2a4\ud2b8 \ud658\uacbd\uc740 Flashback Versions Query\uc640 \ucc28\uc774\uac00 \uc5c6\ub2e4.\n<\/p>\n

          \n

          \ud14c\uc2a4\ud2b8 \uc608\uc81c
          \n<\/h4>\n<\/p>\n

          \n\u00a0<\/p>\n

          \n\n\n<\/colgroup>\n\n\n
          \n

          SQL> select sal from test_emp
          \n<\/span><\/span><\/p>\n

          2 versions between scn minvalue and maxvalue<\/span>
          \n\t\t\t\t\t\t\t<\/span><\/p>\n

          3 where ename=’MILLER’;
          \n<\/span><\/span><\/p>\n

          \n\u00a0<\/p>\n

          SAL
          \n<\/span><\/p>\n

          ———-
          \n<\/span><\/p>\n

          1600
          \n<\/span><\/p>\n

          \n\u00a0<\/p>\n

          SQL> update test_emp set sal=1700
          \n<\/span><\/span><\/p>\n

          2 where ename=’MILLER’;
          \n<\/span><\/span><\/p>\n

          \n\u00a0<\/p>\n

          1 row updated.
          \n<\/span><\/p>\n

          \n\u00a0<\/p>\n

          SQL> commit;
          \n<\/span><\/p>\n

          \n\u00a0<\/p>\n

          Commit complete.
          \n<\/span><\/p>\n

          \n\u00a0<\/p>\n

          SQL> update test_emp set sal=1800
          \n<\/span><\/span><\/p>\n

          2 where ename =’MILLER’;
          \n<\/span><\/span><\/p>\n

          \n\u00a0<\/p>\n

          1 row updated.
          \n<\/span><\/p>\n

          \n\u00a0<\/p>\n

          SQL> commit;
          \n<\/span><\/p>\n

          \n\u00a0<\/p>\n

          Commit complete.
          \n<\/span><\/p>\n

          \n\u00a0<\/p>\n

          SQL> select versions_xid<\/span>, sal
          \n<\/span><\/span><\/p>\n

          2 from test_emp
          \n<\/span><\/span><\/p>\n

          3 versions between scn minvalue and maxvalue<\/span>
          \n\t\t\t\t\t\t\t\t<\/span><\/span><\/p>\n

          4 where ename=’MILLER’;
          \n<\/span><\/span><\/p>\n

          \n\u00a0<\/p>\n

          VERSIONS_XID SAL
          \n<\/span><\/p>\n

          —————- ———-
          \n<\/span><\/p>\n

          0006000F0000001B 1800
          \n<\/span><\/p>\n

          0005000F00000036 1700
          \n<\/span><\/p>\n

          1300
          \n<\/span><\/p>\n

          \n\u00a0<\/p>\n

          SQL> select operation, undo_sql, table_name from
          \n<\/span><\/span><\/p>\n

            \n
          1. flashback_transaction_query<\/span> where xid=’0005000F00000036′;
            \n<\/span><\/span><\/li>\n<\/ol>\n

            \n\u00a0<\/p>\n

            OPERATION
            \n<\/span><\/p>\n

            ——————————–
            \n<\/span><\/p>\n

            UNDO_SQL
            \n<\/span><\/p>\n

            —————————————————————————
            \n<\/span><\/p>\n

            TABLE_NAME
            \n<\/span><\/p>\n

            —————————————————————————
            \n<\/span><\/p>\n

            UPDATE
            \n<\/span><\/p>\n

            update “SCOTT”.”EMP” set “SAL” = ‘1300’ where ROWID = ‘AAAL+ZAAEAAAAAdAAN’;
            \n<\/span><\/p>\n

            EMP<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

            \n\u00a0<\/p>\n

            \n\u00a0<\/p>\n

            \n\u00a0<\/p>\n

            \n\u00a0<\/p>\n

            \n

            \ud65c\uc6a9\uac00\uc774\ub4dc \ubc0f \uacb0\ub860
            \n<\/h2>\n<\/p>\n

            Database\ub97c \uad00\ub9ac\ud558\ub294 DBA\ub294 \ud56d\uc0c1 \uc8fc\uc758\ub97c \uc694\ud558\uac8c \ub41c\ub2e4. \ud558\ub098\uc758 \uc2e4\uc218\uac00 \ub3cc\uc774\ud0ac \uc218 \uc5c6\ub294 \uc5c4\uccad\ub09c \uacb0\uacfc\ub97c \ucd08\ub798\ud560 \uc218 \uc788\uae30 \ub54c\ubb38\uc774\ub2e4. \ubb38\uc81c\ub294 DBA\ub294 \uc0ac\ub78c\uc774\uae30 \ub54c\ubb38\uc5d0 \uadf8\ub7ec\ud55c \uc2e4\uc218\ub97c \uc6d0\ucc9c\uc801\uc73c\ub85c \ubd09\uc1c4\ud560 \ubc29\ubc95\uc774 \uc5c6\ub2e4\ub294 \uac83\uc774\ub2e4. \ub530\ub77c\uc11c \ucc28\ud6c4\uc758 \uc120\ucc45\uc73c\ub85c Flashback Query\ub97c \uc774\uc6a9\ud560 \uc218 \uc788\ub2e4. \uc774\ubbf8 \uc77c\uc5b4\ub09c \uc608\uae30\uce58 \uc54a\uc740 \uc7a5\uc560\uc5d0 \ub300\ud574 \ub9ce\uc740 \ubd80\ubd84\uc744 Flashback Query\uac00 \ud574\uacb0\ud574 \uc904 \uc218 \uc788\ub2e4. \ub9ce\uc740 \uc591\uc758 log\ub4e4\uacfc \uc608\uae30\uce58 \uc54a\uc740 \uc7a5\uc560 \uc2dc \ud574\uacb0\ud560 \ubc29\ubc95 \ubc0f \ub300\ucc45\uc744 \ud6a8\uacfc\uc801\uc73c\ub85c \ub9cc\ub4e4\uc5b4 \ub193\uc558\ub2e4\uba74 Oracle\uc758 \uc0c8\ub85c\uc6b4, \uadf8\ub9ac\uace0 \ub354\uc6b1 \ud5a5\uc0c1\ub41c Flashback Query\ub97c \ud6a8\uacfc\uc801\uc73c\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc744 \uac83\uc774\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"

            Oracle9i\uc758 Flashback Query\ub97c \ud655\uc7a5\ud55c \ub0b4\uc6a9\uc774 Flashback Versions Query\uc640 Flashback Transaction Query\uc774\ub2e4. Flashback Versions Query\ub294 Select\uc2dc versions between\uba85\ub839\uc744 \ub123\uc73c\uba74 \ud574\ub2f9 \uc815\ubcf4\uc758 history \uc815\ubcf4\uac00 \ub098\uc628\ub2e4. Flashback Versions Query\uc640 Flashback Transaction Query\ub294 undo tablespace\uc758 \uc815\ubcf4\ub97c \uc774\uc6a9\ud558\uae30 \ub54c\ubb38\uc5d0, flashback log\uc640\ub294 \uad00\ub828\uc774 \uc5c6\ub2e4. Flashback Versions Query Test \ud14c\uc2a4\ud2b8 \uac1c\uc694 Flashback Version Query\ub294 \ub450 \uac00\uc9c0\ub85c \ub098\ub25c\ub2e4. \ud558\ub098\ub294 System Change Number(SCN)\ub97c \uae30\uc900\uc73c\ub85c […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[9],"tags":[279,280],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1601"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1601"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1601\/revisions"}],"predecessor-version":[{"id":1602,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1601\/revisions\/1602"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1601"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1601"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1601"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}