슬라이드 1

Size: px
Start display at page:

Download "슬라이드 1"

Transcription

1 사례를통해본 RMAN (RMAN Case Study) Seungtaek Lee( 放浪 A)

2 RMAN 백업 Server-Managed Backup(RMAN) Components Target : 백업대상 Catalog : 백업정보가저장되는 RMAN Repository Auxiliary : 백업또는 Target 를 Restore하여여러가지용도로사용하는 Channel : Target 에 Server Session을할당하여실제백업 / 복구를수행하게하는역할대부분의 RMAN Command는 Channel을통하여수행함 MML : RMAN Tape 백업시필요한 Library Catalog Auxiliary Target Server Server Server Session Session Session Connect channel channel channel Connect Connect RMAN MML 2

3 RMAN 백업 Server-Managed Backup(RMAN) 의내부작업 Restored Data File Header Block 1 Block 2 Block 3 Block 4 Block 5 Backup Set Online Data File Header Block 1 Block 2 Block 3 Block 4 Block Header Block 1 Block 2 Block 3 Block 4 Block Header Block 1 Block 2 Block 3 Block 4 Block 5 Block 1 Block 2 Block 3 Block Block 1 Block 2 Block 3 Block 5 Header Block 4 Block Block 1 Block 2 Block 3 Block Block 1 Block Checkpoint Absolute Fuzzy 2 Restore Header Block 1 Block 2 Block 3 Block 4 Block Recovery RMAN 은 BEGIN/END Command 없이백업을수행하기때문에 Block Image 같은추가 Redo 가발생하지않음 RMAN 은 Full Backup 뿐만아니라 Block 레벨의 Incremental Backup, Compressed Backup 등다양한방식의백업을지원 RMAN 은백업시에 Data File 의 Header Block 부터백업을수행하기때문 Header Block 1 Block 2 Block 3 Block 4 Block 5 Block 1 Header 에 User-Managed Backup 방식과달리 Header Block 의 Checkpoint 을고정시키지않음. 복구시 Redo Log 적용을 Header Block 의 Header Block 1 Block 2 Block 3 Block 4 Block 5 1 Online Backup Large Pool Checkpoint 시점부터복구를시작 RMAN 백업은 End Backup 을수행하지않기때문에백업시에 Redo Log 최소적용시점정보인 Absolute Fuzzy 값을백업 Data File Header 에기록 Absolute Fuzzy 은백업 Data File 의 Block SC 값중가장큰 3

4 RMAN 백업 Online Standby Backup Online Standby Backup을수행하기위해서는 Backup 정보를저장하는 Catalog 가필요 RMAN은 Catalog 가구성안되어있을시에는Catalog 대신에 Target 의 Controlfile을사용 Controlfile을사용하면 Primary 와 Standby 의 Control file이다르기때문에 Backup 정보를서로공유할수없음 Target 를 Primary 로설정하고 Catalog 로접속한다음 register database로 Catalog 에 정보를등록 Backup 수행시에는 Standby 를 Target 로설정하고 Catalog 에접속한후 Backup을수행 Standby 와 Primary 의 ID가동일하기때문에 Primary 에서 Standby 의백업을사용할수있음 Primary Standby Instance Tape Drive Instance Primary Catalog Standby 4

5 RMAN 백업 Catalog 생성및 Database 등록 $ rman catalog rman/rman01@rman RMAN> create catalog; rman target / catalog rman/rman01@rman RMAN> register database; Catalog 에 Primary 만등록하면됨 DataGuard 환경에서 RMAN Configuration CONFIGURE _UNIQUE_NAME PRI CONNECT IDENTIFIER PRI_SYN'; CONFIGURE _UNIQUE_NAME STB CONNECT IDENTIFIER STB_SYN'; DataGuard 환경에서는 RMAN CONFIGURE 설정값은 CATALOG 에서 Local Control File 로 Reverse Resync 가발생 각 고유의 CONFIGURE 설정을위해 _UNIQUE_NAME 생성후 FOR _UNIQUE_NAME 구문으로각각설정할수있음 CONFIGURE CONTROLFILE AUTOBACKUP ON; 백업수행시자동으로 Control File 과 spfile 백업수행 (OFF 시에는 Datafile 1 백업시에만포함됨 ) CONFIGURE BACKUP OPTIMIZATION ON; 동일 Checkpoint 에같은백업존재시백업 Skip 함 CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ALL STANY; Standby 에 Apply 된 Archive Log 만삭제 CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+FS_DG/PRI/CONTROLFILE/snapcf_PRI.f ; RAC 일경우 Snapshot Controfile 이 Shared Device 에존재해야함 ( 이상 ) 로컬로설정할경우 ORA 에러가발생 (Bug ) Standby 와 Primary 의 Snapshot Controlfile 은경로와파일명을같게설정해야함 (Bug ) 5

6 RMAN 백업 RAC Multi Instance RMAN Backup Target 가 RAC일경우 Channel을 RAC의여러 Instance에할당하여자원을분산해서사용함으로백업수행속도를빠르게할수있음 Channel할당시 TAF나 Service를사용하면가용성이나자원사용을효율적으로할수있음 Catalog connect target /; connect rcvcat Target Instance 1 Connect Server Server channel Server Session channel Session channel Session Connect RMAN run{ allocate channel t1 type 'SBT_TAPE' connect 'sys/q1w2e3r4@mos15k_lb'; allocate channel t2 type 'SBT_TAPE' connect 'sys/q1w2e3r4@mos15k_lb'; allocate channel t3 type 'SBT_TAPE' connect 'sys/q1w2e3r4@mos15k_lb'; allocate channel t4 type 'SBT_TAPE' connect 'sys/q1w2e3r4@mos15k_lb'; send 'NSR_ENV=(NSR_SERVER=kmesbk, NSR_CLIENT=dmos15d1, NSR_DATA_VOLUME_POOL=MOS)'; backup as backupset incremental level 0 filesperset 4 tag 'STBY_TAPE_BKST_FULL' format '%d_%u' database; Target Instance 2 Server Server Server Session Session Session channel channel channel release channel t1; release channel t2; release channel t3; release channel t4; } 6

7 RMAN 백업 Block Change Tracking File 과거 Backup 이후변경된 block 정보를비트맵으로저장하여 Incremental Backup 수행시변경된 Block만 Read하여빠르게 Backup(Fast Incremental Backup) 할수있게지원하는 File 각 Datafile마다최대 8개버전 (_bct_bitmaps_per_file) 의 Backup에대한변경된 block 정보를 bitmap extent에 switch하면서저장 (bitmap extent 1개에는 1개의버전정보만저장됨 ) 변경된 block은 32k(_bct_chunk_size) 크기의 Chunk 단위로관리 RAC 환경하에서는 BCT File을 ASM/Raw Device/CFS 같은공유Device에생성하여야함 11g부터 Standby 에도적용가능 SGA List of changed blocks CTWR Redo generation Change tracking file Redo log 7

8 RMAN 백업 Incrementally Updated Backup 최초 Backup 시에는 Image Copy Full Backup 을수행하고이후 Backup 수행시에는 Incremental Backup 을 수행하여이때만들어지는 Incremental Backup 을 Image Copy Full Backup 본에 Update 하는 Backup 대용량 환경하에서 Incremental Backup 수행만으로 Full Backup 본을생성할수있으므로 Disk Full Backup 을좀더빠르게수행할수있는 Backup 방식 Tag 를설정하여여러시점의백업본을구성할수도있음 /recover1 Time A1 Time A2 Time A3 Full Backup (Image Copy) Full Backup (Image Copy) Full Backup (Image Copy) Database Update Incremental Backup (Backup Set) Update Incremental Backup (Backup Set) /recover2 Time B1 Time B2 Time B3 Full Backup (Image Copy) Full Backup (Image Copy) Full Backup (Image Copy) Update Incremental Backup (Backup Set) Update Incremental Backup (Backup Set) 8

9 RMAN 백업 Incrementally Updated Backup Script (/recover1) connect target / connect rcvcat rman/rman01@rman run { allocate channel f1d1 device type disk format '/recover1/rman/datafile/%u'; allocate channel f1d2 device type disk format '/recover1/rman/datafile/%u'; allocate channel f1d3 device type disk format '/recover1/rman/datafile/%u'; allocate channel f1d4 device type disk format '/recover1/rman/datafile/%u'; crosscheck backupset tag='stby_disk_copy_full1'; crosscheck copy like '/recover1/rman/%' ; delete noprompt expired backupset tag='stby_disk_copy_full1'; delete noprompt expired copy like '/recover1/rman/%' ; delete noprompt copy like '/recover1/rman/%' completed before 'sysdate-7'; delete noprompt backupset tag 'STBY_DISK_COPY_FULL1' completed before 'sysdate-2'; backup incremental level 1 for recover of copy with tag 'STBY_DISK_COPY_FULL1' database; recover copy of database with tag 'STBY_DISK_COPY_FULL1'; backup as copy current controlfile tag 'STBY_DISK_COPY_FULL1' format '/recover1/rman/controlfile/stbyctl1.cpy' reuse; backup as copy current controlfile tag 'STBY_DISK_COPY_FULL1' format '/recover2/arch/controlfile/stbyctl1.cpy' reuse; backup as backupset current controlfile tag 'STBY_DISK_COPY_FULL1' format '/recover1/rman/controlfile/stbyctl1.bkp.%u'; backup as backupset current controlfile tag 'STBY_DISK_COPY_FULL1' format '/recover2/arch/controlfile/stbyctl1.bkp.%u'; backup as backupset current controlfile tag 'STBY_DISK_COPY_FULL1' format '/recover1/rman/controlfile/stbyctl1.bkp' reuse; backup as backupset current controlfile tag 'STBY_DISK_COPY_FULL1' format '/recover2/arch/controlfile/stbyctl1.bkp' reuse; release channel f1d1; release channel f1d2; release channel f1d3; release channel f1d4; } 9

