{"id":3712,"date":"2018-03-19T11:43:00","date_gmt":"2018-03-19T02:43:00","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=3712"},"modified":"2018-11-16T15:40:34","modified_gmt":"2018-11-16T06:40:34","slug":"oracle-recovery","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=3712","title":{"rendered":"ORACLE RECOVERY"},"content":{"rendered":"

Recovery<\/span>
\n<\/strong><\/span><\/p>\n

Database\uc5d0 \uc774\uc0c1\uc774 \uc0dd\uaca8 Error\ub97c Return\ud560 \uacbd\uc6b0 Instance\uc5d0 \ubc1c\uc0dd\ud55c \ubaa8\ub4e0 Error\ub294 Trace file\ub85c \ubc1b\ud788\uace0 Alert\uc5d0 \uae30\ub85d\ub418\ubbc0\ub85c \uc774\uc0c1\uc774 \ubc1c\uacac\ub418\uba74 \uc81c\uc77c \uba3c\uc800 Trace file\uc744 Check\ud558\uc5ec Error\ub97c \ud655\uc778\ud558\uace0 \uc6d0\uc778\uc744 \ud30c\uc545\ud55c\ub2e4.
\n<\/span><\/p>\n

Recovery \uc791\uc5c5\uc740 \ubc1c\uc0dd\ud55c failure type\uc5d0 \ub530\ub77c \ub2e4\ub974\uac8c \uc218\ud589\ub41c\ub2e4.<\/span>
\n<\/span><\/p>\n

 <\/p>\n

Instance Recovery & Media Recovery
\n<\/strong><\/span><\/p>\n

 <\/p>\n

Instance Recovery
\n<\/strong><\/span><\/p>\n

 <\/p>\n

Database Instance Failure\uac00 \ubc1c\uc0dd\ud588\uc744 \ub54c Instance Recovery\ub294 \uc694\uad6c\ub41c\ub2e4.
\n<\/span><\/p>\n

Database Instance Failure\ub294 Oracle Database Instance ( = SGA + Background process)\uac00 \uc791\ub3d9\ub418\uc9c0 \uc54a\ub294 \uc0c1\ud669\uc774 \ubc1c\uc0dd \ud588\uc744 \uacbd\uc6b0\ub97c \ub9d0\ud55c\ub2e4.
\n<\/span><\/p>\n

\uad6c\uccb4\uc801\uc73c\ub85c \uc815\uc804\uacfc \uac19\uc740 \uacbd\uc6b0\ub098 \uc5ec\ub7ec \uc6d0\uc778\uc5d0 \uc758\ud55c hardware\uc801 \ubb38\uc81c\ub098 Operating system crash\uc640 \uac19\uc740 software\uc801 \ubb38\uc81c\ub85c \uc778\ud574 \ubc1c\uc0dd\ud55c\ub2e4.
\n<\/span><\/p>\n

\uc774\ub7ec\ud55c Instance Failure\uc5d0 \ub300\ud55c Recovery\ub294 Oracle Parallel Server\uac00 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\ub294 \ud658\uacbd\uc774 \ub77c\uba74 SVRMGR>\uc5d0\uc11c STARTUP command\ub97c \uc218\ud589\ud558\uba74 \uc790\ub3d9\uc801\uc73c \ub85c \ubcf5\uad6c\ub41c\ub2e4.
\n<\/span><\/p>\n

Oracle\uc740 Failure \ubc1c\uc0dd \uc774\ud6c4 \ucd5c\ucd08\ub85c database\ub97c Startup \uc2dc\ud0ac \ub54c \uc790\ub3d9\uc801\uc73c\ub85c Instance\ub97c \ubcf5\uad6c\ud55c\ub2e4.
\n<\/span><\/p>\n

\uba3c\uc800 Database buffer\uc548\uc5d0\ub294 \uc800\uc7a5\ub418\uc5b4 \uc788\uc73c\ub098 \uc544\uc9c1 Datafile\uc5d0 \uae30\ub85d\ub418\uc9c0 \uc54a\uc740 transaction\uc774 \uc644\ub8cc\ub41c (\uc989, commit\uc774\ub098 rollback\uc774 \uc218\ud589\ub41c) \uc815\ubcf4\ub97c redo log file\uc5d0 \uae30\ub85d\ub41c \uc0ac\ud56d\uacfc rollback segment\uc5d0 \uae30\ub85d\ub41c \uc0ac\ud56d\uc744 \ucc38\uace0\ub85c \ud558\uc5ec recovery\ud55c\ub2e4.
\n<\/span><\/p>\n

\uadf8\ub9ac\uace0 \uc544\uc9c1 transaction\uc744 \uc644\ub8cc\uc2dc\ud0a4\uc9c0 \ubabb\ud55c \ucc44 failure\uac00 \ubc1c\uc0dd\ud588\ub2e4\uba74(\uc774 \uacbd\uc6b0 \uc774\ubbf8 database buffer\ub294 \uaf49 \ucc28\uc11c Datafile\uc5d0 \uae30\ub85d\ud588\ub2e4.) background process\uc778 SMON\uc740 rollback segment\ub97c \ub4a4\uc838 \uc6d0\ub798\uc758 \uc0c1\ud0dc\ub85c \ubcf5\uad6c\ud55c\ub2e4.
\n<\/span><\/p>\n

\ub610\ud55c lock\uc774 \uac78\ub824\uc788\ub294 \uc0c1\ud0dc\uc5d0\uc11c failure\ub41c transaction\uc740 recovery\uc2dc\uc5d0 lock\uc744 \ud47c\ub2e4.<\/span>
\n<\/span><\/p>\n

 <\/p>\n

Media Recovery
\n<\/strong><\/span><\/p>\n

 <\/p>\n

Media Failure(= Disk Failure) \uac00 \ubc1c\uc0dd\ud588\uc744 \ub54c Media Recovery\ub294 \uc694\uad6c\ub41c\ub2e4.
\n<\/span><\/p>\n

Media Failure\ub294 Instance\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \uc791\ub3d9 \uc911\uc784\uc5d0 \ub3c4 file (data files , redo log files, control files)\uc744 \uc77d\uace0 \uc4f0\uae30\uac00 \uc218\ud589\ub418\uc9c0 \uc54a\ub294 \uc0c1\ud669\uc744 \ub9d0\ud55c\ub2e4.
\n<\/span><\/p>\n

\uc774\ub7ec\ud55c \uc0c1\ud669\uc740 disk head\uac00 crash \ub418\uc5c8\uc744 \uacbd\uc6b0 \ub610\ub294 Disk\uc640\ub294 \uc0c1\uad00\uc5c6\uc774 Database file\uc5d0 \uc774\uc0c1\uc774 \uc0dd\uacbc\uc744 \ub54c \ub098\ud0c0\ub09c\ub2e4.
\n<\/span><\/p>\n

\uadf8\ub7ec\ub098 \uc774\ub7ec\ud55c Disk head crash\uac00 \ubc1c\uc0dd\ud588 \ub354\ub77c\ub3c4 file type\uc5d0 \ub530\ub77c (\uc989, data file\uc774\ub0d0, control file\uc774\ub0d0, redo log file \uc774\ub0d0\uc5d0 \ub530\ub77c) \uc815\uc0c1\uc801\uc73c\ub85c read, write\uac00 \ud589\ud574\uc9c8 \uc218 \uc788\ub2e4.
\n<\/span><\/p>\n

Data file\uc5d0 \uc601\ud5a5\uc744 \ubbf8\uce58\ub294 Media failure\ub294 Read error\uc640 Write error\uc758 2\uac00\uc9c0\uac00 \uc788\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

1.<\/span>\u00a0<\/span>Read Error : Oracle\uc774 read error\ub97c \ubc1c\uacac\ud55c \uacbd\uc6b0\uc5d0 Oracle\uc740 Error Message\ub97c application\uc5d0 \ub098\ud0c0\ub0b8\ub2e4.
\n<\/span><\/span><\/p>\n

2.<\/span>\u00a0<\/span>Write Error : Oracle\uc774 data file\uc5d0 write\ud560 \uc218 \uc5c6\ub2e4\ub294 \uac83\uc744 \ubc1c\uacac\ud558\uac8c \ub418\uba74 DBWR trace file\uc5d0 Error Message\ub97c \ubcf4\ub0b4\uace0 \uc790\ub3d9\uc73c\ub85c \uadf8 data file\uc744 offline \uc2dc\ud0a8\ub2e4. \uadf8\ub7ec\ub098 \uadf8 Datafile \uc774 \uc788\ub294 Tablespace\ub294 \uadf8\ub300\ub85c online\uc744 \uc720\uc9c0\ud55c\ub2e4.
\n<\/span><\/span><\/p>\n

 <\/p>\n

\uadf8\ub7ec\ub098 \ub9cc\uc57d write\uac00 \uc548\ub418\ub294 Datafile\uc774 SYSTEM Tablespace\uc5d0 \uc18d\ud55c\ub2e4\uba74 Oracle\uc740 \uadf8 data file\uc744 offline\uc2dc\ud0a4\uc9c0 \uc54a\ub294\ub2e4.
\n<\/span><\/p>\n

\ub300\uc2e0\uc5d0 Oracle\uc740 Error\ub97c \ubcf4\ub0b4\uace0 Database\ub97c Shutdown\uc2dc\ud0a8\ub2e4.
\n<\/span><\/p>\n

\uc65c\ub0d0\ud558\uba74 SYSTEM Tablespace\uc5d0 \uc788\ub294 \ubaa8\ub4e0 Datafile\uc740 Oracle\uc744 \uc6b4\uc601\ud558\ub294\ub370 \ud544\uc694\ud55c file\ub4e4\uc774\uace0 Data dictionary\uac00 \uc800\uc7a5\ub418\uc5b4 \uc788\ub294 \uc601\uc5ed\uc774\ubbc0\ub85c \uc774 \uc911 \uc5b4\ub290 \ud558\ub098\ub77c\ub3c4 offline \uc0c1\ud0dc\ub85c \ub41c\ub2e4\uba74 Oracle \uc790\uccb4\uac00 \uad6c\ub3d9\ud558\uc9c0 \uc54a\uc744 \uac83\uc774\ub2e4.
\n<\/span><\/p>\n

Media Recovery\ub294 \uc704\uc5d0\uc11c \uc124\uba85\ud588\ub4ef\uc774 Media Failure\uac00 \ubc1c\uc0dd\ud588\uc744 \ub54c \uc218\ud589\ub41c\ub2e4.
\n<\/span><\/p>\n

Media Recovery\ub97c \uc218\ud589\ud568\uc5d0 \uc788\uc5b4\uc11c Failure\uac00 \ubc1c\uc0dd\ud558\uae30 \ubc14\ub85c \uc774\uc804 \uc2dc\uc810\uae4c\uc9c0 Recovery \ud558\ub294 \uac83\uc744 Complete Media Recovery\ub77c \ud558\uace0<\/span>
\n<\/span><\/p>\n

 <\/p>\n

Recovery\ub97c \uc704\ud55c \uae30\ubcf8 Step
\n<\/strong><\/span><\/p>\n

SGA\uc548\uc758 Database buffer\uc758 \ub0b4\uc6a9\uc740 LRU(least-recently-used) Algorithm\uc5d0 \uc758\ud574 Datafile\uc5d0 \uc4f0\uc5ec\uc9c4\ub2e4.
\n<\/span><\/p>\n

\uadf8\ub7ec\ubbc0\ub85c \uc5b4\ub5a4 \uc2dc\uc810\uc5d0\uc11c \ubcf4\uc558\uc744 \ub54c Uncommited\ub41c Transaction\uc5d0 \uc758\ud574 \ubcc0\uacbd\ub41c data\uac00 Datafile\uc5d0 \uc4f0\uc5ec\uc84c\uc744 \uacbd\uc6b0\ub3c4 \uc788\uace0, Commited\ub41c Transaction\uc5d0 \uc758\ud574 \ubcc0\uacbd\ub41c Data\uac00 \uc544\uc9c1 Datafile\uc5d0 \uc4f0\uc5ec\uc9c0\uc9c0 \uc54a\uace0 Database buffer\uc5d0 \ub0a8\uc544\uc788\ub294 \uacbd\uc6b0\ub3c4 \uc788\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

l<\/span>\u00a0<\/span>Redo Log & Rolling Forward
\n<\/span><\/span><\/p>\n

 <\/p>\n

Data\uc758 \ubcc0\ud654\ub97c \uc77c\uc73c\ud0a4\ub294 Transaction\uc774 Commit\ub418\ub4e0 Uncommit\ub418\ub4e0 Database buffer\uc5d0 \uac00\ud574\uc9c4 \ubaa8\ub4e0 \ubcc0\ud654\ub294 Redolog file\uc5d0 \uae30\ub85d\ub41c\ub2e4. <\/span><\/p>\n

Instance failure\ub098 Media Failure\ub85c\ubd80\ud130 Recovery\ud558\ub294 \uccab\ubc88\uc9f8 \ub2e8\uacc4\ub294 Roll-forward\ud558\ub294 \uac83\uc774\ub2e4.
\n<\/span><\/p>\n

Roll-Forward\ub780 Redo log file\uc5d0 \uae30\ub85d\ub41c \ubaa8\ub4e0 \ubcc0\ud654\ub97c Datafile\uc5d0 \uc801\uc6a9\ud558\ub294 \uac83\uc744 \ub9d0\ud55c\ub2e4. <\/span><\/p>\n

\uadf8\ub7ec\ubbc0\ub85c \uc774\ub7ec\ud55c Roll-Forward\uac00 \uc774\ub8e8\uc5b4 \uc9c4 \ub4a4\uc5d0\ub294 Datafile\uc740 Redo log file\uc5d0 \uae30\ub85d\ub41c Commit\uc774 \uc548\ub41c \ubcc0\uacbd\ub41c Data\ubfd0\ub9cc \uc544\ub2c8\ub77c \ubaa8\ub4e0 Commit\ub41c Data\ub97c \uac00\uc9c0\uac8c \ub41c\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

l<\/span>\u00a0<\/span>Rollback Segment\uc640 Rolling Back
\n<\/span><\/span><\/p>\n

 <\/p>\n

Rollback Segment\ub294 Database\ub97c \uc870\uc791(DML)\ud558\ub294 \uc911\uc5d0 Undo\ub418\uc5b4\uc838\uc57c \ud558\ub294 Data\ub97c \uac00\uc9c4\ub2e4. <\/span><\/p>\n

Database Recovery\uc2dc\uc5d0 Rollback Segment\ub294 Rolling Forward\uc5d0 \uc758\ud574 Datafile\uc5d0 \uc801\uc6a9\ub41c \ubaa8\ub4e0 Uncommit\ub41c Transaction\uc744 Rollback\uc2dc\ud0a8\ub2e4. \uc774\uac83\uc774 Rolling Back\uc774\ub2e4.
\n<\/span><\/p>\n

\ub2e4\uc2dc \uc815\ub9ac\ud558\uba74 Backup Datafile\uc744 Restore\ud55c \ud6c4\uc5d0 Recovery\uc2dc\uc5d0 \ub294 \uba3c\uc800 Backup Datafile\uc774\ud6c4\uc758 Database\uc5d0 \uc0dd\uae34 \ubaa8\ub4e0 \ubcc0\ud654\ub97c \uae30\ub85d\ud55c Redo log file\uacfc Archive log file\uc744 \uc774\uc6a9\ud558\uc5ec Rolling-Forward\uac00 \uc218\ud589\ub418\uace0 \uc774\ub54c Redo log file\uc758 Uncommit\ub41c Transaction\uae4c\uc9c0 \ubaa8\ub450 \uc801\uc6a9\ub418\uc5b4 Datafile\uc5d0 \uc4f0\uc5ec\uc9c4\ub2e4. <\/span><\/p>\n

\uadf8 \ub2e4\uc74c\uc5d0 Redo log file\uc774 \uac00\uc9c0\uace0 Rollback\ub420 \uc815\ubcf4\ub97c Rollback Segment\ub97c \uac00\uc9c0\uace0 \uc788\ub294 Datafile\uc5d0 \ubaa8\ub450 \uc801\uc6a9\ud55c\ub2e4. <\/span><\/p>\n

\uadf8 \ub2e4\uc74c\uc5d0 \uc774 \uc801\uc6a9\ub41c Rollback Segment Tablespace\uc758 Datafile\uc744 \uc801\uc6a9\ud558\uc5ec Datafile\uc5d0 \uc4f0\uc5ec\uc9c4 Undo \ub418\uc5b4\uc838\uc57c \ud558\ub294 Uncommit Transaction\uc744 Rollback\uc2dc\ud0a4\uac8c \ub41c\ub2e4..
\n<\/span><\/p>\n

\uae30\ubcf8\uc801\uc778 Recovery \ub2e8\uacc4\ub97c \uadf8\ub9bc\uc73c\ub85c \ub098\ud0c0\ub0b4\uba74,<\/span>
\n<\/span><\/p>\n

 <\/p>\n

\"\"<\/a>
\n<\/span><\/span><\/p>\n

 <\/p>\n

 <\/p>\n

Complete Media Recovery & Incomplete Media Recovery
\n<\/strong><\/span><\/p>\n

Complete Media Recovery
\n<\/strong><\/span><\/p>\n

Complete Media Recovery\ub294 Failure \ubc1c\uc0dd \uc804\uae4c\uc9c0\uc758 \ubaa8\ub4e0 \uc0ac\ud56d\uc744 \ubcf5\uad6c\ud558\ub294 \uac83\uc744 \uc758\ubbf8\ud558\uba70 \ub2e4\uc74c\uc758 3\uac00\uc9c0 Type\uc73c\ub85c \ub098\ub20c \uc218 \uc788\ub2e4.
\n<\/span><\/p>\n

\u00b7<\/span>\u00a0\u00a0\u00a0<\/span>Closed Database\uc778 \uacbd\uc6b0\uc758 Complete Media Recovery
\n<\/span><\/span><\/p>\n

\u00b7<\/span>\u00a0\u00a0\u00a0<\/span>Open Database-Offline Tablespace\uc778 \uacbd\uc6b0\uc758 Complete Media Recovery
\n<\/span><\/span><\/p>\n

\u00b7<\/span>\u00a0\u00a0\u00a0<\/span><\/span>Open Database-Offline Tablespace-Individual Datafile\uc778 \uacbd\uc6b0\uc758 Complete Media Recovery<\/span>
\n<\/span><\/span><\/p>\n

Closed Database\uc778 \uacbd\uc6b0\uc758 Complete Media Recovery
\n<\/strong><\/span><\/p>\n

Closed Database\uc778 \uacbd\uc6b0\ub780 Database\uc5d0 \uac00\ud574\uc9c4 Failure\ub85c \uc778\ud574 Database\uc758 Instance\uac00 Terminated\ub41c \ud6c4 Open\ub418\uc9c0 \uc54a\ub294 \uc0c1\ud0dc\ub97c \ub9d0\ud558\uba70 SYSTEM Tablespace\ub97c \uad6c\uc131\ud558\ub294 Datafile\uc774 \uc788\ub294 Disk\uac00 \uc190\uc0c1\ub41c \uacbd\uc6b0\ub098 Active\ud55c Rollback Segment\ub97c \ud3ec\ud568\ud558\ub294 Tablespace\uc5d0 \uc190\uc0c1\uc774 \ubc1c\uc0dd\ud588\uc744 \ub54c Database\ub294 Close\ub418\uba70 \uc774\ub7ec\ud55c \uacbd\uc6b0\uc5d0 \ub2e4\uc74c\uacfc \uac19\uc740 Complete Media Recovery \ubc29\ubc95\uc5d0 \ub530\ub77c Recovery\ud55c\ub2e4.
\n<\/span><\/p>\n

1.\u00a0<\/span>SHUTDOWN ABORT\ud55c\ub2e4. \ub9cc\uc57d Hardware\ubb38\uc81c\uac00 \uc77c\uc2dc\uc801\uc73c \ub85c \ubc1c\uc0dd\ud55c \uac83\uc774\ub77c\uba74 Data\ub294 \uc190\uc0c1\ub418\uc9c0 \uc54a\uc740 \uac83\uc774\ubbc0\ub85c Recovery\ub97c \uc704\ud55c \ubcc4\ub3c4\uc758 \uc791\uc5c5\uc774 \ud544\uc694\ud558\uc9c0 \uc54a\ub2e4. \uadf8\ub7ec\ubbc0\ub85c Instance\ub97c \ub2e4\uc2dc STARTUP\ud55c\ub2e4.
\n<\/span><\/span><\/p>\n

2.<\/span>\u00a0<\/span>File\uc774 \uc601\uc6d0\ud788 \uc190\uc0c1\ub41c \uacbd\uc6b0\ub77c\uba74 Media Failure\ub85c \uc778\ud574 \ubc1c\uc0dd \ud55c Datafile\ub9cc \uac00\uc7a5 \ucd5c\uadfc\uc5d0 Backup \ubc1b\uc740 file\uc744 \uc774\uc6a9\ud574 Restore\ud55c\ub2e4. \uc190\uc0c1\ub418\uc9c0 \uc54a\uc740 Datafile\uc740 Restore\ud558\uc9c0 \uc54a\ub294\ub2e4.
\n<\/span><\/span><\/p>\n

3.<\/span>\u00a0<\/span>STARTUP MOUNT\ud55c\ub2e4.
\n<\/span><\/span><\/p>\n

4.<\/span>\u00a0<\/span>ALTER DATABASE ~ DATAFILE ONLINE command\ub97c \uc218 \ud589\ud55c\ub2e4. Recover\ud558\uace0\uc790 \ud558\ub294 Datafile\uc740 Complete Media Recovery\ud558\ub294 \ub3d9\uc548\uc5d0 ONLINE\uc774\uc5b4\uc57c \ud55c\ub2e4.
\n<\/span><\/span><\/p>\n

5.<\/span>\u00a0<\/span>\ud558\ub098\uc758 \uc791\uc5c5\uc73c\ub85c \ubaa8\ub4e0 \uc190\uc0c1\ub41c File\uc744 Recovery\ud558\uae30 \uc704\ud574\uc120 RECOVER DATABASE command\ub97c \uc0ac\uc6a9\ud55c\ub2e4. \uac1c\uac1c\uc758 \uc190\uc0c1 \ub41c Datafile\uc5d0 \ub300\ud574 Recovery\ud558\uae30 \uc704\ud574\uc120 RECOVER DATAFILE command\ub97c \uc774\uc6a9\ud558\uc5ec Recovery\ub97c \uc218\ud589\ud55c\ub2e4. \ucc38\uace0\ub85c \ucd5c\ub300\uc758 Performance\ub97c \ubcf4\uc7a5\ud558\uae30 \uc704\ud574\uc120 Parallel Option\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4.
\n<\/span><\/span><\/p>\n

6.<\/span>\u00a0<\/span>ALTER DATABASE OPEN command\ub97c \uc218\ud589\ud55c\ub2e4.
\n<\/span><\/span><\/p>\n

7.<\/span>\u00a0<\/span><\/span>Recovery\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \uc218\ud589\ub418\uc5c8\ub294\uc9c0 Database\ub97c Check\ud55c\ub2e4.<\/span>
\n<\/span><\/span><\/p>\n

 <\/p>\n

 <\/p>\n

Open Database-Offline Tablespace\uc778 \uacbd\uc6b0\uc758 Complete Media Recovery
\n<\/strong><\/span><\/p>\n

Open Database-Offline Tablespace\uc778 \uacbd\uc6b0\ub780 Failure\ub85c \uc778\ud574 Database\uc5d0 Error\uac00 \ubc1c\uc0dd\ud588\uc74c\uc5d0\ub3c4 Database\ub294 Open \uc0c1\ud0dc\uc774\uace0 \uc190\uc0c1\ub418\uc9c0 \uc54a\uc740 Tablespace\uc5d0 \ub300\ud574\uc120 \uc5ec\uc804\ud788 Access\uac00 \uac00\ub2a5 (ONLINE \uc0c1\ud0dc)\ud558\uba70 \ub2e4\ub9cc \uc190\uc0c1\ub41c Tablepsace\ub9cc Offline\uc778 \uc0c1\ud0dc\ub97c \ub9d0\ud55c\ub2e4. Oracle\uc740 Media Failure\uc5d0 \uc758\ud574 Datafile\uc774 \uc190\uc0c1\uc744 \uc785\uc73c\uba74 \uc790\ub3d9\uc73c\ub85c \uc190\uc0c1\ub41c Datafile\uc774 \uc18d\ud55c Tablespace\ub97c Offline \uc2dc\ud0a8\ub2e4. \uc5ec\uae30\uc11c \uc190\uc0c1\ub41c Tabelspace\ub294 SYSTEM Tablespace\uac00 \uc544\ub2c8\uba70 \ub610\ud55c Active\ud55c Rollback Segment\ub97c \ud3ec\ud568\ud558\ub294 Tablespace\ub3c4 \uc544\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uacbd\uc6b0\uc5d0\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 Complete Media Recovery \ubc29\ubc95\uc5d0 \ub530\ub77c Recovery\ud55c\ub2e4.<\/span><\/p>\n

    \n
  1. Media Failure\uac00 \ubc1c\uc0dd\ud55c \uc2dc\uc810\uc5d0 DBA\uac00 Database\ub97c Shutdown \uc2dc\ucf30\ub2e4\uba74 \ub2e4\uc2dc Database\ub97c OPEN \ud55c\ub2e4. Database\ub97c Open\ud558\uba74 \uc190\uc0c1\ub41c Datafile\uc774 \uc18d\ud55c Tablespace\ub294 Offline\uc73c\ub85c \ub098\ud0c0\ub0a0 \uac83\uc774\ub2e4.<\/span>\u00a0 Data Dictionary DBA_TABLESPACES, DBA_DATA_FILES, V$DATAFILE \ub4f1\uc5d0\uc11c STATUS\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/li>\n<\/ol>\n

    \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a02.<\/span>\u00a0<\/span>\uc190\uc0c1\ub41c Datafile\uc5d0 \ub300\ud55c Backup File\uc744 Restore\ud55c\ub2e4. \uc190\uc0c1\ub418\uc9c0 \uc54a\uc740 \ub2e4\ub978 Datafile\uc774\ub098 Redo log file\uc774\ub098 Control file\uc744 Restore\ud558\uc9c0 \uc54a\ub3c4\ub85d \uc8fc\uc758\ud55c\ub2e4.
    \n<\/span><\/span><\/p>\n

    3.<\/span>\u00a0<\/span><\/span>RECOVER TABLESPACE command\ub97c \uc218\ud589\ud55c\ub2e4.
    \n<\/span><\/span><\/p>\n

    4.<\/span>\u00a0<\/span>Recovery\uac00 \uc644\ub8cc \ub418\uc5c8\uc73c\uba74 ALTER TABLESPACE ~ ONLINE command\ub85c Tablespace\ub97c ONLINE\uc2dc\ud0a8\ub2e4.
    \n<\/span><\/span><\/p>\n

    5.<\/span>\u00a0<\/span><\/span>Recovery\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \uc218\ud589\ub418\uc5c8\ub294\uc9c0 Database\ub97c Check\ud55c\ub2e4.<\/span>
    \n<\/span><\/span><\/p>\n

     <\/p>\n

    Open Database-Offline Tablespace-Individual Datafile\uc778 \uacbd\uc6b0\uc758 Complete Media Recovery
    \n<\/strong><\/span><\/p>\n

    Open Database-Offline Tablespace-Individual Datafile\uc778 \uacbd\uc6b0\ub780 \uc704\uc758 \uacbd\uc6b0\uc640 \uac19\uace0 Offline Tablespace \uc911 \ud2b9\uc815 Datafile\ub9cc \uc190\uc0c1\ub41c \uacbd\uc6b0\ub97c \ub9d0\ud55c\ub2e4. Recovery \ubc29\ubc95\ub3c4 Open Database-Offline Tablespace\uc778 \uacbd\uc6b0\uc758 Complete Media Recovery \ubc29\ubc95\uacfc \uac70\uc758 \ube44\uc2b7\ud558\uace0 \ub2e8\uc9c0 RECOVER TABLESPACE command\ub300\uc2e0\uc5d0 RECOVER DATAFILE command\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc190\uc0c1\ub41c Datafile\uc744 Recovery\ud558\ub294 \uac83\uc774 \ub2e4\ub97c \ubfd0\uc774\ub2e4.
    \n<\/span><\/p>\n

    1.<\/span>\u00a0\u00a0<\/span>Media Failure\uac00 \ubc1c\uc0dd\ud55c \uc2dc\uc810\uc5d0 DBA\uac00 Database\ub97c Shutdown \uc2dc\ucf30\ub2e4\uba74 \ub2e4\uc2dc Database\ub97c OPEN \ud55c\ub2e4. Database\ub97c Open\ud558\uba74 \uc190\uc0c1\ub41c Datafile\uc774 \uc18d\ud55c Tablespace\ub294 Offline\uc73c\ub85c \ub098\ud0c0\ub0a0 \uac83\uc774\ub2e4. Data Dictionary DBA_TABLESPACES, DBA_DATA_FILES, V$DATAFILE \ub4f1\uc5d0\uc11c STATUS\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.
    \n<\/span><\/span><\/p>\n

    2.<\/span>\u00a0\u00a0<\/span>\uc190\uc0c1\ub41c Datafile\uc5d0 \ub300\ud55c Backup File\uc744 Restore\ud55c\ub2e4. \uc190\uc0c1\ub418 \uc9c0 \uc54a\uc740 \ub2e4\ub978 Datafile\uc774\ub098 Redo log file\uc774\ub098 Control file\uc744 Restore\ud558\uc9c0 \uc54a\ub3c4\ub85d \uc8fc\uc758\ud55c\ub2e4.
    \n<\/span><\/span><\/p>\n

    3.<\/span>\u00a0\u00a0<\/span>RECOVER DATAFILE command\ub97c \uc218\ud589\ud55c\ub2e4.
    \n<\/span><\/span><\/p>\n

    4.<\/span>\u00a0\u00a0<\/span>Recovery\uac00 \uc644\ub8cc \ub418\uc5c8\uc73c\uba74 ALTER TABLESPACE ~ ONLINE command\ub85c Tablespace\ub97c ONLINE\uc2dc\ud0a8\ub2e4.
    \n<\/span><\/span><\/p>\n

    5.<\/span>\u00a0\u00a0<\/span><\/span>Recovery\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \uc218\ud589\ub418\uc5c8\ub294\uc9c0 Database\ub97c Check\ud55c\ub2e4.<\/span>
    \n<\/span><\/span><\/p>\n

     <\/p>\n

    Incomplete Media Recovery
    \n<\/strong><\/span><\/p>\n

    Incomplete Media Recovery\ub780 Media Failure\uc758 \ubc1c\uc0dd\uc73c\ub85c \uc778\ud55c Media Recovery\uc758 \ud55c \ubc29\ubc95\uc73c\ub85c Failure\uac00 \ubc1c\uc0dd\ud558\uae30 \ubc14\ub85c \uc9c1\uc804\uae4c\uc9c0\uc758 \ubcf5\uad6c\uac00 \uc544\ub2cc \uadf8 \uc774\uc804\uc758 \uc5b4\ub290 \ud2b9\uc815 \uc2dc\uc810\uae4c\uc9c0 Recovery\ub97c \ud558\ub294 \uac83\uc744 \ub9d0\ud55c\ub2e4. \uc774\ub7f0 \uc758\ubbf8\uc5d0\uc11c Incomplete Media Recovery\ub294 Media Recovery\uc758 \ubc18\ub300 \uac1c\ub150\uc774\ub77c\uace0 \ud560 \uc218 \uc788\uc73c\uba70 \uac04\ub2e8\ud55c \uadf8\ub9bc\uc73c\ub85c \ud45c\ud604\ud558\uba74 \uc544\ub798\uc640 \uac19\ub2e4.<\/span>
    \n<\/span><\/p>\n


    \n<\/span><\/a>
    \n<\/span><\/span><\/p>\n

    \"\"<\/a>
    \n<\/span><\/span><\/p>\n

    Incomplete Media Recovery\ub294 Database \uc804\uccb4\uc5d0 \ub300\ud574\uc11c \uacfc\uac70 \ud2b9\uc815 \uc2dc\uc810\uae4c\uc9c0 Recovery\ud558\ub294 \uac83\uc744 \uc804\uc81c\ub85c \ud55c\ub2e4. \uc989 \ud2b9\uc815 Datafile \uc774 \uc190\uc0c1\ub418\uc5c8\ub2e4\uace0 \ud574\uc11c \uadf8 \uc190\uc0c1\ub41c Datafile\ub9cc\uc744 \uacfc\uac70 \ud2b9\uc815 \uc2dc\uc810\uc73c\ub85c Recovery \ud560 \uc218\ub294 \uc5c6\ub2e4.
    \n<\/span><\/p>\n

    Incomplete Media Recovery\ub97c \uc218\ud589\ud558\ub294 \ubc29\ubc95\uc5d0\ub294 \ub2e4\uc74c\uc758 3\uac00\uc9c0 \ubc29\ubc95\uc774 \uc788\uc73c\uba70 \uc0c1\ud669\uc5d0 \ub530\ub77c \uc120\ud0dd\ud558\uc5ec Incomplete Media Recovery\ub97c \uc218\ud589\ud560 \uc218 \uc788\ub2e4.
    \n<\/span><\/p>\n

    \u00b7<\/span>\u00a0\u00a0\u00a0<\/span>Cancel-Based Recovery
    \n<\/span><\/span><\/p>\n

    \u00b7<\/span>\u00a0\u00a0\u00a0<\/span>Time-Based Recovery
    \n<\/span><\/span><\/p>\n

    \u00b7<\/span>\u00a0\u00a0\u00a0<\/span><\/span>Change-Based Recovery<\/span>
    \n<\/span><\/span><\/p>\n

     <\/p>\n

    Cancel-Based Recovery
    \n<\/strong><\/span><\/p>\n

    Cancel-Based Recovery\ub294 \ub2e4\uc74c\uacfc \uac19\uc774 \uc218\ud589\ud55c\ub2e4.
    \n<\/span><\/p>\n

    1.<\/span>\u00a0<\/span>Failure\uac00 \ubc1c\uc0dd\ud55c \uc2dc\uc810\uc5d0 \uc544\uc9c1 Database\uac00 OPEN\ub418\uc5b4 \uc788\ub2e4\uba74 Database\ub97c ABORT\ub85c Shutdown\ud55c\ub2e4.
    \n<\/span><\/span><\/p>\n

    2.<\/span>\u00a0<\/span>Recovery\ud558\ub294 \ub3d9\uc548 \ubc1c\uc0dd\ud560 \uc9c0 \ubaa8\ub97c Error\uc5d0 \ub300\ube44\ud574 Database \uc804\uccb4\uc5d0 \ub300\ud55c Full Cold Backup\uc744 \ubc1b\ub294\ub2e4.
    \n<\/span><\/span><\/p>\n

    3.<\/span>\u00a0<\/span>Media Failure\ub97c \uc57c\uae30\ud55c Hardware \ubb38\uc81c\ub97c \ud574\uacb0\ud55c\ub2e4.
    \n<\/span><\/span><\/p>\n

    4.<\/span>\u00a0<\/span>\ub9cc\uc57d \ud604\uc7ac\uc758 Control file\uc774 Recovery\ud558\uace0\uc790 \ud558\ub294 \uc2dc\uc810\uc758 Database\uc758 Control file\uacfc \uc77c\uce58\ud558\uc9c0 \uc54a\ub294\ub2e4\uba74 (\uc989, Recovery \ud558\uace0\uc790 \ud558\ub294 \uc2dc\uc810 \uc774\ud6c4\uc5d0 Datafile\uc744 \ucd94\uac00\ud588\ub2e4\uba74) Recovery \ud558\uace0\uc790 \ud558\ub294 \uc2dc\uc810\uc758 Database\uc758 Physical file \uad6c\uc870\ub97c \ubc18\uc601 \ud558\uace0 \uc788\ub294 Control file\uc758 Backup file\uc744 Restore\ud55c\ub2e4.
    \n<\/span><\/span><\/p>\n

    5.<\/span>\u00a0<\/span>Recovery \ud558\uace0\uc790 \ud558\ub294 \uc2dc\uc810\uc5d0\uc11c \uac00\uc7a5 \uc9c1\uc804\uc5d0 Backup \ubc1b\uc740 \ubaa8\ub4e0 Database\uc758 Datafile\uc744 Restore\ud55c\ub2e4. \uc608\ub97c \ub4e4\uba74 Log Sequence # 40 \uae4c\uc9c0 Recovery\ud558\uace0\uc790 \ud55c\ub2e4\uba74 Log Sequence # 40 \uc774 \ubc1c\uc0dd\ud558\uae30 \uc804\uc5d0 Backup \ubc1b\uc740 Datafile\uc744 Restore\ud55c\ub2e4. \ub9cc\uc57d Backup file\uc774 \uc5c6\ub2e4\uba74 Empty\ud55c Datafile\uc744 \uc0c8\ub85c \ub9cc\ub4e4\uc5b4 Recovery\ud560 \uc218 \uc788\ub2e4.
    \n<\/span><\/span><\/p>\n

    6.<\/span>\u00a0<\/span>STARTUP MOUNT \ud55c\ub2e4.
    \n<\/span><\/span><\/p>\n

    7.<\/span>\u00a0<\/span>RECOVER DATABASE UNTIL CANCEL command\ub97c \uc218\ud589\ud55c\ub2e4.
    \n<\/span><\/span><\/p>\n

    8.<\/span>\u00a0<\/span>Incomplete Media Recovery\uac00 \uc644\ub8cc \ub418\uc5c8\uc73c\uba74 Database\ub97c OPEN \ud574\uc57c \ud558\ub294 \ub370 \uc774\ub54c Database\ub97c RESETLOGS\ub85c OPEN\ud560 \uac83\uc778\uac00 \uc544\ub2c8\uba74 NORESETLOGS\ub85c OPEN\ud560 \uac83\uc778\uac00 \ub97c \uacb0\uc815\ud574\uc57c \ud55c\ub2e4. \uc989 Log Sequence #\ub97c \ub2e4\uc2dc Reset\ud560 \uac83\uc778 \uc9c0 \uc544\ub2cc\uc9c0\ub97c \uacb0\uc815\ud568\uc744 \uc758\ubbf8\ud55c\ub2e4.
    \n<\/span><\/span><\/p>\n

    9.<\/span>\u00a0<\/span><\/span>Database\ub97c OPEN\ud588\uc73c\uba74 \uc6d0\ud558\ub358 \uc2dc\uc810\uc73c\ub85c Recovery \ub418\uc5c8\ub294 \uc9c0 Check\ud55c\ub2e4.<\/span>
    \n<\/span><\/span><\/p>\n

     <\/p>\n

    RESETLOGS& NORESETLOGS option\uc758 \uc0ac\uc6a9 \uae30\uc900
    \n<\/strong><\/span><\/p>\n

    \ub2e4\uc74c\uc758 \uae30\uc900\uc5d0 \uc758\ud574 RESETLOGS \ub610\ub294 NORESETLOGS\ub97c \uacb0\uc815\ud558\ub3c4\ub85d \ud558\uc790.
    \n<\/span><\/p>\n

    –\u00a0<\/span>Recovery\ud560 \ub54c Control file\uc758 Backup\ubcf8\uc744 \ud65c\uc6a9\ud55c \uacbd\uc6b0(\uc608\ub97c \ub4e4\uc5b4 RECOVER DATABASE UNTIL TIME ‘………’ USING BACKUP CONTROLFILE<\/em><\/strong> command\ub97c \uc218\ud589\ud558\uc5ec Recovery\ud55c \uacbd\uc6b0)\ub294 Recovery\uc758 Type\uc774 Complete Media Recovery\uc774\ub4e0 Incomplete Media Recovery\uc774\ub4e0 \uc0c1\uad00 \uc5c6\uc774 RESETLOGS option\uc73c\ub85c Database\ub97c OPEN \ud55c\ub2e4. RESETLOGS option\uc73c\ub85c Database\ub97c OPEN\ud55c \uacbd\uc6b0\uc5d0 Message\uac00 Alert_SID.log file\uc5d0 \ub0a8\uc9c0\ub9cc Incomplete Media Recovery\ub97c \uc218\ud589\ud588\ub290\ub0d0 \uc544\ub2c8\uba74 Complete Media Recovery\ub97c \uc218\ud589\ud588\ub290\ub0d0\uc5d0 \ub530\ub77c Message\uac00 \ub2e4\ub974\uac8c \uc0dd\uc131\ub41c\ub2e4.
    \n<\/span><\/span><\/p>\n

    Incomplete Media Recovery\ub97c \uc218\ud589\ud55c \ub4a4 RESETLOGS\ud55c \uacbd\uc6b0\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 Message\uac00 \ub0a8\ub294\ub2e4.
    \n<\/span><\/p>\n

    RESETLOGS after incomplete recovery UNTIL CHANGE scn<\/em>
    \n<\/span><\/p>\n

    Complete Media Recovery\ub97c \uc218\ud589\ud55c \ub4a4 RESETLOGS\ud55c \uacbd\uc6b0\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 Message\uac00 \ub0a8\ub294\ub2e4.
    \n<\/span><\/p>\n

    RESETLOGS after complete recovery UNTIL CHANGE scn<\/em>
    \n<\/span><\/p>\n

     <\/p>\n

    –\u00a0<\/span>\uc2e4\uc9c8\uc801\uc73c\ub85c Incomplete Media Recovery\uac00 \uc218\ud589 \ub418\uc5c8\ub2e4\uba74 RESETLOGS option\uc73c\ub85c Database\ub97c OPEN \ud55c\ub2e4. Incomplete Media Recovery\uac00 \uc218\ud589\ub41c \uacbd\uc6b0 Alert_SID.log file\uc5d0\ub294 \ub2e4\uc74c\uc758 Message\uac00 \uc0dd\uc131\ub41c\ub2e4.
    \n<\/span><\/span><\/p>\n

    Incomplete recovery done UNTIL CHANGE scn<\/em>
    \n<\/span><\/p>\n

     <\/p>\n

    –\u00a0<\/span>Backup Control file\uc744 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uace0 Complete Media Recovery\ud55c \uacbd\uc6b0\ub77c\uba74 NORESETLOGS option\uc73c\ub85c Database\ub97c OPEN\ud55c\ub2e4. Complete Media Recovery\ub97c \uc218\ud589 \ud588\uac70\ub098 Incomplete Media Recovery\ub97c \uc218\ud589\ud588\uc9c0\ub9cc \uc2e4\uc9c8\uc801\uc73c \ub85c Redo log file\uc548\uc758 \ubaa8\ub4e0 \ubcc0\ud654\uac00 Recovery\ub41c \uacbd\uc6b0 (command\uc0c1\uc73c\ub85c\ub294 \uba85\uc2dc\uc801\uc73c\ub85c Incomplete Recovery \uc774\uc9c0 \ub9cc \uc2e4\uc9c8\uc801\uc778 Recovery\uc758 \ub0b4\uc6a9\uc740 Complete Recovery\ub97c \ud55c \uac83\uacfc \uac19\uc740 \uacbd\uc6b0)\uac00 \uc774 \uacbd\uc6b0\uc5d0 \ud574\ub2f9\ud55c\ub2e4. \uc774 \uacbd\uc6b0\uc5d0 Alert_SID.log file\uc5d0\ub294 \ub2e4\uc74c\uc758 Message\uac00 \uc0dd\uc131\ub41c\ub2e4.
    \n<\/span><\/span><\/p>\n

    Incomplete recovery applied all redo ever generated. Recovery completed through change nnnnnnnn<\/em>
    \n<\/span><\/p>\n

     <\/p>\n

    –\u00a0<\/span>Recovery\ud558\uace0\uc790 \ud558\ub294 Database\uc758 Redo log file\uc744 Standby Database\uac00 \uc0ac\uc6a9\ud558\uace0 \uc788\ub2e4\uba74 RESETLOGS\ud558\uba74 \uc548\ub41c\ub2e4. \ub9cc\uc57d RESETLOGS\ub85c database\ub97c OPEN\ud588\ub2e4\uba74 Standby Database \ub97c \ub2e4\uc2dc Creation\ud574\uc57c \ud55c\ub2e4.
    \n<\/span><\/span><\/p>\n

     <\/p>\n

    –\u00a0<\/span>RESETLOGS\ub85c Database\ub97c OPEN\ud558\uc5ec Redo log file\uc774 reset \ub418\uc5c8\ub2e4\uba74 Database\ub97c NORMAL\ub85c SHUTDOWN\ud55c \ub4a4 Full Offline Backup\uc744 \uc218\ud589\ud558\ub294 \uac83\uc744 \uc78a\uc5b4\uc11c\ub294 \uc548\ub41c\ub2e4. \uc65c\ub0d0\ud558\uba74 Log sequence\ub97c reset\ud55c \ud6c4 Database\uac00 \uc190\uc0c1\uc744 \uc785\uc740 \uacbd\uc6b0\uc5d0 Backup\ubcf8\uc774 \uc5c6\ub2e4\uba74 Reset log \uc774\ud6c4\uc5d0 Database\uc5d0 \ubc1c\uc0dd\ud55c \ubcc0 \ud654\ub294 Recovery\ud560 \uc218 \uc5c6\uae30 \ub54c\ubb38\uc774\ub2e4. NORESETLOGS\ub85c Database\ub97c OPEN\ud55c \uacbd\uc6b0\uc5d0\ub294 Full Offline Backup\ud560 \ud544\uc694\ub294 \uc5c6\ub2e4.
    \n<\/span><\/span><\/p>\n

     <\/p>\n

    –\u00a0<\/span>RESETLOGS option\uc744 \uc0ac\uc6a9\ud558\uc5ec Database\ub97c open\ud55c \uacbd\uc6b0\uc5d0 \ub294 Data dictionary\uc640 Control file\uc774 \ubd88\uc77c\uce58 \ud558\ub294\uac00\ub97c \ud655\uc778 \ud558\uae30 \uc704\ud574 Alert_SID.log file\uc744 Check\ud574\uc57c \ud55c\ub2e4. \u00a0\u00a0\u00a0\u00a0 \ub9cc\uc77c Datafile\uc774 Data dictionary\uc5d0\ub294 \uc874\uc7ac\ud558\uc9c0\ub9cc Recovery \ub97c \uac70\uccd0 \uc0c8\ub85c \uc0dd\uc131\ub41c Control file\uc5d0\ub294 \uc874\uc7ac\ud558\uc9c0 \uc54a\uc744 \uacbd\uc6b0 Datafile (\uc774 \uacbd\uc6b0 Datafile\uc774 Read Only\ub098 Offline\uc774\uc5b4\uc57c \ud55c\ub2e4.)\uc744 Renaming\ud568\uc73c\ub85c\uc368 \uc811\uadfc \uac00\ub2a5\ud558\uac8c \ud560 \uc218 \uc788\ub2e4. \ubc18\ub300\ub85c Control file\uc5d0 \ub098\ud0c0\ub09c Datafile\uc774 Data dictionary\uc5d0 \ub098\ud0c0\ub098\uc9c0 \uc54a\uc744 \uacbd\uc6b0\uc5d0 Oracle\uc740 Control file\ub85c\ubd80\ud130 \uadf8\uac83\uc744 \uc9c0\uc6b4\ub2e4.<\/span>
    \n<\/span><\/span><\/p>\n

     <\/p>\n

    Time-Based Recovery
    \n<\/strong><\/span><\/p>\n

    Incomplete Media Recovery\ub294 \uc704\uc5d0\uc11c \uc5b8\uae09\ud588\ub4ef\uc774 \uacfc\uac70 \ud2b9\uc815 \uc2dc \uc810\uc73c\ub85c Recovery\ud558\uace0\uc790 \ud560 \ub54c \uc0ac\uc6a9\ub418\ub294 Recovery Type\uc774\uba70 Cancel-Based Recovery, Time-Based Recovery, Change-Based Recovery\uc758 3\uac00\uc9c0 \ubc29\ubc95\uc774 \uc788\uace0 \uc0c1\ud669\uc5d0 \ub530\ub77c \uc801\ub2f9\ud55c \ubc29\ubc95\uc73c\ub85c Recovery\ud55c\ub2e4. Time-Based Recovery\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc0c1\ud669\uc774 \ubc1c\uc0dd\ud55c \uacbd\uc6b0\uc5d0 \ud6a8\uacfc\uc801\uc73c\ub85c Recovery\ud560 \uc218 \uc788\ub2e4.
    \n<\/span><\/p>\n

    1.<\/span>\u00a0<\/span>User\uc758 \uc2e4\uc218\uc5d0 \uc758\ud574 Table\uc774 Drop\ub418\uace0 \ub09c \ub4a4 Table\uc774 Drop\ub41c \uc2dc\uac04\uc744 \ub300\ub7b5 \uc54c\uace0 \uc788\ub2e4\uba74 DBA\ub294 Time-Based Recovery\ub97c \uc801\uc6a9 \ud558\uc5ec Drop \ub418\uae30 \uc9c1\uc804\uc758 \uc2dc\uc810\uc73c\ub85c Database\ub97c Recovery\ud560 \uc218 \uc788\ub2e4.
    \n<\/span><\/span><\/p>\n

    2.<\/span>\u00a0<\/span>\ud604\uc7ac \uc0ac\uc6a9 \uc911\uc778 Online Redo log file\uc758 \uc5b4\ub290 \ud2b9\uc815 \ubd80\ubd84\uc774 System Failure\ub85c \uc778\ud574 Log file\uc548\uc758 Data\uac00 \uc190\uc0c1\ub418\uc5c8\uc9c0\ub9cc User\uac00 \uc774\ub7ec\ud55c \uc0c1\ud669\uc744 \uc778\uc2dd\ud558\uc9c0 \ubabb\ud55c \ucc44 \uacc4\uc18d Database\ub97c \uc0ac\uc6a9\ud558\ub2e4\uac00 \uc2dc\uac04\uc774 \uc5b4\ub290 \uc815\ub3c4 \ud758\ub7ec Log Switch\uac00 \ub2e4\uc2dc \uc774 Corrupt Data\ub97c \uc18c\uc720\ud558\uace0 \uc788\ub294 Log file\ub85c Switch\ub97c \ub118\uae30\ub824\uace0 \ud560 \ub54c Instance\ub294 Terminated \ub41c\ub2e4. \uc774 \uacbd\uc6b0 Media Recovery\uac00 \uc694\uad6c\ub418\uba70 Corrupt data\uac00 \ubc1c\uc0dd\ud558\uae30 \uc9c1\uc804\uc758 \uc2dc\uac04 \uae4c\uc9c0 Recovery \ud574\uc57c \ud558\ubbc0\ub85c Time-Based Recovery\uac00 \ud544\uc694\ud558 \ub2e4. Corrupt Data\uac00 \ubc1c\uc0dd\ud55c \uc774\ud6c4\uc5d0 \uadf8 Online Redo log file\uc5d0 \uae30\ub85d\ub41c Valid\ud55c Data\ub294 Recovery \ub418\uc5b4\uc11c\ub294 \uc548\ub418\ubbc0\ub85c Time-Based Recovery\uac00 \ud544\uc694\ud558\ub2e4.
    \n<\/span><\/span><\/p>\n

    \uc704\uc758 2\uac00\uc9c0 Case\uc758 \uacbd\uc6b0\uc5d0\uc11c Incomplete Media Recovery\ub97c \uc218\ud589\ud558\uae30 \uc704\ud55c Command\uc5d0\uc11c \ud2b9\uc815 \uc2dc\uac04\uc744 \uba85\uc2dc\ud558\uac70\ub098 SCN #\ub97c \uba85\uc2dc\ud558\uc5ec \uc6d0\ud558\ub294 \uacfc\uac70 \ud2b9\uc815 \uc2dc\uc810\uae4c\uc9c0 Recovery\ud560 \uc218 \uc788\ub2e4. \ud2b9\uc815 \uc2dc\uac04\uc744 \uba85\uc2dc\ud574\uc11c Recovery\ud55c \uacbd\uc6b0\uc5d0 \uadf8 \uc2dc\uac04 \ubc14\ub85c \uc774\uc804\uc5d0 Commit\ub41c Transaction\uae4c\uc9c0 Recovery\uac00 \ub41c\ub2e4. \ub9cc\uc57d SCN#\ub97c \uba85\uc2dc\ud574\uc11c Recovery\ub97c \uc218\ud589\ud55c \uacbd\uc6b0\uc5d0\ub294 SCN#\uc758 Commit\ub41c Transaction\uae4c\uc9c0 Recovery\ub41c\ub2e4.
    \n<\/span><\/p>\n

    Time-Based Recovery\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc21c\uc11c\ub85c Recovery\ub41c\ub2e4.
    \n<\/span><\/p>\n

    1.<\/span>\u00a0\u00a0<\/span>Failure\uac00 \ubc1c\uc0dd\ud55c \uc2dc\uc810\uc5d0 \uc544\uc9c1 Database\uac00 OPEN\ub418\uc5b4 \uc788\ub2e4\uba74 Database\ub97c ABORT\ub85c Shutdown\ud55c\ub2e4.
    \n<\/span><\/span><\/p>\n

    2.<\/span>\u00a0\u00a0<\/span>Recovery\ud558\ub294 \ub3d9\uc548 \ubc1c\uc0dd\ud560 \uc9c0 \ubaa8\ub97c Error\uc5d0 \ub300\ube44\ud574 Database \uc804\uccb4\uc5d0 \ub300\ud55c Full Cold Backup\uc744 \ubc1b\ub294\ub2e4.
    \n<\/span><\/span><\/p>\n

    3.<\/span>\u00a0\u00a0<\/span>Media Failure\ub97c \uc57c\uae30\ud55c Hardware \ubb38\uc81c\ub97c \ud574\uacb0\ud55c\ub2e4.
    \n<\/span><\/span><\/p>\n

    4.<\/span>\u00a0\u00a0<\/span>\ub9cc\uc57d \ud604\uc7ac\uc758 Control file\uc774 Recovery\ud558\uace0\uc790 \ud558\ub294 \uc2dc\uc810\uc758 Database\uc758 Control file\uacfc \uc77c\uce58\ud558\uc9c0 \uc54a\ub294\ub2e4\uba74 (\uc989, Recovery \ud558\uace0\uc790 \ud558\ub294 \uc2dc\uc810 \uc774\ud6c4\uc5d0 Datafile\uc744 \ucd94\uac00\ud588\ub2e4\uba74) Recovery \ud558\uace0\uc790 \ud558\ub294 \uc2dc\uc810\uc758 Database\uc758 Physical file \uad6c\uc870\ub97c \ubc18\uc601\ud558 \uace0 \uc788\ub294 Control file\uc758 Backup file\uc744 Restore\ud55c\ub2e4.
    \n<\/span><\/span><\/p>\n

    5.<\/span>\u00a0\u00a0<\/span>Recovery \ud558\uace0\uc790 \ud558\ub294 \uc2dc\uc810\uc5d0\uc11c \uac00\uc7a5 \uc9c1\uc804\uc5d0 Backup \ubc1b\uc740 \ubaa8\ub4e0 Database\uc758 Datafile\uc744 Restore\ud55c\ub2e4. \uc608\ub97c \ub4e4\uba74 Log Sequence # 40 \uae4c\uc9c0 Recovery\ud558\uace0\uc790 \ud55c\ub2e4\uba74 Log Sequence # 40 \uc774 \ubc1c\uc0dd\ud558\uae30 \uc804\uc5d0 Backup \ubc1b\uc740 Datafile\uc744 Restore\ud55c\ub2e4. \ub9cc\uc57d Backup file\uc774 \uc5c6\ub2e4\uba74 Empty\ud55c Datafile\uc744 \uc0c8\ub85c \ub9cc\ub4e4\uc5b4 Recovery\ud560 \uc218 \uc788\ub2e4.
    \n<\/span><\/span><\/p>\n

    6.<\/span>\u00a0\u00a0<\/span>STARTUP MOUNT \ud55c\ub2e4.
    \n<\/span><\/span><\/p>\n

    7.<\/span>\u00a0\u00a0<\/span>Recovery\ub97c \uc218\ud589\ud558\uae30 \uc774\uc804\uc5d0 \ubaa8\ub4e0 Datafile\uc740 Online \uc0c1\ud0dc \uc5ec\uc57c \ud55c\ub2e4. V$DATAFILE\uc5d0\uc11c Recovery\ud560 Datafile\uc744 \ud655\uc778\ud574 \ubcf4\uace0 \ub9cc\uc57d Offline\uc778 Datafile\uc740 Online\uc2dc\ud0a8\ub2e4.
    \n<\/span><\/span><\/p>\n

    8.<\/span>\u00a0\u00a0<\/span>RECOVER DATABASE UNTIL TIME command\ub97c \uc218\ud589\ud55c\ub2e4. Time\uc758 \ud615\uc2dd\uc740 \ubc18\ub4dc\uc2dc \ub2e4\uc74c\uacfc \uac19\uc740 \ud615\uc2dd\uc73c\ub85c \ud55c\ub2e4.\u00a0\u00a0<\/span><\/span>‘YYYY-MM-DD:HH24:MI:SS’<\/span><\/p>\n

    9.<\/span>\u00a0 <\/span>Database\ub97c OPEN\ud55c\ub2e4. \uc774\ub54c RESETLOG\ub85c OPEN\ud560 \uac83\uc778\uc9c0 NORESETLOGS\ub85c OPEN\ud560 \uac83\uc778\uc9c0 \uacb0\uc815\ud55c \ud6c4 \uc774\ub97c Command\uc0c1\uc5d0\uc11c \uba85\uc2dc\ud558\uc5ec Database\ub97c OPEN\ud574\uc57c \ud55c\ub2e4.
    \n<\/span><\/span><\/p>\n

    \u00a0 \u00a0 \u00a010. Database\uac00 \uc815\uc0c1\uc801\uc73c\ub85c Recovery\ub418\uc5c8\ub294\uc9c0 Check\ud55c\ub2e4.<\/span>
    \n<\/span><\/p>\n

     <\/p>\n

     <\/p>\n

    Change-Based Recovery
    \n<\/strong><\/span><\/p>\n

     <\/p>\n

    Change-Based Recovery\ub3c4 Incomplete Media Recovery\uc758 \uc77c\uc885\uc73c \ub85c \ub2e4\uc74c\uacfc \uac19\uc740 \uc0c1\ud669\uc774 \ubc1c\uc0dd\ud55c \uacbd\uc6b0\uc5d0 \ud6a8\uacfc\uc801\uc73c\ub85c Recovery\ud560 \uc218 \uc788\ub2e4.
    \n<\/span><\/p>\n

     <\/p>\n

    1.\u00a0\u00a0<\/span>User\uc758 \uc2e4\uc218\uc5d0 \uc758\ud574 Table\uc774 Drop\ub418\uace0 \ub09c \ub4a4 Table\uc774 Drop\ub41c \uc2dc\uac04\uc744 \ub300\ub7b5 \uc54c\uace0 \uc788\ub2e4\uba74 DBA\ub294 Time-Based Recovery\ub97c \uc801\uc6a9 \ud558\uc5ec Drop \ub418\uae30 \uc9c1\uc804\uc758 \uc2dc\uc810\uc73c\ub85c Database\ub97c Recovery\ud560 \uc218 \uc788\ub2e4.
    \n<\/span><\/span><\/p>\n

    2.<\/span>\u00a0\u00a0<\/span>\ud604\uc7ac \uc0ac\uc6a9 \uc911\uc778 Online Redo log file\uc758 \uc5b4\ub290 \ud2b9\uc815 \ubd80\ubd84\uc774 System Failure\ub85c \uc778\ud574 Log file\uc548\uc758 Data\uac00 \uc190\uc0c1\ub418\uc5c8\uc9c0\ub9cc User\uac00 \uc774\ub7ec\ud55c \uc0c1\ud669\uc744 \uc778\uc2dd\ud558\uc9c0 \ubabb\ud55c \ucc44 \uacc4\uc18d Database\ub97c \uc0ac\uc6a9\ud558\ub2e4\uac00 \uc2dc\uac04\uc774 \uc5b4\ub290 \uc815\ub3c4 \ud758\ub7ec Log Switch\uac00 \ub2e4\uc2dc \uc774 Corrupt Data\ub97c \uc18c\uc720\ud558\uace0 \uc788\ub294 Log file\ub85c Switch\ub97c \ub118\uae30\ub824\uace0 \ud560 \ub54c Instance\ub294 Terminated \ub41c\ub2e4. \uc774 \uacbd\uc6b0 Media Recovery\uac00 \uc694\uad6c\ub418\uba70 Corrupt data\uac00 \ubc1c\uc0dd\ud558\uae30 \uc9c1\uc804\uc758 \uc2dc\uac04 \uae4c\uc9c0 Recovery \ud574\uc57c \ud558\ubbc0\ub85c Time-Based Recovery\uac00 \ud544\uc694\ud558 \ub2e4. Corrupt Data\uac00 \ubc1c\uc0dd\ud55c \uc774\ud6c4\uc5d0 \uadf8 Online Redo log file\uc5d0 \uae30\ub85d\ub41c Valid\ud55c Data\ub294 Recovery \ub418\uc5b4\uc11c\ub294 \uc548\ub418\ubbc0\ub85c Time-Based Recovery\uac00 \ud544\uc694\ud558\ub2e4.
    \n<\/span><\/span><\/p>\n

     <\/p>\n

    \uc704\uc758 2\uac00\uc9c0 Case\uc758 \uacbd\uc6b0\uc5d0\uc11c Incomplete Media Recovery\ub97c \uc218\ud589\ud558\uae30 \uc704\ud55c Command\uc5d0\uc11c \ud2b9\uc815 \uc2dc\uac04\uc744 \uba85\uc2dc\ud558\uac70\ub098 SCN #\ub97c \uba85\uc2dc\ud558\uc5ec \uc6d0\ud558\ub294 \uacfc\uac70 \ud2b9\uc815 \uc2dc\uc810\uae4c\uc9c0 Recovery\ud560 \uc218 \uc788\ub2e4. \ud2b9\uc815 \uc2dc\uac04\uc744 \uba85\uc2dc\ud574\uc11c Recovery\ud55c \uacbd\uc6b0\uc5d0 \uadf8 \uc2dc\uac04 \ubc14\ub85c \uc774\uc804\uc5d0 Commit\ub41c Transaction\uae4c\uc9c0 Recovery\uac00 \ub41c\ub2e4. \ub9cc\uc57d SCN#\ub97c \uba85\uc2dc\ud574\uc11c Recovery\ub97c \uc218\ud589\ud55c \uacbd\uc6b0\uc5d0\ub294 SCN#\uc758 Commit\ub41c Transaction\uae4c\uc9c0 Recovery\ub41c\ub2e4.
    \n<\/span><\/p>\n

     <\/p>\n

     <\/p>\n

    Change-Based Recovery\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc21c\uc11c\ub85c Recovery\ub41c\ub2e4.
    \n<\/span><\/p>\n

    1.<\/span>\u00a0\u00a0<\/span>Failure\uac00 \ubc1c\uc0dd\ud55c \uc2dc\uc810\uc5d0 \uc544\uc9c1 Database\uac00 OPEN\ub418\uc5b4 \uc788\ub2e4 \uba74 Database\ub97c ABORT\ub85c Shutdown\ud55c\ub2e4.
    \n<\/span><\/span><\/p>\n

    2.<\/span>\u00a0\u00a0<\/span>Recovery\ud558\ub294 \ub3d9\uc548 \ubc1c\uc0dd\ud560 \uc9c0 \ubaa8\ub97c Error\uc5d0 \ub300\ube44\ud574 Database \uc804\uccb4\uc5d0 \ub300\ud55c Full Cold Backup\uc744 \ubc1b\ub294\ub2e4.
    \n<\/span><\/span><\/p>\n

    3.<\/span>\u00a0\u00a0<\/span>Media Failure\ub97c \uc57c\uae30\ud55c Hardware \ubb38\uc81c\ub97c \ud574\uacb0\ud55c\ub2e4.
    \n<\/span><\/span><\/p>\n

    4.<\/span>\u00a0\u00a0<\/span>\ub9cc\uc57d \ud604\uc7ac\uc758 Control file\uc774 Recovery\ud558\uace0\uc790 \ud558\ub294 \uc2dc\uc810\uc758 Database\uc758 Control file\uacfc \uc77c\uce58\ud558\uc9c0 \uc54a\ub294\ub2e4\uba74 (\uc989, Recovery \ud558\uace0\uc790 \ud558\ub294 \uc2dc\uc810 \uc774\ud6c4\uc5d0 Datafile\uc744 \ucd94\uac00\ud588\ub2e4\uba74) Recovery \ud558\uace0\uc790 \ud558\ub294 \uc2dc\uc810\uc758 Database\uc758 Physical file \uad6c\uc870\ub97c \ubc18\uc601\ud558 \uace0 \uc788\ub294 Control file\uc758 Backup file\uc744 Restore\ud55c\ub2e4.
    \n<\/span><\/span><\/p>\n

    5.<\/span>\u00a0\u00a0<\/span>Recovery \ud558\uace0\uc790 \ud558\ub294 \uc2dc\uc810\uc5d0\uc11c \uac00\uc7a5 \uc9c1\uc804\uc5d0 Backup \ubc1b\uc740 \ubaa8\ub4e0 Database\uc758 Datafile\uc744 Restore\ud55c\ub2e4. \uc608\ub97c \ub4e4\uba74 Log Sequence # 40 \uae4c\uc9c0 Recovery\ud558\uace0\uc790 \ud55c\ub2e4\uba74 Log Sequence # 40 \uc774 \ubc1c\uc0dd\ud558\uae30 \uc804\uc5d0 Backup \ubc1b\uc740 Datafile\uc744 Restore\ud55c\ub2e4. \ub9cc\uc57d Backup file\uc774 \uc5c6\ub2e4\uba74 Empty\ud55c Datafile\uc744 \uc0c8\ub85c \ub9cc\ub4e4\uc5b4 Recovery\ud560 \uc218 \uc788\ub2e4.
    \n<\/span><\/span><\/p>\n

    6.<\/span>\u00a0\u00a0<\/span>STARTUP MOUNT \ud55c\ub2e4.
    \n<\/span><\/span><\/p>\n

    7.<\/span>\u00a0\u00a0<\/span>Recovery\ub97c \uc218\ud589\ud558\uae30 \uc774\uc804\uc5d0 \ubaa8\ub4e0 Datafile\uc740 Online \uc0c1\ud0dc \uc5ec\uc57c \ud55c\ub2e4. V$DATAFILE\uc5d0\uc11c Recovery\ud560 Datafile\uc744 \ud655\uc778\ud574 \ubcf4\uace0 \ub9cc\uc57d Offline\uc778 Datafile\uc740 Online\uc2dc\ud0a8\ub2e4.
    \n<\/span><\/span><\/p>\n

    8.<\/span>\u00a0\u00a0<\/span>RECOVER DATABASE UNTIL CHANGE command\ub97c \uc218\ud589 \ud55c\ub2e4. SCN#\ub294 Quotation mark (‘`) \uc5c6\uc774 10\uc9c4\uc218\ub85c \ub098\ud0c0\ub0b8 \ub2e4.
    \n<\/span><\/span><\/p>\n

    9.<\/span>\u00a0\u00a0<\/span>Database\ub97c OPEN\ud55c\ub2e4. \uc774\ub54c RESETLOG\ub85c OPEN\ud560 \uac83\uc778 \uc9c0 NORESETLOGS\ub85c OPEN\ud560 \uac83\uc778\uc9c0 \uacb0\uc815\ud55c \ud6c4 \uc774\ub97c Command\uc0c1\uc5d0\uc11c \uba85\uc2dc\ud558\uc5ec Database\ub97c OPEN\ud574\uc57c \ud55c\ub2e4.
    \n<\/span><\/span><\/p>\n

    \u00a0 \u00a0 10. Database\uac00 \uc815\uc0c1\uc801\uc73c\ub85c Recovery\ub418\uc5c8\ub294\uc9c0 Check\ud55c\ub2e4.<\/span>
    \n<\/span><\/p>\n

     <\/p>\n

     <\/p>\n

    Incomplete Media Recovery\uc758 Mechanism
    \n<\/strong><\/span><\/p>\n

    Incomplete Media Recovery\uc5d0 \uc801\uc6a9\ub418\ub294 Backup file\uc740 Recovery \ud558\uace0\uc790 \ud558\ub294 \uc2dc\uc810 \uc774\uc804\uc5d0 \uc644\uc131\ub41c Backup file\ub85c Restore \ub418\uc5b4\uc838 \uc57c \ud55c\ub2e4.
    \n<\/span><\/p>\n

    Incomplete Media Recovery\ub97c \ud558\ub294 \ub3d9\uc548 \uc0ac\uc6a9\ub418\ub294 Control file\uc740 \ubcf5\uad6c\ud558\uace0\uc790 \ud558\ub294 \uc2dc\uc810\uc758 Database\uc758 \ubb3c\ub9ac\uc801 \uad6c\uc870\ub97c \ubc18\uc601\ud558\uace0 \uc788\uc5b4\uc57c \ud55c\ub2e4. RESETLOGS option\uc744 \uc0ac\uc6a9\ud558\uc5ec Database\ub97c OPEN \ud588\uac70\ub098 CREATE CONTROLFILE command\ub97c \uc0ac\uc6a9\ud55c \ud6c4 \uc5d0 Database\ub97c OPEN\ud588\ub2e4\uba74 Oracle\uc740 \ud604\uc7ac\uc758 Database\uc758 Data Dictionary\uc640 Control file\uc744 Check\ud558\uc5ec Database\uc758 \ubb3c\ub9ac\uc801\uc778 \uad6c \uc870\uac00 \uc77c\uce58\ud558\uc9c0 \uc54a\uc73c\uba74 Alert_SID.log file\uc5d0 Error Message\ub97c \uae30\ub85d \ud55c\ub2e4. \ub9cc\uc77c Control file\uc5d0\ub294 \uc5c6\ub294 Datafile\uc774 Data Dictionary\uc5d0 \ucd94\uac00\ub418\uc5b4 \uc788\uac70\ub098, Control file\uc5d0\ub294 Datafile\uc758 \uc815\ubcf4\uac00 \uc874\uc7ac\ud558\uc9c0\ub9cc \ud604\uc7ac Data Dictionary\uc5d0\ub294 \ub098\ud0c0\ub098\uc9c0 \uc54a\ub294\ub2e4\uba74 Oracle\uc740 \uc11c\ub85c \uc77c\uce58\ub418\uac8c\ub054 Control file\uc744 \uc218\uc815\ud55c\ub2e4.
    \n<\/span><\/p>\n

    Incomplete Media Recovery\ub294 \ubaa8\ub4e0 Redo log file\uc744 \uc801\uc6a9\ud558\ub294 \uac83\uc774 \uc544\ub2c8\ub77c Redo log file\uc758 \uc77c\ubd80\ub9cc\uc744 \uc801\uc6a9\ud558\uc5ec Recovery\ub97c \uc644\ub8cc\ud558\ub294 \uac83\uc774\ub2e4. Incomplete Media Recovery\ub294 \uc9c0\uc815\ud55c Stop Point \uae4c\uc9c0 Recovery\ud558\ub294 \uac83\uc774\uba70 Stop Point\uc5d0 \ub3c4\ub2ec\ub418\uc5c8\uc744 \ub54c \uc790\ub3d9\uc801\uc73c\ub85c Recovery\ub294 \uc644\ub8cc\ub418\ub294 \uac83\uc774\ub2e4.
    \n<\/span><\/p>\n

    Incomplete Media Recovery\ub97c \ud558\uae30 \uc804\uc5d0\ub294 \ubc18\ub4dc\uc2dc Offline\uc778 Datafile\uc740 Online\uc73c\ub85c \ubc14\uafb8\uace0 Recovery\ub97c \uc218\ud589\ud574\uc57c \ud55c\ub2e4.
    \n<\/span><\/p>\n

    Incomplete Media Recovery\uac00 \uc131\uacf5\uc801\uc73c\ub85c \uc218\ud589\ub418\uace0 \ub09c \ud6c4 Database\ub97c OPEN \ud560 \ub54c\uc5d0\ub294 \ubc18\ub4dc\uc2dc RESETLOGS option\uc73c\ub85c OPEN\ud574\uc57c \ud55c\ub2e4. RESETLOGS\ub294 \ubaa8\ub4e0 Online Redo log file\uacfc Archived Redo log file\uc5d0\uc11c \ud604\uc7ac Redo Entry\ub97c \ubb34\ud6a8\ub85c \ub9cc\ub4e4\uba70 Log Sequence\uac00 Reset \ub418\uace0 \ub09c \ud6c4 Database\uc758 Redo log file\uc740 \ub9c8\uce58 \ubc29\uae08 Creation\ub41c \uac83\ucc98\ub7fc Oracle\uc740 \uc778\uc2dd\ud558\uac8c \ub418\uace0, Online Redo log file\uc740 \uc5b4\ub5a4 Redo Entry\ub3c4 \ud3ec\ud568\ud558\uc9c0 \uc54a\ub294\ub2e4.<\/span>
    \n<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

    Recovery Database\uc5d0 \uc774\uc0c1\uc774 \uc0dd\uaca8 Error\ub97c Return\ud560 \uacbd\uc6b0 Instance\uc5d0 \ubc1c\uc0dd\ud55c \ubaa8\ub4e0 Error\ub294 Trace file\ub85c \ubc1b\ud788\uace0 Alert\uc5d0 \uae30\ub85d\ub418\ubbc0\ub85c \uc774\uc0c1\uc774 \ubc1c\uacac\ub418\uba74 \uc81c\uc77c \uba3c\uc800 Trace file\uc744 Check\ud558\uc5ec Error\ub97c \ud655\uc778\ud558\uace0 \uc6d0\uc778\uc744 \ud30c\uc545\ud55c\ub2e4. Recovery \uc791\uc5c5\uc740 \ubc1c\uc0dd\ud55c failure type\uc5d0 \ub530\ub77c \ub2e4\ub974\uac8c \uc218\ud589\ub41c\ub2e4.   Instance Recovery & Media Recovery   Instance Recovery   Database Instance Failure\uac00 \ubc1c\uc0dd\ud588\uc744 \ub54c Instance Recovery\ub294 \uc694\uad6c\ub41c\ub2e4. Database Instance […]<\/p>\n","protected":false},"author":1,"featured_media":3402,"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":[14],"tags":[1057,1058],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/1-know-how-1.jpg?fit=937%2C450","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3712"}],"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=3712"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3712\/revisions"}],"predecessor-version":[{"id":3714,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3712\/revisions\/3714"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/3402"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3712"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3712"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3712"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}