[아이티윌 오라클 DBA 과정 91기] 260109 TIL
2026. 1. 11. 16:15ㆍCourses/아이티윌 오라클 DBA 과정
수동으로 백업 받은 백업 파일을 rman image copy 백업으로 등록
현재 상태 조회
RMAN> report schema;
using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name ORA19C
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 910 SYSTEM YES /u01/app/oracle/oradata/ORA19C/system01.dbf
3 720 SYSAUX NO /u01/app/oracle/oradata/ORA19C/sysaux01.dbf
4 340 UNDOTBS1 YES /u01/app/oracle/oradata/ORA19C/undotbs01.dbf
7 5 USERS NO /u01/app/oracle/oradata/ORA19C/users01.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 32 TEMP 32767 /u01/app/oracle/oradata/ORA19C/temp01.dbf
RMAN> list backup;
specification does not match any backup in the repository
RMAN> list copy;
specification does not match any datafile copy in the repository
specification does not match any control file copy in the repository
List of Archived Log Copies for database with db_unique_name ORA19C
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - ---------
2 1 29 A 23-DEC-25
Name: /home/oracle/arch2/arch_1_29_1218118200.arc
1 1 29 A 23-DEC-25
Name: /home/oracle/arch1/arch_1_29_1218118200.arcautobackup off 설정
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORA19C are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/19.3.0/dbhome_1/dbs/snapcf_ora19c.f'; # default
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
new RMAN configuration parameters are successfully storedimage copy backup
RMAN> backup as copy database;
Starting backup at 09-JAN-26
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=155 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/ORA19C/system01.dbf
output file name=/u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_system_np0ppjsr_.dbf tag=TAG20260109T103304 RECID=1 STAMP=1222079586
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/u01/app/oracle/oradata/ORA19C/sysaux01.dbf
output file name=/u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_sysaux_np0ppnrd_.dbf tag=TAG20260109T103304 RECID=2 STAMP=1222079590
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/u01/app/oracle/oradata/ORA19C/undotbs01.dbf
output file name=/u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_undotbs1_np0pprfk_.dbf tag=TAG20260109T103304 RECID=3 STAMP=1222079593
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=/u01/app/oracle/fast_recovery_area/ORA19C/controlfile/o1_mf_TAG20260109T103304_np0ppt4o_.ctl tag=TAG20260109T103304 RECID=4 STAMP=1222079594
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile file number=00007 name=/u01/app/oracle/oradata/ORA19C/users01.dbf
output file name=/u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_users_np0ppv8g_.dbf tag=TAG20260109T103304 RECID=5 STAMP=1222079595
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 09-JAN-26
channel ORA_DISK_1: finished piece 1 at 09-JAN-26
piece handle=/u01/app/oracle/fast_recovery_area/ORA19C/backupset/2026_01_09/o1_mf_nnsnf_TAG20260109T103304_np0ppwdf_.bkp tag=TAG20260109T103304 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 09-JAN-26
RMAN> list copy;
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time Sparse
------- ---- - --------------- ---------- --------------- ------
1 1 A 09-JAN-26 2864178 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_system_np0ppjsr_.dbf
Tag: TAG20260109T103304
2 3 A 09-JAN-26 2864180 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_sysaux_np0ppnrd_.dbf
Tag: TAG20260109T103304
3 4 A 09-JAN-26 2864182 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_undotbs1_np0pprfk_.dbf
Tag: TAG20260109T103304
5 7 A 09-JAN-26 2864184 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_users_np0ppv8g_.dbf
Tag: TAG20260109T103304
List of Control File Copies
===========================
Key S Completion Time Ckp SCN Ckp Time
------- - --------------- ---------- ---------------
4 A 09-JAN-26 2864183 09-JAN-26
Name: /u01/app/oracle/fast_recovery_area/ORA19C/controlfile/o1_mf_TAG20260109T103304_np0ppt4o_.ctl
Tag: TAG20260109T103304
List of Archived Log Copies for database with db_unique_name ORA19C
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - ---------
2 1 29 A 23-DEC-25
Name: /home/oracle/arch2/arch_1_29_1218118200.arc
1 1 29 A 23-DEC-25
Name: /home/oracle/arch1/arch_1_29_1218118200.arc
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 96.00K DISK 00:00:00 09-JAN-26
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20260109T103304
Piece Name: /u01/app/oracle/fast_recovery_area/ORA19C/backupset/2026_01_09/o1_mf_nnsnf_TAG20260109T103304_np0ppwdf_.bkp
SPFILE Included: Modification time: 09-JAN-26
SPFILE db_unique_name: ORA19C- 데이터파일, 컨트롤파일, spfile 백업
backup as copy current controlfile;=alter database backup controlfile to ‘<위치>’;
테이블스페이스 생성
SYS@ora19c> select a.file#, a.creation_change#, to_char(a.creation_time, 'yyyy-mm-dd hh24:mi:ss') creation_time, b.name tbs_name, a.name file_name, a.checkpoint_change#, a.status
from v$datafile a, v$tablespace b
where a.ts# = b.ts#; 2 3
FILE# CREATION_CHANGE# CREATION_TIME TBS_NAME FILE_NAME CHECKPOINT_CHANGE# STATUS
---------- ---------------- ------------------- ------------------------------ -------------------------------------------------- ------------------ -------
3 5480 2019-04-17 00:56:21 SYSAUX /u01/app/oracle/oradata/ORA19C/sysaux01.dbf 2864180 ONLINE
1 9 2019-04-17 00:56:09 SYSTEM /u01/app/oracle/oradata/ORA19C/system01.dbf 2864178 SYSTEM
4 1920446 2019-04-17 02:11:02 UNDOTBS1 /u01/app/oracle/oradata/ORA19C/undotbs01.dbf 2864182 ONLINE
7 32876 2019-04-17 00:57:08 USERS /u01/app/oracle/oradata/ORA19C/users01.dbf 2864184 ONLINE
SYS@ora19c> create tablespace insa_tbs datafile '/u01/app/oracle/oradata/ORA19C/insa_tbs01.dbf' size 10m;
Tablespace created.
SYS@ora19c> select a.file#, a.creation_change#, to_char(a.creation_time, 'yyyy-mm-dd hh24:mi:ss') creation_time, b.name tbs_name, a.name file_name, a.checkpoint_change#, a.status
from v$datafile a, v$tablespace b
where a.ts# = b.ts#; 2 3
FILE# CREATION_CHANGE# CREATION_TIME TBS_NAME FILE_NAME CHECKPOINT_CHANGE# STATUS
---------- ---------------- ------------------- ------------------------------ -------------------------------------------------- ------------------ -------
3 5480 2019-04-17 00:56:21 SYSAUX /u01/app/oracle/oradata/ORA19C/sysaux01.dbf 2864180 ONLINE
1 9 2019-04-17 00:56:09 SYSTEM /u01/app/oracle/oradata/ORA19C/system01.dbf 2864178 SYSTEM
4 1920446 2019-04-17 02:11:02 UNDOTBS1 /u01/app/oracle/oradata/ORA19C/undotbs01.dbf 2864182 ONLINE
7 32876 2019-04-17 00:57:08 USERS /u01/app/oracle/oradata/ORA19C/users01.dbf 2864184 ONLINE
5 2867523 2026-01-09 11:21:41 INSA_TBS /u01/app/oracle/oradata/ORA19C/insa_tbs01.dbf 2867524 ONLINE테이블 생성
SYS@ora19c> create table hr.insa tablespace insa_tbs as select * from hr.employees;
Table created.
SYS@ora19c> select count(*) from hr.insa;
COUNT(*)
----------
107[oracle@ora19c ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Fri Jan 9 11:24:16 2026
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORA19C (DBID=1271306228)
RMAN> list copy;
using target database control file instead of recovery catalog
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time Sparse
------- ---- - --------------- ---------- --------------- ------
1 1 A 09-JAN-26 2864178 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_system_np0ppjsr_.dbf
Tag: TAG20260109T103304
2 3 A 09-JAN-26 2864180 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_sysaux_np0ppnrd_.dbf
Tag: TAG20260109T103304
3 4 A 09-JAN-26 2864182 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_undotbs1_np0pprfk_.dbf
Tag: TAG20260109T103304
5 7 A 09-JAN-26 2864184 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_users_np0ppv8g_.dbf
Tag: TAG20260109T103304
List of Control File Copies
===========================
Key S Completion Time Ckp SCN Ckp Time
------- - --------------- ---------- ---------------
4 A 09-JAN-26 2864183 09-JAN-26
Name: /u01/app/oracle/fast_recovery_area/ORA19C/controlfile/o1_mf_TAG20260109T103304_np0ppt4o_.ctl
Tag: TAG20260109T103304
List of Archived Log Copies for database with db_unique_name ORA19C
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - ---------
2 1 29 A 23-DEC-25
Name: /home/oracle/arch2/arch_1_29_1218118200.arc
1 1 29 A 23-DEC-25
Name: /home/oracle/arch1/arch_1_29_1218118200.arc
insa_tbs 테이블스페이스 백업
SYS@ora19c> alter tablespace insa_tbs begin backup;
Tablespace altered.
SYS@ora19c> !cp -v /u01/app/oracle/oradata/ORA19C/insa_tbs01.dbf /u01/app/oracle/fast_recovery_area/ORA19C/datafile/
‘/u01/app/oracle/oradata/ORA19C/insa_tbs01.dbf’ -> ‘/u01/app/oracle/fast_recovery_area/ORA19C/datafile/insa_tbs01.dbf’
SYS@ora19c> alter tablespace insa_tbs end backup;
Tablespace altered.RMAN 백업 정보 조회
RMAN> report schema;
using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name ORA19C
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 910 SYSTEM YES /u01/app/oracle/oradata/ORA19C/system01.dbf
3 720 SYSAUX NO /u01/app/oracle/oradata/ORA19C/sysaux01.dbf
4 340 UNDOTBS1 YES /u01/app/oracle/oradata/ORA19C/undotbs01.dbf
5 10 INSA_TBS NO /u01/app/oracle/oradata/ORA19C/insa_tbs01.dbf
7 5 USERS NO /u01/app/oracle/oradata/ORA19C/users01.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 32 TEMP 32767 /u01/app/oracle/oradata/ORA19C/temp01.dbf
RMAN> report need backup;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of files with less than 1 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------
5 0 /u01/app/oracle/oradata/ORA19C/insa_tbs01.dbf
RMAN> list copy of tablespace insa_tbs;
specification does not match any datafile copy in the repository
RMAN> list copy of datafile 5;
specification does not match any datafile copy in the repository- 유저가 백업을 받았더라도 백업이 필요하다고 나옴
수동으로 백업 받은 백업 파일 등록
RMAN> catalog datafilecopy '/u01/app/oracle/fast_recovery_area/ORA19C/datafile/insa_tbs01.dbf';
cataloged datafile copy
datafile copy file name=/u01/app/oracle/fast_recovery_area/ORA19C/datafile/insa_tbs01.dbf RECID=6 STAMP=1222083084
RMAN> list copy of datafile 5;
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time Sparse
------- ---- - --------------- ---------- --------------- ------
6 5 A 09-JAN-26 2868757 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/insa_tbs01.dbf
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 96.00K DISK 00:00:00 09-JAN-26
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20260109T103304
Piece Name: /u01/app/oracle/fast_recovery_area/ORA19C/backupset/2026_01_09/o1_mf_nnsnf_TAG20260109T103304_np0ppwdf_.bkp
SPFILE Included: Modification time: 09-JAN-26
SPFILE db_unique_name: ORA19C
RMAN> list copy;
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time Sparse
------- ---- - --------------- ---------- --------------- ------
1 1 A 09-JAN-26 2864178 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_system_np0ppjsr_.dbf
Tag: TAG20260109T103304
2 3 A 09-JAN-26 2864180 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_sysaux_np0ppnrd_.dbf
Tag: TAG20260109T103304
3 4 A 09-JAN-26 2864182 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_undotbs1_np0pprfk_.dbf
Tag: TAG20260109T103304
6 5 A 09-JAN-26 2868757 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/insa_tbs01.dbf
5 7 A 09-JAN-26 2864184 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_users_np0ppv8g_.dbf
Tag: TAG20260109T103304
List of Control File Copies
===========================
Key S Completion Time Ckp SCN Ckp Time
------- - --------------- ---------- ---------------
4 A 09-JAN-26 2864183 09-JAN-26
Name: /u01/app/oracle/fast_recovery_area/ORA19C/controlfile/o1_mf_TAG20260109T103304_np0ppt4o_.ctl
Tag: TAG20260109T103304
List of Archived Log Copies for database with db_unique_name ORA19C
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - ---------
2 1 29 A 23-DEC-25
Name: /home/oracle/arch2/arch_1_29_1218118200.arc
1 1 29 A 23-DEC-25
Name: /home/oracle/arch1/arch_1_29_1218118200.arc
SYS@ora19c> select a.file#, a.name, a.checkpoint_change#, b.status, b.change#, to_char(b.time, 'yyyy-mm-dd hh24:mi:ss') time
from v$datafile a, v$backup b
where a.file# = b.file#; 2 3
FILE# NAME CHECKPOINT_CHANGE# STATUS CHANGE# TIME
---------- -------------------------------------------------- ------------------ ------------------ ---------- -------------------
1 /u01/app/oracle/oradata/ORA19C/system01.dbf 2864178 NOT ACTIVE 0
3 /u01/app/oracle/oradata/ORA19C/sysaux01.dbf 2864180 NOT ACTIVE 0
4 /u01/app/oracle/oradata/ORA19C/undotbs01.dbf 2864182 NOT ACTIVE 0
5 /u01/app/oracle/oradata/ORA19C/insa_tbs01.dbf 2868757 NOT ACTIVE 2868757 2026-01-09 11:26:24
7 /u01/app/oracle/oradata/ORA19C/users01.dbf 2864184 NOT ACTIVE 0등록한 백업 파일 해지
RMAN> change datafilecopy '/u01/app/oracle/fast_recovery_area/ORA19C/datafile/insa_tbs01.dbf' uncatalog;
uncataloged datafile copy
datafile copy file name=/u01/app/oracle/fast_recovery_area/ORA19C/datafile/insa_tbs01.dbf RECID=6 STAMP=1222083084
Uncataloged 1 objects
RMAN> list copy of datafile 5;
specification does not match any datafile copy in the repository다시 등록
RMAN> catalog datafilecopy '/u01/app/oracle/fast_recovery_area/ORA19C/datafile/insa_tbs01.dbf';
cataloged datafile copy
datafile copy file name=/u01/app/oracle/fast_recovery_area/ORA19C/datafile/insa_tbs01.dbf RECID=7 STAMP=1222083423
RMAN> list copy of tablespace insa_tbs;
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time Sparse
------- ---- - --------------- ---------- --------------- ------
7 5 A 09-JAN-26 2868757 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/insa_tbs01.dbf장애 유발
SYS@ora19c> ! rm /u01/app/oracle/oradata/ORA19C/insa_tbs01.dbf복구
손상된 테이블스페이스 offline immediate
RMAN> alter tablespace insa_tbs offline immediate;
Statement processed백업본으로 restore
RMAN> restore tablespace insa_tbs;
Starting restore at 09-JAN-26
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=142 device type=DISK
channel ORA_DISK_1: restoring datafile 00005
input datafile copy RECID=7 STAMP=1222083423 file name=/u01/app/oracle/fast_recovery_area/ORA19C/datafile/insa_tbs01.dbf
destination for restore of datafile 00005: /u01/app/oracle/oradata/ORA19C/insa_tbs01.dbf
rchannel ORA_DISK_1: copied datafile copy of datafile 00005, elapsed time: 00:00:01
output file name=/u01/app/oracle/oradata/ORA19C/insa_tbs01.dbf RECID=0 STAMP=0
Finished restore at 09-JAN-26백업 이후 리두 적용
RMAN>recover tablespace insa_tbs;
Starting recover at 09-JAN-26
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:00
Finished recover at 09-JAN-26복구된 테이블스페이스 online으로 변경
RMAN> alter tablespace insa_tbs online;
Statement processedinsa_tbs 테이블스페이스 삭제
RMAN> drop tablespace insa_tbs including contents and datafiles;
Statement processed
RMAN> report schema;
Report of database schema for database with db_unique_name ORA19C
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 910 SYSTEM YES /u01/app/oracle/oradata/ORA19C/system01.dbf
3 720 SYSAUX NO /u01/app/oracle/oradata/ORA19C/sysaux01.dbf
4 340 UNDOTBS1 YES /u01/app/oracle/oradata/ORA19C/undotbs01.dbf
7 5 USERS NO /u01/app/oracle/oradata/ORA19C/users01.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 32 TEMP 32767 /u01/app/oracle/oradata/ORA19C/temp01.dbf
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Archive Log 1 09-JAN-26 /home/oracle/arch1/arch_1_29_1218118200.arc
Archive Log 2 09-JAN-26 /home/oracle/arch2/arch_1_29_1218118200.arc
Datafile Copy 7 09-JAN-26 /u01/app/oracle/fast_recovery_area/ORA19C/datafile/insa_tbs01.dbf
RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Archive Log 1 09-JAN-26 /home/oracle/arch1/arch_1_29_1218118200.arc
Archive Log 2 09-JAN-26 /home/oracle/arch2/arch_1_29_1218118200.arc
Datafile Copy 7 09-JAN-26 /u01/app/oracle/fast_recovery_area/ORA19C/datafile/insa_tbs01.dbf
Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=/home/oracle/arch1/arch_1_29_1218118200.arc RECID=1 STAMP=1222079406
deleted archived log
archived log file name=/home/oracle/arch2/arch_1_29_1218118200.arc RECID=2 STAMP=1222079406
deleted datafile copy
datafile copy file name=/u01/app/oracle/fast_recovery_area/ORA19C/datafile/insa_tbs01.dbf RECID=7 STAMP=1222083423
Deleted 3 objects# 논리적 copy와 물리적 copy 일치하는지 확인
RMAN> crosscheck copy;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=142 device type=DISK
specification does not match any archived log in the repository
validation succeeded for datafile copy
datafile copy file name=/u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_system_np0ppjsr_.dbf RECID=1 STAMP=1222079586
validation succeeded for datafile copy
datafile copy file name=/u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_sysaux_np0ppnrd_.dbf RECID=2 STAMP=1222079590
validation succeeded for datafile copy
datafile copy file name=/u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_undotbs1_np0pprfk_.dbf RECID=3 STAMP=1222079593
validation succeeded for datafile copy
datafile copy file name=/u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_users_np0ppv8g_.dbf RECID=5 STAMP=1222079595
validation succeeded for control file copy
control file copy file name=/u01/app/oracle/fast_recovery_area/ORA19C/controlfile/o1_mf_TAG20260109T103304_np0ppt4o_.ctl RECID=4 STAMP=1222079594
Crosschecked 5 objects
# expired 된 copy 조회
RMAN> list expired copy;
specification does not match any datafile copy in the repository
specification does not match any control file copy in the repository
specification does not match any archived log in the repository
# expired된 copy 삭제
delete expired copy;초기 파라미터(spfile) 손상
현재 상태 조회
# 백업 조회
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 96.00K DISK 00:00:00 09-JAN-26
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20260109T103304
Piece Name: /u01/app/oracle/fast_recovery_area/ORA19C/backupset/2026_01_09/o1_mf_nnsnf_TAG20260109T103304_np0ppwdf_.bkp
SPFILE Included: Modification time: 09-JAN-26
SPFILE db_unique_name: ORA19C# dbid, db name 조회
RMAN> select dbid, name from v$database;
DBID NAME
---------- ---------
1271306228 ORA19C- dbid를 물어보는 경우가 있으므로 문서화해둘 것
데이터베이스 종료
RMAN> shutdown immediate
database closed
database dismounted
Oracle instance shut down
RMAN> exit[oracle@ora19c ~]$ ls -l /u01/app/oracle/fast_recovery_area/ORA19C/backupset/2026_01_09/o1_mf_nnsnf_TAG20260109T103304_np0ppwdf_.bkp
-rw-r-----. 1 oracle oinstall 114688 Jan 9 10:33 /u01/app/oracle/fast_recovery_area/ORA19C/backupset/2026_01_09/o1_mf_nnsnf_TAG20260109T103304_np0ppwdf_.bkp장애 유발 : 초기파라미터 파일 삭제
[oracle@ora19c ~]$ cd $ORACLE_HOME/dbs
[oracle@ora19c dbs]$ ls
hc_clone.dat init.ora lkCLONE orapwora19c spfileora19c.bak
hc_ora19c.dat initora19c.ora lkORA19C snapcf_ora19c.f spfileora19c.ora
[oracle@ora19c dbs]$ cp -v spfileora19c.ora spfileora19c.bak
‘spfileora19c.ora’ -> ‘spfileora19c.bak’
[oracle@ora19c dbs]$ rm spfileora19c.ora initora19c.ora[oracle@ora19c dbs]$ cd
[oracle@ora19c ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jan 9 12:05:01 2026
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
SYS@ora19c> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/19.3.0/dbhome_1/dbs/initora19c.ora'rman으로 인위적으로 nomount까지 데이터베이스 올리기
RMAN> startup force nomount;
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/19.3.0/dbhome_1/dbs/initora19c.ora'
starting Oracle instance without parameter file for retrieval of spfile
Oracle instance started
Total System Global Area 1073737800 bytes
Fixed Size 8904776 bytes
Variable Size 276824064 bytes
Database Buffers 780140544 bytes
Redo Buffers 7868416 bytesstartup force nomount하면 초기 파라미터 파일이 없어도 오라클 인스턴스를 올리는데 필요한 정보만 가지고 올릴 수 있음
spfile 백업본으로 restore
RMAN> restore spfile from '/u01/app/oracle/fast_recovery_area/ORA19C/backupset/2026_01_09/o1_mf_nnsnf_TAG20260109T103304_np0ppwdf_.bkp';
Starting restore at 09-JAN-26
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=20 device type=DISK
channel ORA_DISK_1: restoring spfile from AUTOBACKUP /u01/app/oracle/fast_recovery_area/ORA19C/backupset/2026_01_09/o1_mf_nnsnf_TAG20260109T103304_np0ppwdf_.bkp
channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete
Finished restore at 09-JAN-26- dbid를 물어보는 경우 :
set dbid <dbid>
[oracle@ora19c ~]$ cd $ORACLE_HOME/dbs
[oracle@ora19c dbs]$ ls
hc_clone.dat init.ora lkORA19C snapcf_ora19c.f spfileora19c.ora
hc_ora19c.dat lkCLONE orapwora19c spfileora19c.bak
[oracle@ora19c dbs]$ ll
total 10384
-rw-rw----. 1 oracle oinstall 1544 Jan 9 10:17 hc_clone.dat
-rw-rw----. 1 oracle oinstall 1544 Jan 9 12:08 hc_ora19c.dat
-rw-r--r--. 1 oracle oinstall 3079 May 14 2015 init.ora
-rw-r-----. 1 oracle oinstall 24 Dec 31 11:20 lkCLONE
-rw-r-----. 1 oracle oinstall 24 Nov 25 14:07 lkORA19C
-rw-r-----. 1 oracle oinstall 2048 Nov 25 14:10 orapwora19c
-rw-r-----. 1 oracle oinstall 10600448 Jan 8 17:54 snapcf_ora19c.f
-rw-r-----. 1 oracle oinstall 3584 Jan 9 12:04 spfileora19c.bak
-rw-r-----. 1 oracle oinstall 3584 Jan 9 12:10 spfileora19c.ora데이터베이스 재시작
RMAN> shutdown abort
Oracle instance shut down
RMAN> startup
connected to target database (not started)
Oracle instance started
database mounted
database opened
Total System Global Area 830469472 bytes
Fixed Size 8901984 bytes
Variable Size 658505728 bytes
Database Buffers 155189248 bytes
Redo Buffers 7872512 bytesimage copy를 이용한 불완전 복구(모든 데이터파일, 컨트롤파일, 리두로그파일 손상), 백업 시점 아카이브 존재
image copy
RMAN> list backup;
specification does not match any backup in the repository
RMAN> backup as copy database;
Starting backup at 09-JAN-26
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/ORA19C/system01.dbf
output file name=/u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_system_np12njg5_.dbf tag=TAG20260109T135648 RECID=1 STAMP=1222091811
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/u01/app/oracle/oradata/ORA19C/sysaux01.dbf
output file name=/u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_sysaux_np12nqm0_.dbf tag=TAG20260109T135648 RECID=2 STAMP=1222091817
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/u01/app/oracle/oradata/ORA19C/undotbs01.dbf
output file name=/u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_undotbs1_np12ntqm_.dbf tag=TAG20260109T135648 RECID=3 STAMP=1222091819
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile file number=00007 name=/u01/app/oracle/oradata/ORA19C/users01.dbf
output file name=/u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_users_np12nvt3_.dbf tag=TAG20260109T135648 RECID=4 STAMP=1222091819
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 09-JAN-26
Starting Control File and SPFILE Autobackup at 09-JAN-26
piece handle=/u01/app/oracle/fast_recovery_area/ORA19C/autobackup/2026_01_09/o1_mf_s_1222091820_np12nwz3_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 09-JAN-26
RMAN> list copy;
specification does not match any control file copy in the repository
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time Sparse
------- ---- - --------------- ---------- --------------- ------
1 1 A 09-JAN-26 2864310 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_system_np12njg5_.dbf
Tag: TAG20260109T135648
2 3 A 09-JAN-26 2864314 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_sysaux_np12nqm0_.dbf
Tag: TAG20260109T135648
3 4 A 09-JAN-26 2864316 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_undotbs1_np12ntqm_.dbf
Tag: TAG20260109T135648
4 7 A 09-JAN-26 2864317 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_users_np12nvt3_.dbf
Tag: TAG20260109T135648
List of Archived Log Copies for database with db_unique_name ORA19C
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - ---------
2 1 29 A 23-DEC-25
Name: /home/oracle/arch2/arch_1_29_1218118200.arc
1 1 29 A 23-DEC-25
Name: /home/oracle/arch1/arch_1_29_1218118200.arc
RMAN> backup as copy current controlfile;
Starting backup at 09-JAN-26
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=/u01/app/oracle/fast_recovery_area/ORA19C/controlfile/o1_mf_TAG20260109T135722_np12om1h_.ctl tag=TAG20260109T135722 RECID=5 STAMP=1222091843
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 09-JAN-26
Starting Control File and SPFILE Autobackup at 09-JAN-26
piece handle=/u01/app/oracle/fast_recovery_area/ORA19C/autobackup/2026_01_09/o1_mf_s_1222091844_np12on69_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 09-JAN-26
RMAN> list copy;
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time Sparse
------- ---- - --------------- ---------- --------------- ------
1 1 A 09-JAN-26 2864310 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_system_np12njg5_.dbf
Tag: TAG20260109T135648
2 3 A 09-JAN-26 2864314 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_sysaux_np12nqm0_.dbf
Tag: TAG20260109T135648
3 4 A 09-JAN-26 2864316 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_undotbs1_np12ntqm_.dbf
Tag: TAG20260109T135648
4 7 A 09-JAN-26 2864317 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_users_np12nvt3_.dbf
Tag: TAG20260109T135648
List of Control File Copies
===========================
Key S Completion Time Ckp SCN Ckp Time
------- - --------------- ---------- ---------------
5 A 09-JAN-26 2864367 09-JAN-26
Name: /u01/app/oracle/fast_recovery_area/ORA19C/controlfile/o1_mf_TAG20260109T135722_np12om1h_.ctl
Tag: TAG20260109T135722
List of Archived Log Copies for database with db_unique_name ORA19C
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - ---------
2 1 29 A 23-DEC-25
Name: /home/oracle/arch2/arch_1_29_1218118200.arc
1 1 29 A 23-DEC-25
Name: /home/oracle/arch1/arch_1_29_1218118200.arc- 테이블스페이스마다 체크포인트 SCN이 다름
SYS@ora19c> select a.group#, a.sequence#, b.member, a.bytes/1024/1024 mb, a.archived, a.status, a.first_change#, to_char(first_time, 'yyyy-mm-dd hh24:mi:ss') first_time, a.next_change#, to_char(next_time, 'yyyy-mm-dd hh24:mi:ss') next_time
from v$log a, v$logfile b
where a.group# = b.group#; 2 3
GROUP# SEQUENCE# MEMBER MB ARC STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- -------------------------------------------------- ---------- --- ---------------- ------------- ------------------- ------------ -------------------
3 28 /u01/app/oracle/oradata/ORA19C/redo03.log 50 YES INACTIVE 2822872 2025-12-12 18:00:43 2850110 2025-12-23 10:12:10
2 30 /u01/app/oracle/oradata/ORA19C/redo02.log 50 NO CURRENT 2863911 2026-01-09 13:48:20 1.8447E+19
1 29 /u01/app/oracle/oradata/ORA19C/redo01.log 50 YES INACTIVE 2850110 2025-12-23 10:12:10 2863911 2026-01-09 13:48:20
SYS@ora19c> alter system archive log current;
System altered.
SYS@ora19c> select a.group#, a.sequence#, b.member, a.bytes/1024/1024 mb, a.archived, a.status, a.first_change#, to_char(first_time, 'yyyy-mm-dd hh24:mi:ss') first_time, a.next_change#, to_char(next_time, 'yyyy-mm-dd hh24:mi:ss') next_time
from v$log a, v$logfile b
where a.group# = b.group#; 2 3
GROUP# SEQUENCE# MEMBER MB ARC STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- -------------------------------------------------- ---------- --- ---------------- ------------- ------------------- ------------ -------------------
3 31 /u01/app/oracle/oradata/ORA19C/redo03.log 50 NO CURRENT 2864871 2026-01-09 14:00:38 1.8447E+19
2 30 /u01/app/oracle/oradata/ORA19C/redo02.log 50 YES ACTIVE 2863911 2026-01-09 13:48:20 2864871 2026-01-09 14:00:38
1 29 /u01/app/oracle/oradata/ORA19C/redo01.log 50 YES INACTIVE 2850110 2025-12-23 10:12:10 2863911 2026-01-09 13:48:20
SYS@ora19c> select sequence#, name, first_change#, to_char(first_time, 'yyyy-mm-dd hh24:mi:ss') first_time, next_change#, to_char(next_time, 'yyyy-mm-dd hh24:mi:ss') next_time
from v$archived_log; 2
SEQUENCE# NAME FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- -------------------------------------------------- ------------- ------------------- ------------ -------------------
29 /home/oracle/arch1/arch_1_29_1218118200.arc 2850110 2025-12-23 10:12:10 2863911 2026-01-09 13:48:20
29 /home/oracle/arch2/arch_1_29_1218118200.arc 2850110 2025-12-23 10:12:10 2863911 2026-01-09 13:48:20
30 /home/oracle/arch1/arch_1_30_1218118200.arc 2863911 2026-01-09 13:48:20 2864871 2026-01-09 14:00:38
30 /home/oracle/arch2/arch_1_30_1218118200.arc 2863911 2026-01-09 13:48:20 2864871 2026-01-09 14:00:38
SYS@ora19c> ! ls arch*
arch1:
arch_1_29_1218118200.arc arch_1_30_1218118200.arc
arch2:
arch_1_29_1218118200.arc arch_1_30_1218118200.arc - image copy로 백업한 경우 데이터 파일마다 scn 이 모두 다르므로 복구를 위해서 redo가 있어야 함 → archive 필수
장애 유발 : 모든 파일 삭제
SYS@ora19c> shutdown abort
ORACLE instance shut down.
SYS@ora19c> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@ora19c ~]$ rm /u01/app/oracle/oradata/ORA19C/*복구 수행
nomount까지 데이터베이스 시작
[oracle@ora19c ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Fri Jan 9 14:09:13 2026
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN> startup nomount
Oracle instance started
Total System Global Area 830469472 bytes
Fixed Size 8901984 bytes
Variable Size 658505728 bytes
Database Buffers 155189248 bytes
Redo Buffers 7872512 bytes백업 컨트롤 파일로 restore
RMAN> restore controlfile from '/u01/app/oracle/fast_recovery_area/ORA19C/controlfile/o1_mf_TAG20260109T135722_np12om1h_.ctl';
Starting restore at 09-JAN-26
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=20 device type=DISK
channel ORA_DISK_1: copied control file copy
output file name=/u01/app/oracle/oradata/ORA19C/control01.ctl
Finished restore at 09-JAN-26mount
RMAN> alter database mount;
released channel: ORA_DISK_1
Statement processed백업 데이터파일 restore
RMAN> restore database;
Starting restore at 09-JAN-26
Starting implicit crosscheck backup at 09-JAN-26
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=23 device type=DISK
Crosschecked 1 objects
Finished implicit crosscheck backup at 09-JAN-26
Starting implicit crosscheck copy at 09-JAN-26
using channel ORA_DISK_1
Crosschecked 4 objects
Finished implicit crosscheck copy at 09-JAN-26
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u01/app/oracle/fast_recovery_area/ORA19C/autobackup/2026_01_09/o1_mf_s_1222091844_np12on69_.bkp
File Name: /u01/app/oracle/fast_recovery_area/ORA19C/controlfile/o1_mf_TAG20260109T135722_np12om1h_.ctl
using channel ORA_DISK_1
channel ORA_DISK_1: restoring datafile 00001
input datafile copy RECID=1 STAMP=1222091811 file name=/u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_system_np12njg5_.dbf
destination for restore of datafile 00001: /u01/app/oracle/oradata/ORA19C/system01.dbf
channel ORA_DISK_1: copied datafile copy of datafile 00001, elapsed time: 00:00:03
output file name=/u01/app/oracle/oradata/ORA19C/system01.dbf RECID=0 STAMP=0
channel ORA_DISK_1: restoring datafile 00003
input datafile copy RECID=2 STAMP=1222091817 file name=/u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_sysaux_np12nqm0_.dbf
destination for restore of datafile 00003: /u01/app/oracle/oradata/ORA19C/sysaux01.dbf
channel ORA_DISK_1: copied datafile copy of datafile 00003, elapsed time: 00:00:03
output file name=/u01/app/oracle/oradata/ORA19C/sysaux01.dbf RECID=0 STAMP=0
channel ORA_DISK_1: restoring datafile 00004
input datafile copy RECID=3 STAMP=1222091819 file name=/u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_undotbs1_np12ntqm_.dbf
destination for restore of datafile 00004: /u01/app/oracle/oradata/ORA19C/undotbs01.dbf
channel ORA_DISK_1: copied datafile copy of datafile 00004, elapsed time: 00:00:01
output file name=/u01/app/oracle/oradata/ORA19C/undotbs01.dbf RECID=0 STAMP=0
channel ORA_DISK_1: restoring datafile 00007
input datafile copy RECID=4 STAMP=1222091819 file name=/u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_users_np12nvt3_.dbf
destination for restore of datafile 00007: /u01/app/oracle/oradata/ORA19C/users01.dbf
channel ORA_DISK_1: copied datafile copy of datafile 00007, elapsed time: 00:00:01
output file name=/u01/app/oracle/oradata/ORA19C/users01.dbf RECID=0 STAMP=0
Finished restore at 09-JAN-26
RMAN> list copy;
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time Sparse
------- ---- - --------------- ---------- --------------- ------
1 1 A 09-JAN-26 2864310 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_system_np12njg5_.dbf
Tag: TAG20260109T135648
2 3 A 09-JAN-26 2864314 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_sysaux_np12nqm0_.dbf
Tag: TAG20260109T135648
3 4 A 09-JAN-26 2864316 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_undotbs1_np12ntqm_.dbf
Tag: TAG20260109T135648
4 7 A 09-JAN-26 2864317 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_users_np12nvt3_.dbf
Tag: TAG20260109T135648
List of Control File Copies
===========================
Key S Completion Time Ckp SCN Ckp Time
------- - --------------- ---------- ---------------
5 A 09-JAN-26 2864367 09-JAN-26
Name: /u01/app/oracle/fast_recovery_area/ORA19C/controlfile/o1_mf_TAG20260109T135722_np12om1h_.ctl
Tag: TAG20260109T135722
List of Archived Log Copies for database with db_unique_name ORA19C
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - ---------
2 1 29 A 23-DEC-25
Name: /home/oracle/arch2/arch_1_29_1218118200.arc
1 1 29 A 23-DEC-25
Name: /home/oracle/arch1/arch_1_29_1218118200.arc백업 이후 리두 적용
RMAN> recover database;
Starting recover at 09-JAN-26
using channel ORA_DISK_1
starting media recovery
archived log file name=/home/oracle/arch2/arch_1_30_1218118200.arc thread=1 sequence=30
unable to find archived log
archived log thread=1 sequence=31
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/09/2026 14:14:21
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 31 and starting SCN of 2864871cancel base recovery
RMAN> run {
set until scn = 2864871;
recover database;
alter database open resetlogs;
}2> 3> 4> 5>
executing command: SET until clause
Starting recover at 09-JAN-26
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:00
Finished recover at 09-JAN-26
Statement processedimage copy를 이용한 불완전 복구(모든 데이터파일, 컨트롤파일, 리두로그파일 손상), 백업 시점 아카이브 X
RMAN> list copy;
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time Sparse
------- ---- - --------------- ---------- --------------- ------
1 1 A 09-JAN-26 2864310 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_system_np12njg5_.dbf
Tag: TAG20260109T135648
2 3 A 09-JAN-26 2864314 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_sysaux_np12nqm0_.dbf
Tag: TAG20260109T135648
3 4 A 09-JAN-26 2864316 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_undotbs1_np12ntqm_.dbf
Tag: TAG20260109T135648
4 7 A 09-JAN-26 2864317 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_users_np12nvt3_.dbf
Tag: TAG20260109T135648
List of Control File Copies
===========================
Key S Completion Time Ckp SCN Ckp Time
------- - --------------- ---------- ---------------
5 A 09-JAN-26 2864367 09-JAN-26
Name: /u01/app/oracle/fast_recovery_area/ORA19C/controlfile/o1_mf_TAG20260109T135722_np12om1h_.ctl
Tag: TAG20260109T135722
List of Archived Log Copies for database with db_unique_name ORA19C
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - ---------
2 1 29 A 23-DEC-25
Name: /home/oracle/arch2/arch_1_29_1218118200.arc
1 1 29 A 23-DEC-25
Name: /home/oracle/arch1/arch_1_29_1218118200.arc
3 1 30 A 09-JAN-26
Name: /home/oracle/arch2/arch_1_30_1218118200.arc
장애 유발
[oracle@ora19c ~]$ ps -ef | grep smon
oracle 7391 11521 0 17:02 pts/0 00:00:00 grep --color=auto smon
oracle 29041 1 0 14:09 ? 00:00:00 ora_smon_ora19c
# 데이터베이스 강제 종료
[oracle@ora19c ~]$ kill -9 29041
# 모든 파일 삭제
[oracle@ora19c ~]$ rm $ORACLE_BASE/oradata/ORA19C/*
[oracle@ora19c ~]$ rm arch*/*복구 수행
nomount로 데이터베이스 시작
[oracle@ora19c ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Fri Jan 9 17:03:47 2026
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN> startup nomount
Oracle instance started
Total System Global Area 830469472 bytes
Fixed Size 8901984 bytes
Variable Size 658505728 bytes
Database Buffers 155189248 bytes
Redo Buffers 7872512 bytes백업 컨트롤 파일로 restore
# 백업 컨트롤 파일로 restore
RMAN> restore controlfile from '/u01/app/oracle/fast_recovery_area/ORA19C/controlfile/o1_mf_TAG20260109T135722_np12om1h_.ctl';
Starting restore at 09-JAN-26
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=19 device type=DISK
channel ORA_DISK_1: copied control file copy
output file name=/u01/app/oracle/oradata/ORA19C/control01.ctl
Finished restore at 09-JAN-26데이터베이스 mount
# 데이터베이스 mount
RMAN> alter database mount;
released channel: ORA_DISK_1
Statement processed
RMAN> list copy;
specification does not match any control file copy in the repository
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time Sparse
------- ---- - --------------- ---------- --------------- ------
1 1 A 09-JAN-26 2864310 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_system_np12njg5_.dbf
Tag: TAG20260109T135648
2 3 A 09-JAN-26 2864314 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_sysaux_np12nqm0_.dbf
Tag: TAG20260109T135648
3 4 A 09-JAN-26 2864316 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_undotbs1_np12ntqm_.dbf
Tag: TAG20260109T135648
4 7 A 09-JAN-26 2864317 09-JAN-26 NO
Name: /u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_users_np12nvt3_.dbf
Tag: TAG20260109T135648
List of Archived Log Copies for database with db_unique_name ORA19C
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - ---------
2 1 29 A 23-DEC-25
Name: /home/oracle/arch2/arch_1_29_1218118200.arc
1 1 29 A 23-DEC-25
Name: /home/oracle/arch1/arch_1_29_1218118200.arc백업본으로 restore
RMAN> restore database;
Starting restore at 09-JAN-26
Starting implicit crosscheck backup at 09-JAN-26
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=22 device type=DISK
Crosschecked 1 objects
Finished implicit crosscheck backup at 09-JAN-26
Starting implicit crosscheck copy at 09-JAN-26
using channel ORA_DISK_1
Crosschecked 4 objects
Finished implicit crosscheck copy at 09-JAN-26
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u01/app/oracle/fast_recovery_area/ORA19C/autobackup/2026_01_09/o1_mf_s_1222091844_np12on69_.bkp
File Name: /u01/app/oracle/fast_recovery_area/ORA19C/autobackup/2026_01_09/o1_mf_s_1222093104_np13x04l_.bkp
File Name: /u01/app/oracle/fast_recovery_area/ORA19C/controlfile/o1_mf_TAG20260109T135722_np12om1h_.ctl
using channel ORA_DISK_1
channel ORA_DISK_1: restoring datafile 00001
input datafile copy RECID=1 STAMP=1222091811 file name=/u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_system_np12njg5_.dbf
destination for restore of datafile 00001: /u01/app/oracle/oradata/ORA19C/system01.dbf
channel ORA_DISK_1: copied datafile copy of datafile 00001, elapsed time: 00:00:07
output file name=/u01/app/oracle/oradata/ORA19C/system01.dbf RECID=0 STAMP=0
channel ORA_DISK_1: restoring datafile 00003
input datafile copy RECID=2 STAMP=1222091817 file name=/u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_sysaux_np12nqm0_.dbf
destination for restore of datafile 00003: /u01/app/oracle/oradata/ORA19C/sysaux01.dbf
channel ORA_DISK_1: copied datafile copy of datafile 00003, elapsed time: 00:00:03
output file name=/u01/app/oracle/oradata/ORA19C/sysaux01.dbf RECID=0 STAMP=0
channel ORA_DISK_1: restoring datafile 00004
input datafile copy RECID=3 STAMP=1222091819 file name=/u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_undotbs1_np12ntqm_.dbf
destination for restore of datafile 00004: /u01/app/oracle/oradata/ORA19C/undotbs01.dbf
channel ORA_DISK_1: copied datafile copy of datafile 00004, elapsed time: 00:00:03
output file name=/u01/app/oracle/oradata/ORA19C/undotbs01.dbf RECID=0 STAMP=0
channel ORA_DISK_1: restoring datafile 00007
input datafile copy RECID=4 STAMP=1222091819 file name=/u01/app/oracle/fast_recovery_area/ORA19C/datafile/o1_mf_users_np12nvt3_.dbf
destination for restore of datafile 00007: /u01/app/oracle/oradata/ORA19C/users01.dbf
channel ORA_DISK_1: copied datafile copy of datafile 00007, elapsed time: 00:00:01
output file name=/u01/app/oracle/oradata/ORA19C/users01.dbf RECID=0 STAMP=0
Finished restore at 09-JAN-26백업 이후 리두 적용
RMAN> recover database;
Starting recover at 09-JAN-26
using channel ORA_DISK_1
starting media recovery
unable to find archived log
archived log thread=1 sequence=30
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/09/2026 17:08:21
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 30 and starting SCN of 2864310작업형 모드로 cancel base recovery 수행 → 실패
RMAN> run {
set until scn = 2864310;
recover database;
alter database open resetlogs;
}2> 3> 4> 5>
executing command: SET until clause
Starting recover at 09-JAN-26
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/09/2026 17:10:41
RMAN-20208: UNTIL CHANGE is before RESETLOGS change- 테이블스페이스마다 SCN이 다르고, 리두도 없기 때문에 복구 불가
- 히든 파라미터를 통해 SCN이 맞지 않더라도 데이터베이스를 open 할 수 있도록 작업
pfile 생성
RMAN> create pfile from spfile;
Statement processedpfile에 히든 파라미터 설정(_allow_resetlogs_corruption)
RMAN> shutdown abort
Oracle instance shut down
RMAN> exit
Recovery Manager complete.
[oracle@ora19c ~]$ cd $ORACLE_HOME/dbs
[oracle@ora19c dbs]$ ls
hc_clone.dat init.ora lkCLONE orapwora19c spfileora19c.bak
hc_ora19c.dat initora19c.ora lkORA19C snapcf_ora19c.f spfileora19c.ora
[oracle@ora19c dbs]$ vi initora19c.ora
[oracle@ora19c dbs]$ tail initora19c.ora
*.log_archive_format='arch_%t_%s_%r.arc'
*.log_checkpoints_to_alert=TRUE
*.memory_target=790m
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=100# 200 -> 100 changed 2025/11/27
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
_allow_resetlogs_corruption=TRUEpfile을 이용해 데이터베이스 mount로 시작 후 resetlogs로 open
[oracle@ora19c ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jan 9 17:18:16 2026
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
SYS@ora19c> startup pfile=$ORACLE_HOME/dbs/initora19c.ora mount
ORACLE instance started.
Total System Global Area 830469472 bytes
Fixed Size 8901984 bytes
Variable Size 658505728 bytes
Database Buffers 155189248 bytes
Redo Buffers 7872512 bytes
Database mounted.
SYS@ora19c> alter database open resetlogs;
Database altered.SYS@ora19c> select a.file#, a.creation_change#, to_char(a.creation_time, 'yyyy-mm-dd hh24:mi:ss') creation_time, b.name tbs_name, a.name file_name, a.checkpoint_change#, a.status
from v$datafile a, v$tablespace b
where a.ts# = b.ts#; 2 3
FILE# CREATION_CHANGE# CREATION_TIME TBS_NAME FILE_NAME CHECKPOINT_CHANGE# STATUS
---------- ---------------- ------------------- ------------------------------ -------------------------------------------------- ------------------ -------
3 5480 2019-04-17 00:56:21 SYSAUX /u01/app/oracle/oradata/ORA19C/sysaux01.dbf 2864314 ONLINE
1 9 2019-04-17 00:56:09 SYSTEM /u01/app/oracle/oradata/ORA19C/system01.dbf 2864314 SYSTEM
4 1920446 2019-04-17 02:11:02 UNDOTBS1 /u01/app/oracle/oradata/ORA19C/undotbs01.dbf 2864314 ONLINE
7 32876 2019-04-17 00:57:08 USERS /u01/app/oracle/oradata/ORA19C/users01.dbf 2864314 ONLINE- 체크 포인트가 모두 일치됨
Backupset을 이용한 불완전 복구(모든 데이터파일, 컨트롤파일, 리두로그파일 손상), 백업 시점 아카이브 X
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORA19C are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/19.3.0/dbhome_1/dbs/snapcf_ora19c.f'; # default백업
- 백업셋으로 백업
RMAN> backup database;
Starting backup at 09-JAN-26
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=31 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/ORA19C/system01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/ORA19C/sysaux01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/ORA19C/undotbs01.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/ORA19C/users01.dbf
channel ORA_DISK_1: starting piece 1 at 09-JAN-26
channel ORA_DISK_1: finished piece 1 at 09-JAN-26
piece handle=/u01/app/oracle/fast_recovery_area/ORA19C/backupset/2026_01_09/o1_mf_nnndf_TAG20260109T172407_np1gs88x_.bkp tag=TAG20260109T172407 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 09-JAN-26
Starting Control File Autobackup at 09-JAN-26
piece handle=/u01/app/oracle/fast_recovery_area/ORA19C/autobackup/2026_01_09/o1_mf_n_1222104255_np1gshd1_.bkp comment=NONE
Finished Control File Autobackup at 09-JAN-26
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 10.20M DISK 00:00:01 09-JAN-26
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20260109T135700
Piece Name: /u01/app/oracle/fast_recovery_area/ORA19C/autobackup/2026_01_09/o1_mf_s_1222091820_np12nwz3_.bkp
SPFILE Included: Modification time: 09-JAN-26
SPFILE db_unique_name: ORA19C
Control File Included: Ckp SCN: 2864326 Ckp time: 09-JAN-26
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 10.20M DISK 00:00:00 09-JAN-26
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20260109T135724
Piece Name: /u01/app/oracle/fast_recovery_area/ORA19C/autobackup/2026_01_09/o1_mf_s_1222091844_np12on69_.bkp
SPFILE Included: Modification time: 09-JAN-26
SPFILE db_unique_name: ORA19C
Control File Included: Ckp SCN: 2864375 Ckp time: 09-JAN-26
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 10.20M DISK 00:00:00 09-JAN-26
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20260109T141824
Piece Name: /u01/app/oracle/fast_recovery_area/ORA19C/autobackup/2026_01_09/o1_mf_s_1222093104_np13x04l_.bkp
SPFILE Included: Modification time: 09-JAN-26
SPFILE db_unique_name: ORA19C
Control File Included: Ckp SCN: 2865005 Ckp time: 09-JAN-26
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 10.17M DISK 00:00:01 09-JAN-26
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20260109T171926
Piece Name: /u01/app/oracle/fast_recovery_area/ORA19C/autobackup/2026_01_09/o1_mf_n_1222103966_np1gjgy2_.bkp
Control File Included: Ckp SCN: 2864458 Ckp time: 09-JAN-26
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5 Full 1.29G DISK 00:00:03 09-JAN-26
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20260109T172407
Piece Name: /u01/app/oracle/fast_recovery_area/ORA19C/backupset/2026_01_09/o1_mf_nnndf_TAG20260109T172407_np1gs88x_.bkp
List of Datafiles in backup set 5
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
1 Full 2865393 09-JAN-26 NO /u01/app/oracle/oradata/ORA19C/system01.dbf
3 Full 2865393 09-JAN-26 NO /u01/app/oracle/oradata/ORA19C/sysaux01.dbf
4 Full 2865393 09-JAN-26 NO /u01/app/oracle/oradata/ORA19C/undotbs01.dbf
7 Full 2865393 09-JAN-26 NO /u01/app/oracle/oradata/ORA19C/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6 Full 10.17M DISK 00:00:00 09-JAN-26
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20260109T172415
Piece Name: /u01/app/oracle/fast_recovery_area/ORA19C/autobackup/2026_01_09/o1_mf_n_1222104255_np1gshd1_.bkp
Control File Included: Ckp SCN: 2865406 Ckp time: 09-JAN-26장애 유발
RMAN> shutdown abort
Oracle instance shut down
RMAN> exit
Recovery Manager complete.
[oracle@ora19c ~]$ rm /u01/app/oracle/oradata/ORA19C/*
[oracle@ora19c ~]$ rm arch*/*
rm: cannot remove ‘arch*/*’: No such file or directory
[oracle@ora19c ~]$ ls arch*
arch1:
arch2:
복구 수행
nomount로 데이터베이스 시작
RMAN> startup nomount
Oracle instance started
Total System Global Area 830469472 bytes
Fixed Size 8901984 bytes
Variable Size 658505728 bytes
Database Buffers 155189248 bytes
Redo Buffers 7872512 bytes백업 컨트롤 파일로 restore
RMAN> restore controlfile from '/u01/app/oracle/fast_recovery_area/ORA19C/autobackup/2026_01_09/o1_mf_n_1222104255_np1gshd1_.bkp';
Starting restore at 09-JAN-26
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=19 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u01/app/oracle/oradata/ORA19C/control01.ctl
Finished restore at 09-JAN-26데이터베이스 mount
RMAN> alter database mount;
released channel: ORA_DISK_1
Statement processed
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 10.20M DISK 00:00:01 09-JAN-26
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20260109T135700
Piece Name: /u01/app/oracle/fast_recovery_area/ORA19C/autobackup/2026_01_09/o1_mf_s_1222091820_np12nwz3_.bkp
SPFILE Included: Modification time: 09-JAN-26
SPFILE db_unique_name: ORA19C
Control File Included: Ckp SCN: 2864326 Ckp time: 09-JAN-26
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 10.20M DISK 00:00:00 09-JAN-26
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20260109T135724
Piece Name: /u01/app/oracle/fast_recovery_area/ORA19C/autobackup/2026_01_09/o1_mf_s_1222091844_np12on69_.bkp
SPFILE Included: Modification time: 09-JAN-26
SPFILE db_unique_name: ORA19C
Control File Included: Ckp SCN: 2864375 Ckp time: 09-JAN-26
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 10.20M DISK 00:00:00 09-JAN-26
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20260109T141824
Piece Name: /u01/app/oracle/fast_recovery_area/ORA19C/autobackup/2026_01_09/o1_mf_s_1222093104_np13x04l_.bkp
SPFILE Included: Modification time: 09-JAN-26
SPFILE db_unique_name: ORA19C
Control File Included: Ckp SCN: 2865005 Ckp time: 09-JAN-26
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 10.17M DISK 00:00:01 09-JAN-26
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20260109T171926
Piece Name: /u01/app/oracle/fast_recovery_area/ORA19C/autobackup/2026_01_09/o1_mf_n_1222103966_np1gjgy2_.bkp
Control File Included: Ckp SCN: 2864458 Ckp time: 09-JAN-26
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5 Full 1.29G DISK 00:00:03 09-JAN-26
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20260109T172407
Piece Name: /u01/app/oracle/fast_recovery_area/ORA19C/backupset/2026_01_09/o1_mf_nnndf_TAG20260109T172407_np1gs88x_.bkp
List of Datafiles in backup set 5
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
1 Full 2865393 09-JAN-26 NO /u01/app/oracle/oradata/ORA19C/system01.dbf
3 Full 2865393 09-JAN-26 NO /u01/app/oracle/oradata/ORA19C/sysaux01.dbf
4 Full 2865393 09-JAN-26 NO /u01/app/oracle/oradata/ORA19C/undotbs01.dbf
7 Full 2865393 09-JAN-26 NO /u01/app/oracle/oradata/ORA19C/users01.dbf백업본으로 restore
RMAN> restore database;
Starting restore at 09-JAN-26
Starting implicit crosscheck backup at 09-JAN-26
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=22 device type=DISK
Crosschecked 5 objects
Finished implicit crosscheck backup at 09-JAN-26
Starting implicit crosscheck copy at 09-JAN-26
using channel ORA_DISK_1
Crosschecked 6 objects
Finished implicit crosscheck copy at 09-JAN-26
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u01/app/oracle/fast_recovery_area/ORA19C/autobackup/2026_01_09/o1_mf_n_1222104255_np1gshd1_.bkp
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/ORA19C/system01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/ORA19C/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/ORA19C/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00007 to /u01/app/oracle/oradata/ORA19C/users01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/ORA19C/backupset/2026_01_09/o1_mf_nnndf_TAG20260109T172407_np1gs88x_.bkp
channel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/ORA19C/backupset/2026_01_09/o1_mf_nnndf_TAG20260109T172407_np1gs88x_.bkp tag=TAG20260109T172407
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:08
Finished restore at 09-JAN-26백업 이후 리두 적용 → 실패
RMAN> recover database;
Starting recover at 09-JAN-26
using channel ORA_DISK_1
starting media recovery
unable to find archived log
archived log thread=1 sequence=1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/09/2026 17:29:36
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 1 and starting SCN of 2865393cancel base recovery
RMAN> run {
set until scn 2865393;
recover database;
alter database open resetlogs;
}2> 3> 4> 5>
executing command: SET until clause
Starting recover at 09-JAN-26
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:00
Finished recover at 09-JAN-26
Statement processed'Courses > 아이티윌 오라클 DBA 과정' 카테고리의 다른 글
| [아이티윌 오라클 DBA 과정 91기] 260113 TIL (0) | 2026.01.13 |
|---|---|
| [아이티윌 오라클 DBA 과정 91기] 260112 TIL (0) | 2026.01.13 |
| [아이티윌 오라클 DBA 과정 91기] 260108 TIL (0) | 2026.01.08 |
| [아이티윌 오라클 DBA 과정 91기] 260107 TIL (1) | 2026.01.07 |
| [아이티윌 오라클 DBA 과정 91기] 260106 TIL (1) | 2026.01.07 |