<![CDATA[
<div class="figure-img" data-ke-type="image" data-ke-style="alignLeft" data-ke-mobilestyle="widthOrigin"><img src="https://t1.daumcdn.net/cafeattach/zchT/8d73ba02e220069954c86d40f761c840d261811b" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/8d73ba02e220069954c86d40f761c840d261811b" data-origin-width="488" data-origin-height="89"></div><p><b>1. 삭제 전 상태확인</b></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/e4d39bd393575402b19deda978daec46eca51fac" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/e4d39bd393575402b19deda978daec46eca51fac" data-origin-width="952" data-origin-height="988"></div><p><b>2. 모든 .dbf, .ctl, .log 파일 삭제 후 복원 작업</b></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/8c438f46c956fd31963ec3cee38342c7c66f3a51" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/8c438f46c956fd31963ec3cee38342c7c66f3a51" data-origin-width="951" data-origin-height="1028"></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/b64ba7f449eec77af8e715de5c6dd7750466bbc7" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/b64ba7f449eec77af8e715de5c6dd7750466bbc7" data-origin-width="951" data-origin-height="354"></div><p><b>3. 복원 완료 후 상태 확인</b></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/59528f22112080320940dc20bda20dde5991b567" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/59528f22112080320940dc20bda20dde5991b567" data-origin-width="953" data-origin-height="1029"></div><p>코드 : </p><p>[oracle@ora19c ~]$ sys <br><br>SQL*Plus: Release 19.0.0.0.0 - Production on Sun Mar 29 16:45:48 2026 <br>Version 19.3.0.0.0 <br><br>Copyright (c) 1982, 2019, Oracle.  All rights reserved. <br><br><br>Connected to: <br>Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production <br>Version 19.3.0.0.0 <br><br>oracle19c> alter system switch logfile; <br><br>System altered. <br><br>oracle19c> / <br><br>System altered. <br><br>oracle19c> / <br><br>System altered. <br><br>oracle19c> / <br>/ <br><br>System altered. <br><br>oracle19c> alter <br>System altered. <br><br>oracle19 <br>SP2-0042: unknown command "alt" - rest of line ignored. <br>oracle19c> alter system checkpoint; <br><br>System altered. <br><br>oracle19c> @log <br><br>    GROUP# STATUS           ARC  SEQUENCE#    MEMBERS BYTES/1024/1024 <br>---------- ---------------- --- ---------- ---------- --------------- <br>         1 INACTIVE         YES          5          2             200 <br>         2 CURRENT          NO           6          2             200 <br>         3 INACTIVE         YES          3          2             200 <br>         4 INACTIVE         YES          4          2             200 <br><br>oracle19c> select file_name from dba_data_files; <br><br>FILE_NAME <br>-------------------------------------------------------------------------------- <br>/u01/app/oracle/oradata/ORCL/system01.dbf <br>/u01/app/oracle/oradata/ORCL/sysaux01.dbf <br>/u01/app/oracle/oradata/ORCL/undotbs01.dbf <br>/u01/app/oracle/oradata/ORCL/users01.dbf <br>/u01/app/oracle/oradata/ORCL/ts01.dbf <br>/u01/app/oracle/oradata/ORCL/indx01.dbf <br>/u01/app/oracle/oradata/ORCL/ts07b.dbf <br>/u01/app/oracle/oradata/ORCL/ts100.dbf <br>/u01/app/oracle/oradata/ORCL/ts300.dbf <br>/u01/app/oracle/oradata/ORCL/ts400.dbf <br><br>10 rows selected. <br><br>oracle19c> select name from v$controlfile; <br><br>NAME <br>-------------------------------------------------------------------------------- <br>/u01/app/oracle/oradata/ORCL/control01.ctl <br>/u01/app/oracle/oradata/ORCL/control02.ctl <br>/u01/app/oracle/oradata/ORCL/control03.ctl <br><br>oracle19c> select member from v$logfile; <br><br>MEMBER <br>-------------------------------------------------------------------------------- <br>/u01/app/oracle/oradata/ORCL/redo03.log <br>/u01/app/oracle/oradata/ORCL/redo03b.log <br>/u01/app/oracle/oradata/ORCL/redo04.log <br>/u01/app/oracle/oradata/ORCL/redo04b.log <br>/u01/app/oracle/oradata/ORCL/redo02.log <br>/u01/app/oracle/oradata/ORCL/redo02b.log <br>/u01/app/oracle/oradata/ORCL/redo01.log <br>/u01/app/oracle/oradata/ORCL/redo01b.log <br><br>8 rows selected. <br><br>oracle19c> shutdown abort <br>ORACLE instance shut down. <br>oracle19c> exit; <br>Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production <br>Version 19.3.0.0.0 <br>[oracle@ora19c ~]$ cd /u01/app/oracle/oradata/ORCL/ <br>[oracle@ora19c ORCL]$ <br>[oracle@ora19c ORCL]$ rm -rf *.dbf <br>[oracle@ora19c ORCL]$ rm -rf *.ctl <br>[oracle@ora19c ORCL]$ rm -rf *.log <br>[oracle@ora19c ORCL]$ ls <br>need_recover.sql <br>[oracle@ora19c ORCL]$ cd <br>[oracle@ora19c ~]$ sys <br><br>SQL*Plus: Release 19.0.0.0.0 - Production on Sun Mar 29 16:49:58 2026 <br>Version 19.3.0.0.0 <br><br>Copyright (c) 1982, 2019, Oracle.  All rights reserved. <br><br>Connected to an idle instance. <br><br>oracle19c> startup <br>ORACLE instance started. <br><br>Total System Global Area 2415917880 bytes <br>Fixed Size                  8899384 bytes <br>Variable Size             520093696 bytes <br>Database Buffers         1879048192 bytes <br>Redo Buffers                7876608 bytes <br>ORA-00205: error in identifying control file, check alert log for more info <br><br><br>oracle19c> exit <br>Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production <br>Version 19.3.0.0.0 <br>[oracle@ora19c ~]$ rman target / nocatalog <br><br>Recovery Manager: Release 19.0.0.0.0 - Production on Sun Mar 29 16:50:35 2026 <br>Version 19.3.0.0.0 <br><br>Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved. <br><br>connected to target database: ORCL (not mounted) <br>using target database control file instead of recovery catalog <br><br>RMAN> restore controlfile from autobackup; <br><br>Starting restore at 2026/03/29:16:51:06 <br>allocated channel: ORA_DISK_1 <br>channel ORA_DISK_1: SID=136 device type=DISK <br><br>recovery area destination: /u01/app/oracle/fast_recovery_area <br>database name (or database unique name) used for search: ORCL <br>channel ORA_DISK_1: AUTOBACKUP /u01/app/oracle/fast_recovery_area/ORCL/autobackup/2026_03_29/o1_mf_s_1229186502_nwkoxq3y_.bkp found in the recovery area <br>AUTOBACKUP search with format "%F" not attempted because DBID was not set <br>channel ORA_DISK_1: restoring control file from AUTOBACKUP /u01/app/oracle/fast_recovery_area/ORCL/autobackup/2026_03_29/o1_mf_s_1229186502_nwkoxq3y_.bkp <br>channel ORA_DISK_1: control file restore from AUTOBACKUP complete <br>output file name=/u01/app/oracle/oradata/ORCL/control01.ctl <br>output file name=/u01/app/oracle/oradata/ORCL/control02.ctl <br>output file name=/u01/app/oracle/oradata/ORCL/control03.ctl <br>Finished restore at 2026/03/29:16:51:11 <br><br>RMAN> alter database mount; <br><br>released channel: ORA_DISK_1 <br>Statement processed <br><br>RMAN> run { set until sequence 6 thread 1; <br>          restore database; <br>          recover database; <br>  }2> 3> 4> <br><br>executing command: SET until clause <br><br>Starting restore at 2026/03/29:16:57:35 <br>Starting implicit crosscheck backup at 2026/03/29:16:57:35 <br>allocated channel: ORA_DISK_1 <br>channel ORA_DISK_1: SID=262 device type=DISK <br>Crosschecked 3 objects <br>Finished implicit crosscheck backup at 2026/03/29:16:57:46 <br><br>Starting implicit crosscheck copy at 2026/03/29:16:57:46 <br>using channel ORA_DISK_1 <br>Finished implicit crosscheck copy at 2026/03/29:16:57:48 <br><br>searching for all files in the recovery area <br>cataloging files... <br>cataloging done <br><br>List of Cataloged Files <br>======================= <br>File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2026_03_29/o1_mf_1_1_nwkp5qqk_.arc <br>File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2026_03_29/o1_mf_1_2_nwkp5ty4_.arc <br>File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2026_03_29/o1_mf_1_3_nwkp5w3r_.arc <br>File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2026_03_29/o1_mf_1_4_nwkp608w_.arc <br>File Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2026_03_29/o1_mf_1_5_nwkp639r_.arc <br>File Name: /u01/app/oracle/fast_recovery_area/ORCL/autobackup/2026_03_29/o1_mf_s_1229186502_nwkoxq3y_.bkp <br><br>using channel ORA_DISK_1 <br><br>channel ORA_DISK_1: starting datafile backup set restore <br>channel ORA_DISK_1: specifying datafile(s) to restore from backup set <br>channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/ORCL/system01.dbf <br>channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/ORCL/indx01.dbf <br>channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/ORCL/sysaux01.dbf <br>channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/ORCL/undotbs01.dbf <br>channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/ORCL/ts01.dbf <br>channel ORA_DISK_1: restoring datafile 00007 to /u01/app/oracle/oradata/ORCL/users01.dbf <br>channel ORA_DISK_1: restoring datafile 00008 to /u01/app/oracle/oradata/ORCL/ts07b.dbf <br>channel ORA_DISK_1: restoring datafile 00009 to /u01/app/oracle/oradata/ORCL/ts100.dbf <br>channel ORA_DISK_1: restoring datafile 00010 to /u01/app/oracle/oradata/ORCL/ts300.dbf <br>channel ORA_DISK_1: restoring datafile 00011 to /u01/app/oracle/oradata/ORCL/ts400.dbf <br>channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/ORCL/backupset/2026_03_29/o1_mf_nnndf_TAG20260329T164117_nwkowxt7_.bkp <br>channel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2026_03_29/o1_mf_nnndf_TAG20260329T164117_nwkowxt7_.bkp tag=TAG20260329T164117 <br>channel ORA_DISK_1: restored backup piece 1 <br>channel ORA_DISK_1: restore complete, elapsed time: 00:00:33 <br>Finished restore at 2026/03/29:16:58:31 <br><br>Starting recover at 2026/03/29:16:58:32 <br>using channel ORA_DISK_1 <br><br>starting media recovery <br><br>archived log for thread 1 with sequence 1 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2026_03_29/o1_mf_1_1_nwkp5qqk_.arc <br>archived log for thread 1 with sequence 2 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2026_03_29/o1_mf_1_2_nwkp5ty4_.arc <br>archived log for thread 1 with sequence 3 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2026_03_29/o1_mf_1_3_nwkp5w3r_.arc <br>archived log for thread 1 with sequence 4 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2026_03_29/o1_mf_1_4_nwkp608w_.arc <br>archived log for thread 1 with sequence 5 is already on disk as file /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2026_03_29/o1_mf_1_5_nwkp639r_.arc <br>archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2026_03_29/o1_mf_1_1_nwkp5qqk_.arc thread=1 sequence=1 <br>archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2026_03_29/o1_mf_1_2_nwkp5ty4_.arc thread=1 sequence=2 <br>archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2026_03_29/o1_mf_1_3_nwkp5w3r_.arc thread=1 sequence=3 <br>archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2026_03_29/o1_mf_1_4_nwkp608w_.arc thread=1 sequence=4 <br>archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2026_03_29/o1_mf_1_5_nwkp639r_.arc thread=1 sequence=5 <br>media recovery complete, elapsed time: 00:00:05 <br>Finished recover at 2026/03/29:16:58:50 <br><br>RMAN> alter database open resetlogs; <br><br>Statement processed <br><br>RMAN> exit; <br><br><br>Recovery Manager complete. <br>[oracle@ora19c ~]$ sys <br><br>SQL*Plus: Release 19.0.0.0.0 - Production on Sun Mar 29 16:59:56 2026 <br>Version 19.3.0.0.0 <br><br>Copyright (c) 1982, 2019, Oracle.  All rights reserved. <br><br><br>Connected to: <br>Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production <br>Version 19.3.0.0.0 <br><br>oracle19c> @log <br><br>    GROUP# STATUS           ARC  SEQUENCE#    MEMBERS BYTES/1024/1024 <br>---------- ---------------- --- ---------- ---------- --------------- <br>         1 CURRENT          NO           1          2             200 <br>         2 UNUSED           YES          0          2             200 <br>         3 UNUSED           YES          0          2             200 <br>         4 UNUSED           YES          0          2             200 <br><br>oracle19c> @logfile <br><br>    GROUP# MEMBER <br>---------- --------------------------------------------- <br>         1 /u01/app/oracle/oradata/ORCL/redo01.log <br>         1 /u01/app/oracle/oradata/ORCL/redo01b.log <br>         2 /u01/app/oracle/oradata/ORCL/redo02.log <br>         2 /u01/app/oracle/oradata/ORCL/redo02b.log <br>         3 /u01/app/oracle/oradata/ORCL/redo03.log <br>         3 /u01/app/oracle/oradata/ORCL/redo03b.log <br>         4 /u01/app/oracle/oradata/ORCL/redo04.log <br>         4 /u01/app/oracle/oradata/ORCL/redo04b.log <br><br>8 rows selected. <br><br>oracle19c> select file_name from dba_data_files; <br><br>FILE_NAME <br>-------------------------------------------------------------------------------- <br>/u01/app/oracle/oradata/ORCL/system01.dbf <br>/u01/app/oracle/oradata/ORCL/sysaux01.dbf <br>/u01/app/oracle/oradata/ORCL/undotbs01.dbf <br>/u01/app/oracle/oradata/ORCL/users01.dbf <br>/u01/app/oracle/oradata/ORCL/ts01.dbf <br>/u01/app/oracle/oradata/ORCL/indx01.dbf <br>/u01/app/oracle/oradata/ORCL/ts07b.dbf <br>/u01/app/oracle/oradata/ORCL/ts100.dbf <br>/u01/app/oracle/oradata/ORCL/ts300.dbf <br>/u01/app/oracle/oradata/ORCL/ts400.dbf <br><br>10 rows selected. <br><br>oracle19c> exit; <br>Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production <br>Version 19.3.0.0.0 <br>[oracle@ora19c ~]$ rman target / nocatalog <br><br>Recovery Manager: Release 19.0.0.0.0 - Production on Sun Mar 29 17:00:55 2026 <br>Version 19.3.0.0.0 <br><br>Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved. <br><br>connected to target database: ORCL (DBID=1756432550) <br>using target database control file instead of recovery catalog <br><br>RMAN> backup database; <br><br>Starting backup at 2026/03/29:17:01:05 <br>allocated channel: ORA_DISK_1 <br>channel ORA_DISK_1: SID=262 device type=DISK <br>channel ORA_DISK_1: starting full datafile backup set <br>channel ORA_DISK_1: specifying datafile(s) in backup set <br>input datafile file number=00001 name=/u01/app/oracle/oradata/ORCL/system01.dbf <br>input datafile file number=00007 name=/u01/app/oracle/oradata/ORCL/users01.dbf <br>input datafile file number=00003 name=/u01/app/oracle/oradata/ORCL/sysaux01.dbf <br>input datafile file number=00004 name=/u01/app/oracle/oradata/ORCL/undotbs01.dbf <br>input datafile file number=00002 name=/u01/app/oracle/oradata/ORCL/indx01.dbf <br>input datafile file number=00005 name=/u01/app/oracle/oradata/ORCL/ts01.dbf <br>input datafile file number=00011 name=/u01/app/oracle/oradata/ORCL/ts400.dbf <br>input datafile file number=00010 name=/u01/app/oracle/oradata/ORCL/ts300.dbf <br>input datafile file number=00008 name=/u01/app/oracle/oradata/ORCL/ts07b.dbf <br>input datafile file number=00009 name=/u01/app/oracle/oradata/ORCL/ts100.dbf <br>channel ORA_DISK_1: starting piece 1 at 2026/03/29:17:01:06 <br>channel ORA_DISK_1: finished piece 1 at 2026/03/29:17:01:41 <br>piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2026_03_29/o1_mf_nnndf_TAG20260329T170105_nwkq22s4_.bkp tag=TAG20260329T170105 comment=NONE <br>channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35 <br>Finished backup at 2026/03/29:17:01:41 <br><br>Starting Control File and SPFILE Autobackup at 2026/03/29:17:01:41 <br>piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2026_03_29/o1_mf_s_1229187701_nwkq363x_.bkp comment=NONE <br>Finished Control File and SPFILE Autobackup at 2026/03/29:17:01:42 <br><br>RMAN> </p><p> </p><div class="figure-img" data-ke-type="image" data-ke-style="alignCenter" data-ke-mobilestyle="widthOrigin"><img src="https://t1.daumcdn.net/cafeattach/zchT/2d3a86cbf68222fbe0db03305250b8a71a50a2e8" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/2d3a86cbf68222fbe0db03305250b8a71a50a2e8" data-origin-width="823" data-origin-height="210"></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/9d848bebab0bd62eba324d85b25c16761c703727" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/9d848bebab0bd62eba324d85b25c16761c703727" data-origin-width="1918" data-origin-height="1010"></div>
<!-- -->
]]>
