{"id":2873,"date":"2018-02-03T18:53:54","date_gmt":"2018-02-03T09:53:54","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=2873"},"modified":"2018-02-03T18:53:54","modified_gmt":"2018-02-03T09:53:54","slug":"oracle-database-%ec%9e%a5%ec%95%a0-%eb%b3%b5%ea%b5%ac-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=2873","title":{"rendered":"Oracle Database \uc7a5\uc560 \ubcf5\uad6c \ubc29\ubc95"},"content":{"rendered":"

[1] Archive Mode \uc6b4\uc601 \uc911\uc778 DB\uc5d0\uc11c \ud2b9\uc815 Table\uc744 Drop \ud588\uc744 \uacbd\uc6b0.<\/span>
\n<\/strong><\/span><\/p>\n

[\ud604\uc0c11] \uac1c\ubc1c\uc790\uac00 \uc2e4\uc218\ub85c \ud2b9\uc815 Table\uc744 Drop \uc744 \ud588\uc74c.(\ub2e8, \uac1c\ubc1c\uc790\uac00 \uc7a5\uc560\uc2dc\uc810\uc744 \uc54c\uace0\uc788\ub2e4\uace0 \uac00\uc815\ud55c\ub2e4.)<\/p>\n

[\ud604\uc0c12] Export \ubc1b\uc740 \ub370\uc774\ud130\uac00 \uc5c6\uc74c. DB\ub97c shutdown \ud560 \uc218 \uc5c6\ub294 \uc0c1\ud669.<\/p>\n

[\ud604\uc0c13] DBA\ub294 2004\ub144 07\uc6d405\uc77c 09:30\ubd84\uacbd\uc5d0 \uac1c\ubc1c\uc790\ub85c\ubd80\ud130mnt_state \ud14c\uc774\ube14\uc744 Drop\ud588\ub2e4\uace0 \uc5f0\ub77d\ubc1b\uc74c.<\/p>\n

[\ud604\uc0c14] RAW Device \ub97c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc74c. DB\ub294 Archvie Mode, Hot Backup \ub370\uc774\ud130 \uc874\uc7ac. Archive log \uc874\uc7ac.<\/p>\n

[\ubcf5\uad6c\ubc29\ubc95] \ubc31\uc5c5\ub41c \ucee8\ud2b8\ub864 \ud30c\uc77c\uc744 \uc774\uc6a9\ud55c \ubd88\uc644\uc804 \ubcf5\uad6c \ubc29\ubc95\uc744 \uc120\ud0dd.<\/p>\n

DB\uc5d0\uc11c HRDEV\ub85c \ubc31\uc5c5 \ubc1b\uc740 \ub370\uc774\ud130\ub97c \uc774\uad00\ud558\uc5ec DB\ub97c \uc0dd\uc131 \uae30\ub3d9\ud558\uc5ec \ud574\ub2f9 \ud14c\uc774\ube14\ub9cc \ubcf5\uad6c.<\/p>\n

[\ubcf5\uad6c\uc2dc\uc810] select to_char(sysdate, ‘YYYY-MM-DD:HH24:MI:SS’) Time from dual<\/p>\n

TIME : 2004-07-05:09:29:30<\/p>\n

[1\ub2e8\uacc4] DB – Object \uc815\ubcf4 \ud655\uc778
\n<\/strong><\/p>\n

1) \uc7a5\uc560\uac00 \ubc1c\uc0dd\ud55c Table\uc774 \uc18d\ud55c Tablespace \ud655\uc778.<\/p>\n

SQL> select owner, segment_name, tablespace_name, bytes\/1024\/1024 from dba_segments where segment_name like ‘MNT%’;<\/p>\n

\n\n\n<\/colgroup>\n\n\n
OWNER SEGMENT_NAME TABLESPACE BYTES\/1024\/1024
\n<\/span><\/p>\n

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

HRMS MNT_PLAN DATA_CDP .125
\n<\/span><\/p>\n

HRMS MNT_STATE DATA_CDP .0625<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\u00e0<\/span> \uc7a5\uc560 \uad00\ub828\ub41c Tablespace \uac00 DATA_CDP \ub77c\ub294 \uac83\uc744 \ud655\uc778\ud568.<\/p>\n

2) \ub370\uc774\ud130\ub97c \ubcf5\uad6c\ud560 Datafile \ud655\uc778<\/p>\n

SQL> select tablespace_name, file_name, bytes\/1024\/1024 from dba_data_files where tablespace_name in (‘SYSTEM’,’RBS’) or tablespace_name = ‘DATA_CDP’;<\/p>\n

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

TABLESPACE_NAME FILE_NAME BYTES\/1024\/1024
\n<\/span><\/p>\n

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

DATA_CDP \/dbstorage0\/hrms\/data_cdp01.dbf 200
\n<\/span><\/p>\n

SYSTEM \/orastorage\/DB\/system01.dbf 1000
\n<\/span><\/p>\n

RBS \/dbstorage0\/hrms\/rbs01.dbf 2048
\n<\/span><\/p>\n

RBS \/dbstorage0\/hrms\/rbs02.dbf 1024
\n<\/span><\/p>\n

TEMP \/orastorage\/DB\/temp01.dbf 384<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

3) Redo log \uc815\ubcf4 \ubc0f control file \uc815\ubcf4 \ud655\uc778<\/p>\n

SQL> select * from v$logfile;<\/p>\n

\n\n\n<\/colgroup>\n\n\n
\/orastorage\/DB\/redo03.log
\n<\/span><\/p>\n

\/orastorage\/DB\/redo02.log
\n<\/span><\/p>\n

\/orastorage\/DB\/redo01.log<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

