꿈꾸는 개발자, DBA 커뮤니티 구루비

개요

오라클 서버가 어떻게 문제가 있는 데이터 파일을 알아내고 복구를 시도하는가?
- Control File 내 Checkpoint SCN 관련 정보와 각종 파일의 이름과 위치 정보 활용

Oracle 시작 단계
1. NOMOUNT
  - 서버 프로세스가 PFILE(SPFILE)에 지정된 대로 INSTANCE 생성
2. MOUNT
  1. CKPT 프로세스가 Control File을 읽고 일시 lock 설정
  2. Control File Header 정보 검증 (Control File 이상 여부 확인), MOUNTID 계산 값 Control File 저장
  3. "Successful mount of redo thread"
  4. "Database mounted..."
3. OPEN
  - Data File Header 정보와 Control File 의 Checkpoint SCN 정보 비교

Oracle 시작 단계 (이미지)

1.1 Recovery의 원리

Control File 내용 관찰


$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Fri Oct 23 00:27:17 2015

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning option

SQL> show parameter user_dump_dest

NAME                                 TYPE
------------------------------------ ----------------------
VALUE
------------------------------
user_dump_dest                       string
/sw/oracle/app/oracle/diag/rdb
ms/utf8/UTF8/trace
SQL> alter session set tracefile_identifier = 'GURUBEE';

Session altered.

SQL> oradebug setmypid;
Statement processed.
SQL> oradebug dump controlf 3;
Statement processed.
SQL> !
$ cd /sw/oracle/app/oracle/diag/rdbms/utf8/UTF8/trace
$ ls -al *GURUBEE*
-rw-r-----    1 oracle   dba           42194 Oct 23 00:27 UTF8_ora_45613110_GURUBEE.trc
-rw-r-----    1 oracle   dba             106 Oct 23 00:27 UTF8_ora_45613110_GURUBEE.trm
$ cat  UTF8_ora_45613110_GURUBEE.trc
Trace file /sw/oracle/app/oracle/diag/rdbms/utf8/UTF8/trace/UTF8_ora_45613110_GURUBEE.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning option
ORACLE_HOME = /sw/oracle/app/oracle/product/11.2.0
System name:    AIX
Node name:      dcbdev1a
Release:        1
Version:        6
Machine:        00F672564C00
Instance name: UTF8
Redo thread mounted by this instance: 1
Oracle process number: 17
Unix process pid: 45613110, image: oracle@dcbdev1a (TNS V1-V3)


*** 2015-10-23 00:27:40.042
*** SESSION ID:(193.5) 2015-10-23 00:27:40.042
*** CLIENT ID:() 2015-10-23 00:27:40.042
*** SERVICE NAME:(SYS$USERS) 2015-10-23 00:27:40.042
*** MODULE NAME:(sqlplus@dcbdev1a (TNS V1-V3)) 2015-10-23 00:27:40.042
*** ACTION NAME:() 2015-10-23 00:27:40.042

Processing Oradebug command 'setmypid'

*** 2015-10-23 00:27:40.043
Oradebug command 'setmypid' console output: <none>

*** 2015-10-23 00:27:43.837
Processing Oradebug command 'dump controlf 3'
DUMP OF CONTROL FILES, Seq # 443268 = 0x6c384
 V10 STYLE FILE HEADER:
        Compatibility Vsn = 186646528=0xb200000
        Db ID=2032672253=0x79281dfd, Db Name='UTF8'
        Activation ID=0=0x0
        Control Seq=443268=0x6c384, File size=470=0x1d6
        File Number=0, Blksiz=16384, File Type=1 CONTROL