10 RMAN 백업 Incrementally Updated Backup Script (/recover2) connect target / connect rcvcat rman/rman01@rman run { allocate channel f2d1 device type disk format '/recover2/rman/datafile/%u'; allocate channel f2d2 device type disk format '/recover2/rman/datafile/%u'; allocate channel f2d3 device type disk format '/recover2/rman/datafile/%u'; allocate channel f2d4 device type disk format '/recover2/rman/datafile/%u'; crosscheck backupset tag='stby_disk_copy_full2'; crosscheck copy like '/recover2/rman/%' ; delete noprompt expired backupset tag='stby_disk_copy_full2'; delete noprompt expired copy like '/recover2/rman/%' ; delete noprompt copy like '/recover2/rman/%' completed before 'sysdate-7'; delete noprompt backupset tag 'STBY_DISK_COPY_FULL2' completed before 'sysdate-2'; backup incremental level 1 for recover of copy with tag 'STBY_DISK_COPY_FULL2' database; recover copy of database with tag 'STBY_DISK_COPY_FULL2'; backup as copy current controlfile tag 'STBY_DISK_COPY_FULL2' format '/recover2/rman/controlfile/stbyctl2.cpy' reuse; backup as copy current controlfile tag 'STBY_DISK_COPY_FULL2' format '/recover2/arch/controlfile/stbyctl2.cpy' reuse; backup as backupset current controlfile tag 'STBY_DISK_COPY_FULL2' format '/recover2/rman/controlfile/stbyctl2.bkp.%u'; backup as backupset current controlfile tag 'STBY_DISK_COPY_FULL2' format '/recover2/arch/controlfile/stbyctl2.bkp.%u'; backup as backupset current controlfile tag 'STBY_DISK_COPY_FULL2' format '/recover2/rman/controlfile/stbyctl2.bkp' reuse; backup as backupset current controlfile tag 'STBY_DISK_COPY_FULL2' format '/recover2/arch/controlfile/stbyctl2.bkp' reuse; release channel f2d1; release channel f2d2; release channel f2d3; release channel f2d4; } 10

11 Standby Image Copy 본을이용한 복구 Standby 의백업본을 Primary 서버에 NFS 로 Mount 함 Primary Control File 에는 Standby 에서수행한디스크백업정보가없기때문에 Catalog 를연결필요 Primary 에서 Standby 백업정보를접근하기위해 set backup files for device type disk to accessible 설정 Standby 에서수행한 Tape Backup 백업정보는 Catalog 만연결하면특별한설정없이 Primary 에서 Default 로볼수있음 Catalog 에있는 Standby 백업정보를이용하여 Full/Tablespace/Datafile/Block 복구를할수있음 Data Guard Primary Standby Instance Block Datafile Tablespace Full 3 RMAN Recovery Online Compress Parallel Image 1 RMAN Backup Instance Primary RMAN Image Standby 2 FS Mount/Cataloging 11

12 STEP 1. Primary 서버에 Standby Image Copy 본 Mount NFS 로 Mount 시 OS 별 Mount 옵션확인할것 (Note ID 참조 ) NFS 문제시 ORA-17500: ODM err:permission denied 에러발생함 $ df kmmepz01-priv1:/export/data % /recover2/rman/datafile/data1 kmmepz02-priv1:/export/data % /recover2/rman/datafile/data2 kmmepz01-priv1:/export/data % /recover2/rman/datafile/data3 kmmepz02-priv1:/export/data % /recover2/rman/datafile/data4 STEP 2. set backup files for device type disk to accessible 설정 10gR2 까지는 Standby 에서디스크백업수행시반드시 Nocatalog 로백업 / 복구를수행하여야했고 Primary 에서복구하기위해서는 Catalog 작업이별도로필요 11gR1 부터는 Standby 에서디스크백업수행시 Catalog 로백업을수행하고 Primary 에서복구시에는 set backup files for device type disk to accessible 구문으로별도의 Catalog 작업없이복구가능 # rman target / catalog rman/rman01@rman RMAN> set backup files for device type disk to accessible RMAN> list copy; 12

13 STEP 3. Restore and Recovery Database/Tablespace/Datafile/Block 단위로 Restore 및 Recovery 가능 $ rman target / catalog rman/rman01@rman run { allocate channel disk1 device type disk ; allocate channel disk2 device type disk ; restore database from tag 'STBY_DISK_COPY_FULL2' ; release channel disk1; release channel disk2; } Block Recover 예 $ rman target / catalog rman/rman01@rman RMAN> blockrecover datafile 6 block 9,10 datafile 8 block 11,15 from tag 'STBY_DISK_COPY_FULL2' ; 13

14 Standby Image Copy 본을이용한 Test 구성 Image Copy 본은 Datafile 과구조가같기때문에 Restore 작업없이 Copy 본으로경로를수정하여 를 Open 할수있음 Open 을위해 Controlfile, Datafile, Tempfile, Redo Log File, Archive Log File, BCT File, Flashback Log 에대한경로변경작업필요 Image Copy 본은 Primary 서버나 Standby 서버가아닌별도의복구 / 테스트서버에구성할것을권고 Primary 서버나 Standby 서버에서구성할경우 Service 등록과데이터베이스파일에대한중복여부 확인작업이필요하기때문에신중하게작업을하여야함 Data Guard Primary Standby 복구 /TEST Instance Instance Instance Primary Standby RMAN Image1 RMAN Image2 복구용 Test 용 14

15 Standby Image Copy 본을이용한 Test 구성 STEP 1. Test 정보확인 Archive log mode 필수 #. oraenv ORACLE_SID = [TEST]? TEST The Oracle base remains unchanged with value /u01/app/oracle # /oracle/ora11g>env grep ORA ORACLE_BASE=/u01/app/oracle ORACLE_SID=TEST ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 # sqlplus / as sysdba SQL> startup nomount STEP 2. Controlfile Restore Test 생성을위해서는별도의 Oracle Home 을설치하고 를 Nomount 함 Nomount 에서 Controlfile Restore 수행 Controlfile Restore 는 Copy 본 (stbyctl2.cpy) 이아닌 Standby 에서수행한 Backupset Controlfile(stbyctl2.bkp) 을사용할것 # export ORACLE_SID=TEST # rman target / RMAN> restore controlfile from '/recover2/rman1/controlfile/stbyctl2.bkp'; RMAN> sql 'alter database mount'; sql statement: alter database mount released channel: ORA_DISK_1 15

16 # export ORACLE_SID=TEST # sqlplus / as sysdba SQL> select CONTROLFILE_TYPE from v$database; CONTROL BACKUP STANY가아닌 BACKUP이어야함 SQL> select name from v$controlfile; STEP 3. Datafile Copy Backup 확인 # rman target / RMAN> list datafilecopy tag='stby_disk_copy_full2'; List of Datafile Copies ======================= Key File S Completion Time Ckp Ckp Time A 02-DEC :54: DEC :23:27 Name: /recover2/rman/datafile/data_d-kmmes_i _ts-system_fno-1_9jnrrbhm Tag: STBY_DISK_COPY_FULL A 02-DEC :55: DEC :23:27 Name: /recover2/rman/datafile/data_d-kmmes_i _ts-sysaux_fno-2_9inrrbhk Tag: STBY_DISK_COPY_FULL

17 STEP 4. Datafile Rename switch database to copy 명령어로 Datafile Rename 수행 # export ORACLE_SID=TEST # rman target / RMAN> switch database to copy; datafile 1 switched to datafile copy "/recover2/rman/datafile/data_d-kmmes_i _ts-system_fno-1_9jnrrbhm" datafile 2 switched to datafile copy "/recover2/rman/datafile/data_d-kmmes_i _ts-sysaux_fno-2_9inrrbhk" datafile 3 switched to datafile copy "/recover2/rman/datafile/data_d-kmmes_i _ts-undotbs1_fno-3_98nrrb24" datafile 4 switched to datafile copy "/recover2/rman/datafile/data_d-kmmes_i _ts-undotbs2_fno-4_99nrrb24" datafile 5 switched to datafile copy "/recover2/rman/datafile/data_d-kmmes_i _ts-users_fno-5_9knrrbij" datafile 6 switched to datafile copy "/recover2/rman/datafile/data_d-kmmes_i _ts-undotbs1_fno-6_9anrrb24" datafile 7 switched to datafile copy "/recover2/rman/datafile/data_d-kmmes_i _ts-undotbs1_fno-7_9bnrrb24" datafile 8 switched to datafile copy "/recover2/rman/datafile/data_d-kmmes_i _ts-undotbs1_fno-8_9cnrrbad" datafile 9 switched to datafile copy "/recover2/rman/datafile/data_d-kmmes_i _ts-undotbs1_fno-9_9dnrrbag" datafile 10 switched to datafile copy "/recover2/rman/datafile/data_d-kmmes_i _ts-undotbs2_fno-10_9enrrbai" datafile 11 switched to datafile copy "/recover2/rman/datafile/data_d-kmmes_i _ts-undotbs2_fno-11_9fnrrbal" datafile 12 switched to datafile copy "/recover2/rman/datafile/data_d-kmmes_i _ts-undotbs2_fno-12_9gnrrbhc" datafile 13 switched to datafile copy "/recover2/rman/datafile/data_d-kmmes_i _ts-undotbs2_fno-13_9hnrrbhi" 17

