데이터베이스 질문과 답변

오라클 데이터파일 덤프했을 때 헤더 내용 질문드립니다. 0 0 1,094

by bbugge [Oracle 기초] [2020.10.22 16:59:27]

Trace file /u01/app/oracle/diag/rdbms/testdb/testdb/trace/testdb_ora_5733.trc
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Build label:    RDBMS_19.3.0.0.0DBRU_LINUX.X64_190417
ORACLE_HOME:    /u01/app/oracle/product/19.0.0/db_1
System name:    Linux
Node name:    orcl19c
Release:    4.14.35-1902.300.11.el7uek.x86_64
Version:    #2 SMP Tue Mar 17 17:11:47 PDT 2020
Machine:    x86_64
Instance name: testdb
Redo thread mounted by this instance: 1
Oracle process number: 58
Unix process pid: 5733, image: oracle@orcl19c (TNS V1-V3)


*** 2020-10-23T00:27:57.629088+09:00
*** SESSION ID:(69.12403) 2020-10-23T00:27:57.629115+09:00
*** CLIENT ID:() 2020-10-23T00:27:57.629124+09:00
*** SERVICE NAME:(SYS$USERS) 2020-10-23T00:27:57.629132+09:00
*** MODULE NAME:(sqlplus@orcl19c (TNS V1-V3)) 2020-10-23T00:27:57.629140+09:00
*** ACTION NAME:() 2020-10-23T00:27:57.629149+09:00
*** CLIENT DRIVER:(SQL*PLUS) 2020-10-23T00:27:57.629156+09:00
 
Processing Oradebug command 'setmypid'

*** 2020-10-23T00:27:57.629257+09:00
Oradebug command 'setmypid' console output: <none>

*** 2020-10-23T00:28:08.036191+09:00
Processing Oradebug command 'dump file_hdrs 1'
DUMP OF DATA FILES: 7 files in database
 
DATA FILE #1: 
  name #9: +DATA01/TESTDB/DATAFILE/system.308.1054429613
creation size=0 block size=8192 status=0xe flg=0x1 head=9 tail=9 dup=1
 pdb_id 0, tablespace 0, index=2 krfil=1 prev_file_in_ts=0 prev_file_in_pdb=0
 unrecoverable scn: 0x0000000000000000 01/01/1988 00:00:00
 Checkpoint cnt:65 scn: 0x00000000001f1fba 10/23/2020 00:09:26
 Stop scn: 0xffffffffffffffff 10/22/2020 04:51:50
 Creation Checkpointed at scn:  0x0000000000000009 04/17/2019 00:56:09
 :
 중략
 :
 Hot Backup end marker scn: 0x0000000000000000
 aux_file is NOT DEFINED 
 Plugged readony: NO
 Plugin scnscn: 0x0000000000000000
 Plugin resetlogs scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Foreign creation scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Foreign checkpoint scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Online move state: 0
 
DATA FILE #2: <deleted>
creation size=0 block size=0 status=0x0 flg=0x0 head=0 tail=0 dup=0
 pdb_id 0, tablespace 0, index=0 krfil=0 prev_file_in_ts=0 prev_file_in_pdb=0
 unrecoverable scn: 0x0000000000000000 01/01/1988 00:00:00
 Checkpoint cnt:0 scn: 0x0000000000000000 01/01/1988 00:00:00
 Stop scn: 0x0000000000000000 01/01/1988 00:00:00
 Creation Checkpointed at scn:  0x0000000000000000 
 :
 중략
 :
 Hot Backup end marker scn: 0x0000000000000000
 aux_file=0 
 Plugged readony: NO
 Plugin scnscn: 0x0000000000000000
 Plugin resetlogs scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Foreign creation scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Foreign checkpoint scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Online move state: 0
 
DATA FILE #3: 
  name #10: +DATA01/TESTDB/DATAFILE/sysaux.307.1054429649
creation size=0 block size=8192 status=0xe flg=0x1 head=10 tail=10 dup=1
 pdb_id 0, tablespace 1, index=1 krfil=3 prev_file_in_ts=0 prev_file_in_pdb=0
 unrecoverable scn: 0x0000000000000000 01/01/1988 00:00:00
 Checkpoint cnt:65 scn: 0x00000000001f1fba 10/23/2020 00:09:26
 Stop scn: 0xffffffffffffffff 10/22/2020 04:51:50
 Creation Checkpointed at scn:  0x0000000000001568 04/17/2019 00:56:21
 :
 중략
 :
 Hot Backup end marker scn: 0x0000000000000000
 aux_file is NOT DEFINED 
 Plugged readony: NO
 Plugin scnscn: 0x0000000000000000
 Plugin resetlogs scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Foreign creation scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Foreign checkpoint scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Online move state: 0
 
DATA FILE #4: 
  name #8: +DATA01/TESTDB/DATAFILE/undotbs1.306.1054429673