***************************************************************************
DATABASE ENTRY
***************************************************************************
 (size = 316, compat size = 316, section max = 1, section in-use = 1,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 1, numrecs = 1)
 11/17/2011 10:57:01
 DB Name "UTF8"		<<< Database Name
 Database flags = 0x00404001 0x00001200
 Controlfile Creation Timestamp  11/17/2011 10:57:02
 Incmplt recovery scn: 0x0000.00000000
 Resetlogs scn: 0x0000.00000001 Resetlogs Timestamp  11/17/2011 10:57:01
 Prior resetlogs scn: 0x0000.00000000 Prior resetlogs Timestamp  01/01/1988 00:00:00
 Redo Version: compatible=0xb200000
 #Data files = 4, #Online files = 4
 Database checkpoint: Thread=1 scn: 0x0000.02a39b65		<<< Database 전체의 Checkpoint SCN
 Threads: #Enabled=1, #Open=1, Head=1, Tail=1
 enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 Max log members = 3, Max data members = 1
 Arch list: Head=2, Tail=2, Force scn: 0x0000.02a18f0cscn: 0x0000.00000000
 Activation ID: 2032700925
 Controlfile Checkpointed at scn:  0x0000.02a39bca 10/23/2015 00:26:49
 thread:0 rba:(0x0.0.0)
 enabled  threads:  00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000




***************************************************************************
CHECKPOINT PROGRESS RECORDS
***************************************************************************
 (size = 8180, compat size = 8180, section max = 11, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 2, numrecs = 11)
THREAD #1 - status:0x2 flags:0x0 dirty:62
low cache rba:(0x91d.49b.0) on disk rba:(0x91d.570.0)
on disk scn: 0x0000.02a39c41 10/23/2015 00:26:55
resetlogs scn: 0x0000.00000001 11/17/2011 10:57:01
heartbeat: 893818072 mount id: 2159023809
THREAD #2 - status:0x0 flags:0x0 dirty:0
low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
on disk scn: 0x0000.00000000 01/01/1988 00:00:00
resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00
heartbeat: 0 mount id: 0
THREAD #3 - status:0x0 flags:0x0 dirty:0
low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
on disk scn: 0x0000.00000000 01/01/1988 00:00:00
resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00
heartbeat: 0 mount id: 0
THREAD #4 - status:0x0 flags:0x0 dirty:0
low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
on disk scn: 0x0000.00000000 01/01/1988 00:00:00
resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00
heartbeat: 0 mount id: 0
THREAD #5 - status:0x0 flags:0x0 dirty:0
low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
on disk scn: 0x0000.00000000 01/01/1988 00:00:00
resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00
heartbeat: 0 mount id: 0
THREAD #6 - status:0x0 flags:0x0 dirty:0
low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
on disk scn: 0x0000.00000000 01/01/1988 00:00:00
resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00
heartbeat: 0 mount id: 0
THREAD #7 - status:0x0 flags:0x0 dirty:0
low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
on disk scn: 0x0000.00000000 01/01/1988 00:00:00
resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00
heartbeat: 0 mount id: 0
THREAD #8 - status:0x0 flags:0x0 dirty:0
low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)
on disk scn: 0x0000.00000000 01/01/1988 00:00:00
resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00
heartbeat: 0 mount id: 0




***************************************************************************
EXTENDED DATABASE ENTRY
***************************************************************************
 (size = 900, compat size = 900, section max = 1, section in-use = 1,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 94, numrecs = 1)
Control AutoBackup date(dd/mm/yyyy)=17/11/2011
Next AutoBackup sequence= 0
Database recovery target inc#:1, Last open inc#:1
flg:0x0, flag:0x10000
Change tracking state=0, file index=0, checkpoint count=0scn: 0x0000.00000000
Flashback log count=0, block count=0
Desired flashback log size=0 blocks
Oldest guarantee restore point=0
Highest thread enable/disable scn: 0x0000.00000001
Number of Open thread with finite next SCN in last log: 0
Number of half-enabled redo threads: 0
Sum of absolute file numbers for files currently being moved online: 0




***************************************************************************
REDO THREAD RECORDS
***************************************************************************
 (size = 256, compat size = 256, section max = 8, section in-use = 1,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 9, numrecs = 8)
THREAD #1 - status:0xf thread links forward:0 back:0
 #logs:3 first:1 last:3 current:2 last used seq#:0x91d
 enabled at scn: 0x0000.00000001 11/17/2011 10:57:02
 disabled at scn: 0x0000.00000000 01/01/1988 00:00:00
 opened at 10/23/2015 00:26:46 by instance UTF8
Checkpointed at scn:  0x0000.02a39b65 10/23/2015 00:26:46
 thread:1 rba:(0x91d.49a.10)
 enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 log history: 2332
 restore point keep sequence: 0