18 STEP 5. Tempfile Rename switch tempfile 명령어로 Tempfile Rename 수행 # rman target / run { SET NEWNAME FOR TEMPFILE 1 TO '/recover2/rman1/datafile/temp01.dbf'; SET NEWNAME FOR TEMPFILE 2 TO '/recover2/rman1/datafile/temp02.dbf'; SET NEWNAME FOR TEMPFILE 3 TO '/recover2/rman1/datafile/temp03.dbf'; SET NEWNAME FOR TEMPFILE 4 TO '/recover2/rman1/datafile/temp04.dbf'; SET NEWNAME FOR TEMPFILE 5 TO '/recover2/rman1/datafile/temp05.dbf'; switch tempfile all; } STEP 6. Redo Log File Rename alter database rename file 명령어로 Redo Log File Rename 수행 # export ORACLE_SID=TEST SQL> alter database rename file '/oracle/kmmes/redolog/1_redo01.log' to '/recover2/rman/datafile/1_redo01.log'; SQL> alter database rename file '/oracle/kmmes/mirrlog/1_redo01_m.log' to '/recover2/rman/datafile/1_redo01_m.lo g ; SQL> alter database rename file '/oracle/kmmes/redolog/stby_1_redo31.log' to '/recover2/rman/datafile/stby_1_red o31.log'; SQL> alter database rename file '/oracle/kmmes/redolog/stby_1_redo32.log' to '/recover2/rman/datafile/stby_1_red o32.log'; 18

19 STEP 7. Active Redo Log Drop drop logfile 에러발생 (Active Standby Log) 시해당 Log Clear 후 drop SQL> alter database clear logfile group 32; alter database clear logfile group 32 * ERROR at line 1: ORA-00344: unable to re-create online log '/oracle/kmmes/redolog/stby_1_redo32.log' ORA-27040: file create error, unable to create file IBM AIX RISC System/6000 Error: 2: No such file or directory Additional information: 1 SQL> alter database drop logfile group 32; STEP 8. BCT File Disable # export ORACLE_SID=TEST # rman target / SQL> ALTER DATABASE DISABLE BLOCK CHANGE TRACKING; SQL> select * from V$BLOCK_CHANGE_TRACKING; 19

20 STEP 9. Database File Rename 최종확인 # export ORACLE_SID=TEST # sqlplus / as sysdba SQL> select name from v$controlfile; SQL> select name from v$datafile; SQL> select file#,name from v$tempfile; SQL> select * from V$BLOCK_CHANGE_TRACKING; SQL> select member from v$logfile; STEP 10. Datafile 복구및 Open noarchivelog 로 Open RAC 백업을 Single 로 resetlog 로 Open 하기위해서 init 파일에 _no_recovery_through_resetlogs=true 설정할것 (Bug ) # export ORACLE_SID=TEST # sqlplus / as sysdba SQL> recover database until cancel using backup controlfile; ORA-00279: change generated at 12/01/ :23:27 needed for thread 1 ORA-00289: suggestion : /recover3/archive/1_74_ dbf ORA-00280: change for thread 1 is in sequence #74 Specify log: {<RET>=suggested filename AUTO CANCEL} CANCEL Media recovery cancelled. SQL> select * from v$recover_file; SQL> alter database noarchivelog; SQL> alter database open resetlogs; 20

21 ZFS Appliance 를이용한 Test 구성 ZFS Appliance 의 Snapshot 기능을이용하여 RMAN Image Copy 본을여러시점의 Snapshot 백업을수행함 필요한 Snapshot 을 Read Write 가가능한 Clone 으로복제하여테스트서버에 Mount 함 테스트 의 Controlfile 에변경된경로정보를다시 Catalog Datafile/Redo Log File/Temp File 등을 rename 함 BCT/Flashback Log 등을 Disable 함 Reset Log 로 Open 함 Data Guard Primary Standby 복구 /TEST Instance Instance Instance Primary Standby RMAN Image Snap 1 Snap 2 Snap 3 Snap 4 Snap 5 Clone 2 Clone 5-1 Clone 5-2 복구용 Test 용 21

22 STEP 1. ZFS Clone 백업본 Mount /clone/recover2/rman/datafile/ STEP 2. Controlfile Restore Test 생성을위해서는별도의 Oracle Home 을설치하고 를 Nomount 함 Nomount 에서 Controlfile Restore 수행 Controlfile Restore 는 Copy 본 (stbyctl2.cpy) 이아닌 Standby 에서수행한 Backupset Controlfile(stbyctl2.bkp) 을사용할것 # sqlplus / as sysdba SQL> startup nomount # rman target / RMAN> restore controlfile from '/clone/recover2/rman1/controlfile/stbyctl2.bkp'; RMAN> sql 'alter database mount'; # sqlplus / as sysdba SQL> select CONTROLFILE_TYPE from v$database; CONTROL BACKUP STANY가아닌 BACKUP이어야함 SQL> select name from v$controlfile; 22

23 STEP 3. Image Copy 본 Uncatalog/Catalog Backup 당시경로와달라졌기때문에 (/recover2 /clone/recover2) 백업정보삭제 (Uncatalog) 후등록 (Catalog ) # rman target / RMAN> list datafilecopy tag='stby_disk_copy_full2'; RMAN> change datafilecopy tag='stby_disk_copy_full2' uncatalog; RMAN> list datafilecopy tag='stby_disk_copy_full2'; RMAN> catalog start with '/clone/recover2/' noprompt; FILE# 로한개의 ImageCopy만존재하는지확인 RMAN> list datafilecopy tag='stby_disk_copy_full2'; RMAN> list incarnation; List of Database Incarnations Key Inc Key Name ID STATUS Reset Reset Time KMQC PARENT 1 10-DEC :56: KMQC PARENT DEC :17: KMQC CURRENT DEC :30:57 # 운영 의 RESETLOGS_CHANGE# 과 Current Incarnation 의 Reset 과 Mismatch 시해당 Incarnation# 로 Reset RMAN> reset database to incarnation 번호 ; 23

24 STEP 4. Datafile Rename switch database to copy 명령어로 Datafile Rename 수행 # rman target / RMAN> switch database to copy; datafile 1 switched to datafile copy "/clone/recover2/rman/datafile/data1/data_d-kmqc_i _ts-system_fno-1 _03nspu7f" datafile 2 switched to datafile copy "/clone/recover2/rman/datafile/data4/data_d-kmqc_i _ts-sysaux_fno-2 _12nsq0kc"... STEP 5. Tempfile Rename switch tempfile 명령어로 Tempfile Rename 수행 # rman target / run { SET NEWNAME FOR TEMPFILE 1 TO '/clone/recover2/rman1/datafile/temp01.dbf'; switch tempfile all; } STEP 6. Redo Log File Rename alter database rename file 명령어로 Redo Log File Rename 수행 alter database rename file '+DATA_EXA2/kmqcdg/onlinelog/group_ ' to '/clone/recover2/rman/datafile /1redo1.log'; alter database rename file '+DATA_EXA2/kmqcdg/onlinelog/group_ ' to '/clone/recover2/rman/datafile /1redo2.log ; 24

25 STEP 7. Standby Log File Drop alter database drop logfile group 31; alter database drop logfile group 32;. drop logfile 에러발생 (Active Standby Log) 시해당 Log Clear 후 drop TEST: SYS> alter database drop logfile group 32 * ERROR at line 1: TEST: SYS> alter database clear logfile group 32; '+data_exa * ORA-29701: unable to connect to Cluster Synchronization Service SQL> alter database drop logfile group 32; STEP 8. Block Change Tracking File Disable SQL> ALTER DATABASE DISABLE BLOCK CHANGE TRACKING; SQL> select * from V$BLOCK_CHANGE_TRACKING; 25

26 STEP 9. Database File Rename 최종확인 SQL> select member from v$logfile; SQL> select file#,name from v$tempfile; SQL> select * from V$BLOCK_CHANGE_TRACKING; SQL> select name from v$controlfile; SQL> select name from v$datafile; STEP 10. Recover 및 Open noarchivelog 로 Open RAC 백업을 Single 로 resetlog 로 Open 하기위해서 init 파일에 _no_recovery_through_resetlogs=true 설정할것 (Bug ) SQL> recover database until time ' :12:30:00' using backup controlfile; SQL> alter database noarchivelog; SQL> alter database open resetlogs; 26

27 Duplicate Database 를이용한 Test 구성 Primary 또는 Standby 에서수행한 VTL 백업을 Restore 하여별도의 Test 를구성할수있음 Duplicate 는원본 와다른 ID 로생성됨 Data Guard Primary Standby TEST Instance Instance Instance Primary Standby Duplicate 27

