OS 환경 : Oracle Linux 8.7 (64bit)
DB 환경 : Oracle Database 19.27.0.0
방법 : 오라클 19c rman 증분 백업 및 복구 시나리오
본문 내용은 풀백업, 증분백업 1,2,3차, 아카이브백업 후 풀백업 시점부터 다시 현재까지 복구하는 시나리오임
복구 및 db를 기동하며 어떤 백업파일을 사용하면서 올라오는지 확인해봄
테스트
샘플 테이블 생성
|
1
2
3
4
5
|
SQL>
create table tbl1 as select * from dba_objects;
insert into tbl1 select * from tbl1;
..반복해서 1gb까지 생성
commit;
|
로그스위치 5번, 체크포인트 5번 수행(아래 sql을 lscp.sql로 저장)
|
1
2
3
4
5
6
7
8
9
10
11
|
SQL>
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
alter system checkpoint;
alter system checkpoint;
alter system checkpoint;
alter system checkpoint;
alter system checkpoint;
|
1차 풀백업
|
1
2
3
4
5
6
7
8
|
$ rman target /
RMAN> run {
allocate channel c1 type disk;
allocate channel c2 type disk;
backup incremental level 0 database format '/oradata1/rman/level0_%T_%U';
release channel c1;
release channel c2;
}
|
추가 테이블 생성
|
1
2
3
|
SQL> create table tbl2 as select * from tbl1;
Table created.
|
로그스위치 5번, 체크포인트 5번 수행
|
1
|
SQL> @lscp
|
1차 증분 백업
|
1
2
3
4
5
6
7
8
|
RMAN>
run {
allocate channel c1 type disk;
allocate channel c2 type disk;
backup incremental level 1 database format '/oradata1/rman/level1_%T_%U';
release channel c1;
release channel c2;
}
|
추가 테이블 생성
|
1
2
3
|
SQL> create table tbl3 as select * from tbl1;
Table created.
|
로그스위치 5번, 체크포인트 5번 수행
|
1
|
SQL> @lscp
|
2차 증분 백업
|
1
2
3
4
5
6
7
8
|
RMAN>
run {
allocate channel c1 type disk;
allocate channel c2 type disk;
backup incremental level 1 database format '/oradata1/rman/level1_%T_%U';
release channel c1;
release channel c2;
}
|
추가 테이블 생성
|
1
2
3
|
SQL> create table tbl4 as select * from tbl1;
Table created.
|
로그스위치 5번, 체크포인트 5번 수행
|
1
|
SQL> @lscp
|
3차 증분 백업
|
1
2
3
4
5
6
7
8
|
RMAN>
run {
allocate channel c1 type disk;
allocate channel c2 type disk;
backup incremental level 1 database format '/oradata1/rman/level1_%T_%U';
release channel c1;
release channel c2;
}
|
추가 테이블 생성
|
1
2
3
|
SQL> create table tbl5 as select * from tbl1;
Table created.
|
로그스위치 5번, 체크포인트 5번 수행
|
1
|
SQL> @lscp
|
현재 테이블들 확인
|
1
2
3
4
5
6
7
8
9
|
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
---------- ------------- ----------
TBL1 TABLE
TBL2 TABLE
TBL3 TABLE
TBL4 TABLE
TBL5 TABLE
|
5개 존재함
각각 tbl1이 풀백업 직전에 생성한 테이블, tbl2가 1차 증분 백업 직전에 생성한 테이블,
tbl3이 2차 증분 백업 직전에 생성한 테이블, tbl4가 3차 증분 백업 직전에 생성한 테이블,
tbl5가 3차 증분 백업 후에 생성한 테이블임
시간 확인
|
1
2
3
4
5
|
SQL> select to_char(sysdate, 'yyyy/mm/dd hh24:mi:ss') from dual;
TO_CHAR(SYSDATE,'YY
-------------------
2025/05/12 20:09:00
|
아카이브로그 백업
|
1
2
3
4
5
6
7
8
|
RMAN>
run {
allocate channel c1 type disk;
allocate channel c2 type disk;
backup archivelog all not backed up delete input format '/oradata1/rman/arc_%T_%U';
release channel c1;
release channel c2;
}
|
아카이브로그를 백업하고 백업된 아카이브로그는 모두 지웠음
백업 summary 확인
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
RMAN> list backup summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- ------------------- ------- ------- ---------- ---
1 B F A DISK 2025-05-12 11:21:47 1 1 NO TAG20250512T112147
2 B 0 A DISK 2025-05-12 19:42:42 1 1 NO TAG20250512T194238
3 B 0 A DISK 2025-05-12 19:42:43 1 1 NO TAG20250512T194238
4 B F A DISK 2025-05-12 19:42:46 1 1 NO TAG20250512T194246 <<--
5 B 1 A DISK 2025-05-12 19:45:43 1 1 NO TAG20250512T194541
6 B 1 A DISK 2025-05-12 19:45:46 1 1 NO TAG20250512T194541
7 B F A DISK 2025-05-12 19:45:48 1 1 NO TAG20250512T194548 <<--
8 B 1 A DISK 2025-05-12 19:50:50 1 1 NO TAG20250512T195047
9 B 1 A DISK 2025-05-12 19:50:54 1 1 NO TAG20250512T195047
10 B F A DISK 2025-05-12 19:50:55 1 1 NO TAG20250512T195055 <<--
11 B 1 A DISK 2025-05-12 19:51:52 1 1 NO TAG20250512T195150
12 B 1 A DISK 2025-05-12 19:51:58 1 1 NO TAG20250512T195150
13 B F A DISK 2025-05-12 19:52:05 1 1 NO TAG20250512T195205 <<--
18 B A A DISK 2025-05-12 20:15:15 1 1 NO TAG20250512T201506
19 B A A DISK 2025-05-12 20:15:19 1 1 NO TAG20250512T201506
20 B A A DISK 2025-05-12 20:15:22 1 1 NO TAG20250512T201506
21 B F A DISK 2025-05-12 20:15:22 1 1 NO TAG20250512T201522 <<--
|
처음을 제외하곤 모두 incremental 1 백업을 했는데 full 백업(F)이 중간중간에 존재함
sql로 백업 확인
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
SQL>
set lines 200 pages 1000
col handle for a70
select bs.recid, bs.incremental_level, bs.backup_type, to_char(bs.completion_time, 'yyyy/mm/dd hh24:mi:ss') completion_time, bp.handle
from v$backup_set bs ,v$backup_piece bp
where bs.set_stamp = bp.set_stamp
and bs.set_count = bp.set_count
order by bs.completion_time;
RECID INCREMENTAL_LEVEL B COMPLETION_TIME HANDLE
---------- ----------------- - ------------------- ----------------------------------------------------------------------
1 D 2025/05/12 11:21:47 /oradata1/rman/db_ctl_c-3371275020-20250512-01
2 0 I 2025/05/12 19:42:42 /oradata1/rman/level0_20250512_043p9tde_1_1
3 0 I 2025/05/12 19:42:43 /oradata1/rman/level0_20250512_033p9tde_1_1
4 D 2025/05/12 19:42:46 /oradata1/rman/db_ctl_c-3371275020-20250512-03 <<--
5 1 I 2025/05/12 19:45:43 /oradata1/rman/level1_20250512_083p9tj5_1_1
6 1 I 2025/05/12 19:45:46 /oradata1/rman/level1_20250512_073p9tj5_1_1
7 D 2025/05/12 19:45:48 /oradata1/rman/db_ctl_c-3371275020-20250512-04 <<--
8 1 I 2025/05/12 19:50:50 /oradata1/rman/level1_20250512_0b3p9tsn_1_1
9 1 I 2025/05/12 19:50:54 /oradata1/rman/level1_20250512_0a3p9tsn_1_1
10 D 2025/05/12 19:50:55 /oradata1/rman/db_ctl_c-3371275020-20250512-05 <<--
11 1 I 2025/05/12 19:51:52 /oradata1/rman/level1_20250512_0e3p9tum_1_1
12 1 I 2025/05/12 19:51:58 /oradata1/rman/level1_20250512_0d3p9tum_1_1
13 D 2025/05/12 19:52:05 /oradata1/rman/db_ctl_c-3371275020-20250512-06 <<--
18 L 2025/05/12 20:15:15 /oradata1/rman/arc_20250512_0l3p9vaa_1_1
19 L 2025/05/12 20:15:19 /oradata1/rman/arc_20250512_0k3p9vaa_1_1
20 L 2025/05/12 20:15:22 /oradata1/rman/arc_20250512_0m3p9vaq_1_1
21 D 2025/05/12 20:15:22 /oradata1/rman/db_ctl_c-3371275020-20250512-08 <<--
17 rows selected.
|
일부 풀백업으로 받아진건 컨트롤파일이었음, 나머지는 정상적으로 증분백업 받아짐
현재시점 컨트롤파일 백업
|
1
2
3
|
SQL> alter database backup controlfile to '/home/oracle/2025.ctl';
Database altered.
|
db abort 종료
|
1
|
SQL> shutdown abort
|
모든 데이터가 삭제되었다고 가정함
|
1
|
$ rm -rf /oradata1/ORACLE19/*
|
nomount 기동
|
1
2
3
4
5
6
7
8
|
SQL> startup nomount
ORACLE instance started.
Total System Global Area 1526722880 bytes
Fixed Size 8896832 bytes
Variable Size 369098752 bytes
Database Buffers 1140850688 bytes
Redo Buffers 7876608 bytes
|
컨트롤파일 restore
|
1
2
3
4
5
6
7
8
9
10
11
|
$ rman target /
RMAN> restore controlfile from '/home/oracle/2025.ctl';
Starting restore at 2025-05-12 20:23:19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=13 device type=DISK
channel ORA_DISK_1: copied control file copy
output file name=/oradata1/ORACLE19/control01.ctl
output file name=/oradata1/ORACLE19/control02.ctl
Finished restore at 2025-05-12 20:23:21
|
mount 모드로 변경
|
1
2
3
4
|
RMAN> alter database mount;
released channel: ORA_DISK_1
Statement processed
|
restore 및 recover 수행
|
1
2
3
4
5
6
7
8
|
RMAN>
run {
set until time "to_date('2025-05-12 20:09:00', 'yyyy-mm-dd hh24:mi:ss')";
allocate channel c1 type disk;
restore database;
recover database;
release channel c1;
}
|
상세 로그
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
|
RMAN> run {
set until time "to_date('2025-05-12 20:09:00', 'yyyy-mm-dd hh24:mi:ss')";
allocate channel c1 type disk;
restore database;
recover database;
release channel c1;
}2> 3> 4> 5> 6> 7>
executing command: SET until clause
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=138 device type=DISK
##먼저 incremental level 0(full) 백업부터 restore 진행함
##level0_20250512_043p9tde_1_1 과 level0_20250512_033p9tde_1_1 백업본임
Starting restore at 2025-05-12 22:21:10
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00001 to /oradata1/ORACLE19/system01.dbf
channel c1: restoring datafile 00004 to /oradata1/ORACLE19/undotbs01.dbf
channel c1: reading from backup piece /oradata1/rman/level0_20250512_043p9tde_1_1
channel c1: piece handle=/oradata1/rman/level0_20250512_043p9tde_1_1 tag=TAG20250512T194238
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:15
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00003 to /oradata1/ORACLE19/sysaux01.dbf
channel c1: restoring datafile 00007 to /oradata1/ORACLE19/users01.dbf
channel c1: reading from backup piece /oradata1/rman/level0_20250512_033p9tde_1_1
channel c1: piece handle=/oradata1/rman/level0_20250512_033p9tde_1_1 tag=TAG20250512T194238
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:25
Finished restore at 2025-05-12 22:21:50
##recover가 시작됨(incremental level 1 백업은 recover 때 restore됨)
Starting recover at 2025-05-12 22:21:50
##첫번째 incremental level 1 백업본중 하나를 restore 진행함
##level1_20250512_083p9tj5_1_1 백업본임
channel c1: starting incremental datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /oradata1/ORACLE19/system01.dbf
destination for restore of datafile 00004: /oradata1/ORACLE19/undotbs01.dbf
channel c1: reading from backup piece /oradata1/rman/level1_20250512_083p9tj5_1_1
channel c1: piece handle=/oradata1/rman/level1_20250512_083p9tj5_1_1 tag=TAG20250512T194541
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:01
##이후 첫번째 incremental level 1 백업본중 하나를 restore 진행함
##level1_20250512_073p9tj5_1_1 백업본임
channel c1: starting incremental datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00003: /oradata1/ORACLE19/sysaux01.dbf
destination for restore of datafile 00007: /oradata1/ORACLE19/users01.dbf
channel c1: reading from backup piece /oradata1/rman/level1_20250512_073p9tj5_1_1
channel c1: piece handle=/oradata1/rman/level1_20250512_073p9tj5_1_1 tag=TAG20250512T194541
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:35
##이후 두번째 incremental level 1 백업본중 하나를 restore 진행함
##level1_20250512_0b3p9tsn_1_1 백업본임
channel c1: starting incremental datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /oradata1/ORACLE19/system01.dbf
destination for restore of datafile 00004: /oradata1/ORACLE19/undotbs01.dbf
channel c1: reading from backup piece /oradata1/rman/level1_20250512_0b3p9tsn_1_1
channel c1: piece handle=/oradata1/rman/level1_20250512_0b3p9tsn_1_1 tag=TAG20250512T195047
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:01
##이후 두번째 incremental level 1 백업본중 하나를 restore 진행함
##level1_20250512_0a3p9tsn_1_1 백업본임
channel c1: starting incremental datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00003: /oradata1/ORACLE19/sysaux01.dbf
destination for restore of datafile 00007: /oradata1/ORACLE19/users01.dbf
channel c1: reading from backup piece /oradata1/rman/level1_20250512_0a3p9tsn_1_1
channel c1: piece handle=/oradata1/rman/level1_20250512_0a3p9tsn_1_1 tag=TAG20250512T195047
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:25
##이후 세번째 incremental level 1 백업본중 하나를 restore 진행함
##level1_20250512_0e3p9tum_1_1 백업본임
channel c1: starting incremental datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /oradata1/ORACLE19/system01.dbf
destination for restore of datafile 00004: /oradata1/ORACLE19/undotbs01.dbf
channel c1: reading from backup piece /oradata1/rman/level1_20250512_0e3p9tum_1_1
channel c1: piece handle=/oradata1/rman/level1_20250512_0e3p9tum_1_1 tag=TAG20250512T195150
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:01
##마지막으로 세번째 incremental level 1 백업본중 하나를 restore 진행함
##level1_20250512_0d3p9tum_1_1 백업본임
channel c1: starting incremental datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00003: /oradata1/ORACLE19/sysaux01.dbf
destination for restore of datafile 00007: /oradata1/ORACLE19/users01.dbf
channel c1: reading from backup piece /oradata1/rman/level1_20250512_0d3p9tum_1_1
channel c1: piece handle=/oradata1/rman/level1_20250512_0d3p9tum_1_1 tag=TAG20250512T195150
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:25
##media recovery 시작
starting media recovery
##아카이브로그 restore 시작1(datafile에 변경사항 적용)
##arc_20250512_0l3p9vaa_1_1 백업본임
channel c1: starting archived log restore to default destination
channel c1: restoring archived log
archived log thread=1 sequence=26
channel c1: restoring archived log
archived log thread=1 sequence=27
channel c1: restoring archived log
archived log thread=1 sequence=28
channel c1: restoring archived log
archived log thread=1 sequence=29
channel c1: restoring archived log
archived log thread=1 sequence=30
channel c1: restoring archived log
archived log thread=1 sequence=31
channel c1: reading from backup piece /oradata1/rman/arc_20250512_0l3p9vaa_1_1
channel c1: piece handle=/oradata1/rman/arc_20250512_0l3p9vaa_1_1 tag=TAG20250512T201506
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:07
archived log file name=/oradata1/arch/oracle19_1_26_1191078862.arc thread=1 sequence=26
archived log file name=/oradata1/arch/oracle19_1_27_1191078862.arc thread=1 sequence=27
archived log file name=/oradata1/arch/oracle19_1_28_1191078862.arc thread=1 sequence=28
archived log file name=/oradata1/arch/oracle19_1_29_1191078862.arc thread=1 sequence=29
archived log file name=/oradata1/arch/oracle19_1_30_1191078862.arc thread=1 sequence=30
archived log file name=/oradata1/arch/oracle19_1_31_1191078862.arc thread=1 sequence=31
##아카이브로그 restore 시작2(datafile에 변경사항 적용)
##arc_20250512_0m3p9vaq_1_1 백업본임
channel c1: starting archived log restore to default destination
channel c1: restoring archived log
archived log thread=1 sequence=32
channel c1: reading from backup piece /oradata1/rman/arc_20250512_0m3p9vaq_1_1
channel c1: piece handle=/oradata1/rman/arc_20250512_0m3p9vaq_1_1 tag=TAG20250512T201506
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:01
archived log file name=/oradata1/arch/oracle19_1_32_1191078862.arc thread=1 sequence=32
media recovery complete, elapsed time: 00:00:00
Finished recover at 2025-05-12 22:23:33
released channel: c1
|
작업이 모두 완료됨
alert log 확인(run 블록 실행시점부터)
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
|
$ tail -300f /ORA19/app/oracle/diag/rdbms/oracle19/oracle19/trace/alert_oracle19.log
##처음엔 datafile을 찾을수 없어 에러가 발생함
2025-05-12T22:21:10.301270+09:00
Errors in file /ORA19/app/oracle/diag/rdbms/oracle19/oracle19/trace/oracle19_mz00_2316166.trc:
ORA-01110: data file 1: '/oradata1/ORACLE19/system01.dbf'
ORA-01565: error in identifying file '/oradata1/ORACLE19/system01.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2025-05-12T22:21:10.998098+09:00
Errors in file /ORA19/app/oracle/diag/rdbms/oracle19/oracle19/trace/oracle19_mz00_2316166.trc:
ORA-01110: data file 3: '/oradata1/ORACLE19/sysaux01.dbf'
ORA-01565: error in identifying file '/oradata1/ORACLE19/sysaux01.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2025-05-12T22:21:12.764401+09:00
Errors in file /ORA19/app/oracle/diag/rdbms/oracle19/oracle19/trace/oracle19_mz00_2316166.trc:
ORA-01110: data file 4: '/oradata1/ORACLE19/undotbs01.dbf'
ORA-01210: data file header is media corrupt
2025-05-12T22:21:14.867053+09:00
Errors in file /ORA19/app/oracle/diag/rdbms/oracle19/oracle19/trace/oracle19_mz00_2316166.trc:
ORA-01110: data file 7: '/oradata1/ORACLE19/users01.dbf'
ORA-01565: error in identifying file '/oradata1/ORACLE19/users01.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
##이후 full 백업의 데이터 파일별 restore가 완료됨
2025-05-12T22:21:16.981950+09:00
Checker run found 5 new persistent data failures
2025-05-12T22:21:18.246891+09:00
Full restore complete of datafile 4 /oradata1/ORACLE19/undotbs01.dbf. Elapsed time: 0:00:08
checkpoint is 2076407
last deallocation scn is 2070767
Undo Optimization current scn is 2072103
2025-05-12T22:21:19.898341+09:00
Full restore complete of datafile 1 /oradata1/ORACLE19/system01.dbf. Elapsed time: 0:00:09
checkpoint is 2076407
last deallocation scn is 2041082
Undo Optimization current scn is 2072103
2025-05-12T22:21:28.109243+09:00
Full restore complete of datafile 3 /oradata1/ORACLE19/sysaux01.dbf. Elapsed time: 0:00:03
checkpoint is 2076406
last deallocation scn is 2043337
2025-05-12T22:21:48.082496+09:00
Full restore complete of datafile 7 /oradata1/ORACLE19/users01.dbf. Elapsed time: 0:00:23
checkpoint is 2076406
last deallocation scn is 2074023
##이후 증분 백업의 데이터 파일별 restore가 완료됨
2025-05-12T22:21:50.612919+09:00
Incremental restore complete of datafile 4 /oradata1/ORACLE19/undotbs01.dbf
checkpoint is 2078454
last deallocation scn is 2070767
Incremental restore complete of datafile 1 /oradata1/ORACLE19/system01.dbf
checkpoint is 2078454
last deallocation scn is 2041082
2025-05-12T22:21:56.050666+09:00
Incremental restore complete of datafile 3 /oradata1/ORACLE19/sysaux01.dbf
checkpoint is 2078453
last deallocation scn is 2043337
2025-05-12T22:22:18.730022+09:00
Incremental restore complete of datafile 7 /oradata1/ORACLE19/users01.dbf
checkpoint is 2078453
last deallocation scn is 2074023
2025-05-12T22:22:26.667249+09:00
Incremental restore complete of datafile 4 /oradata1/ORACLE19/undotbs01.dbf
checkpoint is 2080388
last deallocation scn is 2070767
Incremental restore complete of datafile 1 /oradata1/ORACLE19/system01.dbf
checkpoint is 2080388
last deallocation scn is 2041082
2025-05-12T22:22:27.707374+09:00
Incremental restore complete of datafile 3 /oradata1/ORACLE19/sysaux01.dbf
checkpoint is 2080387
last deallocation scn is 2043337
2025-05-12T22:22:45.223946+09:00
Incremental restore complete of datafile 7 /oradata1/ORACLE19/users01.dbf
checkpoint is 2080387
last deallocation scn is 2074023
2025-05-12T22:22:52.725390+09:00
Incremental restore complete of datafile 4 /oradata1/ORACLE19/undotbs01.dbf
checkpoint is 2082367
last deallocation scn is 2070767
Incremental restore complete of datafile 1 /oradata1/ORACLE19/system01.dbf
checkpoint is 2082367
last deallocation scn is 2041082
2025-05-12T22:22:53.762567+09:00
Incremental restore complete of datafile 3 /oradata1/ORACLE19/sysaux01.dbf
checkpoint is 2082366
last deallocation scn is 2043337
2025-05-12T22:23:11.431756+09:00
Incremental restore complete of datafile 7 /oradata1/ORACLE19/users01.dbf
checkpoint is 2082366
last deallocation scn is 2074023
2025-05-12T22:23:18.783650+09:00
alter database recover datafile list clear
Completed: alter database recover datafile list clear
alter database recover datafile list
1 , 3 , 4 , 7
Completed: alter database recover datafile list
1 , 3 , 4 , 7
alter database recover
if needed start until time '2025/05/12 20:09:00' using backup controlfile
##media recovery가 시작됨(아카이브 로그 적용)
2025-05-12T22:23:18.786998+09:00
Media Recovery Start
Started logmerger process
2025-05-12T22:23:18.878164+09:00
Parallel Media Recovery started with 4 slaves
ORA-279 signalled during: alter database recover
if needed start until time '2025/05/12 20:09:00' using backup controlfile
...
2025-05-12T22:23:26.212824+09:00
alter database recover logfile '/oradata1/arch/oracle19_1_26_1191078862.arc'
2025-05-12T22:23:26.212970+09:00
Media Recovery Log /oradata1/arch/oracle19_1_26_1191078862.arc
2025-05-12T22:23:30.172630+09:00
ORA-279 signalled during: alter database recover logfile '/oradata1/arch/oracle19_1_26_1191078862.arc'...
alter database recover logfile '/oradata1/arch/oracle19_1_27_1191078862.arc'
2025-05-12T22:23:30.191596+09:00
Media Recovery Log /oradata1/arch/oracle19_1_27_1191078862.arc
2025-05-12T22:23:31.233387+09:00
ORA-279 signalled during: alter database recover logfile '/oradata1/arch/oracle19_1_27_1191078862.arc'...
alter database recover logfile '/oradata1/arch/oracle19_1_28_1191078862.arc'
2025-05-12T22:23:31.249502+09:00
Media Recovery Log /oradata1/arch/oracle19_1_28_1191078862.arc
ORA-279 signalled during: alter database recover logfile '/oradata1/arch/oracle19_1_28_1191078862.arc'...
alter database recover logfile '/oradata1/arch/oracle19_1_29_1191078862.arc'
2025-05-12T22:23:31.478210+09:00
Media Recovery Log /oradata1/arch/oracle19_1_29_1191078862.arc
ORA-279 signalled during: alter database recover logfile '/oradata1/arch/oracle19_1_29_1191078862.arc'...
alter database recover logfile '/oradata1/arch/oracle19_1_30_1191078862.arc'
2025-05-12T22:23:31.698638+09:00
Media Recovery Log /oradata1/arch/oracle19_1_30_1191078862.arc
ORA-279 signalled during: alter database recover logfile '/oradata1/arch/oracle19_1_30_1191078862.arc'...
alter database recover logfile '/oradata1/arch/oracle19_1_31_1191078862.arc'
2025-05-12T22:23:31.919219+09:00
Media Recovery Log /oradata1/arch/oracle19_1_31_1191078862.arc
ORA-279 signalled during: alter database recover logfile '/oradata1/arch/oracle19_1_31_1191078862.arc'...
2025-05-12T22:23:33.168437+09:00
alter database recover logfile '/oradata1/arch/oracle19_1_32_1191078862.arc'
2025-05-12T22:23:33.168567+09:00
Media Recovery Log /oradata1/arch/oracle19_1_32_1191078862.arc
2025-05-12T22:23:33.230667+09:00
Incomplete Recovery applied until change 2091925 time 05/12/2025 20:09:18
2025-05-12T22:23:33.232040+09:00
Media Recovery Complete (oracle19)
Completed: alter database recover logfile '/oradata1/arch/oracle19_1_32_1191078862.arc'
|
restore, recover가 완료됨
resetlogs로 open
|
1
2
3
|
RMAN> alter database open resetlogs;
Statement processed
|
open 됨
alert log 확인
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
|
$ tail -300f /ORA19/app/oracle/diag/rdbms/oracle19/oracle19/trace/alert_oracle19.log
2025-05-12T22:30:47.134230+09:00
alter database open resetlogs
2025-05-12T22:30:47.137260+09:00
RESETLOGS after incomplete recovery UNTIL CHANGE 2091925 time 05/12/2025 20:09:18
##rman 백업에 redo가 없기 때문에 처음에 에러가 발생함
2025-05-12T22:30:47.139928+09:00
Errors in file /ORA19/app/oracle/diag/rdbms/oracle19/oracle19/trace/oracle19_ora_2316017.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/oradata1/ORACLE19/redo01.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2025-05-12T22:30:47.140094+09:00
Errors in file /ORA19/app/oracle/diag/rdbms/oracle19/oracle19/trace/oracle19_ora_2316017.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/oradata1/ORACLE19/redo01.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2025-05-12T22:30:47.140460+09:00
Errors in file /ORA19/app/oracle/diag/rdbms/oracle19/oracle19/trace/oracle19_ora_2316017.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/oradata1/ORACLE19/redo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2025-05-12T22:30:47.140598+09:00
Errors in file /ORA19/app/oracle/diag/rdbms/oracle19/oracle19/trace/oracle19_ora_2316017.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/oradata1/ORACLE19/redo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2025-05-12T22:30:47.140895+09:00
Errors in file /ORA19/app/oracle/diag/rdbms/oracle19/oracle19/trace/oracle19_ora_2316017.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/oradata1/ORACLE19/redo03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2025-05-12T22:30:47.141014+09:00
Errors in file /ORA19/app/oracle/diag/rdbms/oracle19/oracle19/trace/oracle19_ora_2316017.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/oradata1/ORACLE19/redo03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2025-05-12T22:30:47.142548+09:00
Errors in file /ORA19/app/oracle/diag/rdbms/oracle19/oracle19/trace/oracle19_ora_2316017.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/oradata1/ORACLE19/redo01.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2025-05-12T22:30:47.142668+09:00
Errors in file /ORA19/app/oracle/diag/rdbms/oracle19/oracle19/trace/oracle19_ora_2316017.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/oradata1/ORACLE19/redo01.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
.... (PID:2316017): Clearing online redo logfile 1 /oradata1/ORACLE19/redo01.log
2025-05-12T22:30:47.143231+09:00
Errors in file /ORA19/app/oracle/diag/rdbms/oracle19/oracle19/trace/oracle19_ora_2316017.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/oradata1/ORACLE19/redo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2025-05-12T22:30:47.143412+09:00
Errors in file /ORA19/app/oracle/diag/rdbms/oracle19/oracle19/trace/oracle19_ora_2316017.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/oradata1/ORACLE19/redo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
.... (PID:2316017): Clearing online redo logfile 2 /oradata1/ORACLE19/redo02.log
2025-05-12T22:30:47.143912+09:00
Errors in file /ORA19/app/oracle/diag/rdbms/oracle19/oracle19/trace/oracle19_ora_2316017.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/oradata1/ORACLE19/redo03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2025-05-12T22:30:47.144051+09:00
Errors in file /ORA19/app/oracle/diag/rdbms/oracle19/oracle19/trace/oracle19_ora_2316017.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/oradata1/ORACLE19/redo03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
.... (PID:2316017): Clearing online redo logfile 3 /oradata1/ORACLE19/redo03.log
Clearing online log 1 of thread 1 sequence number 34
2025-05-12T22:30:47.144662+09:00
Errors in file /ORA19/app/oracle/diag/rdbms/oracle19/oracle19/trace/oracle19_ora_2316017.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/oradata1/ORACLE19/redo01.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2025-05-12T22:30:47.144806+09:00
Errors in file /ORA19/app/oracle/diag/rdbms/oracle19/oracle19/trace/oracle19_ora_2316017.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/oradata1/ORACLE19/redo01.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
Clearing online log 2 of thread 1 sequence number 32
2025-05-12T22:30:47.145172+09:00
Errors in file /ORA19/app/oracle/diag/rdbms/oracle19/oracle19/trace/oracle19_ora_2316017.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/oradata1/ORACLE19/redo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2025-05-12T22:30:47.145331+09:00
Errors in file /ORA19/app/oracle/diag/rdbms/oracle19/oracle19/trace/oracle19_ora_2316017.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/oradata1/ORACLE19/redo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
Clearing online log 3 of thread 1 sequence number 33
2025-05-12T22:30:47.145703+09:00
Errors in file /ORA19/app/oracle/diag/rdbms/oracle19/oracle19/trace/oracle19_ora_2316017.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/oradata1/ORACLE19/redo03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2025-05-12T22:30:47.145856+09:00
Errors in file /ORA19/app/oracle/diag/rdbms/oracle19/oracle19/trace/oracle19_ora_2316017.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/oradata1/ORACLE19/redo03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
##redo를 클렌징하고 재생성함
2025-05-12T22:30:52.422235+09:00
.... (PID:2316017): Clearing online redo logfile 1 complete
.... (PID:2316017): Clearing online redo logfile 2 complete
.... (PID:2316017): Clearing online redo logfile 3 complete
Resetting resetlogs activation ID 3371285772 (0xc8f1bd0c)
Online log /oradata1/ORACLE19/redo01.log: Thread 1 Group 1 was previously cleared
Online log /oradata1/ORACLE19/redo02.log: Thread 1 Group 2 was previously cleared
Online log /oradata1/ORACLE19/redo03.log: Thread 1 Group 3 was previously cleared
##새로운 인카네이션 3을 부여 받음
2025-05-12T22:30:52.437723+09:00
Setting recovery target incarnation to 3
2025-05-12T22:30:52.441203+09:00
Ping without log force is disabled:
instance mounted in exclusive mode.
Endian type of dictionary set to little
2025-05-12T22:30:52.456266+09:00
Assigning activation ID 3381208485 (0xc98925a5)
Redo log for group 1, sequence 1 is not located on DAX storage
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: /oradata1/ORACLE19/redo01.log
Successful open of redo thread 1
2025-05-12T22:30:52.466084+09:00
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
stopping change tracking
2025-05-12T22:30:52.502783+09:00
TT03 (PID:2320175): Sleep 5 seconds and then try to clear SRLs in 2 time(s)
2025-05-12T22:30:52.564760+09:00
Undo initialization recovery: err:0 start: 309007905 end: 309007917 diff: 12 ms (0.0 seconds)
[2316017] Successfully onlined Undo Tablespace 2.
Undo initialization online undo segments: err:0 start: 309007918 end: 309007947 diff: 29 ms (0.0 seconds)
Undo initialization finished serial:0 start:309007905 end:309007949 diff:44 ms (0.0 seconds)
Dictionary check beginning
##temp 파일도 rman 백업에 없어서 에러가 발생함
2025-05-12T22:30:52.616315+09:00
Errors in file /ORA19/app/oracle/diag/rdbms/oracle19/oracle19/trace/oracle19_dbw0_2315290.trc:
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/oradata1/ORACLE19/temp01.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2025-05-12T22:30:52.616562+09:00
Errors in file /ORA19/app/oracle/diag/rdbms/oracle19/oracle19/trace/oracle19_dbw0_2315290.trc:
ORA-01186: file 201 failed verification tests
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/oradata1/ORACLE19/temp01.dbf'
2025-05-12T22:30:52.616646+09:00
File 201 not verified due to error ORA-01157
2025-05-12T22:30:52.618114+09:00
Dictionary check complete
Verifying minimum file header compatibility for tablespace encryption..
Verifying file header compatibility for tablespace encryption completed for pdb 0
2025-05-12T22:30:52.619023+09:00
Errors in file /ORA19/app/oracle/diag/rdbms/oracle19/oracle19/trace/oracle19_dbw0_2315290.trc:
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/oradata1/ORACLE19/temp01.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2025-05-12T22:30:52.619258+09:00
Errors in file /ORA19/app/oracle/diag/rdbms/oracle19/oracle19/trace/oracle19_dbw0_2315290.trc:
ORA-01186: file 201 failed verification tests
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/oradata1/ORACLE19/temp01.dbf'
2025-05-12T22:30:52.619338+09:00
File 201 not verified due to error ORA-01157
##temp 파일도 자동 재생성됨
2025-05-12T22:30:52.620164+09:00
Re-creating tempfile /oradata1/ORACLE19/temp01.dbf
Database Characterset is KO16MSWIN949
No Resource Manager plan active
joxcsys_required_dirobj_exists: directory object exists with required path /ORA19/app/oracle/product/19.0.0/db_1/javavm/admin/, pid 2316017 cid 0
replication_dependency_tracking turned off (no async multimaster replication found)
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete
Starting background process AQPC
2025-05-12T22:30:53.026946+09:00
AQPC started with pid=49, OS id=2320178
Starting background process CJQ0
2025-05-12T22:30:53.144555+09:00
CJQ0 started with pid=50, OS id=2320180
Sequence 10 autobackup already exist, will retry with next sequence (retry: 1)
Control autobackup written to DISK device
handle '/oradata1/rman/db_ctl_c-3371275020-20250512-0b'
Completed: alter database open resetlogs
##open 완료됨, 패치정보 표시됨
2025-05-12T22:30:53.830883+09:00
QPI: opatch file present, opatch
QPI: qopiprep.bat file present
2025-05-12T22:30:55.158826+09:00
===========================================================
Dumping current patch information
===========================================================
Patch Id: 29517242
Patch Description: Database Release Update : 19.3.0.0.190416 (29517242)
Patch Apply Time: 2019-04-18T16:21:17+09:00
Bugs Fixed: 14735102,19697993,20313356,21965541,25806201,25883179,25986062,
26476244,26611353,26872233,27369515,27423500,27666312,27710072,27846298,
27957203,28064977,28072567,28129791,28181021,28210681,28279456,28313275,
28350595,28371123,28379065,28431445,28463226,28489419,28502773,28513333,
28534475,28561704,28569897,28572533,28572544,28587723,28593682,28594086,
28597221,28601957,28605066,28606598,28625862,28627033,28636532,28643718,
28644549,28645570,28646200,28646939,28649388,28655209,28663782,28673945,
28692275,28694872,28696373,28705231,28710385,28710734,28714461,28718469,
28730079,28740708,28760206,28772390,28774416,28777214,28789531,28791852,
28795551,28802734,28804517,28810381,28811560,28815123,28815355,28819640,
28824482,28833912,28835937,28862532,28863432,28873575,28876253,28876639,
28884931,28888327,28892794,28897512,28899663,28901126,28905457,28907196,
28912691,28915561,28917080,28918429,28919145,28922227,28922532,28922608,
28925634,28925880,28933158,28936114,28937717,28938698,28940179,28940281,
28941901,28942455,28945421,28945994,28951533,28952168,28954762,28955606,
28957292,28957723,28962775,28965231,28966444,28974083,28977322,28983095,
28983486,28986326,28986481,28988482,28989306,28993295,28994307,28996376,
29000000,29001888,29002927,29003738,29006318,29006621,29007321,29007775,
29008035,29011936,29013475,29014076,29015118,29017265,29018655,29019121,
29021063,29021352,29024552,29026582,29026606,29027456,29027694,29027940,
29031575,29031600,29032234,29032457,29032607,29033052,29033145,29033200,
29033280,29034587,29037290,29038528,29039089,29039510,29043554,29043651,
29043725,29044763,29044954,29047850,29048289,29048498,29048605,29050560,
29050765,29051702,29052726,29053783,29056024,29056270,29056560,29059011,
29061959,29062692,29062848,29062860,29062868,29110526,29110783,29110790,
29110797,29110802,29110805,29111598,29113282,29113305,29117526,29117642,
29119077,29120223,29122224,29122254,29123297,29123432,29123482,29124368,
29125380,29126345,29127957,29128935,29129450,29129497,29129712,29130219,
29131539,29132938,29134447,29136111,29138641,29141316,29141341,29141685,
29142667,29144995,29145214,29145730,29149829,29150338,29151520,29152357,
29155099,29157389,29158680,29158899,29159909,29159936,29160174,29162095,
29163415,29163437,29163524,29163567,29167111,29167342,29167374,29167940,
29168219,29168433,29169073,29169215,29171942,29172618,29172826,29173140,
29173373,29173817,29174004,29176318,29177466,29177543,29177886,29178385,
29180313,29180455,29180559,29180893,29181153,29181231,29181620,29181743,
29181923,29182019,29183912,29184297,29184666,29185193,29186456,29189302,
29189307,29189889,29190235,29190474,29190740,29191541,29192419,29192468,
29192685,29193207,29194205,29194367,29194493,29194827,29195279,29195337,
29195758,29196725,29199635,29199733,29200316,29200700,29201494,29201539,
29202104,29202850,29203122,29203166,29203425,29203443,29203604,29205281,
29205323,29205419,29205463,29205767,29205918,29206109,29206605,29207073,
29208260,29208732,29211457,29211724,29212012,29212433,29212611,29213351,
29213775,29213850,29213879,29214561,29214960,29216746,29216984,29217294,
29217472,29217828,29217848,29218570,29219205,29219273,29220079,29221248,
29221891,29222031,29222784,29223833,29223859,29223967,29224065,29224605,
29225076,29227602,29228869,29229164,29229754,29229844,29229955,29230252,
29230565,29231133,29232117,29232154,29234123,29237538,29240307,29241345,
29242017,29242884,29243958,29245137,29245160,29246163,29247415,29247712,
29247906,29248552,29248835,29248858,29249991,29250059,29251259,29253184,
29253871,29254031,29254930,29255178,29255273,29255431,29255435,29256426,
29259119,29259320,29261906,29262512,29262887,29265448,29266248,29266899,
29267292,29268412,29269171,29270585,29273539,29273735,29273847,29274428,
29274564,29274627,29275461,29278218,29279658,29279751,29279854,29282898,
29285503,29285788,29285956,29286037,29287130,29287705,29292837,29293072,
29297863,29297915,29298220,29299049,29299082,29299844,29301566,29302963,
29303918,29304781,29311588,29312310,29312734,29312753,29313347,29313417,
29313525,29314539,29318410,29319441,29321489,29323946,29324568,29325087,
29325105,29325257,29325993,29327044,29329087,29331209,29331380,29331493,
29332771,29333500,29337310,29338315,29338453,29338780,29338913,29339155,
29341209,29343086,29346943,29347620,29348176,29350052,29351386,29351716,
29351749,29352867,29353271,29355654,29356547,29356752,29358828,29360672,
29361801,29363151,29364171,29364177,29367019,29367561,29368253,29373418,
29373588,29374179,29377986,29378029,29379978,29382784,29385652,29386502,
29386635,29386660,29387274,29388094,29388524,29388830,29389889,29390435,
29394140,29394749,29397954,29398863,29399100,29399121,29405012,29405651,
29412066,29412269,29417884,29423826,29429264,29429566,29431485,29435652,
29438736,29439522,29450421,29451386,29452576,29452953,29457807,29460252,
29462957,29486181,29507616,29515240,29521748,29530812,29531654,29557336,
29558975,29601461
Patch Id: 29585399
Patch Description: OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
Patch Apply Time: 2019-04-18T16:21:33+09:00
Bugs Fixed: 3,27222128,27572040,27604329,27760043,27877830,28302580,28470673,
28621543,28642469,28699321,28710663,28755846,28772816,28785321,28800508,
28808652,28815557,28847541,28847572,28870496,28871040,28874416,28877252,
28881191,28881848,28888083,28911140,28925250,28925460,28935956,28940472,
28942694,28951332,28963036,28968779,28980448,28995287,29003207,29003617,
29016294,29018680,29024876,29026154,29027933,29047127,29052850,29058476,
29111631,29112455,29117337,29123444,29125708,29125786,29129476,29131772,
29132456,29139727,29146157,29147849,29149170,29152603,29152752,29154631,
29154636,29154829,29159216,29159661,29160462,29161923,29169540,29169739,
29170717,29173618,29181568,29182920,29183298,29186091,29191827,29201143,
29201695,29209545,29210577,29210610,29210624,29210683,29213641,29219627,
29224294,29225861,29229839,29235934,29242906,29243749,29244495,29244766,
29244968,29248723,29249583,29251564,29255616,29260224,29261695,29271019,
29273360,29282090,29282666,29285453,29285621,29290235,29292232,29293806,
29294753,29299830,29307090,29307109,29311336,29329675,29330791,29339299,
29357821,29360467,29360775,29367971,29368725,29379299,29379381,29380527,
29381000,29382296,29391301,29393649,29402110,29411931,29413360,29457319,
29465047
===========================================================
2025-05-12T22:30:56.364345+09:00
Setting Resource Manager plan SCHEDULER[0x4D52]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2025-05-12T22:30:56.969411+09:00
Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
2025-05-12T22:31:13.561488+09:00
End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
|
정상적으로 기동됨
복구 후 테이블 확인
|
1
2
3
4
5
6
7
8
9
|
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
---------- ------------- ----------
TBL1 TABLE
TBL2 TABLE
TBL3 TABLE
TBL4 TABLE
TBL5 TABLE
|
정상적으로 5개 모두 존재함
참고용. 테스트시 사용한 처음 테스트 상태로 복구하는 스크립트
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
sqlplus / as sysdba << EOF
shutdown abort
EOF
rm -rf /oradata1/ORACLE19/*
rm -rf /oradata1/arch/*
rman target / << EOF
startup nomount
restore controlfile from '/home/oracle/2025.ctl';
alter database mount;
EOF
run {
set until time "to_date('2025-05-12 20:09:00', 'yyyy-mm-dd hh24:mi:ss')";
allocate channel c1 type disk;
restore database;
recover database;
release channel c1;
}
|
결론 :
풀백업, 증분백업 1,2,3차, 아카이브백업 후 풀백업 시점부터 다시 현재까지 복구가 정상적으로 완료됨
참조 :
'ORACLE > Backup&Recover' 카테고리의 다른 글
| 오라클 19c rman 일부 테이블스페이스 백업 후 복구 시나리오 (0) | 2025.12.05 |
|---|---|
| 오라클 11g to 19c 업그레이드 시 restore point 이용 복원 테스트(compatible 변경) (0) | 2025.10.10 |
| 오라클 11g to 19c 업그레이드 시 restore point 이용 복원 테스트 (0) | 2025.10.08 |
| 오라클 19c 핫백업시 redo 발생량 차이 확인 (0) | 2025.10.03 |
| 오라클 19c rman 커맨드 빠른 참조 (0) | 2025.07.21 |