***************************************************************************
LOG FILE RECORDS		<<< 복구에 필요한 Redo Log File 관련 내용
***************************************************************************
 (size = 72, compat size = 72, section max = 16, section in-use = 3,
  last-recid= 3, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 10, numrecs = 16)
LOG FILE #1:
  name #1: /oradata2/system/redo01.log		<<< 1번 그룹 파일
 Thread 1 redo log links: forward: 2 backward: 0
 siz: 0x19000 seq: 0x0000091c hws: 0x7 bsz: 512 nab: 0x418b flg: 0x1 dup: 1
 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.02a2f7e1
 Low scn: 0x0000.02a346d5 03/17/2015 18:38:46
 Next scn: 0x0000.02a3972f 03/17/2015 19:15:27
LOG FILE #2:
  name #2: /oradata2/system/redo02.log		<<< 2번 그룹 파일
 Thread 1 redo log links: forward: 3 backward: 1
 siz: 0x19000 seq: 0x0000091d hws: 0x8 bsz: 512 nab: 0xffffffff flg: 0x8 dup: 1
 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.02a346d5
 Low scn: 0x0000.02a3972f 03/17/2015 19:15:27
 Next scn: 0xffff.ffffffff 01/01/1988 00:00:00
LOG FILE #3:
  name #3: /oradata2/system/redo03.log		<<< 3번 그룹 파일
 Thread 1 redo log links: forward: 0 backward: 2
 siz: 0x19000 seq: 0x0000091b hws: 0x8 bsz: 512 nab: 0xbf flg: 0x1 dup: 1
 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.02a2a701
 Low scn: 0x0000.02a2f7e1 03/17/2015 18:13:43
 Next scn: 0x0000.02a346d5 03/17/2015 18:38:46




***************************************************************************
DATA FILE RECORDS		<<< Data File 관련 내용
***************************************************************************
 (size = 520, compat size = 520, section max = 100, section in-use = 5,
  last-recid= 14, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 11, numrecs = 100)
DATA FILE #1:
  name #4: /oradata2/system/system01.dbf		<<<
creation size=131072 block size=8192 status=0xe head=4 tail=4 dup=1
 tablespace 0, index=1 krfil=1 prev_file=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:2366 scn: 0x0000.02a39b65 10/23/2015 00:26:46		<<<	현재 데이터파일에 저장되어 있는 SCN
 Stop scn: 0xffff.ffffffff 03/31/2015 06:51:12		<<< 신규 데이터의 마지막 SCN (OPEN 상태시 항상 무한대 값)
 Creation Checkpointed at scn:  0x0000.00000007 11/17/2011 10:57:07
 thread:1 rba:(0x1.3.10)
 enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 Offline scn: 0x0000.00000000 prev_range: 0
 Online Checkpointed at scn:  0x0000.00000000
 thread:0 rba:(0x0.0.0)
 enabled  threads:  00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 Hot Backup end marker scn: 0x0000.00000000
 aux_file is NOT DEFINED
 Plugged readony: NO
 Plugin scnscn: 0x0000.00000000
 Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/1988 00:00:00
 Foreign creation scn/timescn: 0x0000.00000000 01/01/1988 00:00:00
 Foreign checkpoint scn/timescn: 0x0000.00000000 01/01/1988 00:00:00
 Online move state: 0
DATA FILE #2:
  name #5: /oradata2/system/sysaux01.dbf		<<<
creation size=131072 block size=8192 status=0xe head=5 tail=5 dup=1
 tablespace 1, index=2 krfil=2 prev_file=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:2366 scn: 0x0000.02a39b65 10/23/2015 00:26:46		<<<
 Stop scn: 0xffff.ffffffff 03/31/2015 06:51:12		<<<
 Creation Checkpointed at scn:  0x0000.00000882 11/17/2011 10:57:12
 thread:1 rba:(0x1.1acd.10)
 enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 Offline scn: 0x0000.00000000 prev_range: 0
 Online Checkpointed at scn:  0x0000.00000000
 thread:0 rba:(0x0.0.0)
 enabled  threads:  00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 Hot Backup end marker scn: 0x0000.00000000
 aux_file is NOT DEFINED
 Plugged readony: NO
 Plugin scnscn: 0x0000.00000000
 Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/1988 00:00:00
 Foreign creation scn/timescn: 0x0000.00000000 01/01/1988 00:00:00
 Foreign checkpoint scn/timescn: 0x0000.00000000 01/01/1988 00:00:00
 Online move state: 0
