Re: 오늘의 마지막 문제. 스스로 datafile 을 4개를 랜덤으로 삭제하고...

[21기_여상윤]

16:29:28 SYS @ oracle19 > startup force
ORACLE instance started.

Total System Global Area 2415917880 bytes
Fixed Size                  8899384 bytes
Variable Size             520093696 bytes
Database Buffers         1879048192 bytes
Redo Buffers                7876608 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7: '/u01/app/oracle/oradata/ORACLE19/users01.dbf'


16:29:49 SYS @ oracle19 > @i

STATUS
------------
MOUNTED

Elapsed: 00:00:00.00

16:29:51 SYS @ oracle19 > @r

     FILE# NAME
---------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
         7 /u01/app/oracle/oradata/ORACLE19/users01.dbf
         9 /u01/app/oracle/oradata/ORACLE19/ts834.dbf
        10 /u01/app/oracle/oradata/ORACLE19/ts834b.dbf
        11 /u01/app/oracle/oradata/ORACLE19/ts899.dbf

[oracle@ora19c ~]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Mon Sep 29 16:30:02 2025
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORACLE19 (DBID=3392684450, not open)

RMAN> alter database datafile 7 offline;

using target database control file instead of recovery catalog
Statement processed

RMAN> alter database datafile 9 offline;

Statement processed

RMAN> alter database datafile 10 offline;

Statement processed

RMAN> alter database datafile 11 offline;

Statement processed

RMAN> restore datafile 7;

Starting restore at 2025/09/29:16:31:23
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=138 device type=DISK

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 00007 to /u01/app/oracle/oradata/ORACLE19/users01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/ORACLE19/backupset/2025_09_29/o1_mf_nnndf_TAG20250929T162744_nfnf7k9b_.bkp
channel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/ORACLE19/backupset/2025_09_29/o1_mf_nnndf_TAG20250929T162744_nfnf7k9b_.bkp tag=TAG20250929T162744
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 2025/09/29:16:31:25

RMAN> restore datafile 9;

Starting restore at 2025/09/29:16:31:35
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 00009 to /u01/app/oracle/oradata/ORACLE19/ts834.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/ORACLE19/backupset/2025_09_29/o1_mf_nnndf_TAG20250929T162744_nfnf7k9b_.bkp
channel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/ORACLE19/backupset/2025_09_29/o1_mf_nnndf_TAG20250929T162744_nfnf7k9b_.bkp tag=TAG20250929T162744
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 2025/09/29:16:31:36

RMAN> restore datafile 10;

Starting restore at 2025/09/29:16:31:39
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 00010 to /u01/app/oracle/oradata/ORACLE19/ts834b.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/ORACLE19/backupset/2025_09_29/o1_mf_nnndf_TAG20250929T162744_nfnf7k9b_.bkp
channel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/ORACLE19/backupset/2025_09_29/o1_mf_nnndf_TAG20250929T162744_nfnf7k9b_.bkp tag=TAG20250929T162744
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 2025/09/29:16:31:40

RMAN> restore datafile 11;

Starting restore at 2025/09/29:16:31:44
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 00011 to /u01/app/oracle/oradata/ORACLE19/ts899.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/ORACLE19/backupset/2025_09_29/o1_mf_nnndf_TAG20250929T162744_nfnf7k9b_.bkp
channel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/ORACLE19/backupset/2025_09_29/o1_mf_nnndf_TAG20250929T162744_nfnf7k9b_.bkp tag=TAG20250929T162744
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 2025/09/29:16:31:45

RMAN> recover datafile 7;

Starting recover at 2025/09/29:16:32:49
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:01

Finished recover at 2025/09/29:16:32:50

RMAN> recover datafile 9;

Starting recover at 2025/09/29:16:33:01
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:00

Finished recover at 2025/09/29:16:33:01

RMAN> recover datafile 10;

Starting recover at 2025/09/29:16:33:04
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:00

Finished recover at 2025/09/29:16:33:04

RMAN> recover datafile 11;

Starting recover at 2025/09/29:16:33:06
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:00

Finished recover at 2025/09/29:16:33:06

RMAN> alter database datafile 7 online;

Statement processed

RMAN> alter database datafile 9 online;

Statement processed

RMAN> alter database datafile 10 online;

Statement processed

RMAN> alter database datafile 11 online;

Statement processed

RMAN> exit