creation size=0 block size=8192 status=0xe flg=0x1 head=8 tail=8 dup=1
 pdb_id 0, tablespace 2, index=3 krfil=4 prev_file_in_ts=0 prev_file_in_pdb=0
 unrecoverable scn: 0x0000000000000000 01/01/1988 00:00:00
 Checkpoint cnt:26 scn: 0x00000000001f1fba 10/23/2020 00:09:26
 Stop scn: 0xffffffffffffffff 10/22/2020 04:51:50
 Creation Checkpointed at scn:  0x00000000001d4dbe 04/17/2019 02:11:02
 :
 중략
 :
 Hot Backup end marker scn: 0x0000000000000000
 aux_file is NOT DEFINED 
 Plugged readony: NO
 Plugin scnscn: 0x0000000000000000
 Plugin resetlogs scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Foreign creation scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Foreign checkpoint scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Online move state: 0
 
DATA FILE #5: <deleted>
creation size=0 block size=0 status=0x0 flg=0x0 head=0 tail=0 dup=0
 pdb_id 0, tablespace 0, index=0 krfil=0 prev_file_in_ts=0 prev_file_in_pdb=0
 unrecoverable scn: 0x0000000000000000 01/01/1988 00:00:00
 Checkpoint cnt:0 scn: 0x0000000000000000 01/01/1988 00:00:00
 Stop scn: 0x0000000000000000 01/01/1988 00:00:00
 Creation Checkpointed at scn:  0x0000000000000000 
 :
 중략
 :
 Hot Backup end marker scn: 0x0000000000000000
 aux_file=0 
 Plugged readony: NO
 Plugin scnscn: 0x0000000000000000
 Plugin resetlogs scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Foreign creation scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Foreign checkpoint scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Online move state: 0
 
DATA FILE #6: <deleted>
creation size=0 block size=0 status=0x0 flg=0x0 head=0 tail=0 dup=0
 pdb_id 0, tablespace 0, index=0 krfil=0 prev_file_in_ts=0 prev_file_in_pdb=0
 unrecoverable scn: 0x0000000000000000 01/01/1988 00:00:00
 Checkpoint cnt:0 scn: 0x0000000000000000 01/01/1988 00:00:00
 Stop scn: 0x0000000000000000 01/01/1988 00:00:00
 Creation Checkpointed at scn:  0x0000000000000000 
 :
 중략
 :
 Hot Backup end marker scn: 0x0000000000000000
 aux_file=0 
 Plugged readony: NO
 Plugin scnscn: 0x0000000000000000
 Plugin resetlogs scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Foreign creation scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Foreign checkpoint scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Online move state: 0
 
DATA FILE #7: 
  name #7: +DATA01/TESTDB/DATAFILE/users.305.1054429675
creation size=0 block size=8192 status=0xe flg=0x1 head=7 tail=7 dup=1
 pdb_id 0, tablespace 4, index=4 krfil=7 prev_file_in_ts=0 prev_file_in_pdb=0
 unrecoverable scn: 0x0000000000000000 01/01/1988 00:00:00
 Checkpoint cnt:64 scn: 0x00000000001f1fba 10/23/2020 00:09:26
 Stop scn: 0xffffffffffffffff 10/22/2020 04:51:50
 Creation Checkpointed at scn:  0x000000000000806c 04/17/2019 00:57:08
 :
 중략
 :
 Hot Backup end marker scn: 0x0000000000000000
 aux_file is NOT DEFINED 
 Plugged readony: NO
 Plugin scnscn: 0x0000000000000000
 Plugin resetlogs scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Foreign creation scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Foreign checkpoint scn/timescn: 0x0000000000000000 01/01/1988 00:00:00
 Online move state: 0
DUMP OF TEMP FILES: 1 files in database
 
TEMP FILE #1: External File #201 
  name #11: +DATA01/TESTDB/TEMPFILE/temp.269.1054429757
creation size=2560 block size=8192 status=0x1e head=11 tail=11 dup=1
 pdb_id 0, tablespace 3, index=5 krfil=1 prev_file_in_ts=0 prev_file_in_pdb=0
 unrecoverable scn: 0x00000000001d5055 10/22/2020 01:09:17

*** 2020-10-23T00:28:08.042436+09:00
Oradebug command 'dump file_hdrs 1' console output: <none>

*** 2020-10-23T00:42:13.246778+09:00
Oradebug command 'tracefile_name' console output: 
/u01/app/oracle/diag/rdbms/testdb/testdb/trace/testdb_ora_5733.trc
 

#########################################################################

데이터파일 덤프 후 헤더 내용 보던 중에 DATA FILE #Num : <deleted> 라는 내용이 헤더에 찍히는데

DB 생성 후 데이터 파일을 따로 건들지 않았는데 삭제되었다고 나오는 이유가 뭔가요?

 

 

 

 

댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.
로그인 사용자만 댓글을 작성 할 수 있습니다. 로그인, 회원가입