SQL> select name from v$controlfile;<\/p>\n

\n\n\n<\/colgroup>\n\n\n
\/orastorage\/DB\/system\/control01.ctl
\n<\/span><\/p>\n

\/dbstorage0\/hrms\/system\/control02.ctl
\n<\/span><\/p>\n

\/dbindex0\/hrms\/system\/control03.ctl<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

[2\ub2e8\uacc4] \ubc31\uc5c5 \ubc1b\uc740 \ub370\uc774\ud130 \uc774\uad00 (Media Recovery)
\n<\/strong><\/p>\n

1)\uc2dc\uc2a4\ud15c \ub2f4\ub2f9\uc790\uc5d0\uac8c \ubcf5\uad6c\ud560 \ub300\uc0c1 \ud1b5\ubcf4 \ubc0f Recovery<\/p>\n

– SYSTEM \/ RBS \/ DATA_CDP datafile \uc744 HRDEV DB\ub85c Restore.<\/p>\n

– \/dbstorage0\/hrms\/* \u00e0<\/span> \/backup\/oradata\/ORCL\/* (\uacbd\ub85c\ub97c \ubcc0\uacbd\ud558\uc5ec Restore \ud55c\ub2e4.)<\/p>\n

2) DB\uc758 \uc624\ub77c\ud074 Home Directory\ub97c HRDEV \uc11c\ubc84\ub85c copy<\/p>\n

3) DB\uc758 control file \uc815\ubcf4 \uc5bb\uae30<\/p>\n

SQL> alter database backup controlfile to trace ;<\/p>\n

\u00e0<\/span> udump\uc5d0\uc11c trace \ud30c\uc77c \ud655\uc778 \ud6c4 HRDEV \uc11c\ubc84\ub85c \uc774\uad00.<\/p>\n

4) Trace \ud30c\uc77c \uc774\uad00 \ud6c4 \ud3b8\uc9d1. ( file = recoverdb.trc)<\/p>\n

CREATE CONTROLFILE REUSE DATABASE “DB” NORESETLOGS ARCHIVELOG<\/p>\n

\u00e0<\/span>
\nCREATE CONTROLFILE REUSE set DATABASE “ORCL” RESETLOGS<\/strong><\/span> ARCHIVELOG
\n<\/span><\/p>\n

\n\n\n<\/colgroup>\n\n\n
STARTUP NOMOUNT
\n<\/span><\/p>\n

CREATE CONTROLFILE REUSE set DATABASE “ORCL” RESETLOGS ARCHIVELOG
\n<\/span><\/p>\n

MAXLOGFILES 5
\n<\/span><\/p>\n

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

MAXDATAFILES 2725
\n<\/span><\/p>\n

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

MAXLOGHISTORY 8186
\n<\/span><\/p>\n

LOGFILE
\n<\/span><\/p>\n

GROUP 1 ‘\/backup\/oradata\/ORCL\/redo01.log’ SIZE 100M,
\n<\/span><\/p>\n

GROUP 2 ‘\/backup\/oradata\/ORCL\/redo02.log’ SIZE 100M,
\n<\/span><\/p>\n

GROUP 3 ‘\/backup\/oradata\/ORCL\/redo03.log’ SIZE 100M
\n<\/span><\/p>\n

DATAFILE
\n<\/span><\/p>\n

‘\/backup\/oradata\/ORCL\/system01.dbf ‘,
\n<\/span><\/p>\n

‘ \/backup\/oradata\/ORCL\/rbs01.dbf ‘,
\n<\/span><\/p>\n

‘ \/backup\/oradata\/ORCL\/rbs02.dbf ‘,
\n<\/span><\/p>\n

‘\/backup\/oradata\/ORCL\/data_cdp01.dbf ‘
\n<\/span><\/p>\n

CHARACTER SET KO16KSC5601 ;<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

[3\ub2e8\uacc4] ORCL\ud658\uacbd \uc815\ubcf4 \ud3b8\uc9d1.
\n<\/strong><\/p>\n

1) initORCL.ora \ud30c\uc77c \ubcc0\uacbd.<\/p>\n

– Controlfile \uc704\uce58 \ubcc0\uacbd.
\n<\/span><\/p>\n

\/orastorage\/DB\/system\/control01.ctl <\/span>\u00e0<\/span> \/backup\/oradata\/ORCL\/control01.ctl
\n<\/span><\/span><\/p>\n

– Arch Directory \ubcc0\uacbd
\n<\/span><\/p>\n

\/ora_arch\/arc \u00e0<\/span> \/backup\/ORCL\/arc
\n<\/span><\/p>\n

[4\ub2e8\uacc4] Media Recovery \uac00 \uc644\ub8cc\ub418\uba74 Database Recovery\ub97c \uc218\ud589\ud55c\ub2e4.
\n<\/strong><\/p>\n

1) control file \uc7ac\uc0dd\uc131\uc744 \ud1b5\ud574 instance \ub97c \uae30\ub3d9 (Recoverdb.trc)<\/p>\n

$sqlplus ‘\/as sysdba’<\/p>\n

SQL> @recoverdb.trc<\/p>\n

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

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

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

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

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

Control file Created .<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

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

SQL> alter session set nls_date_format = ‘YYYY-MM-DD:HH24:MI:SS’ ;<\/p>\n

TIME : 2004-07-05:09:29:30<\/p>\n

2) Recovery \uc218\ud589.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
SQL> alter database mount;
\n<\/strong><\/span><\/p>\n

SQL> set autorecovery on<\/h2>\n

SQL> Recover database until time ‘2004-07-05:09:29:30’ using backup controlfile;
\n<\/strong><\/span><\/p>\n

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
\n<\/span><\/p>\n

AUTO <\/strong>
\n\u00e0<\/span> AUTO\ub97c \uc120\ud0dd\ud55c\ub2e4.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

[5\ub2e8\uacc4] Database reset logs\ub97c \uc774\uc6a9\ud55c Open
\n<\/strong><\/p>\n

SQL> alter database open resetlogs;<\/p>\n

[6\ub2e8\uacc4] Temp tablespace \uc0dd\uc131 \ubc0f user temporary tablespace \ubcc0\uacbd.
\n<\/strong><\/p>\n

1)Temp Tablespace \uc0dd\uc131.<\/p>\n

SQL> create temporary tablespace TEMP2 tempfile ‘\/backup\/oradata\/ORCL\/temp2.dbf’ size 100m;<\/p>\n

2) User Temporary Tablespace \ubcc0\uacbd.<\/p>\n

SQL> spool alt_user_temp2.sql<\/p>\n

SQL> select ‘alter user ‘||username|| ‘ temporary tablespace TEMP2;’ from dba_users;<\/p>\n

SQL> spool off<\/p>\n

SQL> @alt_user_temp2.sql<\/p>\n

[7\ub2e8\uacc4] Drop \ub41c \ud14c\uc774\ube14\uc774 \ubcf5\uad6c \ub418\uc5c8\ub294\uc9c0 \ud655\uc778\ud558\uace0, \ud574\ub2f9 Table\ub9cc DB\ub85c \ubcf5\uad6c\ud55c\ub2e4.
\n<\/strong><\/p>\n

SQL> select count(*) from MNT_STATE; \u00e0<\/span> \uac74\uc218 \ud655\uc778<\/p>\n

\u00e0<\/span> export \ub610\ub294 CTAS \ud1b5\ud574 DB\ub85c \ub370\uc774\ud130\ub97c import \ud55c\ub2e4.<\/p>\n

[8\ub2e8\uacc4] Table Recovery \uc644\ub8cc.
\n<\/strong><\/p>\n

[2] NOARCHIVE LOG Mode Database \uc6b4\uc601 \uc911 Datafile \uc190\uc2e4.<\/span>
\n<\/strong><\/span><\/p>\n

1. OFFLINE Full Backup \ubcf8\uc774 \uc788\ub294 \uacbd\uc6b0<\/strong><\/span><\/p>\n

[\ubc1c\uc0dd\uc6d0\uc778] \ud2b9\uc815 Datafile \uc190\uc2e4\ub85c \uc778\ud558\uc5ec Database Crash.<\/p>\n

[\uc7a5\uc560\ud604\uc0c1] – Database shutdown \uc774\ubbc0\ub85c DB \uc0ac\uc6a9 \ubd88\uac00.<\/p>\n

Noarchvie Log Mode \uc774\uace0, \uc9c0\ub09c \uc8fc Full Backup \ub370\uc774\ud130\uac00 \uc874\uc7ac,<\/p>\n

\uc774\ub7ec\ud55c \uacbd\uc6b0\ub294 Full backup \ubc1b\uc740 \uc2dc\uc810\uc73c\ub85c\ub9cc Recovery \uac00 \uac00\ub2a5\ud558\ubbc0\ub85c \ub370\uc774\ud130 \uc190\uc2e4\uc774 \ubc1c\uc0dd\ud568.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
ORA-01157 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud55c\ub2e4. \ub2e4\uc74c\uacfc \uac19\uc740 \uc5d0\ub7ec\uba54\uc2dc\uc9c0\uac00 \ub098\ud0c0\ub09c\ub2e4.
\n<\/span><\/p>\n

ORA-01157 : cannot identify data file 4 – file not found
\n<\/span><\/p>\n

ORA-01110 : data file 4 : ‘<\/span>\/data\/ORADB\/oradbdata\/system\/temp_01.dbf’<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

[\ubcf5\uad6c\ubc29\ubc95]<\/p>\n

– Cold Backup \uc73c\ub85c Full Backup \ubc1b\uc740 \ubc31\uc5c5\ubcf8\uc73c\ub85c Restore \ud55c\ub2e4.
\n<\/strong><\/span><\/p>\n

[1\ub2e8\uacc4] \uac00\uc7a5 \ucd5c\uadfc\uc758 Full Backup \ubcf8\uc744 Restore \ud55c\ub2e4.<\/p>\n

[2\ub2e8\uacc4] Database Startup \ud55c\ub2e4.<\/p>\n

$sqlplus ‘\/as sysdba’<\/p>\n

SQL> startup mount<\/p>\n

SQL> alter database open;<\/p>\n

[3\ub2e8\uacc4] \ud655\uc778<\/p>\n

SQL> select h.tablespace_name, d.name, h.error from v$datafile d , v$datafile_header h<\/p>\n

Where d.file# = h.file#;<\/p>\n

\n\n\n<\/colgroup>\n\n\n
TABLESPACE_NAME NAME ERROR
\n<\/span><\/p>\n

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

SYSTEM \/data\/ORADB\/oradbdata\/system01.dbf
\n<\/span><\/p>\n

SYSTEM \/data\/ORADB\/oradbdata\/system02.dbf
\n<\/span><\/p>\n

SYSTEM \/data\/ORADB\/oradbdata\/system03.dbf
\n<\/span><\/p>\n

SYSTEM \/data\/ORADB\/oradbdata\/system04.dbf
\n<\/span><\/p>\n

SYSTEM \/data\/ORADB\/oradbdata\/system05.dbf
\n<\/span><\/p>\n

CTXD \/data\/ORADB\/oradbdata\/ctxd01.dbf
\n<\/span><\/p>\n

OWAPUB \/data\/ORADB\/oradbdata\/owad01.dbf
\n<\/span><\/p>\n

ABMD \/data\/ORADB\/oradbdata\/abmd01.dbf<\/span>
\n<\/span><\/p>\n

ABMX \/data\/ORADB\/oradbdata\/abmx01.dbf
\n<\/span><\/p>\n

\u2026\u2026.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\u00e0<\/span> \ub9cc\uc57d\ub41c Datafile \uc774 \uc190\uc2e4\ub41c \uacbd\uc6b0 ERROR \ud56d\ubaa9\uc5d0 “FILE NOT FOUND” <\/strong>\ub77c\uace0 \uba54\uc2dc\uc9c0\uac00 \ub098\ud0c0\ub0a8.<\/p>\n

2. \uc190\uc2e4\ub41c Datafile \uc774 Temp Tablespace \uc5d0 \uc18d\ud55c datafile \uc77c \uacbd\uc6b0
\n<\/strong><\/span><\/p>\n

[1\ub2e8\uacc4] DB shutdown \ud55c\ub2e4.<\/p>\n

[2\ub2e8\uacc4] sysdba User connect \ud574\uc11c mount \ub2e8\uacc4\uc5d0\uc11c \ud574\ub2f9 datafile offline drop \ud6c4 DB Open \ud55c\ub2e4.<\/p>\n

$ sqlplus ‘\/as sysdba’<\/p>\n

SQL> startup mount<\/p>\n

SQL> alter databae datafile ‘\/data\/ORADB\/oradbdata\/system\/temp_01.dbf’ offline drop ;<\/p>\n

SQL> alter database open;<\/p>\n

[3\ub2e8\uacc4] \uc190\uc2e4\ub41c datafile \uc758 \ud574\ub2f9 Tablespace \ub97c drop \ud55c\ub2e4.<\/p>\n

$sqlplus ‘\/as sysdba’<\/p>\n

SQL> drop tablespace TEMP ;<\/p>\n

[4\ub2e8\uacc4] TEMP Tablespace \uc7ac\uc0dd\uc131\ud55c\ub2e4.<\/p>\n

$ sqlplus ‘\/as sysdba’<\/p>\n

SQL> create tablespace TEMP datafile ‘\/data\/ORADB\/oradbdata\/system\/temp_01.dbf’ size 1000M;<\/p>\n

3. Media \uc5d0\ub7ec\ub85c \uc778\ud55c \uc784\uc758 Directory \ub85c\uc758 DB \ubcf5\uad6c
\n<\/strong><\/span><\/p>\n

[\uc7a5\uc560\ud604\uc0c1] Media Disk \uc5d0\ub7ec\ub85c \uc778\ud574 \uc7a5\uc560 \ub514\uc2a4\ud06c \/data\/ORADB\/oradbdata \uc811\uadfc\uc774 \ubd88\uac00\ub428 (DB shutdown)<\/p>\n

No Archive \ub85c\uadf8 \ubaa8\ub4dc\uc774\uace0, \ud574\ub2f9 Datafile\uc774 Corrupt \ub428. \ub9e4\uc8fc \uc77c\uc694\uc77c\uc5d0 Offline Full Backup \uc2e4\uc2dc.<\/p>\n

\uc7a5\uc560 Directory\uc5d0\ub294 system \ub370\uc774\ud130 \ud30c\uc77c\uc744 \ud3ec\ud568 control file \uacfc redo log file\ub3c4 \uc874\uc7ac.<\/p>\n

[\ubcf5\uad6c\ubc29\ubc95] Full Backup \ubc1b\uc740 \ub370\uc774\ud130\ub97c \uc784\uc2dc \ub514\ub809\ud1a0\ub9ac\ub85c Restore<\/p>\n

(\/data\/ORADB\/oradbdata \/* \u00e0<\/span> \/data2\/ORADB\/imsy\/* \uc774\uc804)<\/p>\n

[1\ub2e8\uacc4] DB shutdown \ubc0f \uc7a5\uc560 \uc720\ubc1c.
\n<\/strong><\/p>\n

\n\n\n<\/colgroup>\n\n\n
$sqlplus ‘\/as sysdba’
\n<\/span><\/p>\n

SQL> col name format a45
\n<\/span><\/h4>\n

SQL> select name, status from v$datafile;<\/strong>
\nNAME STATUS
\n<\/span><\/p>\n

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

\/data\/ORADB\/oradbdata\/system01.dbf SYSTEM
\n<\/span><\/p>\n

\/data\/ORADB\/oradbdata\/alrd01.dbf ONLINE
\n<\/span><\/p>\n

\/data\/ORADB\/oradbdata\/alrx01.dbf ONLINE
\n<\/span><\/p>\n

\/data\/ORADB\/oradbdata\/amsd01.dbf ONLINE
\n<\/span><\/p>\n

\/data\/ORADB\/oradbdata\/amsx01.dbf ONLINE
\n<\/span><\/p>\n

SQL> col member format a30
\n<\/strong><\/span><\/p>\n

SQL> select member from v$logfile;
\n<\/strong><\/span><\/p>\n

\/data\/ORADB\/oradbdata\/log01a.ora
\n<\/span><\/p>\n

\/data\/ORADB\/oradbdata\/log02a.ora
\n<\/span><\/p>\n

\/data\/ORADB\/oradbdata\/log03a.ora
\n<\/span><\/p>\n

SQL> col NAME format a40
\n<\/span><\/h5>\n

SQL> select name from v$controlfile;
\n<\/strong><\/span><\/p>\n

\/data\/ORADB\/oradbdata\/cntrl01.dbf
\n<\/span><\/p>\n

\/data\/ORADB\/oradbdata\/cntrl02.dbf
\n<\/span><\/p>\n

\/data\/ORADB\/oradbdata\/cntrl03.dbf<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

$ \\rm -rf \/data\/ORADB\/oradbdata\/* \u00e0<\/span> \/data\/ORADB\/oradbdata\/* \ub370\uc774\ud130 \ud30c\uc77c \ubaa8\ub450 \uc0ad\uc81c\ud55c\ub2e4.<\/p>\n

[2\ub2e8\uacc4] \ubc31\uc5c5 \ub370\uc774\ud130 Full Restore
\n<\/strong><\/p>\n

\u00e0<\/span> \ub2e8, \/data\/ORADB\/oradbdata \ucabd\uc740 \uc811\uadfc\uc774 \ubd88\uac00\ub2a5\ud558\ubbc0\ub85c \ud574\ub2f9 \ub370\uc774\ud130 \ud30c\uc77c\uc744 \uc784\uc2dc \ub514\ub809\ud1a0\ub9ac\uc5d0 restore.<\/p>\n

\/data2\/ORADB\/imsy\/* \ub85c \ub0b4\ub9b0\ub2e4. (\ub098\uba38\uc9c4 \ub370\uc774\ud130\ud30c\uc77c\uc740 \uadf8\ub300\ub85c Restore)<\/p>\n

1)\ubcf5\uad6c \uc791\uc5c5\uc774 \uc815\uc0c1\uc801\uc73c\ub85c \uc644\ub8cc\ub41c\uac83\uc774\ub77c\uace0 \uac00\uc815.<\/p>\n

2)\ucee8\ud2b8\ub864 \ud30c\uc77c \uc704\uce58 \ubcc0\uacbd.<\/p>\n

$ vi init_ORADB.ora (\ud30c\ub77c\ubbf8\ud130 \ud30c\uc77c \uc218\uc815)<\/p>\n

control_files = (\/data2\/ORADB\/imsy\/cntrl01.dbf ,
\n<\/span><\/p>\n

\/data2\/ORADB\/imsy\/cntrl02.dbf ,
\n<\/span><\/p>\n

\/data2\/ORADB\/imsy\/cntrl03.dbf )
\n<\/span><\/p>\n

3) Mount \ub2e8\uacc4\uae4c\uc9c0 STARTUP
\n<\/span><\/p>\n

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

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

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

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

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

Database Mounted.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

4) \uc7a5\uc560 \ub370\uc774\ud130 \ud30c\uc77c \uc704\uce58 \ubcc0\uacbd (\ubc18\ub4dc\uc2dc script \ub85c \ub9cc\ub4e4\uc5b4\uc11c \uc791\uc5c5\uc744 \ud560 \uac83\uc744 \uad8c\uace0)<\/p>\n

SQL> @alt_datafile.sql<\/p>\n

SQL> @alt_redo.sql<\/p>\n

\n\n\n<\/colgroup>\n\n\n
$ vi alt_datafile.sql
\n<\/span><\/p>\n

alter database rename file ‘\/data\/ORADB\/oradbdata\/system01.dbf’ to ‘\/data2\/ORADB\/imsy\/system01.dbf’ ;
\n<\/span><\/p>\n

alter database rename file ‘\/data\/ORADB\/oradbdata\/alrd01.dbf’ to \/data2\/ORADB\/imsy\/alrd01.dbf’;
\n<\/span><\/p>\n

alter database rename file ‘\/data\/ORADB\/oradbdata\/alrx01.dbf’ to \/data2\/ORADB\/imsy\/alrx01.dbf’ ;
\n<\/span><\/p>\n

alter database rename file ‘\/data\/ORADB\/oradbdata\/amsd01.dbf’ to \/data2\/ORADB\/imsy\/amsd01.dbf’ ;
\n<\/span><\/p>\n

alter database rename file ‘\/data\/ORADB\/oradbdata\/amsx01.dbf’ to \/data2\/ORADB\/imsy\/amsx01.dbf’ ;
\n<\/span><\/p>\n

$ vi alt_redo.sql
\n<\/span><\/p>\n

alter database drop logfile ‘\/data\/ORADB\/oradbdata\/log01a.ora’
\n<\/span><\/p>\n

alter database drop logfile ‘\/data\/ORADB\/oradbdata\/log02a.ora’
\n<\/span><\/p>\n

alter database drop logfile ‘\/data\/ORADB\/oradbdata\/log03a.ora’
\n<\/span><\/p>\n

alter database add logfile ‘\/data2\/ORADB\/imsy\/log01a.ora’ size 500M
\n<\/span><\/p>\n

alter database add logfile ‘\/data2\/ORADB\/imsy\/log02.ora’ size 500M
\n<\/span><\/p>\n

alter database add logfile ‘\/data2\/ORADB\/imsy\/log03.ora’ size 500M<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

[3\ub2e8\uacc4] Database Open
\n<\/strong><\/p>\n

$ sqlplus ‘\/as sysdba’<\/p>\n

SQL> alter database open;<\/p>\n

[4\ub2e8\uacc4] \ud655\uc778
\n<\/span><\/p>\n

\n\n\n<\/colgroup>\n\n\n
$sqlplus <\/span>‘<\/span>\/as sysdba<\/span>‘<\/span>
\n<\/span><\/span><\/p>\n

SQL> col NAME format a40
\n<\/strong><\/span><\/p>\n

SQL> select name, status from v$datafile;
\n<\/strong><\/span><\/p>\n

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

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

\/data2\/ORADB\/imsy\/system01.dbf SYSTEM
\n<\/span><\/p>\n

\/data2\/ORADB\/imsy\/alrd01.dbf ONLINE
\n<\/span><\/p>\n

\/data2\/ORADB\/imsy\/alrx01.dbf ONLINE
\n<\/span><\/p>\n

\/data2\/ORADB\/imsy\/amsd01.dbf ONLINE
\n<\/span><\/p>\n

\/data2\/ORADB\/imsy\/amsx01.dbf ONLINE
\n<\/span><\/p>\n

SQL> col member format a30
\n<\/strong><\/span><\/p>\n

SQL> select member from v$logfile;
\n<\/strong><\/span><\/p>\n

\/data2\/ORADB\/imsy\/log01a.ora
\n<\/span><\/p>\n

\/data2\/ORADB\/imsy\/log02a.ora
\n<\/span><\/p>\n

\/data2\/ORADB\/imsy\/log03a.ora
\n<\/span><\/p>\n

SQL> col NAME format a40
\n<\/span><\/h5>\n

SQL> select name from v$controlfile;
\n<\/strong><\/span><\/p>\n

\/data2\/ORADB\/imsy\/cntrl01.dbf
\n<\/span><\/p>\n

\/data2\/ORADB\/imsy\/cntrl02.dbf
\n<\/span><\/p>\n

\/data2\/ORADB\/imsy\/cntrl03.dbf<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

[3] ARCHIVELOG Mode DB \uc5d0\uc11c Datafile \uc190\uc2e4\uc5d0 \ub530\ub978 Database Recovery \ubc29\ubc95<\/span>
\n<\/strong><\/span><\/p>\n

[\uc7a5\uc560\ud604\uc0c1] 2004\/07\/03 (\ud1a0) 20:00<\/strong>\uacbd Media Fail \ub85c \uc778\ud55c System Tablespace datafile corrupt \uc73c\ub85c
\n<\/span><\/p>\n

DB shutdown \ub428. \ubc31\uc5c5\uc740 \ub9e4\uc8fc \ud654\uc694\uc77c\uacfc \uae08\uc694\uc77c 23:00\ubd80\ud130 hot backup<\/strong> \uc2e4\uc2dc.
\n<\/span><\/p>\n

[\ubcf5\uad6c\ubc29\ubc95] System Tablespace \uc5d0 \uc18d\ud55c \ud30c\uc77c\uc758 \uc7a5\uc560\uc774\ubbc0\ub85c mount \ub2e8\uacc4\uc5d0\uc11c \ubcf5\uad6c\uc2dc\uc791.
\n<\/span><\/p>\n

\ud654\uc694\uc77c\uc5d0 Hot Backup \ubcf8\uc73c\ub85c \ubc31\uc5c5 \uc774\ud6c4\uc758 \uc0dd\uc131\ub41c Archive log files\ub85c \ubcf5\uad6c.
\n<\/span><\/p>\n

[\uc7a5\uc560\ubcf5\uad6c \uc2dc\ub098\ub9ac\uc624 \uc694\uc57d]
\n<\/span><\/p>\n

1\ub2e8\uacc4> System Tablespace \uc758 datafile \uc190\uc2e4\ub85c DB \uc811\uadfc \ubd88\uac00 \ubc1c\uc0dd.
\n<\/span><\/p>\n

2\ub2e8\uacc4> \uc190\uc2e4\ub41c Datafile \ubc0f Raw device \uc815\ubcf4 \ud655\uc778 \ubc0f Media \ubc31\uc5c5 \ubcf5\uad6c \uc694\uccad \ubc0f \uc2dc\uc791
\n<\/span><\/p>\n

3\ub2e8\uacc4> DB shutdown (shutdown immediate or abort \uc885\ub8cc) DB shutdown \ub418\uc5c8\ub2e4\uba74 \ub2e4\uc74c \ub2e8\uacc4\ub85c.
\n<\/span><\/p>\n

4\ub2e8\uacc4> Mount \ub2e8\uacc4\uae4c\uc9c0 Startup
\n<\/span><\/p>\n

5\ub2e8\uacc4> Datafile \ubc0f Raw Device \ubcf5\uad6c\uac00 \uc644\ub8cc\ub418\uba74, Recover \uba85\ub839\uc73c\ub85cDB \ubcf5\uad6c
\n<\/span><\/p>\n

6\ub2e8\uacc4> Database Open
\n<\/span><\/p>\n

<\uc7a5\uc560 \ubcf5\uad6c \uc138\ubd80 \uc2dc\ub098\ub9ac\uc624>
\n<\/span><\/p>\n

[1\ub2e8\uacc4] System Tablespace \uc758 Datafile \uc190\uc2e4\ub85c DB \uc811\uadfc \ubd88\uac00 \ubc1c\uc0dd.
\n<\/span><\/p>\n

[2\ub2e8\uacc4] \uc190\uc2e4\ub41c Datafile \ubc0f Raw Device \uc815\ubcf4 \ud655\uc778 \ubc0f Media \ubcf5\uad6c \uc694\uccad \ubc0f \ubcf5\uad6c \uc900\ube44
\n<\/span><\/p>\n

– DBA \uc190\uc2e4\ub41c system Tablespace \uc758 Raw Device \ub97c \uc54c\uace0 \uc788\ub2e4.
\n<\/span><\/p>\n

– Raw Device name= \/dev\/rtbl31_4G_001
\n<\/span><\/p>\n

cf) \uc190\uc2e4\ub41c datafile \ud655\uc778 (mount \ub2e8\uacc4\uc5d0\uc11c \uac00\ub2a5)
\n<\/span><\/p>\n

\n\n\n<\/colgroup>\n\n\n
$sqlplus ‘\/as sysdba’
\n<\/span><\/p>\n

SQL> select h.tablespace_name, d.name, h.error from v$datafile d, v$datafile_header h
\n<\/span><\/p>\n

Where d.file#=h.file#;
\n<\/span><\/p>\n

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

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

SYSTEM \/dev\/rtbl31_4G_001 FILE NOT FOUND
\n<\/strong><\/span><\/p>\n

UNDO_KTFINFO \/dev\/rundo101
\n<\/span><\/p>\n

TOOLS \/dev\/rtoolslv
\n<\/span><\/p>\n

USERS \/dev\/ruserslv
\n<\/span><\/p>\n

UNDO_KTFINFO \/dev\/rundo102
\n<\/span><\/p>\n

UNDO_INFORDS \/dev\/rundo202
\n<\/span><\/p>\n

UNDO_KTFINFO \/dev\/rundo103
\n<\/span><\/p>\n

UNDO_INFORDS \/dev\/rundo203
\n<\/strong><\/span><\/p>\n

MINING_01 \/dev\/rtbl10_4G_008
\n<\/span><\/p>\n

MINING_01 \/dev\/rtbl10_4G_009
\n<\/span><\/p>\n

MINING_01 \/dev\/rtbl10_4G_010
\n<\/span><\/p>\n

MINING_01 \/dev\/rtbl10_4G_011
\n<\/span><\/p>\n

MINING_01 \/dev\/rtbl10_4G_012
\n<\/span><\/p>\n

MINING_01 \/dev\/rtbl10_4G_013<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n


\n<\/span>\u00e0<\/span> \uc7a5\uc560\ub97c \uc77c\uc73c\ud0a8 \ud30c\uc77c\uacfc Tablespace \uc5d0\ub294 FILE NOT FOUND \ub77c\ub294 Message \uac00 \ub098\ud0c0\ub0a8.
\n<\/span><\/span><\/p>\n

[3\ub2e8\uacc4] DB shutdown \ud655\uc778
\n<\/span><\/p>\n

– DB shutdown \ub418\uc5c8\ub294\uc9c0 \ud655\uc778 ( DB shutdown \ub418\uc5c8\ub2e4\uba74 \ub2e4\uc74c \ub2e8\uacc4\ub85c Skip)
\n<\/span><\/p>\n

[4\ub2e8\uacc4] mount \ub2e8\uacc4\uae4c\uc9c0 Startup
\n<\/span><\/p>\n

$sqlplus <\/span>‘<\/span>\/as sysdba<\/span>‘<\/span>
\n<\/span><\/span><\/p>\n

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

[5\ub2e8\uacc4] > Datafile \ubc0f Raw Device \ubcf5\uad6c\uac00 \uc644\ub8cc\ub418\uba74, Recover \uba85\ub839\uc73c\ub85cDB \ubcf5\uad6c
\n<\/span><\/p>\n

– Datafile \ubc0f Raw Device \ubcf5\uad6c \uc644\ub8cc\uac00 \ub418\uba74, Recover \uba85\ub839\uc73c\ub85c DB \ubcf5\uad6c \uc2dc\uc791.
\n<\/span><\/p>\n

– \uc801\uc6a9\ub420 \ub85c\uadf8 \ud30c\uc77c\uc774 \ub9ce\uc744 \uacbd\uc6b0 set autorecovery on \uba85\ub839<\/strong>\uc744 \uc0ac\uc6a9\ud55c\ub2e4.
\n<\/span><\/p>\n

– \ubc31\uc5c5\ubcf8 \ub0a0\uc9dc\ub294 7\/2(\uae08) 23:00 \uc2dc \uc7a5\uc560 \uc2dc\uac01\uc740 7\/3(\ud1a0) 20:00 \uacbd \uc774\ubbc0\ub85c hot backup \uc2dc\uc791\ubd80\ud130
\n<\/span><\/p>\n

\uc7a5\uc560 \ubc1c\uc0dd \uc9c1\uc804\uae4c\uc9c0 \uc0dd\uc131\ud55c Archive log file \uc744 \uc801\uc6a9\ud55c\ub2e4. Datafile \ubcf5\uad6c\uac00 \uc644\ub8cc\ub418\uc5c8\ub2e4\uace0 \uac00\uc815\ud568.
\n<\/span><\/p>\n

\n\n\n<\/colgroup>\n\n\n
\u00e0<\/span> \ud604\uc7ac mount \ub2e8\uacc4
\n<\/span><\/span><\/p>\n

SQL> set autorecovery on
\n<\/span><\/p>\n

SQL> recover datafile <\/span>‘<\/span><\/span>\/dev<\/span>\/rtbl31_4G_001′ ;<\/span>
\n<\/span><\/span><\/p>\n

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

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

\ub85c\uadf8\uac00 \uc801\uc6a9\ub418\uc5c8\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

\uba54\uccb4\ubcf5\uad6c\uac00 \uc644\ub8cc\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

[6\ub2e8\uacc4] Database Open
\n<\/span><\/p>\n

SQL> alter database open;
\n<\/span><\/p>\n

– \ud655\uc778
\n<\/span><\/p>\n

\n\n\n<\/colgroup>\n\n\n
$sqlplus ‘\/as sysdba’
\n<\/span><\/p>\n

SQL> col tablespace_name format a15
\n<\/span><\/p>\n

SQL> col name format a40
\n<\/span><\/p>\n

SQL> col error format a10
\n<\/span><\/p>\n

SQL> select h.tablespace_name, d.name, h.error from v$datafile d, v$datafile_header h
\n<\/span><\/p>\n

Where d.file#=h.file#;
\n<\/span><\/p>\n

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

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

SYSTEM \/dev\/rtbl31_4G_001
\n<\/strong><\/span><\/p>\n

UNDO_KTFINFO \/dev\/rundo101
\n<\/span><\/p>\n

TOOLS \/dev\/rtoolslv
\n<\/span><\/p>\n

USERS \/dev\/ruserslv
\n<\/span><\/p>\n

UNDO_KTFINFO \/dev\/rundo102
\n<\/span><\/p>\n

UNDO_INFORDS \/dev\/rundo202
\n<\/span><\/p>\n

UNDO_KTFINFO \/dev\/rundo103
\n<\/span><\/p>\n

UNDO_INFORDS \/dev\/rundo203
\n<\/strong><\/span><\/p>\n

MINING_01 \/dev\/rtbl10_4G_008
\n<\/span><\/p>\n

MINING_01 \/dev\/rtbl10_4G_009
\n<\/span><\/p>\n

MINING_01 \/dev\/rtbl10_4G_010
\n<\/span><\/p>\n

MINING_01 \/dev\/rtbl10_4G_011
\n<\/span><\/p>\n

MINING_01 \/dev\/rtbl10_4G_012
\n<\/span><\/p>\n

MINING_01 \/dev\/rtbl10_4G_013<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

[4] Logical Database Recovery \ubc29\ubc95(export\/import)<\/span>
\n<\/strong><\/span><\/p>\n

[\uac00\uc815] logical recovery \ub97c \uc218\ud589\ud558\uae30 \uc704\ud55c \uc804\uc81c \uc870\uac74\uc740
\n<\/span><\/p>\n

\ud574\ub2f9 object \uc5d0 \ub300\ud55c export dump \ud30c\uc77c\uc774 \uc874\uc7ac\ud574\uc57c\ub9cc recovery \ub97c \ud560\uc218\uc788\ub2e4.
\n<\/span><\/p>\n

\ub530\ub77c\uc11c , \uc544\ub798 \uc0ac\ud56d\uc740 export dump \ud30c\uc77c\uc774 \uc788\uc744 \uacbd\uc6b0\uc758 recovery \ubc29\ubc95\uc784.
\n<\/span><\/p>\n

1. \ud2b9\uc815 USER\uc758 Object \ub97c Full Recovery \ud574\uc57c \ud560 \uacbd\uc6b0
\n<\/span><\/p>\n

[1\ub2e8\uacc4] EUL \uc720\uc800 Export \ubc29\ubc95 (\ub9e4\uc77c \ubc24 \uc218\ud589) : dump \ud30c\uc77c\uc774 \uc788\ub2e4\uace0 \uac00\uc815.
\n<\/span><\/p>\n

$ exp userid=system\/admin owner=eul rows=y file=exp_eul.dmp log=exp_eul.log
\n<\/span><\/p>\n

[2\ub2e8\uacc4] EUL USER Full Import \uc218\ud589.
\n<\/span><\/p>\n

$imp userid=system\/admin fromuser=eul touser=eul file=exp_eul.dmp log=imp_eul.log
\n<\/span><\/p>\n

2. \ud2b9\uc815 Table\ub9cc Recovery \ud560 \uacbd\uc6b0
\n<\/span><\/p>\n

[1\ub2e8\uacc4]\ud2b9\uc815 Table Export \ubc29\ubc95 : \ud574\ub2f9 dump \ud30c\uc77c\uc774 \uc788\ub2e4\uace0 \uac00\uc815.
\n<\/span><\/p>\n

$exp userid=eul\/eul rows=y file=exp_eul_user_table.dmp log=exp_eul_user_table.log
\n<\/span><\/p>\n

[2\ub2e8\uacc4] \ud2b9\uc815 Table \ubcf5\uad6c \ud558\ub294 \ubc29\ubc95 : \ud574\ub2f9 dump \ud30c\uc77c\uc774 \uc788\ub2e4\uace0 \uac00\uc815.
\n<\/span><\/p>\n

$imp userid=eul\/eul rows=y file=exp_eul_user_table.dmp log=imp_eul_user_table.log
\n<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

[1] Archive Mode \uc6b4\uc601 \uc911\uc778 DB\uc5d0\uc11c \ud2b9\uc815 Table\uc744 Drop \ud588\uc744 \uacbd\uc6b0. [\ud604\uc0c11] \uac1c\ubc1c\uc790\uac00 \uc2e4\uc218\ub85c \ud2b9\uc815 Table\uc744 Drop \uc744 \ud588\uc74c.(\ub2e8, \uac1c\ubc1c\uc790\uac00 \uc7a5\uc560\uc2dc\uc810\uc744 \uc54c\uace0\uc788\ub2e4\uace0 \uac00\uc815\ud55c\ub2e4.) [\ud604\uc0c12] Export \ubc1b\uc740 \ub370\uc774\ud130\uac00 \uc5c6\uc74c. DB\ub97c shutdown \ud560 \uc218 \uc5c6\ub294 \uc0c1\ud669. [\ud604\uc0c13] DBA\ub294 2004\ub144 07\uc6d405\uc77c 09:30\ubd84\uacbd\uc5d0 \uac1c\ubc1c\uc790\ub85c\ubd80\ud130mnt_state \ud14c\uc774\ube14\uc744 Drop\ud588\ub2e4\uace0 \uc5f0\ub77d\ubc1b\uc74c. [\ud604\uc0c14] RAW Device \ub97c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc74c. DB\ub294 Archvie Mode, Hot Backup \ub370\uc774\ud130 […]<\/p>\n","protected":false},"author":1,"featured_media":2876,"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":[14],"tags":[946,314,947,948],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/Cover1.png?fit=1000%2C730","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2873"}],"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=2873"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2873\/revisions"}],"predecessor-version":[{"id":2881,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2873\/revisions\/2881"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2876"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2873"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2873"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2873"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}