28 Duplicate Database 를이용한 Test 구성 STEP 1. Startup Nomount Duplicate 생성을위해서는별도의 Oracle Home 을설치하고 를 Nomount 함 kmmepr02[#/oracle/ora11g] sqlplus / as sysdba TEST2: SYS> startup nomount STEP 2. Control File Restore -- Catalog 을이용한 Rman 접속 kmmepr02[#/oracle/ora11g] rman target / catalog rman/rman01@rman run { allocate channel ch00 type 'sbt_tape'; restore controlfile to '/recover3/test2/datafile/test2.ctl' from 'c c'; release channel ch00; } --> '/c c' 해당정보는 RMAN의 'list backupset;' 명령을통해해당시점확인후 "Handle" 번호입력. Handle: bk_7372_1_ ==> Datafie Handle: c a ==> Control File & spfile Handle: al_7377_1_ ==> Archivelog 28

29 STEP 3. Duplicate 생성 Duplicate 생성을위해서는 Taget/Catalog/Auxiliary 에접속하고 Auxiliary 에 Duplicate 가생성됨 kmmepr02[#/oracle/ora11g] rman target catalog auxiliary / run { allocate auxiliary channel ch00 type 'SBT_TAPE' parms="env=(nb_ora_policy=kmmepe04_ora_full_kmqcdg2,nb_ora_clien T=kmmepe04_exa,NB_ORA_SERV=kmmepr01)"; allocate auxiliary channel ch01 type 'SBT_TAPE' parms="env=(nb_ora_policy=kmmepe04_ora_full_kmqcdg2,nb_ora_clien T=kmmepe04_exa,NB_ORA_SERV=kmmepr01)"; allocate auxiliary channel ch02 type 'SBT_TAPE' parms="env=(nb_ora_policy=kmmepe04_ora_full_kmqcdg2,nb_ora_clien T=kmmepe04_exa,NB_ORA_SERV=kmmepr01)"; allocate auxiliary channel ch03 type 'SBT_TAPE' parms="env=(nb_ora_policy=kmmepe04_ora_full_kmqcdg2,nb_ora_clien T=kmmepe04_exa,NB_ORA_SERV=kmmepr01)"; set until time "TO_DATE('2012/12/15 18:00:00','YYYY/MM/DD HH24:MI:SS')"; set newname for database to '/recover3/test2/datafile/%b'; duplicate target database to "TEST2" nofilenamecheck logfile '/recover3/test2/onlinelog/redo01.dbf' size 512M, '/recover3/test2/onlinelog/redo02.dbf' size 512M, '/recover3/test2/onlinelog/redo03.dbf' size 512M ; release channel ch00; release channel ch01; release channel ch02; release channel ch03; } 29

30 RMAN Issues STEP 4. Open -- Duplicate 생성후, TEST2 재기동 kmmepr02[#/oracle/ora11g] sqlplus / as sysdba TEST2: SYS> shutdown immediate; TEST2: SYS> startup; 30

31

슬라이드 1

슬라이드 1 RMAN Backup and Recovery Seungtaek Lee( 放浪 DBA) User-managed Backup vs Server-managed Backup 단계 Inconsistency 현상 User-managed Backup Server-managed Backup (RMAN) 시작. File Inconsistency : Backup 수행시 File

More information

슬라이드 1

슬라이드 1 사례를통해본 ORACLE MAA (Maximum Availability Architecture) 2013. 02. Seungtaek Lee( 放浪 DBA) ORACLE MAA 최고의가용성을보장하기위해 Oracle( 사 ) 의여러솔루션을조합한 Oracle 권고아키텍처 2 ORACLE DB HA Solution Set RAC, Data Guard(ADG), ASM,

More information

<4D F736F F D205BB4EBBBF3C1A4BAB8B1E2BCFA5DB1E2BCFAB9AEBCAD2D524D414EBBE7BFEBBFB9C1A65F39695F313067>

<4D F736F F D205BB4EBBBF3C1A4BAB8B1E2BCFA5DB1E2BCFAB9AEBCAD2D524D414EBBE7BFEBBFB9C1A65F39695F313067> 9i 에서의 RMAN 사용법예제 Author : 여현승 Creation Date : 2009-04-15 Last Updated : Latest Version : 1.0 Updated by Updated date Version < YYYY-MM-DD>

More information

Contents 1. Oracle Recovery Manager(RMAN) RMAN이란? RMAN의특징 RMAN의 Channel과 Media Management RMAN CONFIGURE COMMAND.

Contents 1. Oracle Recovery Manager(RMAN) RMAN이란? RMAN의특징 RMAN의 Channel과 Media Management RMAN CONFIGURE COMMAND. Goodus 기술노트 [40 회 ] Recovery Manager(RMAN) Author Author Job Title 김상국 차장 Creation Date 2009-04-30 Last Updated 2009-04-30 Version 1.0 Copyright(C) 2004 Goodus Inc. All Rights Reserved Contents 1. Oracle

More information

Microsoft Word - RMAN 스터디자료_공개용_ doc

Microsoft Word - RMAN 스터디자료_공개용_ doc RMAN 의특징및기능에대한내부기술자료 발표일 : 2004 년 9 월 3 일 작성자 : LG 카드중형서버운영파트민연홍 작성일 : 2004 년 9 월 3 일 업데이트 : 2006 년 2 월 23 일 목 차 1. rman 의특징... 2 2. rman catalog... 2 3. 컨트롤파일을사용한 rman repository... 2 4. CHANNEL 할당...

More information

ORANGE FOR ORACLE V4.0 INSTALLATION GUIDE (Online Upgrade) ORANGE CONFIGURATION ADMIN O

ORANGE FOR ORACLE V4.0 INSTALLATION GUIDE (Online Upgrade) ORANGE CONFIGURATION ADMIN O Orange for ORACLE V4.0 Installation Guide ORANGE FOR ORACLE V4.0 INSTALLATION GUIDE...1 1....2 1.1...2 1.2...2 1.2.1...2 1.2.2 (Online Upgrade)...11 1.3 ORANGE CONFIGURATION ADMIN...12 1.3.1 Orange Configuration

More information

62

62 2 instance database physical storage 2 1 62 63 tablespace datafiles 2 2 64 1 2 logical view control files datafiles redo log files 65 2 3 9i OMF Oracle Managed Files, OMF 9i 9i / / OMF 9i 66 8 1MB 8 10MB

More information

Tablespace On-Offline 테이블스페이스 온라인/오프라인

Tablespace On-Offline 테이블스페이스 온라인/오프라인 2018/11/10 12:06 1/2 Tablespace On-Offline 테이블스페이스온라인 / 오프라인 목차 Tablespace On-Offline 테이블스페이스온라인 / 오프라인... 1 일반테이블스페이스 (TABLESPACE)... 1 일반테이블스페이스생성하기... 1 테이블스페이스조회하기... 1 테이블스페이스에데이터파일 (DATA FILE) 추가

More information

Advanced Product Service

Advanced Product Service Advanced Oracle Document CONVERT to ASM and Non-ASM Author: Hyun-Ho, Jung Site: http://www.commit.co.kr Email: admin@commit.co.kr cleanto@naver.com Creation Date: 2011-12 - 13 CONVERT to ASM and Non-ASM

More information

세미나(장애와복구-수강생용).ppt

세미나(장애와복구-수강생용).ppt DB PLAN Consultant jina6678@yahoo.co.kr 011-864-1858 - - 1. 2. DB 3. - 4. - 5. 6. 1 INSTANCE MMAN RECO RFS MRP ORBn RBAL MMON Dnnn Snnn Data Buffer Cache SGA Stream Pool Shared pool Large Pool PGA Log

More information

Microsoft Word - 10g RAC on Win2k.doc

Microsoft Word - 10g RAC on Win2k.doc 10g RAC on Win2K Document Control Date Author Change References 2006-03-30 신종근 초기작성함 1-1 ** Agenda 1. 작업목적 Down-Time 최소화!! 2. Pre-Install 환경 3. CRS Install 4. DBMS S/W Install 5. 9i 10g Upgrade 6. 문제점및주의사항

More information

목 차

목      차 Oracle 9i Admim 1. Oracle RDBMS 1.1 (System Global Area:SGA) 1.1.1 (Shared Pool) 1.1.2 (Database Buffer Cache) 1.1.3 (Redo Log Buffer) 1.1.4 Java Pool Large Pool 1.2 Program Global Area (PGA) 1.3 Oracle

More information

Document Server Information Items Description Test Date 2011 / 05 / 31 CPU Intel(R) Xeon(R) CPU 2.40GHz X 8 Main Memory 1GB O/S version OEL 5.

Document Server Information Items Description Test Date 2011 / 05 / 31 CPU Intel(R) Xeon(R) CPU 2.40GHz X 8 Main Memory 1GB O/S version OEL 5. 11g 에서향상된 ASMCMD-CP 기능 (Oracle 11g R1 11.1.0.7) Author: Hyun-Ho, Jung Job: Oracle DBA Site: http://www.commit.co.kr Email: admin@commit.co.kr cleanto@naver.com Creation Date: 2011-05-31 Document Server

More information

Simplify your Job Automatic Storage Management DB TSC

Simplify your Job Automatic Storage Management DB TSC Simplify your Job Automatic Storage Management DB TSC 1. DBA Challenges 2. ASM Disk group 3. Mirroring/Striping/Rebalancing 4. Traditional vs. ASM 5. ASM administration 6. ASM Summary Capacity in Terabytes

More information

목차 BUG offline replicator 에서유효하지않은로그를읽을경우비정상종료할수있다... 3 BUG 각 partition 이서로다른 tablespace 를가지고, column type 이 CLOB 이며, 해당 table 을 truncate

목차 BUG offline replicator 에서유효하지않은로그를읽을경우비정상종료할수있다... 3 BUG 각 partition 이서로다른 tablespace 를가지고, column type 이 CLOB 이며, 해당 table 을 truncate ALTIBASE HDB 6.1.1.5.6 Patch Notes 목차 BUG-39240 offline replicator 에서유효하지않은로그를읽을경우비정상종료할수있다... 3 BUG-41443 각 partition 이서로다른 tablespace 를가지고, column type 이 CLOB 이며, 해당 table 을 truncate 한뒤, hash partition

More information

Microsoft PowerPoint - Linux_10gRAC_3Node

Microsoft PowerPoint - Linux_10gRAC_3Node Linux 환경에서 3 Node 10g RAC 구성및 Data 이관하기 일시 : 2006. 08. 10 Contents I. RAC 구성환경및전체순서 II. Volume 및 Server 환경 Setup III. CRS 및 DB S/W 설치 IV. CRS 및 DB S/W Patchset V. File-System DBF raw-device 이관 VI. Sinlge

More information

오라클 데이터베이스 10g 핵심 요약 노트

오라클 데이터베이스 10g 핵심 요약 노트 1 10g 10g SYSAUX 10g 22 Oracle Database 10g, 10g. 10g. (Grid), 10g.. 10g SYSAUX (ASM, Automatic Storage Management) 10g 10g. g. (DBA).,., 1).,..? 10g,.. (Larry Ellison).. (Leverage Components), (ASM) (

More information

PowerPoint Presentation

PowerPoint Presentation Server I/O utilization System I/O utilization V$FILESTAT V$DATAFILE Data files Statspack Performance tools TABLESPACE FILE_NAME PHYRDS PHYBLKRD READTIM PHYWRTS PHYBLKWRT WRITETIM ------------- -----------------------

More information

단계

단계 본문서에서는 Tibero RDBMS 운영중에발생할수있는장애상황을가정하여각유형별장애상황에대해 Tibero 에서지원하고있는백업및복구방법을알아본다. Contents 1. BACKUP & RECOVERY 개요... 4 1.1. BACKUP( 백업 )... 4 1.2. RECOVERY( 복구 )... 4 2. BACKUP... 5 2.1. 백업형태... 5 2.1.1.

More information

Microsoft Word - dataguard_세미나_v1.8.doc

Microsoft Word - dataguard_세미나_v1.8.doc Oracle9i Dataguard 기술서 작성일 : 2005년 3월 24일업데이트 : 2006년 1월 22일 v1.8 Final 작성자 : LG카드중형서버운영파트 DBA 민연홍 Phone : 016-744-0220 E-Mail : ses0124@hanmail.net 목 차 1. dataguard 개요및아키텍처...2 (1) dataguard 란무엇인가?...2

More information

큰 제목은 18 bold

큰 제목은 18 bold 1. Backup & Recovery 개요 2. Backup 3. Recovery 4. Complete & Incomplete Recovery II - 1 1. Backup & Recovery 개요 Failure 범주 Statement failure - SQL 문수행오류 User Process failure - OS 프로세스의비정상종료 User failure

More information

Oracle Database 10g: Self-Managing Database DB TSC

Oracle Database 10g: Self-Managing Database DB TSC Oracle Database 10g: Self-Managing Database DB TSC Agenda Overview System Resource Application & SQL Storage Space Backup & Recovery ½ Cost ? 6% 12 % 6% 6% 55% : IOUG 2001 DBA Survey ? 6% & 12 % 6% 6%

More information

소개 TeraStation 을 구입해 주셔서 감사합니다! 이 사용 설명서는 TeraStation 구성 정보를 제공합니다. 제품은 계속 업데이트되므로, 이 설명서의 이미지 및 텍스트는 사용자가 보유 중인 TeraStation 에 표시 된 이미지 및 텍스트와 약간 다를 수

소개 TeraStation 을 구입해 주셔서 감사합니다! 이 사용 설명서는 TeraStation 구성 정보를 제공합니다. 제품은 계속 업데이트되므로, 이 설명서의 이미지 및 텍스트는 사용자가 보유 중인 TeraStation 에 표시 된 이미지 및 텍스트와 약간 다를 수 사용 설명서 TeraStation Pro II TS-HTGL/R5 패키지 내용물: 본체 (TeraStation) 이더넷 케이블 전원 케이블 TeraNavigator 설치 CD 사용 설명서 (이 설명서) 제품 보증서 www.buffalotech.com 소개 TeraStation 을 구입해 주셔서 감사합니다! 이 사용 설명서는 TeraStation 구성 정보를

More information

CD-RW_Advanced.PDF

CD-RW_Advanced.PDF HP CD-Writer Program User Guide - - Ver. 2.0 HP CD-RW Adaptec Easy CD Creator Copier, Direct CD. HP CD-RW,. Easy CD Creator 3.5C, Direct CD 3.0., HP. HP CD-RW TEAM ( 02-3270-0803 ) < > 1. CD...3 CD...5

More information

The Self-Managing Database : Automatic Health Monitoring and Alerting

The Self-Managing Database : Automatic Health Monitoring and Alerting The Self-Managing Database : Automatic Health Monitoring and Alerting Agenda Oracle 10g Enterpirse Manager Oracle 10g 3 rd Party PL/SQL API Summary (Self-Managing Database) ? 6% 6% 12% 55% 6% Source: IOUG

More information

Microsoft PowerPoint - 가상환경에최적화된_NetBackup_Appliance

Microsoft PowerPoint - 가상환경에최적화된_NetBackup_Appliance 가상환경에최적화된 Symantec NetBackup Appliance 1 Contents 1 현재백업환경은? 2 NetBackup Appliance 소개 3 가상화환경에서의데이터보호방안 2 현재백업환경은? 3 물리환경과가상환경의추이 4 시장분석 데이터가상화비율 $4,500 $4,000 $3,500 $3,000 $2,500 $2,000 Total Data Protection

More information

Data Guard 기본개념.doc

Data Guard 기본개념.doc Data Guard 개념 (9i R2 9.2.0.1) 김형일 HIKIM000@EMPAL.COM 1 목차 1. DataGuard 개념 3 1.1 Data Guard Architecture 3 1.2 DataGuard 장점 4 1.3 Switch over and Failover 5 1.4 Physical Standby 와 Logical Standby 5 2. Data

More information

I T C o t e n s P r o v i d e r h t t p : / / w w w. h a n b i t b o o k. c o. k r

I T C o t e n s P r o v i d e r h t t p : / / w w w. h a n b i t b o o k. c o. k r I T C o t e n s P r o v i d e r h t t p : / / w w w. h a n b i t b o o k. c o. k r -------------------------------------------------------------------- -- 1. : ts_cre_bonsa.sql -- 2. :

More information

Oracle Database 12c High Availability

Oracle Database 12c High Availability Maximize Availability With Oracle Database 12c 김지훈수석컨설턴트 Tech Sales Consulting / 한국오라클 james.kim@oracle.com 1 Copyright 2013, Oracle and/or its affiliates. All rights reserved. Oracle Database 12c Extreme

More information

Jerry Held

Jerry Held DB / TSC Oracle Database 10g (Self-Managing Database) (Common Infrastructure) (Automatic Workload Repository) (Server-generated Alerts) (Automated Maintenance Tasks) (Advisory Framework) (ADDM) (Self-Managing

More information

SRC PLUS 제어기 MANUAL

SRC PLUS 제어기 MANUAL ,,,, DE FIN E I N T R E A L L O C E N D SU B E N D S U B M O TIO

More information

Remote UI Guide

Remote UI Guide Remote UI KOR Remote UI Remote UI PDF Adobe Reader/Adobe Acrobat Reader. Adobe Reader/Adobe Acrobat Reader Adobe Systems Incorporated.. Canon. Remote UI GIF Adobe Systems Incorporated Photoshop. ..........................................................

More information

Title Slide with Name

Title Slide with Name DB 백업복구에대한새로운접근방안 April 12, 2017 민준흠부장 SE, 베리타스코리아 TECH SYMPOSIUM 2017 1. 데이터베이스보호의고민 2. What is NetBackup Copilot? 3. Summary Agenda TECH SYMPOSIUM 2017 1. 데이터베이스보호의고민 데이터베이스백업 / 복구의 4 가지고민 복잡성증가 데이터증가

More information

PRO1_09E [읽기 전용]

PRO1_09E [읽기 전용] Siemens AG 1999 All rights reserved File: PRO1_09E1 Information and - ( ) 2 3 4 5 Monitor/Modify Variables" 6 7 8 9 10 11 CPU 12 Stop 13 (Forcing) 14 (1) 15 (2) 16 : 17 : Stop 18 : 19 : (Forcing) 20 :

More information

PowerPoint Presentation

PowerPoint Presentation Data Protection Rapid Recovery x86 DR Agent based Backup - Physical Machine - Virtual Machine - Cluster Agentless Backup - VMware ESXi Deploy Agents - Windows - AD, ESXi Restore Machine - Live Recovery

More information

Tibero

Tibero Tibero 백업 & 복구가이드 Copyright 2013 TmaxData Co., Ltd. All Rights Reserved. Copyright Notice Copyright 2013 TmaxData Co., Ltd. All Rights Reserved. 대한민국경기도성남시분당구황새울로 329 번길 5 티맥스빌딩우 ) 463-824 Restricted Rights

More information

Microsoft PowerPoint - Tech-iSeminar_Managing_Tablespace.ppt

Microsoft PowerPoint - Tech-iSeminar_Managing_Tablespace.ppt Tablespace 의관리 Getting the most out of MetaLink 최창권, 김주연 제품지원실한국오라클 ( 주 ) 한국오라클에서주최하는 Technical iseminar DATABASE의 tablespace 이해 에참석해주신여러분께감사드립니다. 저는한국오라클제품지원실에근무하는최창권입니다. 오늘세미나에서는 ORACLE database의논리적인저장소역할을하는

More information

MS-SQL SERVER 대비 기능

MS-SQL SERVER 대비 기능 Business! ORACLE MS - SQL ORACLE MS - SQL Clustering A-Z A-F G-L M-R S-Z T-Z Microsoft EE : Works for benchmarks only CREATE VIEW Customers AS SELECT * FROM Server1.TableOwner.Customers_33 UNION ALL SELECT

More information

Microsoft Word - Oracle10gDB ±âº»¿î¿µÁöħ¼�.doc

Microsoft Word - Oracle10gDB ±âº»¿î¿µÁöħ¼�.doc Oracle 10g 기본운영지침서 - 국립중앙과학관실무자를위한운영지침서 Author : 엄진우 ( jinwoo.eom@oracle.com ) Creation Date : Last Updated : Control Number : Version : 2005년 1월 10일 2005년 1월 11일 Approvals:

More information

PowerChute Personal Edition v3.1.0 에이전트 사용 설명서

PowerChute Personal Edition v3.1.0 에이전트 사용 설명서 PowerChute Personal Edition v3.1.0 990-3772D-019 4/2019 Schneider Electric IT Corporation Schneider Electric IT Corporation.. Schneider Electric IT Corporation,,,.,. Schneider Electric IT Corporation..

More information

목차 BUG 문법에맞지않는질의문수행시, 에러메시지에질의문의일부만보여주는문제를수정합니다... 3 BUG ROUND, TRUNC 함수에서 DATE 포맷 IW 를추가지원합니다... 5 BUG ROLLUP/CUBE 절을포함하는질의는 SUBQUE

목차 BUG 문법에맞지않는질의문수행시, 에러메시지에질의문의일부만보여주는문제를수정합니다... 3 BUG ROUND, TRUNC 함수에서 DATE 포맷 IW 를추가지원합니다... 5 BUG ROLLUP/CUBE 절을포함하는질의는 SUBQUE ALTIBASE HDB 6.3.1.10.1 Patch Notes 목차 BUG-45710 문법에맞지않는질의문수행시, 에러메시지에질의문의일부만보여주는문제를수정합니다... 3 BUG-45730 ROUND, TRUNC 함수에서 DATE 포맷 IW 를추가지원합니다... 5 BUG-45760 ROLLUP/CUBE 절을포함하는질의는 SUBQUERY REMOVAL 변환을수행하지않도록수정합니다....

More information

Backup Exec

Backup Exec (sjin.kim@veritas.com) www.veritas veritas.co..co.kr ? 24 X 7 X 365 Global Data Access.. 100% Storage Used Terabytes 9 8 7 6 5 4 3 2 1 0 2000 2001 2002 2003 IDC (TB) 93%. 199693,000 TB 2000831,000 TB.

More information

K7VT2_QIG_v3

K7VT2_QIG_v3 1......... 2 3..\ 4 5 [R] : Enter Raid setup utility 6 Press[A]keytocreateRAID RAID Type: JBOD RAID 0 RAID 1: 2 7 " RAID 0 Auto Create Manual Create: 2 RAID 0 Block Size: 16K 32K

More information

System Recovery 사용자 매뉴얼

System Recovery 사용자 매뉴얼 Samsung OS Recovery Solution 을이용하여간편하게 MagicInfo 의네트워크를설정하고시스템을백업및복원할수있습니다. 시스템시작시리모컨의 - 버튼이나키보드의 F3 키를연속해서누르면복구모드로진입한후 Samsung OS Recovery Solution 이실행됩니다. Samsung OS Recovery Solution 은키보드와리모컨을사용하여조작할수있습니다.

More information

PowerPoint 프레젠테이션

PowerPoint 프레젠테이션 Reasons for Poor Performance Programs 60% Design 20% System 2.5% Database 17.5% Source: ORACLE Performance Tuning 1 SMS TOOL DBA Monitoring TOOL Administration TOOL Performance Insight Backup SQL TUNING

More information

Slide 1

Slide 1 Enterprise Manager 를활용한 Active Data Guard 강송희 TSC본부 DB 기술팀한국오라클 Agenda Active Data Guard 도입배경 기존 DR 솔루션대비 Active Data Guard 의특장점 Active Data Guard 의구성및동작원리 EM 을이용한설치 EM 을이용한모니터링및관리

More information

문서 제목

문서 제목 1 : Oracle9i JRE(Java Runtime Environment) OUI(Oracle Universal Installer) OS 25MB Memory 512 MB RAM # grep MemTotal /proc/meminfo Swap Space RAM 2 400 MB # /sbin/swapon s CD-ROM Drive Disk Space Temporary

More information

s SINUMERIK 840C Service and User Manual DATA SAVING & LOADING & & /

s SINUMERIK 840C Service and User Manual DATA SAVING & LOADING & & / SINUMERIK 840C Service and Uer Manual DATA SAVING & LOADING & & / / NC, RS232C /. NC NC / Computer link () Device ( )/PC / / Print erial Data input RS232C () Data output Data management FLOPPY DRIVE, FLOPPY

More information

MySQL-Ch10

MySQL-Ch10 10 Chapter.,,.,, MySQL. MySQL mysqld MySQL.,. MySQL. MySQL....,.,..,,.,. UNIX, MySQL. mysqladm mysqlgrp. MySQL 608 MySQL(2/e) Chapter 10 MySQL. 10.1 (,, ). UNIX MySQL, /usr/local/mysql/var, /usr/local/mysql/data,

More information

Mango220 Android How to compile and Transfer image to Target

Mango220 Android How to compile and Transfer image to Target Mango220 Android How to compile and Transfer image to Target http://www.mangoboard.com/ http://cafe.naver.com/embeddedcrazyboys Crazy Embedded Laboratory www.mangoboard.com cafe.naver.com/embeddedcrazyboys

More information

경우, TARGET 키워드 (AUXILIARY 키워드아님 ) 를사용하여반드시대기데이터베이스에접속해야 한다. 백업을수행하는동안, 대기데이터베이스는주데이터베이스를대체한다. 논리적대기데이터베이스의백업및복구주데이터베이스에서사용하는동일한방법으로논리적대기데이터베이스를백업할수있다.

경우, TARGET 키워드 (AUXILIARY 키워드아님 ) 를사용하여반드시대기데이터베이스에접속해야 한다. 백업을수행하는동안, 대기데이터베이스는주데이터베이스를대체한다. 논리적대기데이터베이스의백업및복구주데이터베이스에서사용하는동일한방법으로논리적대기데이터베이스를백업할수있다. 12 장. Data Guard 에대한그외고려사항 학습목표 - 물리적대기데이터베이스를가진주데이터베이스의백업 - 논리적대기데이터베이스의백업 - Data Guard 구조에서플래시백데이터베이스기능사용 - 리두정보암호화 - 연쇄리두로그위치구성 물리적대기데이터베이스로백업본해제 RMAN은대기데이터베이스와관련아카이브리두로그들을백업할수있다. 데이터파일들과아카이브리두로그들의대기백업본은주데이터베이스백업본과완전히대체가가능하다.

More information

Orcad Capture 9.x

Orcad Capture 9.x OrCAD Capture Workbook (Ver 10.xx) 0 Capture 1 2 3 Capture for window 4.opj ( OrCAD Project file) Design file Programe link file..dsn (OrCAD Design file) Design file..olb (OrCAD Library file) file..upd

More information

Microsoft PowerPoint - 프레젠테이션1

Microsoft PowerPoint - 프레젠테이션1 2008.5.22 피플앤데이타 Copyright 2006 Quest Software 주요내용 HyperBac 솔루션소개 DB 보안백업의중요성 Oracle 보안백업을위한 HyperBac 솔루션 HyperBac 운용을위한환경설정 HyperBac 의 Oracle 보안백업 (1-2) Oracle 을위한 HyperBac 압축백업 (1-2) HyperBac 도입시기대효과

More information

Smart Power Scope Release Informations.pages

Smart Power Scope Release Informations.pages v2.3.7 (2017.09.07) 1. Galaxy S8 2. SS100, SS200 v2.7.6 (2017.09.07) 1. SS100, SS200 v1.0.7 (2017.09.07) [SHM-SS200 Firmware] 1. UART Command v1.3.9 (2017.09.07) [SHM-SS100 Firmware] 1. UART Command SH모바일

More information

MAX+plus II Getting Started - 무작정따라하기

MAX+plus II Getting Started - 무작정따라하기 무작정 따라하기 2001 10 4 / Version 20-2 0 MAX+plus II Digital, Schematic Capture MAX+plus II, IC, CPLD FPGA (Logic) ALTERA PLD FLEX10K Series EPF10K10QC208-4 MAX+plus II Project, Schematic, Design Compilation,

More information

T100MD+

T100MD+ User s Manual 100% ) ( x b a a + 1 RX+ TX+ DTR GND TX+ RX+ DTR GND RX+ TX+ DTR GND DSR RX+ TX+ DTR GND DSR [ DCE TYPE ] [ DCE TYPE ] RS232 Format Baud 1 T100MD+

More information

untitled

untitled 1... 2 System... 3... 3.1... 3.2... 3.3... 4... 4.1... 5... 5.1... 5.2... 5.2.1... 5.3... 5.3.1 Modbus-TCP... 5.3.2 Modbus-RTU... 5.3.3 LS485... 5.4... 5.5... 5.5.1... 5.5.2... 5.6... 5.6.1... 5.6.2...

More information

휠세미나3 ver0.4

휠세미나3 ver0.4 andromeda@sparcs:/$ ls -al dev/sda* brw-rw---- 1 root disk 8, 0 2014-06-09 18:43 dev/sda brw-rw---- 1 root disk 8, 1 2014-06-09 18:43 dev/sda1 brw-rw---- 1 root disk 8, 2 2014-06-09 18:43 dev/sda2 andromeda@sparcs:/$

More information

10X56_NWG_KOR.indd

10X56_NWG_KOR.indd 디지털 프로젝터 X56 네트워크 가이드 이 제품을 구입해 주셔서 감사합니다. 본 설명서는 네트워크 기능 만을 설명하기 위한 것입니다. 본 제품을 올바르게 사 용하려면 이 취급절명저와 본 제품의 다른 취급절명저를 참조하시기 바랍니다. 중요한 주의사항 이 제품을 사용하기 전에 먼저 이 제품에 대한 모든 설명서를 잘 읽어 보십시오. 읽은 뒤에는 나중에 필요할 때

More information

PWR PWR HDD HDD USB USB Quick Network Setup Guide xdsl/cable Modem PC DVR 1~3 1.. DVR DVR IP xdsl Cable xdsl Cable PC PC DDNS (

PWR PWR HDD HDD USB USB Quick Network Setup Guide xdsl/cable Modem PC DVR 1~3 1.. DVR DVR IP xdsl Cable xdsl Cable PC PC DDNS ( PWR PWR HDD HDD USB USB Quick Network Setup Guide xdsl/cable Modem PC DVR 1~3 1.. DVR DVR IP xdsl Cable xdsl Cable PC PC DDNS (http://ddns.hanwha-security.com) Step 1~5. Step, PC, DVR Step 1. Cable Step

More information

OPCTalk for Hitachi Ethernet 1 2. Path. DCOMwindow NT/2000 network server. Winsock update win95. . . 3 Excel CSV. Update Background Thread Client Command Queue Size Client Dynamic Scan Block Block

More information

Contents Data Mart 1. 개요 실습방향 테스트위한사전설정 본격실습시작 ) 데이터파일 dd 명령어로 백업수행및유실시키기 ) 장애복구수행 결론...7 페이지 2 / 7

Contents Data Mart 1. 개요 실습방향 테스트위한사전설정 본격실습시작 ) 데이터파일 dd 명령어로 백업수행및유실시키기 ) 장애복구수행 결론...7 페이지 2 / 7 ( 참 ) 본상단부머리말에있는 Data Mart 는본문서작성자의블로그이름입니다 dd 명령어를 이용한백업수행 최소개념이해 본문서의 pdf 문서는다음 URL 참조 http://mindata.tistory.com/55 Version 변경일자 ( 작성일자 ) 변경자 ( 작성자 ) 주요내용 1 2013.4.3 김민기 최초작성 2 3 페이지 1 / 7 Contents

More information

最即時的Sybase ASE Server資料庫診斷工具

最即時的Sybase ASE Server資料庫診斷工具 TOAD 9.5 Toad Oracle 料 SQL 料 行 理 SQLprofile Quest Software 了 Oracle -Toad Tools of Oracle Application Developers Toad 了 DBA DBA 理 易 度 Toad 料 SQL PL/SQL Toad Oracle PL/SQL Toad Schema Browser Schema Browser

More information

LCD Display

LCD Display LCD Display SyncMaster 460DRn, 460DR VCR DVD DTV HDMI DVI to HDMI LAN USB (MDC: Multiple Display Control) PC. PC RS-232C. PC (Serial port) (Serial port) RS-232C.. > > Multiple Display

More information

목차 1. 제품 소개... 4 1.1 특징... 4 1.2 개요... 4 1.3 Function table... 5 2. 기능 소개... 6 2.1 Copy... 6 2.2 Compare... 6 2.3 Copy & Compare... 6 2.4 Erase... 6 2

목차 1. 제품 소개... 4 1.1 특징... 4 1.2 개요... 4 1.3 Function table... 5 2. 기능 소개... 6 2.1 Copy... 6 2.2 Compare... 6 2.3 Copy & Compare... 6 2.4 Erase... 6 2 유영테크닉스( 주) 사용자 설명서 HDD014/034 IDE & SATA Hard Drive Duplicator 유 영 테 크 닉 스 ( 주) (032)670-7880 www.yooyoung-tech.com 목차 1. 제품 소개... 4 1.1 특징... 4 1.2 개요... 4 1.3 Function table... 5 2. 기능 소개... 6 2.1 Copy...

More information

Oracle hacking 작성자 : 임동현 작성일 2008 년 10 월 11 일 ~ 2008 년 10 월 19 일 신규작성 작성내용

Oracle hacking 작성자 : 임동현 작성일 2008 년 10 월 11 일 ~ 2008 년 10 월 19 일 신규작성 작성내용 Oracle hacking 작성자 : 임동현 (ddongsbrk@naver.com) 작성일 2008 년 10 월 11 일 ~ 2008 년 10 월 19 일 신규작성 작성내용 Skill List 1. Oracle For Pentest 1. Find TNS Listener (Default 1521 port) (with nmap or amap) 2. Get the

More information

Oracle9i Real Application Clusters

Oracle9i Real Application Clusters Senior Sales Consultant Oracle Corporation Oracle9i Real Application Clusters Agenda? ? (interconnect) (clusterware) Oracle9i Real Application Clusters computing is a breakthrough technology. The ability

More information

USB USB DV25 DV25 REC SRN-475S REC SRN-475S LAN POWER LAN POWER Quick Network Setup Guide xdsl/cable Modem PC DVR 1~3 1.. DVR DVR IP xdsl Cable xdsl C

USB USB DV25 DV25 REC SRN-475S REC SRN-475S LAN POWER LAN POWER Quick Network Setup Guide xdsl/cable Modem PC DVR 1~3 1.. DVR DVR IP xdsl Cable xdsl C USB USB DV25 DV25 REC SRN-475S REC SRN-475S LAN POWER LAN POWER Quick Network Setup Guide xdsl/cable Modem PC DVR 1~3 1.. DVR DVR IP xdsl Cable xdsl Cable PC PC Step 1~5. Step, PC, DVR Step 1. Cable Step

More information

PCServerMgmt7

PCServerMgmt7 Web Windows NT/2000 Server DP&NM Lab 1 Contents 2 Windows NT Service Provider Management Application Web UI 3 . PC,, Client/Server Network 4 (1),,, PC Mainframe PC Backbone Server TCP/IP DCS PLC Network

More information

ALTIBASE HDB Patch Notes

ALTIBASE HDB Patch Notes ALTIBASE HDB 5.3.3.93 Patch Notes Table of Contents BUG-27950 ALL PRIVILEGES 권한을가진계정이다른계정의테이블에 Foreign Key 를 생성하지못한다. 3 BUG-38105 PASSWORD_LIFE_TIME 경과후유예기간 (PASSWORD_GRACE_TIME) 내에 접속을시도할경우알림메시지를발생해야한다.

More information

1217 WebTrafMon II

1217 WebTrafMon II (1/28) (2/28) (10 Mbps ) Video, Audio. (3/28) 10 ~ 15 ( : telnet, ftp ),, (4/28) UDP/TCP (5/28) centralized environment packet header information analysis network traffic data, capture presentation network

More information

ETL_project_best_practice1.ppt

ETL_project_best_practice1.ppt ETL ETL Data,., Data Warehouse DataData Warehouse ETL tool/system: ETL, ETL Process Data Warehouse Platform Database, Access Method Data Source Data Operational Data Near Real-Time Data Modeling Refresh/Replication

More information

PRO1_02E [읽기 전용]

PRO1_02E [읽기 전용] Siemens AG 1999 All rights reserved File: PRO1_02E1 Information and 2 STEP 7 3 4 5 6 STEP 7 7 / 8 9 10 S7 11 IS7 12 STEP 7 13 STEP 7 14 15 : 16 : S7 17 : S7 18 : CPU 19 1 OB1 FB21 I10 I11 Q40 Siemens AG

More information

SMB_ICMP_UDP(huichang).PDF

SMB_ICMP_UDP(huichang).PDF SMB(Server Message Block) UDP(User Datagram Protocol) ICMP(Internet Control Message Protocol) SMB (Server Message Block) SMB? : Microsoft IBM, Intel,. Unix NFS. SMB client/server. Client server request

More information

PowerPoint 프레젠테이션

PowerPoint 프레젠테이션 Spider For MySQL 실전사용기 피망플러스유닛최윤묵 Spider For MySQL Data Sharding By Spider Storage Engine http://spiderformysql.com/ 성능 8 만 / 분 X 4 대 32 만 / 분 많은 DB 중에왜 spider 를? Source: 클라우드컴퓨팅구 선택의기로 Consistency RDBMS

More information

Oracle 11gR2 RAC to RAC Active Dataguard

Oracle 11gR2 RAC to RAC Active Dataguard Oracle 11gR2 RAC to RAC Active DataGuard (with ASM+Rawdevice) Author 강경구 Creation Date 2010-08-05 Last Updated Version 1.0 Copyright(C) 2009 Goodus Inc. All Rights Reserved Version 변경일자변경자 ( 작성자 ) 주요내용

More information

untitled

untitled Push... 2 Push... 4 Push... 5 Push... 13 Push... 15 1 FORCS Co., LTD A Leader of Enterprise e-business Solution Push (Daemon ), Push Push Observer. Push., Observer. Session. Thread Thread. Observer ID.

More information

본교재는수업용으로제작된게시물입니다. 영리목적으로사용할경우저작권법제 30 조항에의거법적처벌을받을수있습니다. [ 실습 ] 스위치장비초기화 1. NVRAM 에저장되어있는 'startup-config' 파일이있다면, 삭제를실시한다. SWx>enable SWx#erase sta

본교재는수업용으로제작된게시물입니다. 영리목적으로사용할경우저작권법제 30 조항에의거법적처벌을받을수있습니다. [ 실습 ] 스위치장비초기화 1. NVRAM 에저장되어있는 'startup-config' 파일이있다면, 삭제를실시한다. SWx>enable SWx#erase sta [ 실습 ] 스위치장비초기화 1. NVRAM 에저장되어있는 'startup-config' 파일이있다면, 삭제를실시한다. SWx>enable SWx#erase startup-config Erasing the nvram filesystem will remove all configuration files Continue? [confirm] ( 엔터 ) [OK] Erase

More information

6주차.key

6주차.key 6, Process concept A program in execution Program code PCB (process control block) Program counter, registers, etc. Stack Heap Data section => global variable Process in memory Process state New Running

More information

Sun Java System Messaging Server 63 64

Sun Java System Messaging Server 63 64 Sun Java System Messaging Server 6.3 64 Sun Java TM System Communications Suite Sun Microsystems, Inc. 4150 Network Circle Santa Clara, CA 95054 U.S.A. : 820 2868 2007 7 Copyright 2007 Sun Microsystems,

More information

github_introduction.key

github_introduction.key Github/Git Starter Guide for Introductory Level Curtis Kim @ KAKAO Why Github/Git? - :, - - Q1 :? - Q2 :? - Q3 : ( )? - Q4 :? - Github/Git. Old Paradigm : - - a.java.. Git. - - - - - - - - - (commit &

More information

디지털포렌식학회 논문양식

디지털포렌식학회 논문양식 ISSN : 1976-5304 http://www.kdfs.or.kr Virtual Online Game(VOG) 환경에서의 디지털 증거수집 방법 연구 이 흥 복, 정 관 모, 김 선 영 * 대전지방경찰청 Evidence Collection Process According to the Way VOG Configuration Heung-Bok Lee, Kwan-Mo

More information

Chapter 1

Chapter 1 3 Oracle 설치 Objectives Download Oracle 11g Release 2 Install Oracle 11g Release 2 Download Oracle SQL Developer 4.0.3 Install Oracle SQL Developer 4.0.3 Create a database connection 2 Download Oracle 11g

More information

10.ppt

10.ppt : SQL. SQL Plus. JDBC. SQL >> SQL create table : CREATE TABLE ( ( ), ( ),.. ) SQL >> SQL create table : id username dept birth email id username dept birth email CREATE TABLE member ( id NUMBER NOT NULL

More information

문서 대제목

문서 대제목 Linux OS Backup 교육자료 v1.1 2013. 12. 27. 이스턴네트웍스 기술지원팀전흥수 목차 1. Linux OS Backup & Cloning Layout 2. Solution Install & Configuration 3. Recovery Procedure 4. Reference Site - 1 - 1. Linux OS Backup / Cloning

More information

슬라이드 1

슬라이드 1 Pairwise Tool & Pairwise Test NuSRS 200511305 김성규 200511306 김성훈 200614164 김효석 200611124 유성배 200518036 곡진화 2 PICT Pairwise Tool - PICT Microsoft 의 Command-line 기반의 Free Software www.pairwise.org 에서다운로드후설치

More information

MPLAB C18 C

MPLAB C18 C MPLAB C18 C MPLAB C18 MPLAB C18 C MPLAB C18 C #define START, c:\mcc18 errorlevel{0 1} char isascii(char ch); list[list_optioin,list_option] OK, Cancel , MPLAB IDE User s Guide MPLAB C18 C

More information

1. What is AX1 AX1 Program은 WIZnet 사의 Hardwired TCP/IP Chip인 iinchip 들의성능평가및 Test를위해제작된 Windows 기반의 PC Program이다. AX1은 Internet을통해 iinchip Evaluation

1. What is AX1 AX1 Program은 WIZnet 사의 Hardwired TCP/IP Chip인 iinchip 들의성능평가및 Test를위해제작된 Windows 기반의 PC Program이다. AX1은 Internet을통해 iinchip Evaluation 1. What is AX1 AX1 Program은 WIZnet 사의 Hardwired TCP/IP Chip인 iinchip 들의성능평가및 Test를위해제작된 Windows 기반의 PC Program이다. AX1은 Internet을통해 iinchip Evaluation Board(EVB B/D) 들과 TCP/IP Protocol로연결되며, 연결된 TCP/IP

More information

PowerPoint Presentation

PowerPoint Presentation FORENSIC INSIGHT; DIGITAL FORENSICS COMMUNITY IN KOREA SQL Server Forensic AhnLab A-FIRST Rea10ne unused6@gmail.com Choi Jinwon Contents 1. SQL Server Forensic 2. SQL Server Artifacts 3. Database Files

More information

인켈(국문)pdf.pdf

인켈(국문)pdf.pdf M F - 2 5 0 Portable Digital Music Player FM PRESET STEREOMONO FM FM FM FM EQ PC Install Disc MP3/FM Program U S B P C Firmware Upgrade General Repeat Mode FM Band Sleep Time Power Off Time Resume Load

More information

Cloud Friendly System Architecture

Cloud Friendly System Architecture -Service Clients Administrator 1. -Service 구성도 : ( 좌측참고 ) LB(LoadBlancer) 2. -Service 개요 ucloud Virtual Router F/W Monitoring 개념 특징 적용가능분야 Server, WAS, DB 로구성되어 web service 를클라우드환경에서제공하기위한 service architecture

More information

Contents db2set DB2LINUXAIO=true CONNECT TO SAMPLE; CREATE REGULAR TABLESPACE DIRECTTS MANAGED BY DATABASE USING (FILE /data/dbinst1/container1500) NO FILE SYSTEM CACHING; CONNECT RESET; TERMINATE; db2set

More information

Oracle Regular Expression

Oracle Regular Expression Installing Oracle Cloud Control 12c on Oracle Linux 6.1 SEUNGCHEOL HAN 설치에앞서 현재설치과정은 Oracle Linux Enterprise 6.1 (64bit) 에서진행됩니다. Oracle Cloud Control 12c 설치를위해 Repository DB 로사용할 Oracle 11g R2 (11.2.0.3)

More information

UNIST_교원 홈페이지 관리자_Manual_V1.0

UNIST_교원 홈페이지 관리자_Manual_V1.0 Manual created by metapresso V 1.0 3Fl, Dongin Bldg, 246-3 Nonhyun-dong, Kangnam-gu, Seoul, Korea, 135-889 Tel: (02)518-7770 / Fax: (02)547-7739 / Mail: contact@metabrain.com / http://www.metabrain.com

More information

2011년 10월 초판 c 2011 Sony Corporation. All rights reserved. 서면 허가 없이 전체 또는 일부를 복제하는 것을 금합니다. 기능 및 규격은 통보 없이 변경될 수 있습니다. Sony와 Sony 로고는 Sony의 상표입니다. G L

2011년 10월 초판 c 2011 Sony Corporation. All rights reserved. 서면 허가 없이 전체 또는 일부를 복제하는 것을 금합니다. 기능 및 규격은 통보 없이 변경될 수 있습니다. Sony와 Sony 로고는 Sony의 상표입니다. G L HXR-NX3D1용 3D 워크플로 가이드북 2011년 10월 초판 c 2011 Sony Corporation. All rights reserved. 서면 허가 없이 전체 또는 일부를 복제하는 것을 금합니다. 기능 및 규격은 통보 없이 변경될 수 있습니다. Sony와 Sony 로고는 Sony의 상표입니다. G Lens, Exmor, InfoLITHIUM, Memory

More information

,,,,,, (41) ( e f f e c t ), ( c u r r e n t ) ( p o t e n t i a l difference),, ( r e s i s t a n c e ) 2,,,,,,,, (41), (42) (42) ( 41) (Ohm s law),

,,,,,, (41) ( e f f e c t ), ( c u r r e n t ) ( p o t e n t i a l difference),, ( r e s i s t a n c e ) 2,,,,,,,, (41), (42) (42) ( 41) (Ohm s law), 1, 2, 3, 4, 5, 6 7 8 PSpice EWB,, ,,,,,, (41) ( e f f e c t ), ( c u r r e n t ) ( p o t e n t i a l difference),, ( r e s i s t a n c e ) 2,,,,,,,, (41), (42) (42) ( 41) (Ohm s law), ( ),,,, (43) 94 (44)

More information

<C0CCBCBCBFB52DC1A4B4EBBFF82DBCAEBBE7B3EDB9AE2D313939392D382E687770>

<C0CCBCBCBFB52DC1A4B4EBBFF82DBCAEBBE7B3EDB9AE2D313939392D382E687770> i ii iii iv v vi 1 2 3 4 가상대학 시스템의 국내외 현황 조사 가상대학 플랫폼 개발 이상적인 가상대학시스템의 미래상 제안 5 웹-기반 가상대학 시스템 전통적인 교수 방법 시간/공간 제약을 극복한 학습동기 부여 교수의 일방적인 내용전달 교수와 학생간의 상호작용 동료 학생들 간의 상호작용 가상대학 운영 공지사항,강의록 자료실, 메모 질의응답,

More information

Multi Channel Analysis. Multi Channel Analytics :!! - (Ad network ) Report! -! -!. Valuepotion Multi Channel Analytics! (1) Install! (2) 3 (4 ~ 6 Page

Multi Channel Analysis. Multi Channel Analytics :!! - (Ad network ) Report! -! -!. Valuepotion Multi Channel Analytics! (1) Install! (2) 3 (4 ~ 6 Page Multi Channel Analysis. Multi Channel Analytics :!! - (Ad network ) Report! -! -!. Valuepotion Multi Channel Analytics! (1) Install! (2) 3 (4 ~ 6 Page ) Install!. (Ad@m, Inmobi, Google..)!. OS(Android

More information

데이터베이스_오라클_부록(최종).indd

데이터베이스_오라클_부록(최종).indd C httpwwworaclecomdownloads DownloadsJavaJavaSE C1 5JDK JDKJavaDevelopmentKit Eclipse IDE JavaSEJavaSE7u55JDKDOWNLOAD JavaSEDevelopmentKitAcceptLicenseAgreement OS jdk7u55windowsi586exe7u55 version7update55windowsosi586os

More information