DATA FILE #3:
  name #6: /oradata2/system/undotbs01.dbf		<<<
creation size=262144 block size=8192 status=0xe head=6 tail=6 dup=1
 tablespace 2, index=3 krfil=3 prev_file=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:2366 scn: 0x0000.02a39b65 10/23/2015 00:26:46		<<<
 Stop scn: 0xffff.ffffffff 03/31/2015 06:51:12		<<<
 Creation Checkpointed at scn:  0x0000.00000d39 11/17/2011 10:57:20
 thread:1 rba:(0x1.2575.10)
 enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 Offline scn: 0x0000.00000000 prev_range: 0
 Online Checkpointed at scn:  0x0000.00000000
 thread:0 rba:(0x0.0.0)
 enabled  threads:  00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 Hot Backup end marker scn: 0x0000.00000000
 aux_file is NOT DEFINED
 Plugged readony: NO
 Plugin scnscn: 0x0000.00000000
 Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/1988 00:00:00
 Foreign creation scn/timescn: 0x0000.00000000 01/01/1988 00:00:00
 Foreign checkpoint scn/timescn: 0x0000.00000000 01/01/1988 00:00:00
 Online move state: 0
DATA FILE #4:
  name #8: /oradata2/system/users01.dbf		<<<
creation size=6400 block size=8192 status=0xe head=8 tail=8 dup=1
 tablespace 4, index=5 krfil=4 prev_file=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:2365 scn: 0x0000.02a39b65 10/23/2015 00:26:46		<<<
 Stop scn: 0xffff.ffffffff 03/31/2015 06:51:12		<<<
 Creation Checkpointed at scn:  0x0000.00004539 11/17/2011 10:57:33
 thread:1 rba:(0x1.c55b.10)
 enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 Offline scn: 0x0000.00000000 prev_range: 0
 Online Checkpointed at scn:  0x0000.00000000
 thread:0 rba:(0x0.0.0)
 enabled  threads:  00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 Hot Backup end marker scn: 0x0000.00000000
 aux_file is NOT DEFINED
 Plugged readony: NO
 Plugin scnscn: 0x0000.00000000
 Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/1988 00:00:00
 Foreign creation scn/timescn: 0x0000.00000000 01/01/1988 00:00:00
 Foreign checkpoint scn/timescn: 0x0000.00000000 01/01/1988 00:00:00
 Online move state: 0
DATA FILE #5: <deleted>
creation size=12800 block size=8192 status=0x810 head=0 tail=0 dup=0
 tablespace 5, index=6 krfil=5 prev_file=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:3 scn: 0x0000.02a34908 03/17/2015 18:40:12
 Stop scn: 0x0000.02a39730 03/17/2015 19:15:27
 Creation Checkpointed at scn:  0x0000.02a3477e 03/17/2015 18:39:02
 thread:1 rba:(0x91c.7a.10)
 enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 Offline scn: 0x0000.00000000 prev_range: 0
 Online Checkpointed at scn:  0x0000.00000000
 thread:0 rba:(0x0.0.0)
 enabled  threads:  00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
  00000000 00000000 00000000 00000000 00000000 00000000
 Hot Backup end marker scn: 0x0000.00000000
 aux_file is NOT DEFINED
 Plugged readony: NO
 Plugin scnscn: 0x0000.00000000
 Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/1988 00:00:00
 Foreign creation scn/timescn: 0x0000.00000000 01/01/1988 00:00:00
 Foreign checkpoint scn/timescn: 0x0000.00000000 01/01/1988 00:00:00
 Online move state: 0




***************************************************************************
TEMP FILE RECORDS
***************************************************************************
 (size = 56, compat size = 56, section max = 100, section in-use = 1,
  last-recid= 1, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 54, numrecs = 100)
TEMP FILE #1: External File #201
  name #7: /oradata2/system/temp01.dbf		<<<
