복구에 필요한 정보 보기

◈ logfile 정보 보기

set line 150
col tname format a10
col file_name format a40
col error format a10
col first_change# format 999,999,999,999
col OFFLINE_CHANGE# format 999,999,999,999
col ONLINE_CHANGE# format 999,999,999,999
col change# format 999,999,999,999
COL MEMBER format a45

SELECT A1.GROUP#, MEMBER, A1.STATUS, SEQUENCE#, FIRST_CHANGE#
FROM V$LOG A1, V$LOGFILE B2
WHERE A1.GROUP# = B2.GROUP# ;

◈ 복구가 필요한 datafile list 보기

col change# format 9999999999999999999999

select t.name tname, d.name file_name, r.change#,d.status, d.enabled, OFFLINE_CHANGE#,
ONLINE_CHANGE#, to_char(ONLINE_TIME,'RR/MM/DD:HH24:MI:SS') ONTIME
from v$tablespace t, v$datafile d, v$recover_file r
where t.ts#=d.ts# and d.file#=r.file#;

◈ tablespace 와 file의 status 보기

col fname format a50

select t.name TNAME, d.name FNAME, d.status, d.enabled, h.error header_err
from v$tablespace t, v$datafile d, v$datafile_header h
where t.ts#=d.ts# and h.file#=d.file#;

◈ 복구에 필요한 archive파일 리스트 보기

col name format a50

select a.name, a.sequence# , a.first_change#,
to_char(a.first_time,'YYYY/MM/DD:HH24:MI:SS') fst_time,
to_char(a.next_time,'YYYY/MM/DD:HH24:MI:SS') next_time
from v$archived_log a, v$recovery_log r
where a.sequence#=r.sequence#;

◈ recovery file status 보기

select * from V$RECOVERY_FILE_STATUS;

◈ recovery progress 보기

select * from v$recovery_progress;

◈ recovery status 보기

select * from v$recovery_status;

[출처] Oracle 복구에 필요한 정보 보는 방법|작성자 쏘심이