BACKRUSH  À¯´Ð½º¸í·É  ´ÙÀ½  ÀÚ·á½Ç  Ascii Table   ¿ø°ÝÁ¢¼Ó  ´Þ·Â,½Ã°£   ÇÁ·Î¼¼½º   ½©
ÁöÇÏö³ë¼±   RFC¹®¼­   SUN FAQ   SUN FAQ1   C¸Þ´º¾ó   PHP¸Þ´º¾ó   ³Ê±¸¸®   ¾Æ½ºÅ°¿ùµå ¾ÆÀÌÇǼ­Ä¡

±Û¾´ÀÌ: Rman Rman º¹±¸ Á¶È¸¼ö: 3544


[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>

°ü·Ã±Û : ¾øÀ½ ±Û¾´½Ã°£ : 2021/10/20 12:27 from 106.240.251.114

  ¸ñ·Ïº¸±â »õ±Û ¾²±â Áö¿ì±â ÀÀ´ä±Û ¾²±â ±Û ¼öÁ¤ Rman ¹é¾÷  
BACKRUSH  À¯´Ð½º¸í·É  ´ÙÀ½  ÀÚ·á½Ç  Ascii Table   ¿ø°ÝÁ¢¼Ó  ´Þ·Â,½Ã°£   ÇÁ·Î¼¼½º   ½©
ÁöÇÏö³ë¼±   RFC¹®¼­   SUN FAQ   SUN FAQ1   C¸Þ´º¾ó   PHP¸Þ´º¾ó   ³Ê±¸¸®   ¾Æ½ºÅ°¿ùµå ¾ÆÀÌÇǼ­Ä¡