creation size=262144 block size=8192 status=0xe head=7 tail=7 dup=1
 tablespace 3, index=4 krfil=1 prev_file=0
 unrecoverable scn: 0x0000.00000ec5 11/17/2011 10:57:20




***************************************************************************
TABLESPACE RECORDS
***************************************************************************
 (size = 68, compat size = 68, section max = 100, section in-use = 6,
  last-recid= 15, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 53, numrecs = 100)
TABLESPACE #0 SYSTEM: recno=1
 First datafile link=1  Tablespace Flag=0
 Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
 Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #1 SYSAUX: recno=2
 First datafile link=2  Tablespace Flag=0
 Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
 Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #2 UNDOTBS1: recno=3
 First datafile link=3  Tablespace Flag=0
 Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
 Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #3 TEMP: recno=4
 First datafile link=1  Tablespace Flag=1
 Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
 Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #4 USERS: recno=5
 First datafile link=4  Tablespace Flag=0
 Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
 Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #2147483647 HOTSOURCE: recno=6
 First datafile link=0  Tablespace Flag=0
 Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
 Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00




***************************************************************************
RMAN CONFIGURATION RECORDS
***************************************************************************
 (size = 1108, compat size = 1108, section max = 50, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 55, numrecs = 50)




***************************************************************************
FLASHBACK LOGFILE RECORDS
***************************************************************************
 (size = 84, compat size = 84, section max = 2048, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 96, numrecs = 2048)




***************************************************************************
THREAD INSTANCE MAPPING RECORDS
***************************************************************************
 (size = 80, compat size = 80, section max = 8, section in-use = 8,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 113, numrecs = 8)
UTF8 recno=1
UNNAMED_INSTANCE_2 recno=2
UNNAMED_INSTANCE_3 recno=3
UNNAMED_INSTANCE_4 recno=4
UNNAMED_INSTANCE_5 recno=5
UNNAMED_INSTANCE_6 recno=6
UNNAMED_INSTANCE_7 recno=7
UNNAMED_INSTANCE_8 recno=8




***************************************************************************
MTTR RECORDS
***************************************************************************
 (size = 100, compat size = 100, section max = 8, section in-use = 1,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 114, numrecs = 8)
MTTR record for thread 1
MTTR statistics status: 3
Init time: Avg: 9061423 us, Times measured: 4
File open time: Avg: 4772 us, Times measured: 13
Log block read time: Avg: 2 us, Times measured: 36445
Data block read/claim time: Avg: 170 us, Times measured: 1000
Data block write time: Avg: 390 us
1000 change vector apply time: Avg: 8750 us, Times measured: 2
Ratio Information:
# of log blocks measured: 295556
# of data blocks measured: 10562
# of change vectors measured: 611635




***************************************************************************
STANDBY DATABASE MAP RECORDS
***************************************************************************
 (size = 400, compat size = 400, section max = 31, section in-use = 31,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 116, numrecs = 31)




***************************************************************************
RESTORE POINT RECORDS
***************************************************************************
 (size = 212, compat size = 212, section max = 2048, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 117, numrecs = 2048)




***************************************************************************
ACM SERVICE RECORDS
***************************************************************************
 (size = 104, compat size = 104, section max = 64, section in-use = 6,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 212, numrecs = 64)
ACM record=1
  id=0
  descrip=ACM unit testing operation
  attr=1
  ver=0
  exptime=0
  cpid=0
  cinst=0
  phase=1
ACM record=2
  id=1
  descrip=LSB Database Guard
  attr=1
  ver=0
  exptime=0
  cpid=0
  cinst=0
  phase=1
ACM record=3
  id=2
  descrip=Supplemental Log Data DDL
  attr=1
  ver=0
  exptime=0
  cpid=0
  cinst=0
  phase=1
ACM record=4
  id=3
  descrip=LSB Role Change Support
  attr=1
  ver=0
  exptime=0
  cpid=0
  cinst=0
  phase=1
ACM record=5
  id=4
  descrip=RFS block and kill across RAC
  attr=1
  ver=0
  exptime=0
  cpid=0
  cinst=0
  phase=1
ACM record=6
  id=5
  descrip=RAC-wide SGA
  attr=1
  ver=0
  exptime=0
  cpid=0
  cinst=0
  phase=1




