Re: 오늘의 마지막 문제. 다음의 3가지 파일들을 삭제하고 복구하시오

<p>1. 파일 삭제</p><div class="figure-img" data-ke-type="image" data-ke-style="alignLeft" data-ke-mobilestyle="widthOrigin"><img src="https://t1.daumcdn.net/cafeattach/zchT/418c4598689d29964ded6ebb4ead376b1776a155" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/418c4598689d29964ded6ebb4ead376b1776a155" data-origin-width="454" data-origin-height="66"></div><p>2. 오류 발생</p><div class="figure-img" data-ke-type="image" data-ke-style="alignLeft" data-ke-mobilestyle="widthOrigin"><img src="https://t1.daumcdn.net/cafeattach/zchT/564ae78d4cdfbff7f0c1bfd917eb90a857eaf166" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/564ae78d4cdfbff7f0c1bfd917eb90a857eaf166" data-origin-width="741" data-origin-height="287"></div><p>3. nomount 상태에서 cluster_database parameter false로 변경</p><div class="figure-img" data-ke-type="image" data-ke-style="alignLeft" data-ke-mobilestyle="widthOrigin"><img src="https://t1.daumcdn.net/cafeattach/zchT/47272ad2eca4f0108d571f287889a124e3ac1a85" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/47272ad2eca4f0108d571f287889a124e3ac1a85" data-origin-width="655" data-origin-height="333"></div><p>4. shutdown  후 다시 nomount로 올려 controlfile 복구</p><div class="figure-img" data-ke-type="image" data-ke-style="alignLeft" data-ke-mobilestyle="widthOrigin"><img src="https://t1.daumcdn.net/cafeattach/zchT/7551137c97806449e743dcc4624af10a1dcef3b3" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/7551137c97806449e743dcc4624af10a1dcef3b3" data-origin-width="525" data-origin-height="145"></div><p>5. mount 상태에서 database restore, recover</p><p> </p><p>6. alter database open resetlogs</p><p> </p><p>7. 복구완료</p><div class="figure-img" data-ke-type="image" data-ke-style="alignLeft" data-ke-mobilestyle="widthOrigin"><img src="https://t1.daumcdn.net/cafeattach/zchT/b3d90b3b2b1ef22008e366cc6ccccf984a2eda69" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/b3d90b3b2b1ef22008e366cc6ccccf984a2eda69" data-origin-width="330" data-origin-height="58"></div><div class="figure-img" data-ke-type="image" data-ke-style="alignLeft" data-ke-mobilestyle="widthOrigin"><img src="https://t1.daumcdn.net/cafeattach/zchT/80baa5fa1215b4b076f962be3a69afc8981364b6" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/80baa5fa1215b4b076f962be3a69afc8981364b6" data-origin-width="500" data-origin-height="239"></div><div class="figure-img" data-ke-type="image" data-ke-style="alignLeft" data-ke-mobilestyle="widthOrigin"><img src="https://t1.daumcdn.net/cafeattach/zchT/be3d6cc7762884483bd1538ca044bbbb91080d20" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/be3d6cc7762884483bd1538ca044bbbb91080d20" data-origin-width="464" data-origin-height="97"></div><p>8. cluster database parameter 다시 true로 바꾸고 노드 2개 다 올라오는지 확인</p><div class="figure-img" data-ke-type="image" data-ke-style="alignLeft" data-ke-mobilestyle="widthOrigin"><img src="https://t1.daumcdn.net/cafeattach/zchT/a5a3c5d246541abc4988fa3001bfef7c2f98fa27" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/a5a3c5d246541abc4988fa3001bfef7c2f98fa27" data-origin-width="601" data-origin-height="294"></div><p> </p><p> </p><p> </p><p><span data-ke-size="size18"><b> <span>면접질문 답변:</span> DML, DDL, DCL, TCL 각 유형에 속하는 SQL 명령어를 답으로 써주세요.</b> </span></p><p><b>1. DML(데이터 조작어) : SELECT, INSERT, UPDATE, DELETE</b></p><p><b>2. DDL(데이터 정의어) : CREATE, ALTER, DROP, TRUNCATE, RENAME</b></p><p><b>3. DCL(데이터 제어어) : GRANT <-> REVOKE</b></p><p><b>4. TCL(트랜젝션 제어어) : COMMIT, ROLLBACK, SAVEPOINT</b></p><p> </p><p> </p><p> </p><p> </p>