BACKRUSH  유닉스명령  다음  자료실  Ascii Table   원격접속  달력,시간   프로세스  
지하철노선   RFC문서   SUN FAQ   SUN FAQ1   C메뉴얼   PHP메뉴얼   너구리   아스키월드 아이피서치

글쓴이: Rman Rman 복구 조회수: 934


[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메뉴얼   너구리   아스키월드 아이피서치