***************************************************************************
LOG FILE HISTORY RECORDS
***************************************************************************
 (size = 56, compat size = 56, section max = 292, section in-use = 292,
  last-recid= 2332, old-recno = 289, last-recno = 288)
 (extent = 1, blkno = 59, numrecs = 292)
Earliest record:
 RECID #2041 Recno 289 Record timestamp  12/18/13 22:10:51 Thread=1 Seq#=2041 Link-Recid=2040 kccic-Recid=1
  Low scn: 0x0000.024fc8bd 12/18/13 15:00:52 Next scn: 0x0000.02500aa5
Latest record:
 RECID #2332 Recno 288 Record timestamp  03/17/15 19:15:27 Thread=1 Seq#=2332 Link-Recid=2331 kccic-Recid=1
  Low scn: 0x0000.02a346d5 03/17/15 18:38:46 Next scn: 0x0000.02a3972f




***************************************************************************
OFFLINE RANGE RECORDS
***************************************************************************
 (size = 200, compat size = 200, section max = 163, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 60, numrecs = 163)




***************************************************************************
ARCHIVED LOG RECORDS
***************************************************************************
 (size = 328, compat size = 328, section max = 49, section in-use = 5,
  last-recid= 5, old-recno = 1, last-recno = 5)
 (extent = 1, blkno = 62, numrecs = 49)
Earliest record:
 RECID #1 Recno 1 Record timestamp  03/17/15 18:06:39 Thread=1 Seq#=2328
  Flags: <produced by archive operation> <created by the ARCH process>
  Resetlogs scn and time scn: 0x0000.00000001 11/17/11 10:57:01
  filename /sw/oracle/app/oracle/product/11.2.0/dbs/arch1_2328_767444221.dbf
  Low scn: 0x0000.02a200e4 03/17/15 17:34:54 Next scn: 0x0000.02a2567d 03/17/15 18:06:39
  Block count=35127  Blocksize=512
Latest record:
 RECID #5 Recno 5 Record timestamp  03/17/15 19:15:27 Thread=1 Seq#=2332
  Flags: <produced by archive operation> <created by the ARCH process>
  Resetlogs scn and time scn: 0x0000.00000001 11/17/11 10:57:01
  filename /sw/oracle/app/oracle/product/11.2.0/dbs/arch1_2332_767444221.dbf
  Low scn: 0x0000.02a346d5 03/17/15 18:38:46 Next scn: 0x0000.02a3972f 03/17/15 19:15:27
  Block count=16778  Blocksize=512




***************************************************************************
FOREIGN ARCHIVED LOG RECORDS
***************************************************************************
 (size = 348, compat size = 348, section max = 1034, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 213, numrecs = 1034)




***************************************************************************
BACKUP SET RECORDS
***************************************************************************
 (size = 40, compat size = 40, section max = 409, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 63, numrecs = 409)




***************************************************************************
BACKUP PIECE RECORDS
***************************************************************************
 (size = 480, compat size = 480, section max = 204, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 64, numrecs = 204)




***************************************************************************
BACKUP DATAFILE RECORDS
***************************************************************************
 (size = 200, compat size = 200, section max = 245, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 70, numrecs = 245)




***************************************************************************
BACKUP LOG RECORDS
***************************************************************************
 (size = 76, compat size = 76, section max = 215, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 73, numrecs = 215)




***************************************************************************
DATAFILE COPY RECORDS
***************************************************************************
 (size = 480, compat size = 480, section max = 204, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 74, numrecs = 204)




***************************************************************************
BACKUP DATAFILE CORRUPTION RECORDS
***************************************************************************
 (size = 44, compat size = 44, section max = 371, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 80, numrecs = 371)




***************************************************************************
DATAFILE COPY CORRUPTION RECORDS
***************************************************************************
 (size = 40, compat size = 40, section max = 409, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 81, numrecs = 409)




***************************************************************************
DELETION RECORDS
***************************************************************************
 (size = 20, compat size = 20, section max = 818, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 82, numrecs = 818)




***************************************************************************
PROXY COPY RECORDS
***************************************************************************
 (size = 672, compat size = 672, section max = 243, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 83, numrecs = 243)




