180326 불완전 백업(=Point Intime Recovery)
[oracle@localhost ~]$ export NLS_LANG=american_america.WE8ISO8859P15 // 해당하는 국가의 언어설정, 지역설정
[oracle@localhost ~]$ export NLS_DATE_FORMAT='yyyy-mm-dd:hh24:mi:ss' // 날짜 환경변수 설정
[oracle@localhost ~]$ sqlplus hr/hr
HR@orcl>select sysdate from dual;
SYSDATE
-------------------
2018-03-26:14:36:16
hr에서 로그 좀 쌓고...
.
.
SYS@orcl>alter system switch logfile
.
.
.
archive log list;
rman target /
shutdown abort
startup mount
restore database;
run{ // 볼완전 복구 명령어
set until time='2018-03-26:14:27:40'; << 세팅 형식에 맞게
recover database;}
alter database open resetlogs;
sys> archive log list 들어가면 현재 로그가 다 1로 맞춰져 있다.
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
delete obsolete; < 불필요한 것들 삭제
<rman에게 tbs 복구 후 경로를 재 지정해주는 쿼리문?>
RMAN> run{set newname for datafile 6 to '/home/oracle/haksa01.dbf';
2> restore tablespace haksa;}
카피로 백업 받기
RMAN> backup as copy datafile 6
2> format '/home/oracle/haksa01.bk';
<switch 경로지정 다른 방법>
>alter database rename datafile '/home/oracle/haksa01.bk' to '/u01/app/oracle/oradata/orcl/haksa01.dbf'
<오래 걸리는 작업 할 때 어느정도 되었는 지 상태 보여주는 쿼리문>
SYS@orcl>select opname, sofar, totalwork,
2 ROUND(sofar/totalwork*100,2) "%_completed"
3 FROM v$session_longops
4 WHERE opname LIKE 'RMAN%'
5 AND opname NOT LIKE '%aggregate%'
6 AND totalwork<>0
7 AND sofar<> totalwork;
no rows selected
SYS@orcl>save /home/oracle/labs/q_longops.sql
Created file /home/oracle/labs/q_longops.sql
SYS@orcl>alter tablespace users online;
Tablespace altered.
SYS@orcl>@/home/oracle/labs/q_longops
OPNAME SOFAR TOTALWORK %_completed
---------------------------------------------------------------- ---------- ---------- -----------
RMAN: full datafile backup 70586 303360 23.27
SYS@orcl>/
no rows selected
SYS@orcl>