<![CDATA[
<p><b><span style="color: #000000;">1.2개의 파일 rm 후 rman에서 crosscheck archivelog all;</span></b></p><div class="table-wrap"><table data-ke-type="table" data-ke-align="alignLeft" style="width: 100%;" border="1"><tbody><tr><td style="width: 100%;"><span style="color: #000000;">RMAN>  crosscheck archivelog all;</span><br><br><br><span style="color: #000000;">using target database control file instead of recovery catalog</span><br><span style="color: #000000;">allocated channel: ORA_DISK_1</span><br><span style="color: #000000;">channel ORA_DISK_1: SID=273 device type=DISK</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_5_1212487829.dbf RECID=1 STAMP=1212494501</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_6_1212487829.dbf RECID=2 STAMP=1212502827</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_7_1212487829.dbf RECID=3 STAMP=1212759277</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_8_1212487829.dbf RECID=4 STAMP=1212759278</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_1_1212759291.dbf RECID=5 STAMP=1212759303</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_2_1212759291.dbf RECID=6 STAMP=1212759313</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_3_1212759291.dbf RECID=7 STAMP=1212767655</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_4_1212759291.dbf RECID=8 STAMP=1212767659</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_5_1212759291.dbf RECID=9 STAMP=1212768334</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_6_1212759291.dbf RECID=10 STAMP=1212768454</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_7_1212759291.dbf RECID=11 STAMP=1212768455</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_8_1212759291.dbf RECID=12 STAMP=1212768457</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="background-color: #f89009;"><b><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_9_1212759291.dbf RECID=13 STAMP=1212769043</span></b></span><br><span style="background-color: #f89009;"><b><span style="color: #000000;">validation failed for archived log</span></b></span><br><span style="background-color: #f89009;"><b><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_10_1212759291.dbf RECID=14 STAMP=1212769053</span></b></span><br><span style="background-color: #f89009;"><b><span style="color: #000000;">validation failed for archived log</span></b></span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_11_1212759291.dbf RECID=15 STAMP=1212769071</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_12_1212759291.dbf RECID=16 STAMP=1212769250</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_13_1212759291.dbf RECID=17 STAMP=1212769373</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_14_1212759291.dbf RECID=18 STAMP=1212769387</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_15_1212759291.dbf RECID=19 STAMP=1212769399</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_16_1212759291.dbf RECID=20 STAMP=1212769926</span><br><span style="color: #000000;">Crosschecked 20 objects</span></td></tr></tbody></table></div><p><b>2. 복구</b></p><div class="table-wrap"><table data-ke-type="table" data-ke-align="alignLeft" style="width: 100%;" border="1"><tbody><tr><td style="width: 100%;">rman > <span style="color: #000000; background-color: #ffffff;" data-ke-size="size16">restore archivelog from suquence 9</span><span style="color: #000000; background-color: #ffffff;" data-ke-size="size16">;</span> <br>rman > <span style="color: #000000; background-color: #ffffff;" data-ke-size="size16">restore archivelog from suquence 10</span><span style="color: #000000; background-color: #ffffff;" data-ke-size="size16">;</span></td></tr></tbody></table></div><p><b>3. 확인</b></p><div class="table-wrap"><table data-ke-type="table" data-ke-align="alignLeft" style="width: 100%; height: 18px;" border="1"><tbody><tr style="height: 18px;"><td style="width: 100%; height: 18px;">rman > <span style="color: #000000; background-color: #ffffff;" data-ke-size="size16">crosscheck archivelog all</span><span style="color: #000000; background-color: #ffffff;" data-ke-size="size16">;</span> <br><br><span style="color: #000000;">released channel: ORA_DISK_1</span><br><span style="color: #000000;">allocated channel: ORA_DISK_1</span><br><span style="color: #000000;">channel ORA_DISK_1: SID=273 device type=DISK</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_5_1212487829.dbf RECID=1 STAMP=1212494501</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_6_1212487829.dbf RECID=2 STAMP=1212502827</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_7_1212487829.dbf RECID=3 STAMP=1212759277</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_8_1212487829.dbf RECID=4 STAMP=1212759278</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_1_1212759291.dbf RECID=5 STAMP=1212759303</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_2_1212759291.dbf RECID=6 STAMP=1212759313</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_3_1212759291.dbf RECID=7 STAMP=1212767655</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_4_1212759291.dbf RECID=8 STAMP=1212767659</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_5_1212759291.dbf RECID=9 STAMP=1212768334</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_6_1212759291.dbf RECID=10 STAMP=1212768454</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_7_1212759291.dbf RECID=11 STAMP=1212768455</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_8_1212759291.dbf RECID=12 STAMP=1212768457</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_9_1212759291.dbf RECID=13 STAMP=1212769043</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_10_1212759291.dbf RECID=22 STAMP=1212770272</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_11_1212759291.dbf RECID=21 STAMP=1212770272</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_12_1212759291.dbf RECID=16 STAMP=1212769250</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_13_1212759291.dbf RECID=17 STAMP=1212769373</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_14_1212759291.dbf RECID=18 STAMP=1212769387</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_15_1212759291.dbf RECID=19 STAMP=1212769399</span><br><span style="color: #000000;">validation succeeded for archived log</span><br><span style="color: #000000;">archived log file name=/u01/app/oracle/product/19c/db_1/dbs/arch1_16_1212759291.dbf RECID=20 STAMP=1212769926</span><br><span style="color: #000000;">Crosschecked 20 objects</span><br><br></td></tr></tbody></table></div><div class="figure-img" data-ke-type="image" data-ke-style="alignCenter" data-ke-mobilestyle="widthOrigin"><img src="https://t1.daumcdn.net/cafeattach/zchT/246cadefc0597d11ab964b310f05c3776fba2f60" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/246cadefc0597d11ab964b310f05c3776fba2f60" data-origin-width="799" data-origin-height="744"></div><p> </p><p> </p>
<!-- -->
]]>
카페 게시글
7.오라클 백업과 복구
Re: 오늘의 마지막 문제. (백업과 복구 이수자 평가 2번 제출물)
다음검색
