[oracle@idisk ~]$ sqlplus /nolog
SQL*Plus: Release 12.2.0.1.0 Production on Wed Oct 20 12:21:54 2021
Copyright (c) 1982, 2016, Oracle. All rights reserved.
SQL> !rm /app/oracle/oradata/orcl/users01.dbf
SQL> !ls /app/oracle/oradata/orcl/users01.dbf
ls: cannot access /app/oracle/oradata/orcl/users01.dbf: ¡¾¡¿¡¤¡¾ ¨¡ÄÀÏÀÌ©ø¨£ µ©£¡¤¨¬ÅÍ¢¬¢ç¡Æ¢® ¨ú©ª¨öÀ¢¥Ï¢¥Ù
SQL> connect /as sysdba
???????.
SQL> shutdown immediate
ORA-01116: 7 ?????? ?? ??? ?????
ORA-01110: 7 ??? ??: '/app/oracle/oradata/orcl/users01.dbf'
ORA-27041: ??? ? ? ????
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
SQL> shutdown abort
ORACLE ????? ???????.
SQL> startup
ORACLE ????? ???????.
Total System Global Area 1.0100E+10 bytes
Fixed Size 8631096 bytes
Variable Size 1912605896 bytes
Database Buffers 8153726976 bytes
Redo Buffers 24920064 bytes
??????? ????????.
ORA-01157: ??? 7 ??? ?? ?? ?? ? ? ????- DBWR ?? ??? ????
ORA-01110: 7 ??? ??: '/app/oracle/oradata/orcl/users01.dbf'
SQL> quit
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production?? ???????.
[oracle@idisk ~]$ rman target / nocatalog
Recovery Manager: Release 12.2.0.1.0 - Production on Wed Oct 20 12:24:39 2021
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1602153044, not open)
using target database control file instead of recovery catalog
RMAN> restore datafile 7;
Starting restore at 20-OCT-21
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1110 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 /app/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: reading from backup piece /orabackup/backup/rman/010c3djc_1_1_20211020
channel ORA_DISK_1: piece handle=/orabackup/backup/rman/010c3djc_1_1_20211020 tag=TAG20211020T120252
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 20-OCT-21
RMAN> recover datafile 7;
Starting recover at 20-OCT-21
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:01
Finished recover at 20-OCT-21
RMAN> quit
Recovery Manager complete.
[oracle@idisk ~]$ sqlplus /nolog
SQL*Plus: Release 12.2.0.1.0 Production on Wed Oct 20 12:25:38 2021
Copyright (c) 1982, 2016, Oracle. All rights reserved.
SQL> connect /as sysdba
???????.
SQL> select status from v$instance;
STATUS
------------
MOUNTED
SQL> alter database open;
??????? ???????.
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL>
|