{"id":1296,"date":"2016-02-11T06:52:52","date_gmt":"2016-02-11T06:52:52","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1296"},"modified":"2016-02-11T06:52:52","modified_gmt":"2016-02-11T06:52:52","slug":"rman%ec%9d%98-%ea%b8%b0%eb%b3%b8%ec%a0%81-%ec%a7%80%ec%8b%9d","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1296","title":{"rendered":"RMAN\uc758 \uae30\ubcf8\uc801 \uc9c0\uc2dd"},"content":{"rendered":"

RMAN\uc740 \ub3c5\ub9bd\ud615 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc73c\ub85c \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \ud074\ub77c\uc774\uc5b8\ud2b8 \uc5f0\uacb0 \ubc29\uc2dd\uc744 \ud1b5\ud574 \uc811\uc18d\ub429\ub2c8\ub2e4. \uc2e4\uc81c RMAN\uc740 Command Interpreter\uc5d0 \ubd88\uacfc\ud558\uc5ec \uc720\uc800\uc758 \uba85\ub839\uc744 \ud574\ub3c5\ud55c \ud6c4, RPC\ub97c \ud1b5\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uac8c \ub118\uaca8\uc90d\ub2c8\ub2e4. \uc2e4\uc81c\uc801\uc778 \uc791\uc5c5\uc758 \ucc98\ub9ac\ub294 \ub300\uc0c1 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uc218\ud589\ud558\uac8c \ub429\ub2c8\ub2e4. RMAN\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub300\uc0c1 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uc18d\ud560 \uc2dc\uc5d0\ub294 \ud574\ub2f9 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 SYS \uad8c\ud55c\uc73c\ub85c \uc811\uc18d\ud574\uc57c \ud569\ub2c8\ub2e4. \uc774\ub54c RMAN \uc740 as sysdba \ub97c \uc790\ub3d9\uc801\uc73c\ub85c \uc0ac\uc6a9\ud558\uac8c \ub429\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

Enterprise Edition\uc774 \uc544\ub2c8\uba74 RMAN\uc740 \ubc31\uc5c5 \uc2dc\uc5d0 \uc624\uc9c1 \ud558\ub098\uc758 \ucc44\ub110\ub9cc\uc744 \uad6c\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. Client \uc124\uce58 \uc2dc\uc5d0\ub294 Runtime Client Option\uc774 \uc544\ub2cc Administrator option\uc744 \uc120\ud0dd\ud574\uc57c RMAN\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

\ub124\ud06c\uc6cc\ud06c\ub85c\uc758 \uc5f0\uacb0 \uc2dc, Oracle NET \uc5f0\uacb0\ubc29\uc2dd\uc744 \ud1b5\ud574 \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc5f0\uacb0\ub429\ub2c8\ub2e4. Local \ub85c \uc5f0\uacb0\ud560 \ub54c\uc5d0\ub294 \ud2b9\uc815\ud55c \ud544\uc694 \uc791\uc5c5\uc774 \uc5c6\uc9c0\ub9cc Remote\ub85c \uc5f0\uacb0\ub420 \uc2dc\uc5d0\ub294 RMAN\uc744 \uad6c\ub3d9\ud558\ub294 \uba38\uc2e0\uc758 tnsnames.ora \ud30c\uc77c\uc5d0 \uc815\ud655\ud55c ORACLE_SID\uac00 \ubbf8\ub9ac \uc124\uc815\ub418\uc5b4\uc57c \ud558\uba70, \ud328\uc2a4\uc6cc\ub4dc \ud30c\uc77c \ub610\ud55c \uc0dd\uc131\uc774 \ub418\uc5b4 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4. \ub610\ud55c, 9iR2 \ubc84\uc804\uc5d0\uc11c\uc758 \ub514\ud3f4\ud2b8 \uc124\uce58\uac12\uc778 Shared Server \ud615\uc2dd\uc73c\ub85c \uc124\uce58\uac00 \ub418\uc5b4 \uc788\uc744 \uc2dc\uc5d0\ub294 tnsnames.ora \ud30c\uc77c\uc5d0\uc11c\uc758 \uc5f0\uacb0\ubc29\uc2dd\uc740 \ud56d\uc0c1 (SERVER=DEDICATED)\ub85c \uc124\uc815\uc774 \ub418\uc5b4\uc57c \ud569\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

\n <\/p>\n

RMAN\uc758 \uba54\ubaa8\ub9ac \uc0ac\uc6a9
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

RMAN\uc744 \uc0ac\uc6a9\ud560 \uc2dc \uc8fc\uc758\ud574\uc57c \ud558\ub294 \uac83\uc740 shared pool\uacfc large pool \uc785\ub2c8\ub2e4. RMAN\uc740 \uba87 \uac1c\uc758 Oracle PL\/SQL \ud328\ud0a4\uc9c0\ub4e4\uc744 \uae30\uc874\uc758 PL\/SQL \ud328\ud0a4\uc9c0\ub4e4\uacfc \ub9c8\ucc2c\uac00\uc9c0\ub85c Shared Pool \uc5d0 \uc62c\ub824 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uc774 \ub54c Shared Pool\uc758 \uc5ec\uc720 \uacf5\uac04\uc774 \ubd80\uc871\ud558\uac70\ub098 \ub2e8\ud3b8\ud654 \ud604\uc0c1\uc774 \uc2ec\ud560 \uc2dc\uc5d0\ub294 RMAN \ud328\ud0a4\uc9c0\uac00 \uc2e4\ud589\ub418\uc9c0 \uc54a\uc744 \uc218\uac00 \uc788\uc2b5\ub2c8\ub2e4. \ud56d\uc0c1 Shared Pool \ub0b4\ubd80\uc5d0 RMAN\uc758 \uc2e4\ud589\uc5d0 \ucda9\ubd84\ud55c \uba54\ubaa8\ub9ac\uac00 \uc874\uc7ac\ud574\uc57c \ud569\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

Large Pool\uc740 RMAN\uc774 \ub514\ud3f4\ud2b8\ub85c \uc0ac\uc6a9\ud558\ub3c4\ub85d \uc124\uc815\ub41c \uacf5\uac04\uc774 \uc544\ub2c8\uba70, \uc0ac\uc6a9\ud558\ub3c4\ub85d \uc124\uc815\uc744 \ud558\uc600\uc744 \uc2dc\uc5d0\ub3c4 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\uc744 \uc218\uac00 \uc788\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

\n <\/p>\n

RMAN\uacfc Control file\uc758 \uc5f0\uad00
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

Control File\uc740 \ub9d0 \uadf8\ub300\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub0b4\uc758 \uc2e4\uc81c\uc801 (Physical) \ud30c\uc77c\ub4e4\uc744 \uad00\ub9ac\ud558\ub294\ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. Control File\uc758 \ub0b4\ubd80\uc801\uc778 \uc815\ubcf4\ub294 Circular reuse records\uc640 noncircular reuse records\ub85c \uad6c\ubd84\ub429\ub2c8\ub2e4. Physical Backup\uc744 \uad00\uc7a5\ud558\ub294 RMAN\uc73c\ub85c\uc11c\ub294 Control File\uc758 \uc0ac\uc6a9\uc774 \uc808\ub300\uc801\uc73c\ub85c \ud544\uc694\ud569\ub2c8\ub2e4. RMAN\uc740 Control File\ub85c\ubd80\ud130 \ud544\uc694\ud55c \ud30c\uc77c\ub4e4\uc758 \ub9ac\uc2a4\ud2b8, checkpoint\uc758 \uc815\ubcf4 \ubc0f \ubcf5\uad6c \uac00\ub2a5 \uc5ec\ubd80\ub97c \uc218\uc9d1\ud569\ub2c8\ub2e4. \ub610\ud55c Control File\uc744 \uc9c1\uc811 \uc561\uc138\uc2a4\ud558\ubbc0\ub85c \uc720\uc800\uac00 \uc218\ub3d9\uc73c\ub85c \ud30c\uc77c \ub9ac\uc2a4\ud2b8\ub97c \uc791\uc131\ud560 \ud544\uc694\uc131\uc744 \ubc30\uc7ac\uc2dc\ud0b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ucd94\uac00\uc801\uc778 \uc815\ubcf4\ub4e4\uc744 \uc800\uc7a5\ud558\uae30 \uc704\ud574 Control File\uc740 8\uc5d0\uc11c\ubd80\ud130 \uc880\ub354 \ud070 \uc0ac\uc774\uc988\ub85c \uc791\uc131\uc774 \ub429\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

RMAN\uc740 \uc2a4\uc2a4\ub85c \ud589\ud55c \ubc31\uc5c5 \uc791\uc5c5\uc758 \uc815\ubcf4\ub4e4\uc744 \uc77c\ubc18\uc801\uc73c\ub85c\ub294 Control File\uc5d0 \uae30\ub85d\ud558\uc5ec \ud544\uc694 \uc2dc \ucc38\uc870\ud558\uac8c \ub429\ub2c8\ub2e4. Control File\uc758 \ub0b4\ubd80\uc801\uc778 \uc815\ubcf4\ub294 Circular reuse records\uc640 noncircular reuse records\ub85c \uad6c\ubd84\ub429\ub2c8\ub2e4. RMAN Catalog\uc758 \uc0ac\uc6a9 \uc2dc\uc5d0\ub294 Control File \ub300\uc2e0 Catalog\uc5d0 \uc774\ub7ec\ud55c \uc815\ubcf4\ub4e4\uc744 \uae30\ub85d\ud558\uac8c \ub429\ub2c8\ub2e4. \ub9cc\uc57d \uc774\ub7ec\ud55c \ubc31\uc5c5\uacfc \uad00\ub828\ub41c \uc815\ubcf4\uac00 Control File\uc5d0 \uae30\ub85d\ub418\uc9c0 \uc54a\uac70\ub098 \uc0ad\uc81c\ub418\uc5c8\ub2e4\uba74 RMAN\uc744 \ud1b5\ud574 \uad6c\ucd95\ud574\ub454 \ubc31\uc5c5\uc740 \uc0ac\uc6a9\uc774 \ubd88\uac00\ub2a5\ud574\uc9d1\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uc774\uc720\ub85c \uc778\ud558\uc5ec Control File\uc740 RMAN\uc744 \uc0ac\uc6a9\ud558\uae30 \uc704\ud55c \uc808\ub300\uc801 \ud544\uc694 \uc694\uc18c\ub77c \ub9d0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

Control File\uc740 \uadf9\ud788 \ub4dc\ubb3c\uc9c0\ub9cc \ub514\uc2a4\ud06c \uc6a9\ub7c9\uc758 \ubd80\uc871\uc73c\ub85c \uc778\ud558\uc5ec \uc624\ub798\ub41c \ub0b4\ubd80\uc801\uc778 \uc815\ubcf4\ub4e4\uc774 \uc790\uccb4\uc801\uc73c\ub85c \uc0ad\uc81c\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c CONTROLFILE_RECORD_KEEP_TIME \ud30c\ub77c\ubbf8\ud130\uc758 \uc801\uc808\uce58 \ubabb\ud55c \uc124\uc815\uc73c\ub85c \uc778\ud558\uc5ec \uc790\uccb4 \uc815\ubcf4\ub4e4\uc774 \uc0ad\uc81c\ub420 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \ud30c\ub77c\ubbf8\ud130\uc758 \uae30\ubcf8\uac12\uc740 7 \ub85c\uc11c DAY \ub2e8\uc704\ub97c \ub098\ud0c0\ub0c5\ub2c8\ub2e4. \ubb3c\ub860 RMAN\uc758 \ubc31\uc5c5 \uc815\ubcf4\uac00 \uc0ad\uc81c\ub418\ub294 \uac83\uc744 \ubc29\uc9c0\ud558\uae30 \uc704\ud574\uc11c \uc785\ub2c8\ub2e4. \ub610\ud55c \ub4a4\uc5d0\uc11c \ub2e4\uc2dc \uc124\uba85\ud558\uaca0\uc9c0\ub9cc \uc774 \ud30c\ub77c\ubbf8\ud130\uc758 \uac12\uc744 RMAN\uc758 BACKUP RETENTION PERIOD\uc758 \uac12\ubcf4\ub2e4 \uae38\uac8c \uc7a1\ub294 \uac83 \ub610\ud55c \ubb38\uc81c\uc758 \ubc1c\uc0dd \uc694\uc9c0\uac00 \uc788\uc5b4 \ucd94\ucc9c\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

\ub610\ud55c \uadf9\ud788 \uc8fc\uc758\ud574\uc57c \ud560 \uc0ac\ud56d\uc740 Control File\uc744 \ubc31\uc5c5\ud560 \uc2dc\uc5d0 RMAN\uc774 \ubc31\uc5c5\ud55c Control File \ub300\uc2e0, ‘alter database backup controlfile to trace’\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc0dd\uc131\ud55c \ubc31\uc5c5\uc6a9 Control File\uc758 \uc0ac\uc6a9\uc785\ub2c8\ub2e4. \uc774\uc640 \uac19\uc774 \ubc31\uc5c5\ub41c Control File\uc740 RMAN\uc774 \uae30\ub85d\ud55c \ubc31\uc5c5 \uc815\ubcf4\ub4e4\uc744 \ud3ec\ud568\uc2dc\ud0a4\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ub9cc\uc57d RMAN Catalog\ub97c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294 \uc0c1\ud0dc\uc5d0\uc11c \uc774\uc640 \uac19\uc740 Control File\uc744 \uc0ac\uc6a9\ud558\uc5ec \uae30\uc874\uc758 Control File\uc744 \ub36e\uc5b4 \uc50c\uc6b4\ub2e4\uba74 RMAN\uc744 \ud1b5\ud55c \ubc31\uc5c5\uc740 \uc804\ubd80 \uc0ac\uc6a9\uc774 \ubd88\uac00\ub2a5\ud574\uc9d1\ub2c8\ub2e4. \uc774\uc640 \uac19\uc774 Control File\uc744 \uc7ac\uad6c\uc131\ud574\uc57c \ud560 \uacbd\uc6b0\ub294 \ud754\ud788 MAXLOGFILES \ub098 MAXLOGHISTORY \ud30c\ub77c\ubbf8\ud130 \uac12\ub4f1\uc758 \ubcc0\uacbd\uacfc \uac19\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ub0b4\ubd80\uc801\uc778 \uad6c\uc870\ub97c \ubcc0\uacbd\uc2dc\ucf30\uc744 \ub54c \ud544\uc694\ud55c\ub370, \uac00\ub2a5\ud558\ub2e4\uba74 \uc774\uc640 \uac19\uc774 TRACE\ub97c \uc0ac\uc6a9\ud558\uc5ec Control File\uc744 \ubc31\uc5c5\ud558\ub294 \uac83\uc740 RMAN\uc744 \uc0ac\uc6a9\ud560 \uc2dc\uc5d0\ub294 \ucd5c\ub300\ud55c \ubc30\uc7ac\ud574\uc57c \ud569\ub2c8\ub2e4. \ud639\uc740 Trace \ub300\uc2e0 Binary file \uc790\uccb4\ub85c\uc11c Control File\uc744 \ubc31\uc5c5\ud558\uc5ec RMAN \uad00\ub828 \uc815\ubcf4\ub97c \ubcf4\uc874\ud558\uba74\uc11c Control File\uc744 \ubc31\uc5c5\ud558\ub294 \uac83 \ub610\ud55c \uac00\ub2a5\ud569\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

Control File\uc740 Binary File\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub0b4\uc5d0\uc11c \ub9e4\uc6b0 \uc5c5\ub370\uc774\ud2b8 \uc131\uc774 \uac15\ud55c \ud30c\uc77c\uc785\ub2c8\ub2e4. \ub9cc\uc57d RMAN\uc744 \ud1b5\ud55c \ubc31\uc5c5 \uc911\uc5d0 Control File\uc758 \ub0b4\uc6a9\uc774 \ubcc0\uacbd\uc774 \ub41c\ub2e4\uba74 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud558\uaca0\uc9c0\uc694. \ud639\uc740 Control File\uc758 \ubcc0\uacbd\uc744 \uc7a0\uae08\ud560 \uc218\ub3c4 \uc788\uc9c0\ub9cc \uc774\ub807\uac8c \ub41c\ub2e4\uba74 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc804\uccb4\ub97c \uc7a0\uae08\ud558\ub294 \uac83\uacfc \ub2e4\ub97c \ubc14\uac00 \uc5c6\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uc810\uc744 \uadf9\ubcf5\ud558\uae30 \uc704\ud574 RMAN\uc740 Snapshot Controlfile\uc774\ub77c\ub294 \uae30\ubc95\uc744 \uc0ac\uc6a9\ud558\uc5ec \ubc31\uc5c5 \ub3c4\uc911\uc758 Control File\uacfc\uc758 \ub3d9\uc9c8\uc131\uc744 \uc720\uc9c0\ud569\ub2c8\ub2e4. \uc774\ub807\uac8c \uc0dd\uc131\ub41c Snapshot Controlfile\uc740 ORACLE_HOME\/dbs (UNIX), ORACLE_HOME\/database (MS) \uc5d0 SNCF<ORACLE_SID>\ub77c\ub294 \uc774\ub984\uc73c\ub85c \uc800\uc7a5\ub418\uac8c \ub429\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uae30\ubcf8\uc801\uc778 \uc704\uce58\ub294 ‘configure snapshot controlfile name to ‘<location\/file_name>’ \uc758 \uc0ac\uc6a9\uc744 \ud1b5\ud558\uc5ec \ubcc0\uacbd\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

\n <\/p>\n

RMAN-08512 : waiting for snapshot controlfile enqueue
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

\uc704\uc640 \uac19\uc740 \uc5d0\ub7ec\ub294 \uae30\uc874\uc758 snapshot controlfile header\uac00 \ub2e4\ub978 \ud504\ub85c\uc138\uc2a4\uc5d0 \uc758\ud574 \uc7a0\uaca8\uc788\uc744 \ub54c \ubc1c\uc0dd\ud569\ub2c8\ub2e4. \ub450\uac1c \uc774\uc0c1\uc758 RMAN \ud504\ub85c\uc138\uc2a4\ub97c \uc2e4\ud589\ud558\uc5ec \ubcf5\uc218\uc758 \ubc31\uc5c5\uc744 \uc2e4\ud589\ud560 \ub54c\uc5d0\ub3c4 \ubc1c\uc0dd\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4. \uc774\uc640 \uac19\uc740 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud558\uc600\uc744 \uc2dc \ub2e4\uc74c\uacfc \uac19\uc740 \ubc29\ubc95\uc73c\ub85c \ud2b8\ub7ec\ube14\uc288\ud305\uc744 \ud574\ubcf4\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

select s.sid, username as “User”, program, moduel, action, logon_time”Logon”, l.*
\n<\/span><\/p>\n

from v$seesion s, v$enqueue_lock l
\n<\/span><\/p>\n

where l.sid = s.sid and l.type = ‘CF’ and l.idl = 0 and l.id2 = 2;
\n<\/span><\/p>\n

\n <\/p>\n

\n <\/p>\n

RMAN Server Processes
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

RMAN \uc2e4\ud589 \uc2dc, \ub450\uac1c\uc758 \uc11c\ubc84 \ud504\ub85c\uc138\uc2a4\uc640 \ucc44\ub110 \ub2f9 \ud558\ub098\uc758 \ucc44\ub110 \ud504\ub85c\uc138\uc2a4\uac00 \uc0dd\uc131\ub429\ub2c8\ub2e4. \ud55c \uac1c\uc758 \uc11c\ubc84 \ud504\ub85c\uc138\uc2a4\ub294 \ub300\uc0c1 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c\uc758 SYS\uad8c\ud55c\uc73c\ub85c \ud544\uc694\ud55c RMAN \ud328\ud0a4\uc9c0\ub97c \ud638\ucd9c\ud558\uba70 \ubc31\uc5c5\uacfc \ubcf5\uad6c\uc5d0 \uc744 \uc2e4\ud589\ud558\ub294 \ucc44\ub110 \ud504\ub85c\uc138\uc2a4\uc758 \uc791\uc5c5\uc591\uc744 coordinate \ud569\ub2c8\ub2e4. \ub450\ubc88\uc9f8 \uc11c\ubc84 \ud504\ub85c\uc138\uc2a4\ub294 shadow\ub77c\uace0\ub3c4 \ubd88\ub9ac\uba70, RMAN\uc758 \uc7a5\uc2dc\uac04 \ud2b8\ub79c\uc7ad\uc158\uc744 \uac10\uc2dc\ud558\uba70 \ud544\uc694\ud55c \uc815\ubcf4\ub4e4\uc744 \ub85c\uadf8\ud569\ub2c8\ub2e4. \ucc44\ub110 \ud504\ub85c\uc138\uc2a4\ub294 \uc2e4\uc81c\uc801\uc73c\ub85c \ubc31\uc5c5\uacfc \ubcf5\uad6c\ub97c \uc2e4\ud589\ud558\ub294 \ud504\ub85c\uc138\uc2a4\ub85c\uc11c \ub370\uc774\ud130\ud30c\uc77c\ub85c\ubd80\ud130 \uc2e4\uc9c0 \uc77c\uae30\uc640 \uc4f0\uae30\ub97c \ub2f4\ub2f9\ud569\ub2c8\ub2e4. \ucc44\ub110 \ud504\ub85c\uc138\uc2a4\uc758 \ud0c0\uc785\uc740 DISK CHANNEL\uacfc TAPE CHANNEL \ub450\uac00\uc9c0\uac00 \uc874\uc7ac\ud569\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

\uc774\uc640 \uac19\uc774 \uc7a5\uae30\uac04 \ucc98\ub9ac\ub418\ub294 \ud504\ub85c\uc138\uc2a4\ub4e4\uc740 \ub2e4\uc74c\uacfc \uac19\uc774 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

Select sid, serial#, context, sofar, totalwork, round(sofar\/totalwork * 100, 2) “%_COMPLETE”
\n<\/span><\/p>\n

From v$session_longops
\n<\/span><\/p>\n

And opname like ‘RMAN%’
\n<\/span><\/p>\n

And totalwork != 0
\n<\/span><\/p>\n

And sofar <> totalwork
\n<\/span><\/p>\n

\n <\/p>\n

\n <\/p>\n

RMAN I\/O Processes
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

RMAN\uc740 \ub300\uc0c1 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc801\uc808\ud558\uac8c \uad6c\uc131\ub418\uc5c8\uc744 \uacbd\uc6b0 I\/O slave\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c I\/O slave \uc5d0\ub294 disk I\/O\uc640 tape I\/O \ub450\uac00\uc9c0\uac00 \uc788\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

Disk I\/O Slave\uc758 \uacbd\uc6b0, DBWR_IO_SLAVE \ud30c\ub77c\ubbf8\ud130\ub85c \uc870\uc815\ub429\ub2c8\ub2e4. \uc5b4\ub5a0\ud55c \uc22b\uc790\ub85c\ub4e0 \uc124\uc815\uc774 \uac00\ub2a5\ud558\uba70 0 \uc774 \uc544\ub2cc \uac12\uc73c\ub85c \uc124\uc815\uc774 \ub418\uc5b4 \uc788\uc744 \uacbd\uc6b0 RMAN\uc740 \uc790\ub3d9\uc801\uc73c\ub85c \ud558\ub098\uc758 \ucc44\ub110\ub2f9 4\uac1c\uc758 I\/O \ud504\ub85c\uc138\uc2a4\ub97c \ud560\ub2f9\ud558\uc5ec \ub370\uc774\ud130\ube14\ub7ed\uc744 RMAN \uba54\ubaa8\ub9ac \ubc84\ud37c\ub85c \uc77d\uc5b4 \uc62c\ub9ac\uac8c \ud569\ub2c8\ub2e4. \uc774\uac83\uc740 \uc88b\uc740 \uae30\ub2a5\uc774\uae30\ub294 \ud558\uc9c0\ub9cc RMAN\uc774 \uba54\ubaa8\ub9ac\ub97c \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc5d0 \uc788\uc5b4 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. DBWR_IO_SLAVE\uc758 \ud65c\uc6a9\uc740 \uc624\uc9c1 OS\uc5d0\uc11c \ube44\ub3d9\uae30\uc801 I\/O \ub97c \uc9c0\uc6d0\ud558\uc9c0 \uc54a\uac70\ub098 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub3c4\ub85d \uc124\uc815\ud558\uc600\uc744 \uacbd\uc6b0\uc5d0\ub9cc \uc720\uc6a9\ud558\uac8c \uc4f0\uc785\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

Tape I\/O \uc758 \uacbd\uc6b0 BACKUP_TAPE_IO_SLAVES \ud30c\ub77c\ubbf8\ud130\uc758 \uac12\uc774 TRUE\ub85c \uc124\uc815\uc774 \ub418\uc5b4 \uc788\ub294 \uacbd\uc6b0\uc5d0 RMAN\uc740 \uac01 \ucc44\ub110 \ub2f9 \ud558\ub098\uc758 Tape I\/O Slave\ub97c \uc124\uc815\ud569\ub2c8\ub2e4. \uc774 \uc124\uc815\uc740 Disk I\/O\uc640\ub294 \ub2ec\ub9ac \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub300\ud574 \uc5b4\ub5a0\ud55c \ubcc0\uacbd\ub3c4 \ud558\uc9c0 \uc54a\uc73c\uba70 \ub2e8\uc9c0 Tape Backup\uc5d0\ub9cc \uc601\ud5a5\uc744 \ubbf8\uce69\ub2c8\ub2e4. \ubb3c\ub860 Tape\uc740 \uae30\ubcf8\uc801\uc73c\ub85c \ube44\ub3d9\uae30\uc801 I\/O\ub97c \uc9c0\uc6d0\ud558\uc9c0 \uc54a\uae30 \ub54c\ubb38\uc5d0 Tape Backup\uc758 \uc0ac\uc6a9 \uc2dc, \ud56d\uc0c1 \uc774 \ud30c\ub77c\ubbf8\ud130\uc758 \uac12\uc744 TRUE\ub85c \uc124\uc815\ud558\ub294 \uac83\uc744 \uad8c\uc7a5\ud569\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

RMAN\uc758 SYS \ud328\ud0a4\uc9c0 \uc0ac\uc6a9
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

RMAN\uc740 SYS\uad8c\ud55c\uc73c\ub85c DBMS_RVCMAN\uacfc DBMS_BACKUP_RESTORE \ud328\ud0a4\uc9c0\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uc774 \ud328\ud0a4\uc9c0\ub4e4\uc740 catproc.sql\ub85c \ub514\ud3f4\ud2b8 \uc0dd\uc131\ub418\uba70, 8.0.3\ubd80\ud130 \uae30\ubcf8\uc801\uc73c\ub85c \uc0dd\uc131\ub429\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ud328\ud0a4\uc9c0\ub4e4\uc740 Oracle \ub77c\uc774\ube0c\ub7ec\ub9ac\ud30c\uc77c\ub85c \uc790\uccb4 \ub0b4\uc7a5\uc774 \ub418\uc5b4 \uc788\uc5b4, \ub2e4\ub978 \ud328\ud0a4\uc9c0\ub4e4\uacfc\ub294 \ub2ec\ub9ac \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc624\ud508\ub418\uc9c0 \uc54a\uc558\uc744 \uc2dc\uc5d0\ub3c4 \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4. \uc989 \ucd5c\uc18c\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 nomount \uc2a4\ud14c\uc774\uc9c0\uc77c \ub54c\ubd80\ud130 \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

\n <\/p>\n

SYS.DBMS_RCVMAN
\n<\/span><\/p>\n

\n <\/p>\n

\uc774 \ud328\ud0a4\uc9c0\ub294 Control File\uc744 \uc77d\uc5b4 RMAN\uc774 \ud574\ub2f9 \uc791\uc5c5\uc744 \uc218\ud589\ud558\uae30 \uc704\ud574 \ud544\uc694\ud55c \uc815\ubcf4\ub4e4\uc744 \uc785\ub825\ud558\ub294 \uc5ed\ud560\uc744 \ud569\ub2c8\ub2e4. \ubc31\uc5c5 \ubc0f \ubcf5\uad6c\uc5d0 \ud544\uc694\ud55c \ud30c\uc77c\ub4e4\uc758 \uc704\uce58\uc640 \ud30c\uc77c \ud5e4\ub354 \uc815\ubcf4 \ubc0f \ud06c\uae30 \ub4f1\uc758 \uc815\ubcf4 \ucde8\uae09\uc744 \ub2f4\ub2f9\ud569\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

SYS.DBMS_BACKUP_RESTORE
\n<\/span><\/p>\n

\n <\/p>\n

\uc774 \ud328\ud0a4\uc9c0\ub294 \ubc31\uc5c5 \ubc0f \ubcf5\uad6c\uc5d0 \ud544\uc694\ud55c \ub370\uc774\ud130\ud30c\uc77c, \ucee8\ud2b8\ub864\ud30c\uc77c, ARCHIVED REDO LOG \ud30c\uc77c\ub4e4\uc744 \ud638\ucd9c\ud558\uae30 \uc704\ud55c SYSTEM CALL\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

RMAN\uc758 DATA BLOCK BACKUP
\n<\/span><\/p>\n

\n <\/p>\n

RMAN\uc5d0\uc11c\ub294 BLOCK-LEVEL BACKUP\uc758 \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4. RMAN\uc758 \uad6c\uc870\ub294 INPUT \uba54\ubaa8\ub9ac\uc640 OUTPUT \uba54\ubaa8\ub9ac\ub85c \uc774\ub8e8\uc5b4\uc838 \uac01 DB \ube14\ub85d\uc774 \ubc31\uc5c5\uc744 \uc704\ud574 \ucc98\ub9ac\ub420 \ub54c, \uac01 \ube14\ub85d\uc5d0 \ub300\ud574 CORRUPTION \uc810\uac80\uc744 \ud558\uac8c \ub429\ub2c8\ub2e4. (PROXY COPY\ub85c \uc2e4\ud589\ud560 \uacbd\uc6b0\uc5d0\ub294 \uc81c\uc678\ub429\ub2c8\ub2e4.) \ub610\ud55c \uc774 \ucc98\ub9ac \uc808\ucc28 \ub2e8\uacc4\uc5d0\uc11c Null Compression \uc810\uac80\uc744 \ud558\uc5ec \ube14\ub85d \ud5e4\ub354\uac00 0 \uc73c\ub85c \uc7a1\ud600\uc788\ub294, \uc989 \ube44\uc5b4\uc788\ub294 \ube14\ub85d\uc5d0 \ub300\ud574\uc11c\ub294 \ubc31\uc5c5\uc5d0 \ud3ec\ud568\uc2dc\ud0a4\uc9c0 \uc54a\uc544 \ud6e8\uc52c \ub354 \ud6a8\uacfc\uc801\uc778 \ubc31\uc5c5\uc744 \uc218\ud589\ud558\uac8c \ub429\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

\uc774 \ub54c \uc644\ubcbd\ud558\uac8c \ube44\uc5b4\uc788\ub294 \ubaa8\ub4e0 DB \ube14\ub85d\ub4e4\uc774 \ubc31\uc5c5 \ub300\uc0c1\uc5d0\uc11c \uc81c\uc678\ub418\ub294 \uac83\uc740 \uc544\ub2d9\ub2c8\ub2e4. RMAN\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \ub2e4\uc6b4\ub418\uc5b4 \uc788\uc744 \ub54c\uc5d0\ub3c4 \uc218\ud589\ub418\uc5b4\uc57c \ud558\uae30 \ub54c\ubb38\uc5d0, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc6b4\uc6a9\ub418\uc5b4 \uc788\ub294 \uc911\uc758 Segment Management \uc815\ubcf4\ub97c \ud3ec\ud568\ud558\uace0 \uc788\ub294 \ubdf0\uc5d0 \uc811\uadfc\ud558\ub294 \ub300\uc2e0 (\ubcf4\ub2e4 \uc815\ud655\ud55c \uc815\ubcf4\ub97c \uc5bb\uc744 \uc218 \uc788\ub294), OS \ub808\ubca8\uc5d0\uc11c\uc758 \ub370\uc774\ud130\ud30c\uc77c \ud5e4\ub354\uc5d0\uc11c \ud544\uc694\ud55c \uc815\ubcf4\ub97c \uc5bb\uc5b4\uc624\uae30 \ub54c\ubb38\uc5d0 \uc608\ub97c \ub4e4\uc5b4 Truncate \uc2dc\ud0a8 \ud14c\uc774\ube14\uc5d0 \uc18c\ubaa8\ub418\uc5b4 \uc788\ub294 DB \ube14\ub85d\uc5d0 \ub300\ud55c \uc815\ubcf4\ub4e4\uc744 \uc5bb\uc5b4\uc62c \uc218\uc5c6\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

\uadf8\ub9ac\uace0 \uc774\ub7ec\ud55c \ubc29\uc2dd\uc73c\ub85c \ubbf8\uc0ac\uc6a9\ub41c \ube14\ub85d\uc758 \ubc31\uc5c5 \ubd88\ud3ec\ud568\uc774 \uc2dc\uac04\uc801\uc778 \uc131\ub2a5 \ud5a5\uc0c1\uc744 \ubd88\ub7ec \uc77c\uc73c\ud0a4\ub294 \uac83\uc740 \uc544\ub2d9\ub2c8\ub2e4. \uc2ec\uac01\ud55c \ubcd1\ud569\ud604\uc0c1\uc744 \ubcf4\uc774\ub294 \ubc31\uc5c5 \ub300\uc0c1 \uc7a5\uce58\ub97c \uc81c\uc678\ud558\uace0\ub294 \uc2dc\uac04\uc801\uc73c\ub85c\ub294 \uac70\uc758 \ub3d9\uc77c\ud55c \uc2dc\uac04\uc744 \uc18c\ubaa8\ud558\uac8c \ub429\ub2c8\ub2e4. \uc65c\ub0d0\ud558\uba74 RMAN\uc740 \uc5ec\uc804\ud788 \ub370\uc774\ud130\ud30c\uc77c \ub0b4\uc758 \ubaa8\ub4e0 \ube14\ub85d\uc744 \ub300\uc0c1\uc73c\ub85c \uac80\uc0ac\ub97c \ud558\uc5ec\uc57c \ud558\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

\uc774\ub7ec\ud55c BLOCK-Level Backup\uc740 Redo \uc758 \uc0dd\uc131\uc744 \uc801\uac8c \ud569\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc778 \ubaa8\ub4dc\uc758 \ubc31\uc5c5 \uc791\uc5c5\uc740 \ub9ce\uc740 \uc591\uc758 Redo Log \uc0dd\uc131 \ubc0f, Archived Redo Log \ub97c \uc704\ud55c Log Switch\uc758 \ub300\ub7c9 \ubc1c\uc0dd\ub4f1\uc774 \uc57c\uae30\ub418\ub098, RMAN \uc740 DBWR \uc640 \uc5f0\uacc4\ud558\uc5ec \uc791\uc5c5\uc744 \uc218\ud589\ud558\uae30\uc5d0 Block \ub808\ubca8\uc758 \ub3d9\uae30\uc131\uc744 \ubcf4\uc7a5\ud560 \ud544\uc694\uac00 \uc5c6\uc5b4 \uc774\ub7ec\ud55c \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

\uc624\ub77c\ud074 9i \ubd80\ud130\ub294 ‘ora-1578: block corruption detected’ \uc5d0\ub7ec\uc758 \ubc1c\uc0dd \uc2dc, \ud30c\uc77c\uc744 \ud1b5\uc9f8\ub85c \ubcf5\uad6c\ud558\ub294 \ub300\uc2e0, \ub2e8\uc21c\ud788 Corrupt \ub41c \ube14\ub85d\ub9cc\uc744 \uad50\uccb4\ud560\uc218 \uc788\uc5b4 \uadf8 \ud6a8\uc6a9\uc131\uc774 \ub354\uc6b1 \uc99d\uac00\ub418\uc5c8\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

\n <\/p>\n

RMAN\uc758 \uba54\ubaa8\ub9ac \uc0ac\uc6a9
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

RMAN\uc758 \ub450\uac00\uc9c0\uc758 \ubc84\ud37c\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \ud558\ub098\ub294 INPUT BUFFER\ub85c \ubc31\uc5c5\ub418\ub294 \ud30c\uc77c\ub4e4\uc758 \ub370\uc774\ud130\ube14\ub85d\uc774 \ub85c\ub529\ub418\ub294 \uacf3\uc774\uba70 \ub2e4\ub978 \ud558\ub098\ub294 OUTPUT BUFFER\ub85c\uc368 \ud574\ub2f9 \ube14\ub85d\uc774 \ubc31\uc5c5\uc774 \ud544\uc694\ud55c\uc9c0\uc758 \uc5ec\ubd80\ub97c \uac80\uc0ac\ud558\ub294 \uacf3\uc785\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

\n <\/p>\n

INPUT MEMORY BUFFER
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

– \ubc31\uc5c5 \uc14b\uc5d0 \ud3ec\ud568\ub420 \ud30c\uc77c\ub4e4\uc758 \uac1c\uc218\uac00 4, \ud639\uc740 \uc774\ud558\uc77c \ub54c RMAN\uc740 \ud30c\uc77c \ub2f9 4\uac1c\uc758 \ubc84\ud37c\ub97c 1MB \ud06c\uae30\ub85c \uc0dd\uc131\ud569\ub2c8\ub2e4. \uc804\uccb4 \ud06c\uae30\ub294 16MB \ud639\uc740 \uadf8\ubcf4\ub2e4 \uc791\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

– \ubc31\uc5c5 \uc14b\uc5d0 \ud3ec\ud568\ub420 \ud30c\uc77c\ub4e4\uc758 \uac1c\uc218\uac00 4 \ubcf4\ub2e4 \ud06c\uace0 9 \ubcf4\ub2e4 \uc791\uc744 \ub54c, RMAN\uc740 \ud30c\uc77c \ub2f9 4\uac1c\uc758 \ubc84\ud37c\ub97c 512 KB \ud06c\uae30\ub85c \uc0dd\uc131\ud569\ub2c8\ub2e4. \uc804\uccb4 \ud06c\uae30\ub294 16MB \ud639\uc740 \uadf8\ubcf4\ub2e4 \uc791\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

– \ubc31\uc5c5 \uc14b\uc5d0 \ud3ec\ud568\ub420 \ud30c\uc77c\ub4e4\uc758 \uac1c\uc218\uac00 8 \ubcf4\ub2e4 \ud074 \ub54c RMAN\uc740 \ud30c\uc77c \ub2f9 4\uac1c\uc758 \ubc84\ud37c\ub97c 128KB \ud06c\uae30\ub85c \uc0dd\uc131\ud569\ub2c8\ub2e4. \ud30c\uc77c \ub2f9 \ud560\ub2f9\ub418\ub294 \ucd5c\ub300 INPUT \ubc84\ud37c\uc758 \ud06c\uae30\ub294 512KB \uc785\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

– \uc774\ub7ec\ud55c \ubaa8\ub4e0 \uc0ac\ud56d\uc740 \ucc44\ub110 \ub2f9 \ud560\ub2f9\ub418\ub294 \uac83\uc784\uc744 \uba85\uc2ec\ud558\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

\n <\/p>\n

OUTPUT MEMORY BUFFER
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

– \ub514\uc2a4\ud06c\ub85c \uc4f8 \ub54c, \ucc44\ub110 \ubcc4\ub85c \ucd1d 4\uac1c\uc758 OUTPUT BUFFER\uac00 \uc0dd\uc131\ub418\uba70 \uac01\uac01\uc758 \ud06c\uae30\ub294 1MB\uac00 \ub429\ub2c8\ub2e4. \uc774\ub9ac\ud558\uc5ec \uac01 \ucc44\ub110\ubcc4 \ucd5c\ub300 \ud06c\uae30\ub294 4MB\uac00 \ub429\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

– \ud14c\uc774\ud504\uc5d0 \uc4f8 \ub54c, \ucc44\ub110 \ubcc4\ub85c \ucd1d 4\uac1c\uc758 OUTPUT BUFFER\uac00 \uc0dd\uc131\ub418\uba70 \uac01\uac01\uc758 \ud06c\uae30\ub294 256KB\uac00 \ub429\ub2c8\ub2e4. \uc774\ub9ac\ud558\uc5ec \uac01 \ucc44\ub110\ubcc4 \ucd5c\ub300 \ud06c\uae30\ub294 \ucd1d 1MB\uac00 \ub429\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

\n <\/p>\n

\ubcf5\uad6c\uc2dc \uc0ac\uc6a9\ub418\ub294 \uba54\ubaa8\ub9ac \ubc84\ud37c
\n<\/span><\/p>\n

\n <\/p>\n

– \ub514\uc2a4\ud06c\uc5d0\uc11c\uc758 \ubcf5\uad6c \uc2dc, \ucc44\ub110 \ubcc4\ub85c \ucd1d 4\uac1c\uc758 INPUT BUFFER\uac00 \uc0dd\uc131\ub418\uba70 \uac01\uac01\uc758 \ud06c\uae30\ub294 \ucd1d 1MB\uac00 \ub429\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

– \ud14c\uc774\ud504\uc5d0\uc11c\uc758 \ubcf5\uad6c \uc2dc, \ucc44\ub110 \ubcc4\ub85c \ucd1d 4\uac1c\uc758 INPUT BUFFER\uac00 \uc0dd\uc131\ub418\uba70 \uac01\uac01\uc758 \ud06c\uae30\ub294 BLKSIZE\uc758 \ud06c\uae30\uc5d0 \ub9de\ucd94\uc5b4 \uc0dd\uc131\ub429\ub2c8\ub2e4. \uae30\ubcf8\uac12\uc740 256KB\uc785\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

– \ubcf5\uad6c \uc2dc\uc758 OUTPUT BUFFER\uc758 \ud06c\uae30\ub294 \ucc44\ub110 \ubcc4\ub85c \ucd1d 4\uac1c\uc758 OUTPUT BUFFER\uac00 \uc0dd\uc131\ub418\uba70 \ud56d\uc0c1 128KB \ud06c\uae30\ub85c \uc0dd\uc131\ub429\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

\n <\/p>\n

RMAN \uc758 \uba54\ubaa8\ub9ac \uc0ac\uc6a9: PGA vs SGA
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

– \uae30\ubcf8\uc801\uc73c\ub85c \uba54\ubaa8\ub9ac \ud560\ub2f9\uc740 PGA\uc5d0\uc11c \uc0dd\uc131\ub418\uac8c \ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \ub9cc\uc57d DBWR_IO_SLAVES \ub098 BACKUP_TAPE_IO_SLAVE \uac00 \uc124\uc815\ub418\uc5b4 \uc788\ub2e4\uba74 SGA\uc758 Shared Pool\uc5d0\uc11c \ud560\ub2f9\ubc1b\uac8c \ub429\ub2c8\ub2e4. \uc774 \ub54c Shared Server\ub098 JDBC connection pooling \ud639\uc740 PARALLEL_AUTOMATIC_TUNING=TRUE\uc758 \uc0ac\uc6a9\uc73c\ub85c Large Pool\uc774 \uc0dd\uc131\ub418\uc5b4 \uc788\ub2e4\uba74 Shared Pool \ub300\uc2e0 Large Pool\uc5d0\uc11c \ud560\ub2f9\ubc1b\uac8c \ub429\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

– \uc704\uc640 \uac19\uc774 Slave I\/O process\ub97c \uc0ac\uc6a9\ud558\uc5ec SGA\uc5d0\uc11c \ud560\ub2f9\ubc1b\uac8c \ub418\uae30\ub97c \uc6d0\ud560 \uacbd\uc6b0, \ucc44\ub110\uc758 \uac1c\uc218\uc640 \uac01 \uba54\ubaa8\ub9ac \ubc84\ud37c\uc758 \ucd1d \ud06c\uae30\uc5d0 1MB\uc758 \uc624\ubc84\ud5e4\ub4dc \uc601\uc5ed\uc744 \ud3ec\ud568\ud55c \uba54\ubaa8\ub9ac\ub97c \ubbf8\ub9ac \ud560\ub2f9\ud558\uae30\ub97c \uad8c\uc7a5\ud569\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

– \ud14c\uc774\ud504\ub85c \ubc31\uc5c5\ud560 \uc2dc \uc0ac\uc6a9\ub418\uc5b4\uc9c0\ub294 Media Management Server \uac00 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \ub3d9\uc77c \uba38\uc2e0\uc5d0 \uc124\uce58\ub418\uc5b4 \uc788\ub2e4\uba74, \ubc31\uc5c5\uc2dc \ubc1c\uc0dd\ud560 \ucd94\uac00\uc801\uc778 \uc2dc\uc2a4\ud15c \uc790\uc6d0 \uc18c\ubaa8\uc5d0 \ub300\ud574 \ub300\ube44\ud558\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

\n <\/p>\n

RECOVERY CATALOG
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

Recovery Catalog\ub294 RMAN\uc758 \ubc31\uc5c5 \uc791\uc5c5\uc5d0 \ub300\ud55c \uba54\ud0c0\ub370\uc774\ud130\uc758 \uc800\uc7a5\uc18c\uc785\ub2c8\ub2e4. \uc27d\uac8c \ub9d0\ud574 \ucee8\ud2b8\ub864\ud30c\uc77c\uc5d0\uc11c RMAN\uc758 \ubc31\uc5c5\uacfc \ubcf5\uad6c\uc5d0 \uad00\ub828\ub41c \uc815\ubcf4\ub4e4\ub9cc\uc744 \ub530\ub85c \ubaa8\uc544 \uc0dd\uc131\uc2dc\ud0a8 \ud30c\uc77c\uacfc\ub3c4 \uac19\uc2b5\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \uc774 Recovery Catalog\ub294 \ub300\uc0c1 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 ‘resync’ \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud574\ub2f9 \uc815\ubcf4\ub97c \ub3d9\uae30\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uc774\uc810 \ub54c\ubb38\uc5d0 Recovery Catalog\ub294 \ubcf5\uc218\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub300\ud55c \ubc31\uc5c5 \ubc0f \ubcf5\uad6c \uc791\uc5c5\uc744 \uc911\uc559 \uad00\ub9ac\ud558\ub294\ub370 \ud3b8\ub9ac\ud55c \uc774\uc810\uc744 \uac00\uc9d1\ub2c8\ub2e4. \uc774\uc640 \uac19\uc740 Recovery Catalog\uc758 \uc815\ubcf4 \ubcf4\ud638\ub97c \uc704\ud574 \uc9c1\uc811\uc801\uc73c\ub85c \uc561\uc138\uc2a4\ud558\ub294 \uac83\uc740 \uad8c\uc7a5\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ub300\uc2e0 RC_* \uc758 \ubdf0\ub97c \ucc38\uc870\ud558\uc5ec \ud574\ub2f9 Recovery Catalog \ub0b4\uc758 \uc815\ubcf4\ub97c \ucc38\uc870\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

Recovery Catalog\uc758 \uc0ac\uc6a9\uc744 \uc704\ud574\uc11c\ub294 \uba3c\uc800 \ub300\uc0c1 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc5f0\uacb0\ud55c \ud6c4, \ub450\ubc88\uc9f8 NET \uc5f0\uacb0\uc744 \ud1b5\ud558\uc5ec Recovery Catalog\uc640\uc758 \uc138\uc158\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4. \uc774 \ub54c Recovery Catalog\uc758 \uc5f0\uacb0\uc740 \uae30\uc874\uc758 RMAN\uc758 \uc5f0\uacb0\uacfc\ub294 \ub2ec\ub9ac as sysdba\uc758 \uad8c\ud55c\uc744 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc5f0\uacb0\ub41c \ud6c4\uc5d0\ub294 \uc218\ub3d9\uc73c\ub85c \ub300\uc0c1 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \ub3d9\uae30\ud654\ub97c \uc2dc\ud0a4\uac70\ub098, \ubc31\uc5c5 \uc791\uc5c5\uc758 \uc2e4\ud589\uc2dc \uc790\ub3d9\uc73c\ub85c \ub3d9\uae30\ud654\uac00 \uc774\ub8e8\uc5b4 \uc9d1\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

\n <\/p>\n

Recovery Catalog\uc758 \uc0ac\uc6a9\uc740 \ud544\uc218\uac00 \uc544\ub2d9\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uba87\uba87 RMAN\ub9cc\uc758 \uac15\ub825\ud55c \uc131\ub2a5\uc744 \uc0ac\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 \ud544\uc218\uc801\uc73c\ub85c \uc801\uc6a9\ub418\uc5b4\uc57c \ud588\uc2b5\ub2c8\ub2e4. 8i\uc5d0\uc11c\ub294 \uc774\uc640 \uac19\uc740 \uacbd\uc6b0\uac00 \ub2e4\uc218 \uc874\uc7ac\ud558\uc600\uc2b5\ub2c8\ub2e4\ub9cc, 9i\uc5d0\uc11c\ub294 \uc624\uc9c1 \ud558\ub098, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 incarnation \ub808\ubca8\uc758 \ubcf5\uad6c\ub97c \uc704\ud574\uc11c\ub9cc \ud544\uc218\uc785\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

\n <\/p>\n

\n <\/p>\n

\n <\/p>\n

AUXILIARY DATABASE
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

Auxiliary Database\ub780 Tablespace Point In Time Recovery \ub098, \ubcf5\uc81c, \ud639\uc740 Standby Database\uc758 \uc0dd\uc131 \ub4f1\uc758 \uc791\uc5c5\uc5d0 \uc0ac\uc6a9\ub418\uc5b4\uc9c0\ub294, \ub300\uc0c1 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc561\uc138\uc2a4\ud558\uc5ec \ud30c\uc77c\uc744 \ubcf5\uad6c\ud558\ub294 \uc5ed\ud560\uc744 \ud558\ub294 \uc778\uc2a4\ud134\uc2a4\uc6a9 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uac00\ub9ac\ud0b5\ub2c8\ub2e4. \uc704\uc640 \uac19\uc740 \uc791\uc5c5\uc744 \ud558\ub294 \uacbd\uc6b0 \ub300\uc0c1 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 Auxiliary \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub450\uad70\ub370\uc5d0 \uc5f0\uacb0\uc744 \ud558\uac8c \ub429\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uacbd\uc6b0 \ub450 \uac1c \uac1c\ubcc4\uc801\uc778 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ub300\uc0c1\uc73c\ub85c as sysdba \uc5f0\uacb0\uc744 \uc0dd\uc131\ud558\ub294 \uac83\uc774\uae30\uc5d0 \uc2e4\uc81c\ub85c\ub294 \ub458\ub2e4 \uac19\uc740 \uba38\uc2e0\uc5d0\uc11c \uc6b4\uc6a9\ub418\uace0 RMAN \ub610\ud55c \ub3d9\uc77c\ud55c \uba38\uc2e0\uc5d0\uc11c \uc6b4\uc6a9\ub41c\ub2e4\uc190 \uce58\ub354\ub77c\ub3c4 \ub450 \ucee4\ub125\uc158\uc744 \ubaa8\ub450 Local\ub85c \ucc98\ub9ac\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \ucd5c\uc18c \ud558\ub098\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub300\ud574 \ud328\uc2a4\uc6cc\ub4dc \ud30c\uc77c\uc744 \uc0dd\uc131\ud558\uace0 tnsnames.ora \ud30c\uc77c\uc5d0 \uc801\uc808\ud55c NET connection\uc774 \uc124\uc815\ub418\uc5b4\uc57c\ub9cc \ud569\ub2c8\ub2e4. \uc624\ub77c\ud074 8i\uae4c\uc9c0\ub294 Auxiliary Database\uc758 \uc0ac\uc6a9\uc744 \uc704\ud574\uc11c\ub294 Recovery Catalog\uc758 \uc0ac\uc6a9\uc774 \ud544\uc218\uc600\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

\n <\/p>\n

\ud638\ud658\uc131
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

\uc774\uc81c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 RMAN, \uadf8\ub9ac\uace0 Auxiliary Database \ub4f1 \ub300\ud45c\uc801\uc778 \ub3c5\ub9bd\ub41c \uac1d\uccb4\ub4e4\uac04\uc758 \ud638\ud658\uc131\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

– \ub300\uc0c1 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 RMAN \uc2e4\ud589\ud30c\uc77c\uc740 \uc11c\ub85c \ub3d9\uc77c\ud55c \ubc84\uc804\uc774\uc5b4\uc57c \ud569\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

– Recovery Catalog\uc758 \uc0ac\uc6a9 \uc2dc, Recovery Catalog\uc758 \ubc84\uc804\ubcf4\ub2e4 \ub0ae\uc740 \ubc84\uc804\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \ud3ec\ud568\ub420 \uc218\ub294 \uc788\uc9c0\ub9cc, Recovery Catalog \ubcf4\ub2e4 \ub192\uc740 \ubc84\uc804\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ub300\uc0c1\uc73c\ub85c \ud560 \uc218\ub294 \uc5c6\uc2b5\ub2c8\ub2e4. 9.2\ubc84\uc804\uc758 Recovery Catalog\uc778 \uacbd\uc6b0, 8.0.4 \ubc84\uc804\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uae4c\uc9c0 \ub300\uc0c1\uc73c\ub85c \ud3ec\ud568\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n<\/span><\/p>\n

\n <\/p>\n

– Auxiliary Database\uc758 \uc0ac\uc6a9 \uc2dc, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ubcf5\uc81c\ub97c \uc704\ud574\uc11c\ub294 \uc11c\ub85c \ub3d9\uc77c\ud55c \ubc84\uc804\uc774\uc5b4\uc57c \ud569\ub2c8\ub2e4.
\n<\/span><\/p>\n


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

RMAN\uc740 \ub3c5\ub9bd\ud615 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc73c\ub85c \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \ud074\ub77c\uc774\uc5b8\ud2b8 \uc5f0\uacb0 \ubc29\uc2dd\uc744 \ud1b5\ud574 \uc811\uc18d\ub429\ub2c8\ub2e4. \uc2e4\uc81c RMAN\uc740 Command Interpreter\uc5d0 \ubd88\uacfc\ud558\uc5ec \uc720\uc800\uc758 \uba85\ub839\uc744 \ud574\ub3c5\ud55c \ud6c4, RPC\ub97c \ud1b5\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uac8c \ub118\uaca8\uc90d\ub2c8\ub2e4. \uc2e4\uc81c\uc801\uc778 \uc791\uc5c5\uc758 \ucc98\ub9ac\ub294 \ub300\uc0c1 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uc218\ud589\ud558\uac8c \ub429\ub2c8\ub2e4. RMAN\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub300\uc0c1 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uc18d\ud560 \uc2dc\uc5d0\ub294 \ud574\ub2f9 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 SYS \uad8c\ud55c\uc73c\ub85c \uc811\uc18d\ud574\uc57c \ud569\ub2c8\ub2e4. \uc774\ub54c RMAN \uc740 as sysdba \ub97c \uc790\ub3d9\uc801\uc73c\ub85c \uc0ac\uc6a9\ud558\uac8c \ub429\ub2c8\ub2e4.   Enterprise Edition\uc774 \uc544\ub2c8\uba74 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[9],"tags":[291,77],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1296"}],"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=1296"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1296\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1296"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1296"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1296"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}