***************************************************************************
INCARNATION RECORDS
***************************************************************************
 (size = 56, compat size = 56, section max = 292, section in-use = 1,
  last-recid= 1, old-recno = 1, last-recno = 1)
 (extent = 1, blkno = 95, numrecs = 292)
Earliest record:
 RECID #1 Recno 1 Record timestamp
  Resetlogs scn and time scn: 0x0000.00000001 11/17/11 10:57:01
  Previous Resetlogs scn and time scn: 0x0000.00000000 01/01/88 00:00:00
 Incarnation (parent inc#, flag)=(0, 2)
Latest record:
 RECID #1 Recno 1 Record timestamp
  Resetlogs scn and time scn: 0x0000.00000001 11/17/11 10:57:01
  Previous Resetlogs scn and time scn: 0x0000.00000000 01/01/88 00:00:00
 Incarnation (parent inc#, flag)=(0, 2)




***************************************************************************
RMAN STATUS RECORDS
***************************************************************************
 (size = 116, compat size = 116, section max = 141, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 112, numrecs = 141)




***************************************************************************
DATAFILE HISTORY RECORDS
***************************************************************************
 (size = 312, compat size = 312, section max = 52, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 115, numrecs = 52)




***************************************************************************
NORMAL RESTORE POINT RECORDS
***************************************************************************
 (size = 212, compat size = 212, section max = 2083, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 144, numrecs = 2083)




***************************************************************************
DATABASE BLOCK CORRUPTION RECORDS
***************************************************************************
 (size = 80, compat size = 80, section max = 8384, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 171, numrecs = 8384)
*** END OF DUMP ***

*** 2015-10-23 00:27:43.856
Oradebug command 'dump controlf 3' console output: <none>
$

DATA FILE RECORDS


-- OPEN
***************************************************************************
DATA FILE RECORDS		<<< Data File 관련 내용
***************************************************************************
 (size = 520, compat size = 520, section max = 100, section in-use = 5,
  last-recid= 14, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 11, numrecs = 100)
DATA FILE #1:
  name #4: /oradata2/system/system01.dbf		<<<
creation size=131072 block size=8192 status=0xe head=4 tail=4 dup=1
 tablespace 0, index=1 krfil=1 prev_file=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:2366 scn: 0x0000.02a39b65 10/23/2015 00:26:46		<<<	현재 데이터파일에 저장되어 있는 SCN
 Stop scn: 0xffff.ffffffff 03/31/2015 06:51:12		<<< 신규 데이터의 마지막 SCN (OPEN 상태시 항상 무한대 값)
 Creation Checkpointed at scn:  0x0000.00000007 11/17/2011 10:57:07
 thread:1 rba:(0x1.3.10)

-- SHUTDOWN
***************************************************************************
DATA FILE RECORDS
***************************************************************************
 (size = 520, compat size = 520, section max = 100, section in-use = 5,
  last-recid= 14, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 11, numrecs = 100)
DATA FILE #1:
  name #4: /oradata2/system/system01.dbf		<<<
creation size=131072 block size=8192 status=0xe head=4 tail=4 dup=1
 tablespace 0, index=1 krfil=1 prev_file=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:2382 scn: 0x0000.02a3e4bf 10/23/2015 07:21:12		<<<
 Stop scn: 0x0000.02a3e4bf 10/23/2015 07:21:12		<<< 정상 종료시 Checkpoint scn = Stop scn
 Creation Checkpointed at scn:  0x0000.00000007 11/17/2011 10:57:07
 thread:1 rba:(0x1.3.10)

-- SHUTDOWN ABORT
***************************************************************************
DATA FILE RECORDS
***************************************************************************
 (size = 520, compat size = 520, section max = 100, section in-use = 5,
  last-recid= 14, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 11, numrecs = 100)
DATA FILE #1:
  name #4: /oradata2/system/system01.dbf		<<<
creation size=131072 block size=8192 status=0xe head=4 tail=4 dup=1
 tablespace 0, index=1 krfil=1 prev_file=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:2383 scn: 0x0000.02a3e4c2 10/23/2015 07:22:49		<<< 비정상 종료시 Checkpoint scn != Stop scn
 Stop scn: 0xffff.ffffffff 10/23/2015 07:21:12		<<< OPEN 상태가 아닐 때 Stop scn = 0xffff.ffffffff 인 경우 비정상 종료 되었음을 의미
 Creation Checkpointed at scn:  0x0000.00000007 11/17/2011 10:57:07
 thread:1 rba:(0x1.3.10)

- DB 정상 종료 혹은 OFFLINE 시 Checkpoint 발생으로 Checkpoint scn 과 Stop scn 값을 일치 시키고 파일 닫음
  - 장애 시 두 값이 일치 되지 않은 채 종료 됨
- STARTUP, RECOVER 명령이 수행시 복구 판단 기준
  1. Control File 내 DATA FILE RECORDS 부분의 각 데이터 파일의 Checkpoint scn, Stop scn 값의 일치 여부
  2. 데이터 파일 헤더의 Checkpoint scn 값과 Control File 의 Stop scn 값의 일치 여부

LOG FILE RECORDS
- 복구 필요시 데이터 파일 헤더의 제일 낮은 Checkpoint scn 값으로 Control File 내 LOG FILE RECORDS 접근
- Low scn 기준으로 필요한 로그 파일을 찾아 순차적 적용
  1. Roll Forward
  2. Roll Backward (COMMIT 미수행 트랜잭션 UNDO$ 에서 확인)


***************************************************************************
LOG FILE RECORDS
***************************************************************************
 (size = 72, compat size = 72, section max = 16, section in-use = 3,
  last-recid= 3, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 10, numrecs = 16)
LOG FILE #1:
  name #1: /oradata2/system/redo01.log		<<<
 Thread 1 redo log links: forward: 2 backward: 0
 siz: 0x19000 seq: 0x0000091c hws: 0x7 bsz: 512 nab: 0x418b flg: 0x1 dup: 1
 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.02a2f7e1
 Low scn: 0x0000.02a346d5 03/17/2015 18:38:46		<<<
 Next scn: 0x0000.02a3972f 03/17/2015 19:15:27		<<<
LOG FILE #2:
  name #2: /oradata2/system/redo02.log		<<<
 Thread 1 redo log links: forward: 3 backward: 1
 siz: 0x19000 seq: 0x0000091d hws: 0x8 bsz: 512 nab: 0xffffffff flg: 0x8 dup: 1
 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.02a346d5
 Low scn: 0x0000.02a3972f 03/17/2015 19:15:27		<<<
 Next scn: 0xffff.ffffffff 01/01/1988 00:00:00		<<<
LOG FILE #3:
  name #3: /oradata2/system/redo03.log		<<<
 Thread 1 redo log links: forward: 0 backward: 2
 siz: 0x19000 seq: 0x0000091b hws: 0x8 bsz: 512 nab: 0xbf flg: 0x1 dup: 1
 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.02a2a701
 Low scn: 0x0000.02a2f7e1 03/17/2015 18:13:43		<<<
 Next scn: 0x0000.02a346d5 03/17/2015 18:38:46		<<<

Recovery
- Instance(Crash) Recovery : 비정상 종료된 DB가 STARTUP 될 때 자동 복구 (ONLINE REDO LOG FILE 사용)
- Media Recovery : 파일 손상시 수동 백업 파일 복원 및 로그 적용 복구 (ONLINE 및 ARCHIVED REDO LOG FILE 사용)

1.2 Recovery 관련 명령어

RECOVER DATABASE
- DATABASE 전체 복구, MOUNT 상태에서 수행
  - 복구 대상 파일이 "NOT USE" 상태여야 함

RECOVER TABLESPACE [복구 대상 테이블 스페이스명]
- MOUNT, OPEN 상태에서 수행
  - 복구 대상 테이블스페이스가 "NOT USE" 상태여야 함 (OFFLINE)

RECOVER DATAFILE [복구 대상 파일명]
- MOUNT, OPEN 상태에서 수행
  - 복구 대상 파일이 "NOT USE" 상태여야 함 (OFFLINE)

Chap.01 Recovery 원리 (by openlsw) [2015.10.23]

개요

1.1 Recovery의 원리

1.2 Recovery 관련 명령어