{"id":1209,"date":"2016-01-03T10:35:15","date_gmt":"2016-01-03T01:35:15","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1209"},"modified":"2019-04-16T11:21:31","modified_gmt":"2019-04-16T02:21:31","slug":"db-12c-%ec%8b%9c%ec%9e%91-%eb%b0%8f-%ec%84%9c%eb%b9%84%ec%8a%a4%ec%a0%91%ec%86%8d-cdbpdb-%ec%8b%9c%ec%9e%91-%eb%b0%8f-%ec%a2%85%eb%a3%8c","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1209","title":{"rendered":"DB 12c \u2013 \uc2dc\uc791 \ubc0f \uc11c\ube44\uc2a4\uc811\uc18d, CDB\/PDB \uc2dc\uc791 \ubc0f \uc885\ub8cc"},"content":{"rendered":"

\ubc30\uacbd : \ud604\uc7ac 12c \uc124\uce58\ub418\uc5b4 \uc788\uace0 PDB 2\uac1c \uc124\uce58 \ub418\uc5b4 \uc788\ub294 \uc0c1\ud0dc \uc785\ub2c8\ub2e4.
\n<\/span><\/p>\n

\u00a0
\n\u00a0<\/p>\n

# \uc2dc\uc791 \ubc0f \uc11c\ube44\uc2a4 \uc811\uc18d\ubc29\ubc95
\n<\/strong><\/span><\/p>\n

    \n
  1. \n
    CDB & PDB \uc2dc\uc791
    \n<\/strong><\/span><\/div>\n

    [root@test ~]# su – oracle
    \n<\/span><\/p>\n

    [test@cdb1 : \/home\/oracle]$ sqlplus
    \n<\/span><\/p>\n

    \u00a0
    \n\u00a0<\/p>\n

    SQL*Plus: Release 12.1.0.1.0 Production on Fri Aug 7 11:11:51 2015
    \n<\/span><\/p>\n

    \u00a0
    \n\u00a0<\/p>\n

    Copyright (c) 1982, 2013, Oracle. All rights reserved.
    \n<\/span><\/p>\n

    \u00a0
    \n\u00a0<\/p>\n

    Enter user-name: \/as sysdba
    \n<\/span><\/p>\n

    Connected to an idle instance.
    \n<\/span><\/p>\n

    \u00a0
    \n\u00a0<\/p>\n

    SQL> startup (CDB\uc2dc\uc791)<\/span>
    \n\t\t\t\t<\/span><\/p>\n

    ORACLE instance started.
    \n<\/span><\/p>\n

    \u00a0
    \n\u00a0<\/p>\n

    Total System Global Area 835104768 bytes
    \n<\/span><\/p>\n

    Fixed Size 2293880 bytes
    \n<\/span><\/p>\n

    Variable Size 595595144 bytes
    \n<\/span><\/p>\n

    Database Buffers 234881024 bytes
    \n<\/span><\/p>\n

    Redo Buffers 2334720 bytes
    \n<\/span><\/p>\n

    Database mounted.
    \n<\/span><\/p>\n

    Database opened.
    \n<\/span><\/p>\n

    SQL> !lsnrctl start
    \n<\/span><\/p>\n

    \u00a0
    \n\u00a0<\/p>\n

    LSNRCTL for Linux: Version 12.1.0.1.0 – Production on 07-AUG-2015 11:17:31
    \n<\/span><\/p>\n

    \u00a0
    \n\u00a0<\/p>\n

    Copyright (c) 1991, 2013, Oracle. All rights reserved.
    \n<\/span><\/p>\n

    \u00a0
    \n\u00a0<\/p>\n

    Starting \/oracle\/product\/12.1.0\/db_1\/bin\/tnslsnr: please wait…
    \n<\/span><\/p>\n

    \u00a0
    \n\u00a0<\/p>\n

    TNSLSNR for Linux: Version 12.1.0.1.0 – Production
    \n<\/span><\/p>\n

    System parameter file is \/oracle\/product\/12.1.0\/db_1\/network\/admin\/listener.ora
    \n<\/span><\/p>\n

    Log messages written to \/oracle\/diag\/tnslsnr\/test\/listener\/alert\/log.xml
    \n<\/span><\/p>\n

    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test)(PORT=1521)))
    \n<\/span><\/p>\n

    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
    \n<\/span><\/p>\n

    \u00a0
    \n\u00a0<\/p>\n

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1521)))
    \n<\/span><\/p>\n

    STATUS of the LISTENER
    \n<\/span><\/p>\n

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

    Alias LISTENER
    \n<\/span><\/p>\n

    Version TNSLSNR for Linux: Version 12.1.0.1.0 – Production
    \n<\/span><\/p>\n

    Start Date 07-AUG-2015 11:17:31
    \n<\/span><\/p>\n

    Uptime 0 days 0 hr. 0 min. 0 sec
    \n<\/span><\/p>\n

    Trace Level off
    \n<\/span><\/p>\n

    Security ON: Local OS Authentication
    \n<\/span><\/p>\n

    SNMP OFF
    \n<\/span><\/p>\n

    Listener Parameter File \/oracle\/product\/12.1.0\/db_1\/network\/admin\/listener.ora
    \n<\/span><\/p>\n

    Listener Log File \/oracle\/diag\/tnslsnr\/test\/listener\/alert\/log.xml
    \n<\/span><\/p>\n

    Listening Endpoints Summary…
    \n<\/span><\/p>\n

    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test)(PORT=1521)))
    \n<\/span><\/p>\n

    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
    \n<\/span><\/p>\n

    The listener supports no services
    \n<\/span><\/p>\n

    The command completed successfully
    \n<\/span><\/p>\n

    \u00a0
    \n\u00a0<\/p>\n

    SQL> alter pluggable database all open; (PDB \uc804\uccb4 OPEN)<\/span>
    \n\t\t\t\t<\/span><\/p>\n

    \u00a0
    \n\u00a0<\/p>\n

    Pluggable database altered.
    \n<\/span><\/p>\n

    \u00a0
    \n\u00a0<\/p>\n

    SQL> show pdbs (PDB \ud655\uc778)<\/span>
    \n\t\t\t\t<\/span><\/p>\n

    \u00a0
    \n\u00a0<\/p>\n

    CON_ID CON_NAME OPEN MODE RESTRICTED
    \n<\/span><\/p>\n

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

    2 PDB$SEED READ ONLY NO
    \n<\/span><\/p>\n

    3 PDB11 READ WRITE NO
    \n<\/span><\/p>\n

    4 PDB12 READ WRITE NO
    \n<\/span><\/p>\n

    \u00a0
    \n\u00a0<\/p>\n<\/li>\n

  2. CDB \uc811\uc18d \ubc29\ubc95
    \n<\/strong><\/span><\/li>\n<\/ol>\n
      \n
    • \n
      OS \uc778\uc99d \ubc29\ubc95<\/span>\n\t\t\t<\/div>\n

      [test@cdb1 : \/home\/oracle]$ sqlplus \/ as sysdba
      \n<\/span><\/p>\n

      \u00a0
      \n\u00a0<\/p>\n

      SQL*Plus: Release 12.1.0.1.0 Production on Fri Aug 7 11:33:06 2015
      \n<\/span><\/p>\n

      \u00a0
      \n\u00a0<\/p>\n

      Copyright (c) 1982, 2013, Oracle. All rights reserved.
      \n<\/span><\/p>\n

      \u00a0
      \n\u00a0<\/p>\n

      \u00a0
      \n\u00a0<\/p>\n

      Connected to:
      \n<\/span><\/p>\n

      Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 – 64bit Production
      \n<\/span><\/p>\n

      With the Partitioning, OLAP and Real Application Testing options
      \n<\/span><\/p>\n

      \u00a0
      \n\u00a0<\/p>\n

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

      \u00a0
      \n\u00a0<\/p>\n<\/li>\n

    • \n
      Easy Connect \ubc29\ubc95<\/span>\n\t\t\t<\/div>\n

      [test@cdb1 : \/home\/oracle]$ sqlplus sys\/oracle@test:1521\/cdb1 as sysdba
      \n<\/span><\/p>\n

      \u00a0
      \n\u00a0<\/p>\n

      SQL*Plus: Release 12.1.0.1.0 Production on Fri Aug 7 11:34:30 2015
      \n<\/span><\/p>\n

      \u00a0
      \n\u00a0<\/p>\n

      Copyright (c) 1982, 2013, Oracle. All rights reserved.
      \n<\/span><\/p>\n

      \u00a0
      \n\u00a0<\/p>\n

      \u00a0
      \n\u00a0<\/p>\n

      Connected to:
      \n<\/span><\/p>\n

      Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 – 64bit Production
      \n<\/span><\/p>\n

      With the Partitioning, OLAP and Real Application Testing options
      \n<\/span><\/p>\n

      \u00a0
      \n\u00a0<\/p>\n

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

      \u00a0
      \n\u00a0<\/p>\n<\/li>\n

    • \n
      Net Service Name \ubc29\ubc95(tnsnames.ora \uc124\uc815)<\/span>\n\t\t\t<\/div>\n

      [test@cdb1 : \/home\/oracle]$ sqlplus sys\/oracle@cdb1 as sysdba
      \n<\/span><\/p>\n

      \u00a0
      \n\u00a0<\/p>\n

      SQL*Plus: Release 12.1.0.1.0 Production on Fri Aug 7 11:46:58 2015
      \n<\/span><\/p>\n

      \u00a0
      \n\u00a0<\/p>\n

      Copyright (c) 1982, 2013, Oracle. All rights reserved.
      \n<\/span><\/p>\n

      \u00a0
      \n\u00a0<\/p>\n

      \u00a0
      \n\u00a0<\/p>\n

      Connected to:
      \n<\/span><\/p>\n

      Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 – 64bit Production
      \n<\/span><\/p>\n

      With the Partitioning, OLAP and Real Application Testing options
      \n<\/span><\/p>\n

      \u00a0
      \n\u00a0<\/p>\n

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

      \u00a0
      \n\u00a0<\/p>\n

      \u00a0
      \n\u00a0<\/p>\n<\/li>\n<\/ul>\n

        \n
      1. PDB \uc811\uc18d \ubc29\ubc95
        \n<\/strong><\/span><\/li>\n<\/ol>\n
          \n
        • \n
          Easy Connect \ubc29\ubc95<\/span>\n\t\t\t<\/div>\n

          [test@cdb1 : \/home\/oracle]$ sqlplus sys\/oracle@test:1521\/pdb11 as sysdba
          \n<\/span><\/p>\n

          \u00a0
          \n\u00a0<\/p>\n

          SQL*Plus: Release 12.1.0.1.0 Production on Fri Aug 7 11:44:26 2015
          \n<\/span><\/p>\n

          \u00a0
          \n\u00a0<\/p>\n

          Copyright (c) 1982, 2013, Oracle. All rights reserved.
          \n<\/span><\/p>\n

          \u00a0
          \n\u00a0<\/p>\n

          \u00a0
          \n\u00a0<\/p>\n

          Connected to:
          \n<\/span><\/p>\n

          Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 – 64bit Production
          \n<\/span><\/p>\n

          With the Partitioning, OLAP and Real Application Testing options
          \n<\/span><\/p>\n

          \u00a0
          \n\u00a0<\/p>\n

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

          \u00a0
          \n\u00a0<\/p>\n<\/li>\n

        • \n
          Net Service Name \ubc29\ubc95(tnsnames.ora \uc124\uc815)<\/span>\n\t\t\t<\/div>\n

          [test@cdb1 : \/oracle\/product\/12.1.0\/db_1\/network\/admin]$ cat tnsnames.ora
          \n<\/span><\/p>\n

          # tnsnames.ora Network Configuration File: \/oracle\/product\/12.1.0\/db_1\/network\/admin\/tnsnames.ora
          \n<\/span><\/p>\n

          # Generated by Oracle configuration tools.
          \n<\/span><\/p>\n

          \u00a0
          \n\u00a0<\/p>\n

          LISTENER_CDB1 =
          \n<\/span><\/p>\n

          (ADDRESS = (PROTOCOL = TCP)(HOST = test)(PORT = 1521))
          \n<\/span><\/p>\n

          \u00a0
          \n\u00a0<\/p>\n

          \u00a0
          \n\u00a0<\/p>\n

          CDB1 =
          \n<\/span><\/p>\n

          (DESCRIPTION =
          \n<\/span><\/p>\n

          (ADDRESS = (PROTOCOL = TCP)(HOST = test)(PORT = 1521))
          \n<\/span><\/p>\n

          (CONNECT_DATA =
          \n<\/span><\/p>\n

          (SERVER = DEDICATED)
          \n<\/span><\/p>\n

          (SERVICE_NAME = cdb1)
          \n<\/span><\/p>\n

          )
          \n<\/span><\/p>\n

          )
          \n<\/span><\/p>\n

          \u00a0
          \n\u00a0<\/p>\n

          PDB11 =
          \n<\/span><\/p>\n

          (DESCRIPTION =
          \n<\/span><\/p>\n

          (ADDRESS = (PROTOCOL = TCP)(HOST = test)(PORT = 1521))
          \n<\/span><\/p>\n

          (CONNECT_DATA =
          \n<\/span><\/p>\n

          (SERVER = DEDICATED)
          \n<\/span><\/p>\n

          (SERVICE_NAME = pdb11)
          \n<\/span><\/p>\n

          )
          \n<\/span><\/p>\n

          )
          \n<\/span><\/p>\n

          \u00a0
          \n\u00a0<\/p>\n

          [test@cdb1 : \/home\/oracle]$ sqlplus sys\/oracle@pdb11 as sysdba
          \n<\/span><\/p>\n

          \u00a0
          \n\u00a0<\/p>\n

          SQL*Plus: Release 12.1.0.1.0 Production on Fri Aug 7 11:46:16 2015
          \n<\/span><\/p>\n

          \u00a0
          \n\u00a0<\/p>\n

          Copyright (c) 1982, 2013, Oracle. All rights reserved.
          \n<\/span><\/p>\n

          \u00a0
          \n\u00a0<\/p>\n

          \u00a0
          \n\u00a0<\/p>\n

          Connected to:
          \n<\/span><\/p>\n

          Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 – 64bit Production
          \n<\/span><\/p>\n

          With the Partitioning, OLAP and Real Application Testing options
          \n<\/span><\/p>\n

          \u00a0
          \n\u00a0<\/p>\n

          SQL>
          \n<\/span><\/p>\n<\/li>\n<\/ul>\n

          # \uad00\ub828 View \ubc0f Database \ud30c\uc77c \uc0b4\ud3b4\ubcf4\uae30
          \n<\/strong><\/span><\/p>\n

            \n
          1. \n
            v$ view \uc0b4\ud3b4\ubcf4\uae30
            \n<\/strong><\/span><\/div>\n

            SQL> select instance_name,status,con_id from v$instance;
            \n<\/span><\/p>\n

            \u00a0
            \n\u00a0<\/p>\n

            INSTANCE_NAME STATUS CON_ID
            \n<\/span><\/p>\n

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

            cdb1 OPEN 0
            \n<\/span><\/p>\n

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

            \u00a0
            \n\u00a0<\/p>\n<\/li>\n<\/ol>\n

              \n
            • \n
              CON_ID \uceec\ub7fc\uc740 \uc704\uc640 \uac19\uc740 \uaddc\uce59\uc73c\ub85c \ubc88\ud638\uac00 \ubd80\uc5ec\ub41c\ub2e4.<\/span>\n\t\t\t<\/div>\n

              \u00a0
              \n\u00a0<\/p>\n

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

              \u00a0
              \n\u00a0<\/p>\n

              CDB
              \n<\/span><\/p>\n

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

              YES
              \n<\/span><\/p>\n

              \u00a0
              \n\u00a0<\/p>\n

              SQL> column name format a8;
              \n<\/span><\/p>\n

              SQL> select name,con_id,dbid,con_uid,guid from v$containers order by con_id;
              \n<\/span><\/p>\n

              \u00a0
              \n\u00a0<\/p>\n

              NAME CON_ID DBID CON_UID GUID
              \n<\/span><\/p>\n

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

              CDB$ROOT 1 822464397 1 FA6D34E1B2670B5BE0430100007F1063
              \n<\/span><\/p>\n

              PDB$SEED 2 4091349325 4091349325 FA6D34E1B2660B5BE0430100007F1063
              \n<\/span><\/p>\n

              PDB11 3 3833008008 3833008008 FA811565F8BA0989E0430100007FF65C
              \n<\/span><\/p>\n

              PDB12 4 4037515505 4037515505 FA811565F8BB0989E0430100007FF65C
              \n<\/span><\/p>\n

              \u00a0
              \n\u00a0<\/p>\n<\/li>\n

            • \n
              CDB\uc77c \ub54c<\/span>\n\t\t\t<\/div>\n

              SQL> select name,con_id from v$active_services order by 1;
              \n<\/span><\/p>\n

              \u00a0
              \n\u00a0<\/p>\n

              NAME CON_ID
              \n<\/span><\/p>\n

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

              SYS$BACK 1
              \n<\/span><\/p>\n

              GROUND
              \n<\/span><\/p>\n

              \u00a0
              \n\u00a0<\/p>\n

              SYS$USER 1
              \n<\/span><\/p>\n

              S
              \n<\/span><\/p>\n

              \u00a0
              \n\u00a0<\/p>\n

              cdb1 1
              \n<\/span><\/p>\n

              cdb1XDB 1
              \n<\/span><\/p>\n

              pdb11 3
              \n<\/span><\/p>\n

              pdb12 4
              \n<\/span><\/p>\n

              \u00a0
              \n\u00a0<\/p>\n

              6 rows selected.
              \n<\/span><\/p>\n

              \u00a0
              \n\u00a0<\/p>\n<\/li>\n

            • \n
              PDB\uc77c \ub54c<\/span>\n\t\t\t<\/div>\n

              SQL> select name,con_id from v$active_services order by 1;
              \n<\/span><\/p>\n

              \u00a0
              \n\u00a0<\/p>\n

              NAME CON_ID
              \n<\/span><\/p>\n

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

              pdb11 3
              \n<\/span><\/p>\n

              \u00a0
              \n\u00a0<\/p>\n

              \u00a0
              \n\u00a0<\/p>\n

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

              \u00a0
              \n\u00a0<\/p>\n<\/li>\n

            • CDB\uc5d0\ub294 \ubaa8\ub4e0 DBA_ view\uc5d0 \uc0c1\uc751\ud558\ub294 CDB_ view\uac00 \uc874\uc7ac\ud569\ub2c8\ub2e4<\/span>\n\t\t<\/li>\n
            • \ud604\uc7ac CDB\uc5d0 \uc811\uc18d\ud574 \uc788\ub2e4\uba74 CDB_ view\ub97c \ud1b5\ud558\uc5ec root\uc640 PDBs \uc758 metadata\ub97c \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span>\n\t\t<\/li>\n
            • \n
              PDB\uc5d0 \uc811\uc18d\ud574 \uc788\ub2e4\uba74 PDB\uc758 \uc815\ubcf4\ub9cc \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4<\/span>\n\t\t\t<\/div>\n

              \u00a0
              \n\u00a0<\/p>\n<\/li>\n<\/ul>\n

                \n
              1. \n
                DATABASE FILE \uc0b4\ud3b4\ubcf4\uae30
                \n<\/strong><\/span><\/div>\n

                SQL> COL MEMBER FORMAT A40
                \n<\/span><\/p>\n

                SQL> SELECT GROUP#, CON_ID, MEMBER FROM V$LOGFILE;
                \n<\/span><\/p>\n

                \u00a0
                \n\u00a0<\/p>\n

                GROUP# CON_ID MEMBER
                \n<\/span><\/p>\n

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

                1 0 \/oradata\/cdb1\/redo01.log
                \n<\/span><\/p>\n

                2 0 \/oradata\/cdb1\/redo02.log
                \n<\/span><\/p>\n

                3 0 \/oradata\/cdb1\/redo03.log
                \n<\/span><\/p>\n

                \u00a0
                \n\u00a0<\/p>\n

                SQL> COL NAME FORMAT A60;
                \n<\/span><\/p>\n

                SQL> SELECT NAME FROM V$CONTROLFILE;
                \n<\/span><\/p>\n

                \u00a0
                \n\u00a0<\/p>\n

                NAME
                \n<\/span><\/p>\n

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

                \/oradata\/cdb1\/control01.ctl
                \n<\/span><\/p>\n

                \/oradata\/cdb1\/control02.ctl
                \n<\/span><\/p>\n

                \u00a0
                \n\u00a0<\/p>\n

                SQL> set line 140 pages 1000
                \n<\/span><\/p>\n

                SQL> col TABLESPACE_NAME for a10
                \n<\/span><\/p>\n

                SQL> COL FILE_NAME FORMAT A60
                \n<\/span><\/p>\n

                SQL> SELECT FILE_NAME, TABLESPACE_NAME, FILE_ID FROM CDB_TEMP_FILES;
                \n<\/span><\/p>\n

                \u00a0
                \n\u00a0<\/p>\n

                FILE_NAME TABLESPACE FILE_ID
                \n<\/span><\/p>\n

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

                \/oradata\/cdb1\/temp01.dbf TEMP 1
                \n<\/span><\/p>\n

                \/oradata\/cdb1\/PDB11\/temp01.dbf TEMP 3
                \n<\/span><\/p>\n

                \/oradata\/cdb1\/PDB12\/temp01.dbf TEMP 4
                \n<\/span><\/p>\n

                \/oradata\/cdb1\/pdbseed\/temp01.dbf TEMP 2
                \n<\/span><\/p>\n

                \u00a0
                \n\u00a0<\/p>\n<\/li>\n<\/ol>\n

                  \n
                • Redo log, Controlfile\uc740 CDB, PDB \ubaa8\ub450 \uac19\uc774 \uc0ac\uc6a9\ud558\uac8c \ub41c\ub2e4.<\/span>\n\t\t<\/li>\n
                • \n
                  CDB Temp Tablespace\uc758 \uacbd\uc6b0 \ubaa8\ub4e0 PDB\uac00 \ub2e4 \uac19\uc774 \uc0ac\uc6a9\ud558\uc9c0\ub9cc, \uac01 PDB \ub9cc\uc744 \uc704\ud55c local temporary tablespace\ub97c<\/span>\n\t\t\t<\/div>\n

                  \ub9cc\ub4e4\uc5b4 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4
                  \n<\/span><\/p>\n

                  \u00a0
                  \n\u00a0<\/p>\n

                  SQL> COL FILE_NAME FORMAT A50
                  \n<\/span><\/p>\n

                  SQL> COL TABLESPACE_NAME FORMAT A8
                  \n<\/span><\/p>\n

                  SQL> COL FILE_ID FORMAT 9999
                  \n<\/span><\/p>\n

                  SQL> COL FILE_NAME FORMAT A50
                  \n<\/span><\/p>\n

                  SQL> COL TABLESPACE_NAME FORMAT A8
                  \n<\/span><\/p>\n

                  SQL> COL CON_ID FORMAT 999
                  \n<\/span><\/p>\n

                  SQL> SELECT FILE_NAME, TABLESPACE_NAME, FILE_ID, CON_ID FROM CDB_DATA_FILES ORDER BY CON_ID;
                  \n<\/span><\/p>\n

                  \u00a0
                  \n\u00a0<\/p>\n

                  FILE_NAME TABLESPA FILE_ID CON_ID
                  \n<\/span><\/p>\n

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

                  \/oradata\/cdb1\/system01.dbf SYSTEM 1 1
                  \n<\/span><\/p>\n

                  \/oradata\/cdb1\/sysaux01.dbf SYSAUX 3 1
                  \n<\/span><\/p>\n

                  \/oradata\/cdb1\/undotbs01.dbf UNDOTBS1 5 1
                  \n<\/span><\/p>\n

                  \/oradata\/cdb1\/users01.dbf USERS 6 1
                  \n<\/span><\/p>\n

                  \/oradata\/cdb1\/pdbseed\/sysaux01.dbf SYSAUX 4 2
                  \n<\/span><\/p>\n

                  \/oradata\/cdb1\/pdbseed\/system01.dbf SYSTEM 2 2
                  \n<\/span><\/p>\n

                  \/oradata\/cdb1\/PDB11\/system01.dbf SYSTEM 7 3
                  \n<\/span><\/p>\n

                  \/oradata\/cdb1\/PDB11\/sysaux01.dbf SYSAUX 8 3
                  \n<\/span><\/p>\n

                  \/oradata\/cdb1\/PDB12\/system01.dbf SYSTEM 9 4
                  \n<\/span><\/p>\n

                  \/oradata\/cdb1\/PDB12\/sysaux01.dbf SYSAUX 10 4
                  \n<\/span><\/p>\n

                  \u00a0
                  \n\u00a0<\/p>\n

                  10 rows selected.
                  \n<\/span><\/p>\n<\/li>\n<\/ul>\n

                  \u00a0
                  \n\u00a0<\/p>\n

                  # CDB, PDB \uc2dc\uc791<\/span>, \uc911\uc9c0<\/span>
                  \n\t\t\t<\/strong><\/span><\/p>\n

                    \n
                  1. CDB SHUTDOWN & STARTUP
                    \n<\/strong><\/span><\/li>\n<\/ol>\n
                      \n
                    • CDB\ub294 NON-CDB\uc640 \uac19\uc774 shutdown \uba85\ub839\uc5b4\ub85c \ub0b4\ub9b4 \uc218 \uc788\ub2e4.<\/span>\n\t\t<\/li>\n
                    • CDB\ub97c shutdown\ud558\uac8c \ub418\uba74 PDB\ub4e4\uc740 \uc790\ub3d9\uc73c\ub85c \ub2eb\ud788\uac8c \ub41c\ub2e4.<\/span>\n\t\t<\/li>\n
                    • \n
                      CDB\uac00 \uc2dc\uc791\ub418\uc5b4\ub3c4 PDB\ub294 \uc790\ub3d9\uc73c\ub85c \uc2dc\uc791\ub418\uc9c0 \uc54a\ub294\ub2e4.<\/span>\n\t\t\t<\/div>\n

                      \u00a0
                      \n\u00a0<\/p>\n

                      SQL> SELECT NAME, CDB, CON_ID FROM V$DATABASE;\n<\/p>\n

                      \u00a0
                      \n\u00a0<\/p>\n

                      NAME CDB CON_ID\n<\/p>\n

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

                      CDB1 YES 0\n<\/p>\n

                      \u00a0
                      \n\u00a0<\/p>\n

                      SQL> SHUTDOWN IMMEDIATE;\n<\/p>\n

                      Database closed.\n<\/p>\n

                      Database dismounted.\n<\/p>\n

                      ORACLE instance shut down.\n<\/p>\n

                      SQL> SELECT CON_ID, NAME, OPEN_MODE FROM V$PDBS;\n<\/p>\n

                      SELECT CON_ID, NAME, OPEN_MODE FROM V$PDBS\n<\/p>\n

                      *\n<\/p>\n

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

                      ORA-01034: ORACLE not available\n<\/p>\n

                      Process ID: 0\n<\/p>\n

                      Session ID: 0 Serial number: 0\n<\/p>\n

                      \u00a0
                      \n\u00a0<\/p>\n

                      \u00a0
                      \n\u00a0<\/p>\n

                      SQL> STARTUP NOMOUNT;\n<\/p>\n

                      ORACLE instance started.\n<\/p>\n

                      \u00a0
                      \n\u00a0<\/p>\n

                      Total System Global Area 835104768 bytes\n<\/p>\n

                      Fixed Size 2293880 bytes\n<\/p>\n

                      Variable Size 595595144 bytes\n<\/p>\n

                      Database Buffers 234881024 bytes\n<\/p>\n

                      Redo Buffers 2334720 bytes\n<\/p>\n

                      SQL> SELECT CON_ID, NAME, OPEN_MODE FROM V$PDBS;\n<\/p>\n

                      \u00a0
                      \n\u00a0<\/p>\n

                      no rows selected\n<\/p>\n

                      \u00a0
                      \n\u00a0<\/p>\n

                      SQL> ALTER DATABASE MOUNT;\n<\/p>\n

                      \u00a0
                      \n\u00a0<\/p>\n

                      Database altered.\n<\/p>\n

                      \u00a0
                      \n\u00a0<\/p>\n

                      SQL> SELECT CON_ID, NAME, OPEN_MODE FROM V$PDBS;\n<\/p>\n

                      \u00a0
                      \n\u00a0<\/p>\n

                      CON_ID NAME OPEN_MODE\n<\/p>\n

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

                      2 PDB$SEED MOUNTED\n<\/p>\n

                      3 PDB11 MOUNTED\n<\/p>\n

                      4 PDB12 MOUNTED\n<\/p>\n

                      \u00a0
                      \n\u00a0<\/p>\n

                      SQL> ALTER PLUGGABLE DATABASE PDB11 OPEN;\n<\/p>\n

                      ALTER PLUGGABLE DATABASE PDB11 OPEN\n<\/p>\n

                      *\n<\/p>\n

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

                      ORA-01109: database not open\n<\/p>\n

                      \u00a0
                      \n\u00a0<\/p>\n

                      \u00a0
                      \n\u00a0<\/p>\n

                      SQL> ALTER DATABASE OPEN;\n<\/p>\n

                      \u00a0
                      \n\u00a0<\/p>\n

                      Database altered.\n<\/p>\n

                      \u00a0
                      \n\u00a0<\/p>\n

                      SQL> SELECT CON_ID, NAME, OPEN_MODE FROM V$PDBS;\n<\/p>\n

                      \u00a0
                      \n\u00a0<\/p>\n

                      CON_ID NAME OPEN_MODE\n<\/p>\n

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

                      2 PDB$SEED READ ONLY\n<\/p>\n

                      3 PDB11 MOUNTED\n<\/p>\n

                      4 PDB12 MOUNTED\n<\/p>\n

                      \u00a0
                      \n\u00a0<\/p>\n

                      SQL> ALTER PLUGGABLE DATABASE ALL OPEN;\n<\/p>\n

                      \u00a0
                      \n\u00a0<\/p>\n

                      Pluggable database altered.\n<\/p>\n

                      \u00a0
                      \n\u00a0<\/p>\n

                      SQL> SELECT CON_ID, NAME, OPEN_MODE FROM V$PDBS;\n<\/p>\n

                      \u00a0
                      \n\u00a0<\/p>\n

                      CON_ID NAME OPEN_MODE\n<\/p>\n

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

                      2 PDB$SEED READ ONLY\n<\/p>\n

                      3 PDB11 READ WRITE\n<\/p>\n

                      4 PDB12 READ WRITE\n<\/p>\n

                      \u00a0
                      \n\u00a0<\/p>\n<\/li>\n<\/ul>\n

                        \n
                      1. PDB OPEN and CLOSE
                        \n<\/strong><\/span><\/li>\n<\/ol>\n
                          \n
                        • ALTER PLUGGABLE DATABASE \uad6c\ubb38<\/span>
                          \n\t\t\t\ub610\ub294<\/span> SQL*PLUS STARTUP \uba85\ub839\uc5b4\ub85c<\/span> PDB\ub97c<\/span>
                          \n\t\t\t\ucee8\ud2b8\ub864<\/span>
                          \n\t\t\t\ud560<\/span>
                          \n\t\t\t\uc218<\/span>
                          \n\t\t\t\uc788\uc74c<\/span>\n\t\t<\/li>\n
                        • \n
                          CDB\uc5d0\uc11c<\/span>
                          \n\t\t\t\t\uc2e4\uc2dc<\/span>\n\t\t\t<\/div>\n

                          SQL> SELECT NAME, CDB, CON_ID FROM V$DATABASE;\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          NAME CDB CON_ID\n<\/p>\n

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

                          CDB1 YES 0\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          SQL> STARTUP FORCE;\n<\/p>\n

                          ORACLE instance started.\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          Total System Global Area 835104768 bytes\n<\/p>\n

                          Fixed Size 2293880 bytes\n<\/p>\n

                          Variable Size 595595144 bytes\n<\/p>\n

                          Database Buffers 234881024 bytes\n<\/p>\n

                          Redo Buffers 2334720 bytes\n<\/p>\n

                          Database mounted.\n<\/p>\n

                          Database opened.\n<\/p>\n

                          SQL> SELECT CON_ID, NAME, OPEN_MODE FROM V$PDBS;\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          CON_ID NAME OPEN_MODE\n<\/p>\n

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

                          2 PDB$SEED READ ONLY\n<\/p>\n

                          3 PDB11 MOUNTED\n<\/p>\n

                          4 PDB12 MOUNTED\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          SQL> ALTER PLUGGABLE DATABASE ALL OPEN;\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          Pluggable database altered.\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          SQL> SELECT CON_ID, NAME, OPEN_MODE FROM V$PDBS;\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          CON_ID NAME OPEN_MODE\n<\/p>\n

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

                          2 PDB$SEED READ ONLY\n<\/p>\n

                          3 PDB11 READ WRITE\n<\/p>\n

                          4 PDB12 READ WRITE\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          SQL> ALTER PLUGGABLE DATABASE PDB11 CLOSE;\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          Pluggable database altered.\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          SQL> SELECT CON_ID, NAME, OPEN_MODE FROM V$PDBS;\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          CON_ID NAME OPEN_MODE\n<\/p>\n

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

                          2 PDB$SEED READ ONLY\n<\/p>\n

                          3 PDB11 MOUNTED\n<\/p>\n

                          4 PDB12 READ WRITE\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          SQL> CONNECT SYS\/oracle@PDB11\n<\/p>\n

                          ERROR:\n<\/p>\n

                          ORA-01033: ORACLE initialization or shutdown in progress\n<\/p>\n

                          Process ID: 0\n<\/p>\n

                          Session ID: 0 Serial number: 0\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          SQL> CONNECT SYS\/oracle@CDB1 AS SYSDBA;\n<\/p>\n

                          Connected.\n<\/p>\n

                          SQL> ALTER PLUGGABLE DATABASE PDB11 OPEN;\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          Pluggable database altered.\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          SQL> SELECT CON_ID, NAME, OPEN_MODE FROM V$PDBS;\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          CON_ID NAME OPEN_MODE\n<\/p>\n

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

                          2 PDB$SEED READ ONLY\n<\/p>\n

                          3 PDB11 READ WRITE\n<\/p>\n

                          4 PDB12 READ WRITE\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          SQL> ALTER PLUGGABLE DATABASE ALL EXCEPT PDB12 CLOSE;\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          Pluggable database altered.\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          SQL> SELECT CON_ID, NAME, OPEN_MODE FROM V$PDBS;\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          CON_ID NAME OPEN_MODE\n<\/p>\n

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

                          2 PDB$SEED READ ONLY\n<\/p>\n

                          3 PDB11 MOUNTED\n<\/p>\n

                          4 PDB12 READ WRITE\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          SQL> ALTER PLUGGABLE DATABASE ALL CLOSE;\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          Pluggable database altered.\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          SQL> SELECT CON_ID, NAME, OPEN_MODE FROM V$PDBS;\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          CON_ID NAME OPEN_MODE\n<\/p>\n

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

                          2 PDB$SEED READ ONLY\n<\/p>\n

                          3 PDB11 MOUNTED\n<\/p>\n

                          4 PDB12 MOUNTED\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          SQL> ALTER PLUGGABLE DATABASE ALL EXCEPT PDB11 OPEN;\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          Pluggable database altered.\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          SQL> SELECT CON_ID, NAME, OPEN_MODE FROM V$PDBS;\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          CON_ID NAME OPEN_MODE\n<\/p>\n

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

                          2 PDB$SEED READ ONLY\n<\/p>\n

                          3 PDB11 MOUNTED\n<\/p>\n

                          4 PDB12 READ WRITE\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          SQL> STARTUP PLUGGABLE DATABASE PDB11 OPEN READ ONLY;\n<\/p>\n

                          Pluggable Database opened.\n<\/p>\n

                          SQL> SELECT CON_ID, NAME, OPEN_MODE FROM V$PDBS;\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          CON_ID NAME OPEN_MODE\n<\/p>\n

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

                          2 PDB$SEED READ ONLY\n<\/p>\n

                          3 PDB11 READ ONLY\n<\/p>\n

                          4 PDB12 READ WRITE\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          SQL> STARTUP PLUGGABLE DATABASE PDB11 FORCE;\n<\/p>\n

                          Pluggable Database opened.\n<\/p>\n

                          SQL> SELECT CON_ID, NAME, OPEN_MODE FROM V$PDBS;\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          CON_ID NAME OPEN_MODE\n<\/p>\n

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

                          2 PDB$SEED READ ONLY\n<\/p>\n

                          3 PDB11 READ WRITE\n<\/p>\n

                          4 PDB12 READ WRITE\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          SQL> ALTER PLUGGABLE DATABASE PDB11 CLOSE;\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          Pluggable database altered.\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          SQL> SELECT CON_ID, NAME, OPEN_MODE FROM V$PDBS;\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          CON_ID NAME OPEN_MODE\n<\/p>\n

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

                          2 PDB$SEED READ ONLY\n<\/p>\n

                          3 PDB11 MOUNTED\n<\/p>\n

                          4 PDB12 READ WRITE\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n<\/li>\n

                        • \n
                          PDB\uc5d0\uc11c<\/span>
                          \n\t\t\t\t\uc2e4\uc2dc<\/span>\n\t\t\t<\/div>\n

                          SQL> CONNECT SYS\/oracle@PDB11 AS SYSDBA;\n<\/p>\n

                          Connected.\n<\/p>\n

                          SQL> SELECT CON_ID, NAME, OPEN_MODE FROM V$PDBS;\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          CON_ID NAME OPEN_MODE\n<\/p>\n

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

                          3 PDB11 MOUNTED\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          SQL> STARTUP;\n<\/p>\n

                          Pluggable Database opened.\n<\/p>\n

                          SQL> SELECT CON_ID, NAME, OPEN_MODE FROM V$PDBS;\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          CON_ID NAME OPEN_MODE\n<\/p>\n

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

                          3 PDB11 READ WRITE\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          SQL> SHUTDOWN IMMEDIATE;\n<\/p>\n

                          Pluggable Database closed.\n<\/p>\n

                          SQL> SELECT CON_ID, NAME, OPEN_MODE FROM V$PDBS;\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          CON_ID NAME OPEN_MODE\n<\/p>\n

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

                          3 PDB11 MOUNTED\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          SQL> STARTUP OPEN READ ONLY;\n<\/p>\n

                          Pluggable Database opened.\n<\/p>\n

                          SQL> SELECT CON_ID, NAME, OPEN_MODE FROM V$PDBS;\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          CON_ID NAME OPEN_MODE\n<\/p>\n

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

                          3 PDB11 READ ONLY\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          SQL> STARTUP FORCE;\n<\/p>\n

                          Pluggable Database opened.\n<\/p>\n

                          SQL> SELECT CON_ID, NAME, OPEN_MODE FROM V$PDBS;\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          CON_ID NAME OPEN_MODE\n<\/p>\n

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

                          3 PDB11 READ WRITE\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          SQL> ALTER PLUGGABLE DATABASE CLOSE IMMEDIATE;\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          Pluggable database altered.\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          SQL> SELECT CON_ID, NAME, OPEN_MODE FROM V$PDBS;\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          CON_ID NAME OPEN_MODE\n<\/p>\n

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

                          3 PDB11 MOUNTED\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          SQL> ALTER PLUGGABLE DATABASE OPEN READ ONLY;\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          Pluggable database altered.\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          SQL> SELECT CON_ID, NAME, OPEN_MODE FROM V$PDBS;\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          CON_ID NAME OPEN_MODE\n<\/p>\n

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

                          3 PDB11 READ ONLY\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          SQL> ALTER PLUGGABLE DATABASE OPEN FORCE;\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          Pluggable database altered.\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          SQL> SELECT CON_ID, NAME, OPEN_MODE FROM V$PDBS;\n<\/p>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                          CON_ID NAME OPEN_MODE\n<\/p>\n

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

                          3 PDB11 READ WRITE\n<\/p>\n<\/li>\n<\/ul>\n

                          \u00a0
                          \n<\/span>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"

                          \ubc30\uacbd : \ud604\uc7ac 12c \uc124\uce58\ub418\uc5b4 \uc788\uace0 PDB 2\uac1c \uc124\uce58 \ub418\uc5b4 \uc788\ub294 \uc0c1\ud0dc \uc785\ub2c8\ub2e4. \u00a0 \u00a0 # \uc2dc\uc791 \ubc0f \uc11c\ube44\uc2a4 \uc811\uc18d\ubc29\ubc95 CDB & PDB \uc2dc\uc791 [root@test ~]# su – oracle [test@cdb1 : \/home\/oracle]$ sqlplus \u00a0 \u00a0 SQL*Plus: Release 12.1.0.1.0 Production on Fri Aug 7 11:11:51 2015 \u00a0 \u00a0 Copyright (c) 1982, 2013, Oracle. All rights reserved. […]<\/p>\n","protected":false},"author":1,"featured_media":1210,"comment_status":"closed","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":[20],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile7.uf.2566F34D5688F959332EA4.png?fit=374%2C128","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1209"}],"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=1209"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1209\/revisions"}],"predecessor-version":[{"id":4424,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1209\/revisions\/4424"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/1210"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1209"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1209"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}