ASM \ud658\uacbd\uc5d0\uc11c Hot Backup & Single DB \uad6c\ucd95<\/P>
\n
\ud754\ud788 ASM \ud658\uacbd\uc5d0\uc11c RMAN \uc744 \uc774\uc6a9\ud558\uc5ec \ubc31\uc5c5\uc744 \ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. <\/P>
\n
RMAN \uc744 \uc774\uc6a9\ud55c Backup\uc774 \uc544\ub2cc Hot Backup\uc744 \uc774\uc6a9\ud558\uc5ec \ubc31\uc5c5 \ud6c4 Single DB\ub85c \ubcf5\uad6c \ud558\ub294 \ud14c\uc2a4\ud2b8\ub97c \ud574\ubd24\uc2b5\ub2c8\ub2e4.<\/P>
\n
— \ud544\uc694\ud55c VM
ASM \uc744 \uc0ac\uc6a9\ud558\ub294 \ud658\uacbd (Single ASM, RAC(ASM)) , Single DB \uad6c\ucd95\ud560 VM (softonly\ub85c \uc124\uce58)
RAC \ud658\uacbd\uc778 \uacbd\uc6b0 \uc591\ucabd Node \uc758 Archive Log \ub97c \uac00\uc838\uc640\uc57c \ud569\ub2c8\ub2e4.<\/P>
\n
– \ubc31\uc5c5 \ubc1b\uc744 File \ud655\uc778.
SQL) select file_name from dba_data_files;<\/P>
\n
FILE_NAME
————————————————-
+DATA\/orcl\/datafile\/users.259.824961691
+DATA\/orcl\/datafile\/undotbs1.258.824961691
+DATA\/orcl\/datafile\/sysaux.257.824961689
+DATA\/orcl\/datafile\/system.256.824961687
+DATA\/orcl\/datafile\/sysaux.278.894653489
+DATA2\/orcl\/datafile\/sysaux02.dbf
+DATA\/orcl\/datafile\/sysaux.272.894653613
+DATA\/orcl\/datafile\/sysaux
+DATA\/orcl\/datafile\/mvtest0101.dbf
+DATA\/orcl\/datafile\/mvtest0202.dbf
+DATA2\/orcl\/datafile\/system.268.875036169<\/P>
\n
– Begin Backup \uc218\ud589
$) sqlplus “\/as sysdba”
SQL) alter database begin backup;<\/P>
\n
– SID \ubcc0\uacbd
$) . oraenv
ORACLE_SID = [ORCL1] ? +ASM1
The Oracle base remains unchanged with value \/u01\/app\/oracle<\/P>
\n
– File Copy \uc218\ud589
$asmcmd
ASMCMD> cp +DATA\/orcl\/datafile\/users.259.824961691 \/home\/oracle\/npa\/users01.dbf
ASMCMD> cp +DATA\/orcl\/datafile\/undotbs1.258.824961691 \/home\/oracle\/npa\/undotbs01.dbf
ASMCMD> cp +DATA\/orcl\/datafile\/sysaux.257.824961689 \/home\/oracle\/npa\/sysaux01.dbf
ASMCMD> cp +DATA\/orcl\/datafile\/system.256.824961687 \/home\/oracle\/npa\/system01.dbf
ASMCMD> cp +DATA\/orcl\/datafile\/sysaux.278.894653489 \/home\/oracle\/npa\/sysaux02.dbf
ASMCMD> cp +DATA2\/orcl\/datafile\/sysaux02.dbf \/home\/oracle\/npa\/sysaux05.dbf
ASMCMD> cp +DATA\/orcl\/datafile\/sysaux.272.894653613 \/home\/oracle\/npa\/sysaux03.dbf
ASMCMD> cp +DATA\/orcl\/datafile\/sysaux \/home\/oracle\/npa\/sysaux04.dbf
ASMCMD> cp +DATA\/orcl\/datafile\/mvtest0101.dbf \/home\/oracle\/npa\/mvtest01.dbf
ASMCMD> cp +DATA\/orcl\/datafile\/mvtest0202.dbf \/home\/oracle\/npa\/mvtest02.dbf
ASMCMD> cp +DATA2\/orcl\/datafile\/system.268.875036169 \/home\/oracle\/npa\/system02.dbf<\/P>
\n
– End Backup \uc218\ud589
$) . oraenv
ORACLE_SID = [+ASM1] ? ORCL1
The Oracle base remains unchanged with value \/u01\/app\/oracle<\/P>
\n
$) sqlplus “\/as sysdba”
SQL) alter database end backup;<\/P>
\n
– Control file Trace \ub85c \ub0b4\ub824 \ubc1b\uae30
SQL) alter backup controlfile to trace ‘\/home\/oracle\/control.trc’;<\/P>
\n
– Pfile \ubc1b\uae30
SQL) create pfile=’\/home\/oracle\/pfile.txt’ from spfile;<\/P>
\n
# Single DB \uad6c\ucd95\ud560 VM\uc5d0 Backup \ubc1b\uc740 Datafile\uacfc Controlfile Trace File, Pfile,Archive Log \ub97c FTP \ubcf5\uc0ac \ud6c4 \uc9c4\ud589<\/P>
\n
– Pfile \uc218\uc815
% audit_file_dest \ud3f4\ub354\ub97c \uc0dd\uc131\ud574\uc8fc\uc5b4\uc57c \ud55c\ub2e4. controlfile \uc774 \uc774\uc911\ud654 \ud560 \uacbd\uc6b0 \uc774\uc911\ud654 \ub41c \uacbd\ub85c \uae4c\uc9c0 \ud3f4\ub354\ub97c \uc0dd\uc131 \ud574\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/P>
\n
– Control File \uc0dd\uc131
% Pfile\uc744 \ubd88\ub7ec\uc624\uc9c0 \ubabb\ud558\ub294 \uacbd\uc6b0 SQL) startup nomount pfile='<LOCATION>’; \uc218\ud589\uc744 \uba3c\uc800 \ud569\ub2c8\ub2e4.
% ControlFile Trace File\uc744 \ud655\uc778 \ud574\ubcf4\uba74 CREATE CONTROLFILE REUSE DATABASE “TEST” \ub85c \ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.
\uae30\uc874\uc5d0 \uc788\ub358 \uac78 \ub2e4\uc2dc \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \uc544\ub2cc \uc2e0\uaddc DB\ub85c \uad6c\ucd95\ud558\ub294 \uac83 \uc774\uae30 \ub54c\ubb38\uc5d0 REUSE -> SET\uc73c\ub85c \ubcc0\uacbd\ud574\uc8fc\uc2dc\uba74 \ub429\ub2c8\ub2e4.<\/P>
\n
STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE “TEST” RESETLOGS ARCHIVELOG
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
MAXINSTANCES 32
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ‘\/u01\/app\/oracle\/oradata\/test\/redo01.log’ SIZE 50M BLOCKSIZE 512,
GROUP 2 ‘\/u01\/app\/oracle\/oradata\/test\/redo02.log’ SIZE 50M BLOCKSIZE 512,
GROUP 3 ‘\/u01\/app\/oracle\/oradata\/test\/redo03.log’ SIZE 100M BLOCKSIZE 512,
GROUP 4 ‘\/u01\/app\/oracle\/oradata\/test\/redo04.log’ SIZE 10M BLOCKSIZE 512,
GROUP 5 ‘\/u01\/app\/oracle\/oradata\/test\/redo05.log’ SIZE 10M BLOCKSIZE 512
— STANDBY LOGFILE
DATAFILE
‘\/u01\/app\/oracle\/oradata\/test\/system01.dbf’,
‘\/u01\/app\/oracle\/oradata\/test\/sysaux05.dbf’,
‘\/u01\/app\/oracle\/oradata\/test\/users01.dbf’,
‘\/u01\/app\/oracle\/oradata\/test\/undotbs01.dbf’,
‘\/u01\/app\/oracle\/oradata\/test\/system02.dbf’,
‘\/u01\/app\/oracle\/oradata\/test\/sysaux01.dbf’,
‘\/u01\/app\/oracle\/oradata\/test\/sysaux02.dbf’,
‘\/u01\/app\/oracle\/oradata\/test\/sysaux03.dbf’,
‘\/u01\/app\/oracle\/oradata\/test\/sysaux04.dbf’,
‘\/u01\/app\/oracle\/oradata\/test\/mvtest01.dbf’,
‘\/u01\/app\/oracle\/oradata\/test\/mvtest02.dbf’
CHARACTER SET AL32UTF8
;<\/P>
\n
– Recover(Archive Log \uc801\uc6a9)
% Archive Log Dest \ub97c \uc801\uc6a9 \uc2dc\ud0a8 \ud6c4 \ud574\ub2f9 \uc704\uce58\uc5d0 Archive Log \ub97c Move \ud574\ub193\uc73c\uba74 Recover \uc2dc \ub530\ub85c \uacbd\ub85c\ub97c \uc9c0\uc815 \uc548\ud574\uc918\ub3c4 \ub429\ub2c8\ub2e4.<\/P>
\n
SQL) alter system set log_archive_dest_1=’LOCATION=\/u01\/app\/oracle\/arch’ scope=both;
SQL) recover database using backup controlfile
ORA-00279: change 55307193 generated at 11\/20\/2015 00:52:18 needed for thread 1
ORA-00289: suggestion : \/u01\/app\/oracle\/oradata\/orcl\/1_3_896153147.dbf
ORA-00280: change 55307193 for thread 1 is in sequence #3<\/P>
\n
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO (% \uc790\ub3d9\uc73c\ub85c Archive Log \uc801\uc6a9)<\/P>
\n
% \uc911\uac04\uc5d0 Archive Log\uac00 \ube44\uc5b4\uc788\uc73c\uba74 Error \ubc1c\uc0dd\ud569\ub2c8\ub2e4. Archive Log\ub97c \ub2e4 \uc801\uc6a9 \uc2dc\ucf30\ub294\ub370\ub3c4 Archive Log \ub97c \ucc3e\uc744\ud150\ub370
\uae30\uc874 Redo \uc5d0 \uc788\ub294 \ub0b4\uc6a9\uc744 \ucc3e\ub294 \uac83\uc785\ub2c8\ub2e4. \ud574\uc11c \uae30\uc874 Redo \uac00 \uc788\uc73c\uba74 Redo Log\ub97c \uc801\uc6a9\uc2dc\ucf1c\uc8fc\uba74 \ub418\uace0, \uc5c6\ub2e4\uba74 \uc544\ub798\uc758 \uba85\ub839\uc5b4\ub85c CANCEL \uc2dc\ucf1c\uc90d\ub2c8\ub2e4.<\/P>
\n
SQL) recover database until cancel using backup controlfile
ORA-00279: change 55307193 generated at 11\/20\/2015 00:52:18 needed for thread 1
ORA-00289: suggestion : \/u01\/app\/oracle\/oradata\/npa112db\/1_3_896153147.dbf
ORA-00280: change 55307193 for thread 1 is in sequence #3<\/P>
\n
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
CANCEL
Media recovery cancelled.<\/P>
\n
% \uc704\uc640 \uac19\uc740 \ubb38\uad6c\uac00 \ub098\uc654\ub2e4\uba74 \uc544\ub798\uc758 \uba85\ub839\uc5b4\ub85c DB\ub97c OPEN \ud574\uc8fc\uc2dc\uba74 \ub429\ub2c8\ub2e4.
SQL> alter database open resetlogs;
Database altered.<\/P>
\n
– \uc0c1\ud0dc \ud655\uc778.<\/P>
\n
SQL> SELECT INSTANCE_NAME,VERSION,STATUS FROM V$INSTANCE;<\/P>
\n
INSTANCE_NAME VERSION STATUS
—————– ———- ————
orcl 11.2.0.2.0 OPEN
<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"
ASM \ud658\uacbd\uc5d0\uc11c Hot Backup & Single DB \uad6c\ucd95 \ud754\ud788 ASM \ud658\uacbd\uc5d0\uc11c RMAN \uc744 \uc774\uc6a9\ud558\uc5ec \ubc31\uc5c5\uc744 \ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. RMAN \uc744 \uc774\uc6a9\ud55c Backup\uc774 \uc544\ub2cc Hot Backup\uc744 \uc774\uc6a9\ud558\uc5ec \ubc31\uc5c5 \ud6c4 Single DB\ub85c \ubcf5\uad6c \ud558\ub294 \ud14c\uc2a4\ud2b8\ub97c \ud574\ubd24\uc2b5\ub2c8\ub2e4. — \ud544\uc694\ud55c VMASM \uc744 \uc0ac\uc6a9\ud558\ub294 \ud658\uacbd (Single ASM, RAC(ASM)) , Single DB \uad6c\ucd95\ud560 VM (softonly\ub85c \uc124\uce58)RAC \ud658\uacbd\uc778 \uacbd\uc6b0 \uc591\ucabd Node \uc758 Archive […]<\/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":[2],"tags":[72,318,319,240,267],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/654"}],"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=654"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/654\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=654"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=654"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=654"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}