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

Size: px
Start display at page:

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

Transcription

1 Goodus 기술노트 [40 회 ] Recovery Manager(RMAN) Author Author Job Title 김상국 차장 Creation Date Last Updated Version 1.0 Copyright(C) 2004 Goodus Inc. All Rights Reserved

2 Contents 1. Oracle Recovery Manager(RMAN) RMAN이란? RMAN의특징 RMAN의 Channel과 Media Management RMAN CONFIGURE COMMAND SHOW 명령어 LIST명령어 REPORT명령어 RECOVERY CATALOG RMAN without a Recovery Catalog(Backup & Recovery) RMAN with a Recovery Catalog Recovery Catalog Setup Recovery Catalog를이용한 Rman Backup(Archive mode) Incremental Backup RMAN with Recovery(Datafile,Tablespace) Rman 을통한 Recovery 시나리오 ( 예제 ) Rman Recovery 를이용한 NEW 서버에 Restore Rman Backup 을위한 Script create Rman Repository 의유지관리 Removing Obsolete Backupsets RAC 환경에서의 RMAN Backup Migration using TTS with RMAN [ 이기종 Endian[ - Linux (Little) HP-UX (Big) 10G 이상 ]...33 Step1) Transportable Tablespace 사용을위한 Relation Check Step2) 해당 Transportable Tablespace 를 Read-only mode 로변경한다 Step3) rman 을이용한 datafile convert 작업 Step4) 해당 tablespace 를 export 한다 Step5) target DB 환경구성 (user) Step6) target DB 해당 tablespace Plugging 한다 Step7) 해당 tablespace Read-Write mode 로변경한다 Recovery Catalog Tables & Views 기타유용한 Script & 명령어정리 본산출물의내용은굿어스 의사전승인없이 외부유출및공개를금지합니다.

3 1. Oracle Recovery Manager(RMAN) 1.1. RMAN 이란? recovery manager (RMAN) 은오라클에서제공하는 backup/recovery solution이다. RMAN을이용하여많은 backup vender에서는 solution을제공하고있다. oracle도 EM을통해 RMAN backup을지원하고있다. rman은 oracle datafile, control file, archive file 을 backup할수있다. 그러나 online redo log에대해서는 backup을하지못하므로 archive 화하여 backup을한다. 또 init file이나 password file도 backup을하지못한다. 10g에서는 spfile backup이가능하게되었다. archive mode는물론 no-archive mode에대해 backup도가능하다. 하지만 no-archive mode에서의 backup시 target database는 open 상태이면당연히안된다. rman은 catalog를이용하는운영방법과 target database의 controlfile을이용하는방법이있으며, 오라클에서는 catalog를이용하는방법을강력히권고한다. control file을이용하는경우복구가어려울수있으며, resync 등의작업들이필요하게된다 rman은 Incremental Backup을지원하므로 backup 정책을유연하게수립할수있다. 만약다음과같이 backup 정책을수립했다고하면.. 일요일에 level 0로 full backup, 월요일에는 level 2로일요일 backup시점이후변동사항만을 incremental backup, 화요일에는 level 2로월요일 backup 시점이후변동사항만을 incremental backup, 수요일에는 level 1으로일요일 backup 시점이후변동사항만을 incremental backup, 목요일에는 level 2로수요일 backup 시점이후변동사항만을 incremental backup. 금요일에는 level 2로목요일 backup 시점이후변동사항만을 incremental backup 만약토요일에장애가발생하면, 일요일, 수요일, 목요일, 금요일의 backup을이용하여 recovery하면된다. 만약 level 1 incremental backup을이틀에한번정도할수있다면 recovery 시간은더단축할수있다

4 1.2. RMAN 의특징 DB 전체, Tablespace 단위,Database files, Archive logs, 그리고 Control files 들을 Backup 자주실행되는 operation 들은 script 로저장하여간단하게실행할수있다. Incremental block level backup 을할수있다. 사용되어지지않은 database block 들은 skip 한다. Backup /resotre 시각 block 에대한 checksum 을통해 Corrupted block 을 detection Online file 을 backup 할때, tablespace 를 backup mode 로할필요가없다. Backup performance 향상 (Parallelization, less redo log 생성 ) OS 의 open file limit 을피하기위해 open file limit 을지정할수있으며, backup 의사이즈의 limit 을줄수있다. 또한 file 당, second 당 reads 를지정해서부하를조정할수있다. RMAN 의메모리사용 RMAN 을사용할시주의해야하는것은 shared pool 과 large pool 입니다. RMAN 은몇개의 Oracle PL/SQL 패키지들을기존의 PL/SQL 패키지들과마찬가지로 Shared Pool 에올려사용합니다. 이때 Shared Pool 의여유공간이부족하거나단편화현상이심할시에는 RMAN 패키지가실행되지않을수가있습니다. 항상 Shared Pool 내부에 RMAN 의실행에충분한메모리가존재해야합니다. RMAN 의주요용어와개념 - Target database backup,restore,recovery action 이수행될대상데이타베이스입니다. - Recovery Catalog RMAN 에서사용하는 Information 저장장소입니다. target database 의물리적스키마, datafile 과 archivelog 의 backup sets 과 pieces, backup script 등을포함하고있습니다. - channel allocation channel 은 target database 의 backup,restore,recover 에대한 server process 초기화를합니다. 즉, 이 channel 은 disk 를포함기타 OS device 를지정하게되며, 이에따라 parallelization 의 degree 가결정됩니다. - Backup sets 하나또는그이상의 Datafiles 또는 Archivelogs 를포함하며,Backup pieces 의 Complate Set 으로, Full 또는 Incremental Backup 으로구성됩니다. Oracle proprietary format 을사용합니다. - Backup Pieces 하나의 Backup Set 은하나또는그이상의 Backup Pieces 로구성이되어지며, 각 Backup Piece 는 Single Output File 로 O/S 의 File system Size 의제한을갖고있습니다 RMAN 의 Channel 과 Media Management Oracle RMAN을이용하여 DataBase백업시 Channel을할당하여야한다. Channel 할당방법은 allocate channel이라는명령어에의한 Manual Channel allocation과 Configure 명령어에의한 Automatic Channel allocation이있다

5 configure defautl device type to sbt; 에서 sbt 는 tape 장치를의미한다. 즉기본적인 default 백업장치를지정해주는것이다. RMAN 에서 Backup device 에 backup 을하기위해 Media Management Library 가필요하며 media vendor 가제공하는 libraray 로 Oracle 과의 interface 를제공한다 본산출물의내용은굿어스 의사전승인없이 외부유출및공개를금지합니다.

6 1.4. RMAN CONFIGURE COMMAND configure channel device type disk format '/db01/backup/%u'; 포멧을지정해준다. 자동채널할당참고 %d : db name, %s : backup set, %p : backup piece, %c : backup copy configure retention policy to recovery window of 7 days; 복구를위한백업을유지해주는기간설정 configure retention policy to redundancy 2; default 는 1 이다. configure retention policy clear ; retention policy 정보를 clear configure datafile backup copies form device type disk to 2; 백업의복사본을 2 개로만들겠다는설정명령. Format 에서 %c 가있어야중복되지않으므로에러가발생하지않는다. configure backup optimization on ; backup 시 optimize 시킴 configure retention policy clear; retention policy 를 clear (backup 유지기간설정을 clear) configure channel device type sbt clear ; configure RMAN 관련한 default configuration (note Persistent Controlfile configurations for RMAN in 9i and 10g. 참고 ) - CONFIGURE RETENTION POLICY TO REDUNDANCY 1; Backup 보관주기나 backup 본의갯수를설정합니다. - CONFIGURE BACKUP OPTIMIZATION OFF; 이미 backup 된동일한 (checkpoint SCN 등 ) datafile, archived redolog, backup set 이있다면 skip 합니다. - CONFIGURE DEFAULT DEVICE TYPE TO DISK; default backup device 를설정합니다

7 - CONFIGURE CONTROLFILE AUTOBACKUP OFF; RMAN 의 BACKUP 이나 COPY 명령등의수행후자동으로 control file backup 을수행합니다. - CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; autobackup 되는 control file 의기본 format 을변경합니다. - CONFIGURE DEVICE TYPE DISK PARALLELISM 1; 특정 device 에 automatic channel allocation 될때 channel 의갯수를지정합니다. - CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; DATAFILE, CONTROL FILE 의 backup set 의 copy 본갯수를지정합니다. - CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; ARCHIVELOG FILE 의 backup set 의 copy 본갯수를지정합니다. - CONFIGURE MAXSETSIZE TO UNLIMITED; backupset 의 maximum size 를설정합니다. - CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; (10g only) flash recovery area 의 archived redo log 에대한삭제여부를설정합니다. - CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/oracle/product/ora10g/dbs/snapcf_db10g.f'; RMAN 은 resync 시생성되는임시 snapshot control file 의이름을지정한다 SHOW 명령어 show all 명령을하면모두보인다. 아래는특정한것만볼경우사용을한다

8 1.6. LIST 명령어 list backup of database; 데이터베이스백업정보를출력한다. list backup of datafile ~ : 데이터파일백업정보를출력한다. List copy of tablespace system : system tablespace 가 copy 명령으로백업되었는지확인한다 REPORT 명령어 report need backup incremental 3 ; incremental level 3 일경우백업이필요한지 report 참고 > backup database incremental level 0 이면전체백업 report need backup days 3 ;3 일이지났을경우백업이필요한것을 report ; 만약 retention policy 에의해서 backup 한것이기간이지났을경우, report 됨. 2. RECOVERY CATALOG Recovery Catalog 는 RMAN 에의해사용되어지며 Recovery Catalog 에저장되어있는정보를사용하여요청되어진 Backup 과 Resotre 를실행한다. Rman Backup 에있어서 Backup & Recovery 를용이하게하고속도를향상시키고, 동시에데이터손실위험을감소시키려면다음지침을따라야한다. 1. 대상데이터베이스에복구카탈로그 (Recovery Catalog) 를생성하지마십시요. 2. 별도의디스크상에파일을가진별개의 DB 를생성하라. 3. 백업해야할 DB 가많다면모든대상 DB 의정보를담아둘별도의 Recovery Catalog DB 를생성하라

9 4. Recovery Catalog 를백업하라. catalog 없이 RMAN 을사용할때의단점은 recovery catalog 의 overhead 가없는대신, Point-In-Time recovery 를쉽게할수없다. 또한, control file 손상시에 recovery 할수없고, stored script 를사용할수없다. 이에 RMAN 을사용하기에앞서 Recovery Catalog 를사용할지아니면 Target DataBase 의 Control file 을사용할지 (NoCatalog) 에대해결정을하여야한다. Oracle 은항상 Recovery Catalog 를사용하도록권장한다. Recovery Catalog 를사용하므로써 Backup 의 performance 를높일수있으며 Target Database 의 Controlfile 유실에대비해서도 Recovery 를효과적으로수행할수있다. 3. RMAN without a Recovery Catalog(Backup & Recovery) Recovery Catalog 없이 rman 을사용하여기본 configure 및 Backup & Recovery 를진행한다. [busan1 $ rman target / nocatalog Recovery Catalog 없이접속 Recovery Manager: Release Production on Mon Jan 1 23:45: Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: PROD (DBID= ) using target database control file instead of recovery catalog RMAN> configure channel device type disk format '/u01/app/oracle/backup/prod_%u'; device 에대한 channel 을설정한다. RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/oracle/backup/control/%f'; controlfile Auto backup channel 설정 RMAN> CONFIGURE BACKUP OPTIMIZATION ON; Backup 최적화 option RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; controlfile Auto Backup 설정 RMAN> configure retention policy to recovery window of 7 days; 백업보관주기설정 RMAN> show all 전체 configure 를보여준다. RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; CONFIGURE BACKUP OPTIMIZATION ON; CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/oracle/backup/control/%f'; CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u01/app/oracle/backup/prod_%u'; RMAN> backup as compressed backupset database spfile plus archivelog delete input; 백업진행 Recovery TEST SQL>!rm /u01/app/oracle/oradata/prod/disk1/system01.dbf SQL> shutdown abort ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area bytes Fixed Size bytes Variable Size bytes Datafile 삭제

10 Database Buffers bytes Redo Buffers bytes Database mounted. ORA-01157: cannot identify/lock data file 1 - see DBWR trace file ORA-01110: data file 1: '/u01/app/oracle/oradata/prod/disk1/system01.dbf' 실제파일이없으므로장애유발 [busan1:oracle:/u01]$ rman target / nocatalog Recovery Manager: Release Production on Sat Jan 27 04:32: Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: PROD (DBID= , not open) RMAN> restore datafile 1; Starting restore at 27-JAN-07 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=285 devtype=disk channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile to /u01/app/oracle/oradata/prod/disk1/system01.dbf channel ORA_DISK_1: reading from backup piece /u01/app/oracle/backup/prod_1ni8hbo2_1_1 channel ORA_DISK_1: restored backup piece 1 piece handle=/u01/app/oracle/backup/prod_1ni8hbo2_1_1 tag=tag t channel ORA_DISK_1: restore complete, elapsed time: 00:01:46 Finished restore at 27-JAN-07 RMAN> recover datafile 1 Starting recover at 27-JAN-07 using channel ORA_DISK_1 starting media recovery media recovery complete, elapsed time: 00:00:06 Finished recover at 27-JAN-07 RMAN> alter database open; database opened ==>DB 가 open 되고서비스가정상가동됨 < 참고 > backupset 파일이름형식 - Format : 출력이름의형식 - %c : backup piece 의 copy number - %p : backup piece number, 1 부터시작하고 1 씩증가한다. - %s : backup set number, control file 내의 counter, set 이생성될때마다증가한다. - %d : database name - %n : database name, padded on the right with x char to total length oh 8 char - %t : fixed reference time 이후경과한시간 ( 초 ) 을 4byte 로나타낸값 %s 와조합하면 backup set 에 unique name 을지정할수있다. - %u : backup set 번호와생성시간에대한단축표기법, 8 자이름지정 - %U : %u_%p_%c (default) 4. RMAN with a Recovery Catalog 4.1. Recovery Catalog Setup Target DB(PROD) 와 Catalog DB(RESP) 초기 TNS Setting ===== tnsnames.ora=====(prod,resp DB 에동일하게 setup) PROD = Target DB (DESCRIPTION =

11 ) (ADDRESS = (PROTOCOL = TCP)(HOST = busan1)(port = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = PROD) ) RESP = Catalog DB (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = busan2)(port = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RESP) ) ) ======================================================== busan1 $ tnsping resp target DB 쪽에서 Catalog DB 쪽으로 tnsping TEST(Ok) TNS Ping Utility for Solaris: Version Production on 01-JAN :52:33 Copyright (c) 1997, 2005, Oracle. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = busan2)(port = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RESP))) OK (10 msec) busan2 $ tnsping PROD Catalog DB 쪽에서 Target DB 쪽으로 tnsping TEST (Ok) TNS Ping Utility for Solaris: Version Production on 01-JAN :53:19 Copyright (c) 1997, 2005, Oracle. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = busan1)(port = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = PROD))) OK (0 msec) Catalog DB(SID=RESP) 에 Tablespace 및 User 생성작업 busan2 $ sqlplus '/as sysdba' SQL*Plus: Release Production on Mon Jan 1 22:36: Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release bit Production With the Partitioning and Data Mining options SQL> create tablespace catalog datafile '/oratest/oradata/resp/catalog01.dbf' size 50m; Tablespace created. SQL> create user rman identified by rman default tablespace catalog; User created. SQL> grant recovery_catalog_owner to rman; Grant succeeded. SQL> grant connect,resource to rman; SQL> select instance_name from v$instance; INSTANCE_NAME RESP Rman catalog DB 쪽에유저를생성한다

12 Target DB(PROD) 에 Recovery Catalog 생성작업 busan1 $ rman target / catalog rman/rman@resp Recovery Manager: Release Production on Mon Jan 1 22:46: Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: PROD (DBID= ) connected to recovery catalog database RMAN> list incarnation of database; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of list command at 01/01/ :46:35 RMAN-06428: recovery catalog is not installed 아직까지 catalog 가생성되지않았음 RMAN> create catalog; recovery catalog created RMAN> register database; database registered in recovery catalog starting full resync of recovery catalog full resync complete RMAN> list incarnation of database; DataBase 등록확인 List of Database Incarnations DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time PROD CURRENT 1 08-MAR-07oracle Jan16? <note> target database 가잘못등록된경우삭제방법 RESP DB 의 rman 유저로접속후 package 를사용하여삭제 busan2 $ sqlplus rman/rman SQL*Plus: Release Production on Mon Jan 1 23:15: Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release bit Production With the Partitioning and Data Mining options SQL> select * from db ; DB_KEY DB_ID HIGH_CONF_RECID LAST_KCCDIVTS HIGH_IC_RECID CURR_DBINC_KEY SQL> execute dbms_rcvcat.unregisterdatabase(1, ); 잘못등록된 DB 삭제 (DB_KEY,DB_ID) PL/SQL procedure successfully completed. SQL> select * from db ; no rows selected 4.2. Recovery Catalog 를이용한 Rman Backup(Archive mode) Recovery Catalog 는 RMAN 의백업작업에대한메타데이터의저장소입니다. 쉽게말해컨트롤파일에서 RMAN 의백업과복구에관련된정보들만을따로모아생성시킨파일과도같다. 그리고이 Recovery Catalog 는대상데이터

13 베이스와 resync 명령어를사용하여해당정보를동기화할수있습니다. 이러한이점때문에 Recovery Catalog 는복수의데이터베이스에대한백업및복구작업을중앙관리하는데편리한이점을가진다. 이와같은 Recovery Catalog 의정보보호를위해직접적으로액세스하는것은권장되지않고. 대신 RC_* 의뷰를참조하여해당 Recovery Catalog 내의정보를참조할수있다. Recovery Catalog의사용을위해서는먼저대상데이터베이스에연결한후, 두번째 NET 연결을통하여 Recovery Catalog와의세션을생성하고, 이때 Recovery Catalog의연결은기존의 RMAN의연결과는달리 as sysdba의권한을사용하지않는다. 연결된후에는수동으로대상데이터베이스와동기화를시키거나, 백업작업의실행시자동으로동기화가이루어진다. Complete Database Backup(full) busan1 $ rman target / catalog rman/rman@resp Recovery Manager: Release Production on Wed Jan 3 22:04: Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: PROD (DBID= ) connected to recovery catalog database 전체 DB 에대한백업을수행한다. 2> # backup the complete database to disk 3> allocate channel c1 type disk; 4> backup 5> full 6> tag full_db_sunday_night 7> format '/rman_backup/prod/db_t%t_s%s_p%p' 8> (database); 9> release channel c1; 10> allocated channel: c1 channel c1: sid=144 devtype=disk Starting backup at 08-JAN-07 channel c1: starting full datafile backupset channel c1: specifying datafile(s) in backupset input datafile fno=00001 name=/oratest/oradata/prod/system01.dbf input datafile fno=00002 name=/oratest/oradata/prod/undotbs01.dbf input datafile fno=00003 name=/oratest/oradata/prod/sysaux01.dbf input datafile fno=00005 name=/oratest/oradata/prod/catalog01.dbf input datafile fno=00004 name=/oratest/oradata/prod/users01.dbf channel c1: starting piece 1 at 08-JAN-07 channel c1: finished piece 1 at 08-JAN-07 piece handle=/rman_backup/prod/db_t _s3_p1 tag=full_db_sunday_night comment=none channel c1: backup set complete, elapsed time: 00:00:55 channel c1: starting full datafile backupset channel c1: specifying datafile(s) in backupset including current control file in backupset channel c1: starting piece 1 at 08-JAN-07 channel c1: finished piece 1 at 08-JAN-07 piece handle=/rman_backup/prod/db_t _s4_p1 tag=full_db_sunday_night comment=none channel c1: backup set complete, elapsed time: 00:00:02 Finished backup at 08-JAN

14 released channel: c1 RMAN> list backupset of database; 백업정보를확인할수있다 List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time Full M DISK 00:00:49 08-JAN-07 BP Key: 67 Status: AVAILABLE Compressed: NO Tag: FULL_DB_SUNDAY_NIGHT Piece Name: /rman_backup/prod/db_t _s3_p1 List of Datafiles in backup set 65 File LV Type Ckp SCN Ckp Time Name Full JAN-07 /oratest/oradata/prod/system01.dbf 2 Full JAN-07 /oratest/oradata/prod/undotbs01.dbf 3 Full JAN-07 /oratest/oradata/prod/sysaux01.dbf 4 Full JAN-07 /oratest/oradata/prod/users01.dbf 5 Full JAN-07 /oratest/oradata/prod/catalog01.dbf Tablespace Backup(Users Tablespace Backup) busan1 $ rman target / catalog rman/rman@resp Recovery Manager: Release Production on Wed Jan 3 22:04: Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: PROD (DBID= ) connected to recovery catalog database 2> allocate channel c1 type disk; 3> backup 4> tag tbs_users 5> format '/rman_backup/prod/tbs_users_t%t_s%s' 6> (tablespace users); 2 개이상의 tablespace 를사용하고자한다면 7> release channel c1; # (tablespace users,system) 분리해서입력이가능함 8> allocated channel: c1 channel c1: sid=145 devtype=disk Starting backup at 08-JAN-07 channel c1: starting full datafile backupset channel c1: specifying datafile(s) in backupset input datafile fno=00004 name=/oratest/oradata/prod/users01.dbf channel c1: starting piece 1 at 08-JAN-07 channel c1: finished piece 1 at 08-JAN-07 piece handle=/rman_backup/prod/tbs_users_t _s5 tag=tbs_users comment=none channel c1: backup set complete, elapsed time: 00:00:04 Finished backup at 08-JAN-07 released channel: c1 RMAN> list backupset of tablespace users; users 라는 tablespace 백업사항확인 BS Key Type LV Size Device Type Elapsed Time Completion Time Full 88.00K DISK 00:00:02 08-JAN-07 BP Key: 102 Status: AVAILABLE Compressed: NO Tag: TBS_USERS Piece Name: /rman_backup/prod/tbs_users_t _s5 List of Datafiles in backup set

15 File LV Type Ckp SCN Ckp Time Name Full JAN-07 /oratest/oradata/prod/users01.dbf Datafile backup busan1 $ rman target / catalog rman/rman@resp Recovery Manager: Release Production on Wed Jan 3 22:04: Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: PROD (DBID= ) connected to recovery catalog database 2> allocate channel c1 type disk; 3> backup 4> format '/rman_backup/prod/df_%d_%u' 5> (datafile '/oratest/oradata/prod/sysaux01.dbf'); 6> release channel c1; 7> 또는 report schema 를확인후 file number 로도가능하다. RMAN> report schema 2> ; Report of database schema List of Permanent Datafiles =========================== File Size(MB) Tablespace RB segs Datafile Name SYSTEM YES /oratest/oradata/prod/system01.dbf UNDOTBS1 YES /oratest/oradata/prod/undotbs01.dbf SYSAUX NO /oratest/oradata/prod/sysaux01.dbf 4 5 USERS NO /oratest/oradata/prod/users01.dbf 5 50 CATALOG NO /oratest/oradata/prod/catalog01.dbf List of Temporary Files ======================= File Size(MB) Tablespace Maxsize(MB) Tempfile Name TEMP /oratest/oradata/prod/temp01.dbf 아래와같이수정도가능하다 run { allocate channel c1 type disk; backup format '/rman_backup/df_%d_%u' (datafile 3); datafile 의번호입력 release channel c1; allocated channel: c1 channel c1: sid=145 devtype=disk

16 Starting backup at 08-JAN-07 channel c1: starting full datafile backupset channel c1: specifying datafile(s) in backupset input datafile fno=00003 name=/oratest/oradata/prod/sysaux01.dbf channel c1: starting piece 1 at 08-JAN-07 channel c1: finished piece 1 at 08-JAN-07 piece handle=/rman_backup/prod/df_prod_06i71a4d tag=tag t comment=none channel c1: backup set complete, elapsed time: 00:00:15 Finished backup at 08-JAN-07 released channel: c1 RMAN> list backupset of datafile 3; BS Key Type LV Size Device Type Elapsed Time Completion Time Full 84.29M DISK 00:00:12 08-JAN-07 BP Key: 112 Status: AVAILABLE Compressed: NO Tag: TAG T Piece Name: /rman_backup/prod/df_prod_06i71a4d List of Datafiles in backup set 110 File LV Type Ckp SCN Ckp Time Name Full JAN-07 /oratest/oradata/prod/sysaux01.dbf Controlfile Backup busan1 $ rman target / catalog rman/rman@resp Recovery Manager: Release Production on Wed Jan 3 22:04: Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: PROD (DBID= ) connected to recovery catalog database 2> allocate channel c1 type disk; 3> backup 4> format '/rman_backup/prod/cf_t%t_s%s_p%p' 5> tag cf_monday_night 6> (current controlfile); 7> release channel c1; 8> allocated channel: c1 channel c1: sid=145 devtype=disk Starting backup at 08-JAN-07 channel c1: starting full datafile backupset channel c1: specifying datafile(s) in backupset including current control file in backupset channel c1: starting piece 1 at 08-JAN-07 channel c1: finished piece 1 at 08-JAN-07 piece handle=/rman_backup/prod/cf_t _s7_p1 tag=cf_monday_night comment=none channel c1: backup set complete, elapsed time: 00:00:03 Finished backup at 08-JAN-07 released channel: c1-16 -

17 모든 archive log backup busan1 $ rman target / catalog rman/rman@resp Recovery Manager: Release Production on Wed Jan 3 22:04: Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: PROD (DBID= ) connected to recovery catalog database 2> allocate channel c1 type disk; 3> backup 4> format '/rman_backup/prod/log_t%t_s%s_p%p' 5> (archivelog all); 6> release channel c1; 7> allocated channel: c1 channel c1: sid=145 devtype=disk Starting backup at 08-JAN-07 current log archived channel c1: starting archive log backupset channel c1: specifying archive log(s) in backup set input archive log thread=1 sequence=1 recid=1 stamp= input archive log thread=1 sequence=2 recid=2 stamp= input archive log thread=1 sequence=3 recid=3 stamp= input archive log thread=1 sequence=4 recid=4 stamp= input archive log thread=1 sequence=5 recid=5 stamp= input archive log thread=1 sequence=6 recid=6 stamp= input archive log thread=1 sequence=7 recid=7 stamp= channel c1: starting piece 1 at 08-JAN-07 channel c1: finished piece 1 at 08-JAN-07 piece handle=/rman_backup/prod/log_t _s8_p1 tag=tag t comment=none channel c1: backup set complete, elapsed time: 00:00:08 Finished backup at 08-JAN-07 released channel: c1 RMAN> list backupset of archivelog all; List of Backup Sets =================== BS Key Size Device Type Elapsed Time Completion Time M DISK 00:00:04 08-JAN-07 BP Key: 148 Status: AVAILABLE Compressed: NO Tag: TAG T Piece Name: /rman_backup/prod/log_t _s8_p1 List of Archived Logs in backup set 146 Thrd Seq Low SCN Low Time Next SCN Next Time JAN JAN JAN JAN JAN JAN JAN JAN JAN JAN JAN JAN JAN JAN

18 특정범위의 Sequence Archive log Backup 2> allocate channel c1 type disk; 3> backup 4> format '/rman_backup/prod/log_t%t_s%s_p%p' 5> (archivelog from sequence=1 until sequence=4 thread 1); 6> release channel c1; 7> allocated channel: c1 channel c1: sid=145 devtype=disk Starting backup at 08-JAN-07 channel c1: starting archive log backupset channel c1: specifying archive log(s) in backup set input archive log thread=1 sequence=1 recid=1 stamp= input archive log thread=1 sequence=2 recid=2 stamp= input archive log thread=1 sequence=3 recid=3 stamp= input archive log thread=1 sequence=4 recid=4 stamp= channel c1: starting piece 1 at 08-JAN-07 channel c1: finished piece 1 at 08-JAN-07 piece handle=/rman_backup/prod/log_t _s9_p1 tag=tag t comment=none channel c1: backup set complete, elapsed time: 00:00:08 Finished backup at 08-JAN-07 released channel: c1 특정시간이경과한 Archive log Backup 2> allocate channel c1 type disk; 3> backup 4> format '/rman_backup/prod/log_t%t_s%s_p%p' 5> (archivelog from time sysdate-1 all delete input); 6> release channel c1; 7> sysdate-1 : 현재날짜와시간보다 1일전 sysdate-7 : 현재날짜와시간보다 7일전 sysdate- 1/24 : 현재날짜와시간보다 1시간전 sysdate- 9/24 : 현재날짜와시간보다 9시간전 sysdate- 5/3600 : 현재날짜와시간보다 5분전 ##Backup 이완료되면삭제가된다. 만일 Backup 이실패를한다면 Archivelog 들은지워지지않음. Online Redolog 의 Backup RMAN>run { allocate channel c1 type disk; sql "alter system archive log current"; backup format '/rman_backup/log_t%t_s%s_p%p'

19 (archivelog from time 'sysdate-1' all delete input); release channel c1; Online Redolog 는백업에앞서 Archived 되어져야하므로위와같이 sql command 를이용하여백업을진행한다 Incremental Backup Level N incremental Backup 은가장최근의 N 또는 N 보다작은 Backup 이후의변경된부분만을 Backup 하는것이 다.List Backup Set 을조회해보면 Type Column 에는 Incr, LV Column 에는 0 이라고나타난다. Level 0 DataBase Full Backup allocate channel c1 type disk; backup incremental level 0 DB 전체에대해 Level 0 로백업을받는다. filesperset 4 format '/rman_backup/prod/sunday_level0_%t' (database); release channel c1; BS Key Type LV Size Device Type Elapsed Time Completion Time Incr M DISK 00:00:22 08-JAN-07 BP Key: 244 Status: AVAILABLE Compressed: NO Tag: TAG T Piece Name: /rman_backup/prod/sunday_level0_ List of Datafiles in backup set 233 File LV Type Ckp SCN Ckp Time Name Incr JAN-07 /oratest/oradata/prod/system01.dbf 4 0 Incr JAN-07 /oratest/oradata/prod/users01.dbf 5 0 Incr JAN-07 /oratest/oradata/prod/catalog01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time Incr M DISK 00:00:19 08-JAN-07 BP Key: 245 Status: AVAILABLE Compressed: NO Tag: TAG T Piece Name: /rman_backup/prod/sunday_level0_ List of Datafiles in backup set 234 File LV Type Ckp SCN Ckp Time Name Incr JAN-07 /oratest/oradata/prod/undotbs01.dbf 3 0 Incr JAN-07 /oratest/oradata/prod/sysaux01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time Incr M DISK 00:00:02 08-JAN-07 BP Key: 246 Status: AVAILABLE Compressed: NO Tag: TAG T Piece Name: /rman_backup/prod/sunday_level0_ Control File Included: Ckp SCN: Ckp time: 08-JAN

20 만약다음과같이 backup 정책을수립했다고하면.. 일요일에 level 0로 full backup, 월요일에는 level 2로일요일 backup시점이후변동사항만을 incremental backup, 화요일에는 level 2로월요일 backup 시점이후변동사항만을 incremental backup, 수요일에는 level 1으로일요일 backup 시점이후변동사항만을 incremental backup, 목요일에는 level 2로수요일 backup 시점이후변동사항만을 incremental backup. 금요일에는 level 2로목요일 backup 시점이후변동사항만을 incremental backup 만약토요일에장애가발생하면, 일요일, 수요일, 목요일, 금요일의 backup을이용하여 recovery하면된다. 만약 level 1 incremental backup을이틀에한번정도할수있다면 recovery 시간은더단축할수있다. 5. RMAN with Recovery(Datafile,Tablespace) Datafile Crash or Deleted(DataBase OPEN) DataBase 가운영중에 Disk 장애및여러가지이유에서 datafile 이 deleted 되었다면두가지방법으로 recovery 가가능하다. 1. Datafile restore 후 Datafile Recovery 2. Datafile restore 후 Tablespace Recovery 단 system tablespace 에해당하는 datafile 에이상이생겼다면 Database close 후복구가진행되어야한다. DATAFILE RECOVERY busan1 $ sqlplus '/as sysdba' SQL*Plus: Release Production on Mon Jan 8 23:51: Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release bit Production With the Partitioning and Data Mining options SQL>!rm /oratest/oradata/prod/users01.dbf 실제 Disk 장애를유발시킨다. SQL> shutdown immediate ORA-01116: error in opening database file 4 ORA-01110: data file 4: '/oratest/oradata/prod/users01.dbf' ORA-27041: unable to open file SVR4 Error: 2: No such file or directory Additional information: 3 ##RMAN 을통해서 Recovery 를진행한다.## 2> allocate channel c1 type disk; 3> sql "alter tablespace users offline immediate"; 4> restore datafile 4; 5> recover datafile 4; 6> sql "alter tablespace users online"; 7> release channel c1; 8> released channel: ORA_DISK_1-20 -

21 allocated channel: c1 channel c1: sid=145 devtype=disk sql statement: alter tablespace users offline immediate Starting restore at 08-JAN-07 channel c1: starting datafile backupset restore channel c1: specifying datafile(s) to restore from backup set restoring datafile to /oratest/oradata/prod/users01.dbf channel c1: reading from backup piece /rman_backup/prod/sunday_level0_ channel c1: restored backup piece 1 piece handle=/rman_backup/prod/sunday_level0_ tag=tag t channel c1: restore complete, elapsed time: 00:00:02 Finished restore at 08-JAN-07 Starting recover at 08-JAN-07 starting media recovery media recovery complete, elapsed time: 00:00:04 Finished recover at 08-JAN-07 sql statement: alter tablespace users online Datafile 이 recovery 되었음을확인할수있다. released channel: c1 TABLESPACE RECOVERY 2> allocate channel c1 type disk; 3> sql "alter tablespace users offline immediate"; 4> restore tablespace users; 5> recover tablespace users; 6> sql "alter tablespace users online"; 7> release channel c1; 8> Online Redo log file lost(database Closed) allocate channel c1 type disk; set until logseq=105 thread=1; restore controlfile to '/oratest/oradata/prod/control01.ctl'; replicate controlfile from '/oratest/oradata/prod/control01.ctl'; restore database; sql "alter database mount"; recover database; sql "alter database open resetlogs"; release channel c1; RMAN> reset database; 1. set until command 는어떠한 log sequence 까지 recovery 하고 stop 할것인지를가리킨다. 이문장은 datafile 들이 restore 되기전에나와야한다. 그렇지않으면 RMAN 은지정한 log sequence 보다앞선가장

22 최근의 datafile 들을 restore 하려고한다. 2. 기본적으로 restore controlfile command 에의하여 init.ora 에지정되어있는 control_files 의위치로자동적으로 controlfile 들이 restore 된다. 이렇게하지않고특정한위치를지정하기위해서는 restore controlfile to filename 이라고지정하면된다. 3. replicate controlfile 은 init.ora 에지정되어있는위치에 controlfile 을 restore 하지않고특정한위치에 controlfile 을 restore 했을때이것들을다시 init.ora 에지정되어있는 control_files 의위치에 controlfile 을 copy 하기위하여사용한다. 4. Database 가 resetlogs 로 open 이되어졌기때문에 database 의새로운 incarnation 을 register 해야할필요가있다. 이것은 reset database command 를통하여할수있다 Rman 을통한 Recovery 시나리오 ( 예제 ) #### SCENARIO 1 : COMPLETE RECOVERY - DATAFILE RECOVERY #### 1. db open 중에, 해당 tablespace 를 offline 2. datafile 을 restore 3. recover 수행 4. 해당 tablespace online RMAN> report schema; Report of database schema List of Permanent Datafiles =========================== File Size(MB) Tablespace RB segs Datafile Name SYSTEM YES /oracle/oradata/wippy/system01.dbf UNDOTBS1 YES /oracle/oradata/wippy/undotbs01.dbf SYSAUX NO /oracle/oradata/wippy/sysaux01.dbf 4 5 USERS NO /oracle/oradata/wippy/users01.dbf 5 20 ORACLE NO /oracle/oradata/wippy/oracle01.dbf 8 50 RMAN_TS NO /oracle/oradata/wippy/rman01.dbf 2> sql "alter tablespace oracle offline immediate"; 3> restore datafile 5; 4> recover datafile 5; 5> sql "alter tablespace oracle online"; #### SCENARIO 2 : COMPLETE RECOVERY - TABLESPACE RECOVERY #### 1. SCENARIO 1 과과정은동일하나, command 가조금달라짐. 2> sql "alter tablespace oracle offline immediate"; 3> restore tablespace oracle; 4> recover tablespace oracle; 5> sql "alter tablespace oracle online";!! 참고!! 여러개의 backupset 중에선택해서 restore 할려면?? restore tablespace oracle from tag=' 태그이름 ' 을주면된다. #### SCENARIO 3 : COMPLETE RECOVERY - TABLESPACE RECOVERY( 새로운곳에 RESTORE 후 RECOVERY) #### 2> sql "alter tablespace oracle offline immediate"; 3> set newname for datafile '/oracle/oradata/wippy/control/oracle01.dbf' to '/oracle/oradata/wippy/oracle01.dbf';

23 4> restore tablespace oracle; 5> switch datafile all; 6> recover tablespace oracle; 7> sql "alter tablespace oracle online"; # set newname for ' 원본경로 ' to ' 이동경로 ' # switch datafile all : Update the control file and recovery catalog #### SCENARIO 4 : INCOMPLETE RECOVERY - CURRENT ONLINE REDO LOG GROUP 의유실 #### 1. alertlog 를보고 log sequence 를알아둔다. 2> set until sequence=3 thread=1; 3> restore database; 4> recover database; 5> alter database open resetlogs; executing command: SET until clause Starting restore at 09-JUL-07 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=156 devtype=disk channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile to /oracle/oradata/wippy/system01.dbf restoring datafile to /oracle/oradata/wippy/undotbs01.dbf restoring datafile to /oracle/oradata/wippy/sysaux01.dbf restoring datafile to /oracle/oradata/wippy/users01.dbf restoring datafile to /oracle/oradata/wippy/oracle01.dbf restoring datafile to /oracle/oradata/wippy/rman01.dbf channel ORA_DISK_1: reading from backup piece /oracle/oradata/backup/full imdbmn_1_ channel ORA_DISK_1: restored backup piece 1 piece handle=/oracle/oradata/backup/full imdbmn_1_ tag=full_backup channel ORA_DISK_1: restore complete, elapsed time: 00:01:16 Finished restore at 09-JUL-07 Starting recover at 09-JUL-07 using channel ORA_DISK_1 starting media recovery archive log thread 1 sequence 1 is already on disk as file /oracle/arch/10.2.0/1_1_ dbf archive log thread 1 sequence 2 is already on disk as file /oracle/arch/10.2.0/1_2_ dbf archive log filename=/oracle/arch/10.2.0/1_1_ dbf thread=1 sequence=1 archive log filename=/oracle/arch/10.2.0/1_2_ dbf thread=1 sequence=2 media recovery complete, elapsed time: 00:00:06 Finished recover at 09-JUL-07 database opened new incarnation of database registered in recovery catalog starting full resync of recovery catalog full resync complete #### SCENARIO 5 : INCOMPLETE RECOVERY - CONTROLFILE 과 DATAFILE 동시에유실 #### 1. 복구수행.(nomount 상태 ) 2> set until sequence=9 thread=1; 3> restore controlfile; 4> alter database mount; 5> restore database; 6> recover database; 7> alter database open resetlogs; 8>

24 executing command: SET until clause Starting restore at 09-JUL-07 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=155 devtype=disk channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: restoring control file channel ORA_DISK_1: reading from backup piece /oracle/oradata/backup/full pimd5dh_1_ channel ORA_DISK_1: restored backup piece 1 piece handle=/oracle/oradata/backup/full pimd5dh_1_ tag=full_backup channel ORA_DISK_1: restore complete, elapsed time: 00:00:05 output filename=/oracle/oradata/wippy/control/control01.ctl output filename=/oracle/oradata/wippy/control/control02.ctl output filename=/oracle/oradata/wippy/control/control03.ctl Finished restore at 09-JUL-07 database mounted released channel: ORA_DISK_1 Starting restore at 09-JUL-07 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=155 devtype=disk channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile to /oracle/oradata/wippy/system01.dbf restoring datafile to /oracle/oradata/wippy/undotbs01.dbf restoring datafile to /oracle/oradata/wippy/sysaux01.dbf restoring datafile to /oracle/oradata/wippy/users01.dbf restoring datafile to /oracle/oradata/wippy/oracle01.dbf restoring datafile to /oracle/oradata/wippy/rman01.dbf channel ORA_DISK_1: reading from backup piece /oracle/oradata/backup/full oimd5bg_1_ channel ORA_DISK_1: restored backup piece 1 piece handle=/oracle/oradata/backup/full oimd5bg_1_ tag=full_backup channel ORA_DISK_1: restore complete, elapsed time: 00:01:15 Finished restore at 09-JUL-07 Starting recover at 09-JUL-07 using channel ORA_DISK_1 starting media recovery archive log thread 1 sequence 8 is already on disk as file /oracle/arch/10.2.0/1_8_ dbf archive log filename=/oracle/arch/10.2.0/1_8_ dbf thread=1 sequence=8 media recovery complete, elapsed time: 00:00:02 Finished recover at 09-JUL-07 database opened new incarnation of database registered in recovery catalog starting full resync of recovery catalog full resync complete 2. backupset file delete RMAN> delete backupset; RMAN> delete archivelog all; #### SCENARIO 6 : INCOMPLETE RECOVERY - 시간기반으로 RECOVERY ####.bash_profile 에 export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS' 입력후쉘다시적용. date command 로현재시간확인 :23:00 이라고가정

25 oracle 에서 table 삭제. nomount 상태에서복구시작. 2> set until time=' :23:00'; 3> restore controlfile; 4> alter database mount; 5> restore database; 6> recover database; 7> alter database open resetlogs; 8> 6. Rman Recovery 를이용한 NEW 서버에 Restore rman 으로다른서버에전체 restore 방법 busan1 $ rman target / catalog rman/rman@resp Recovery Manager: Release Production on Thu Jan 11 14:13: Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: PROD (DBID= ) connected to recovery catalog database RMAN> configure channel device type disk format '/rman_backup/prod/%d_%s_%p.bak' RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/rman_backup/prod/snap_control_prod.f'; RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/rman_backup/prod/%f.ctl' RMAN> show all; 전체 configure 를확인한다. RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS; CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/rman_backup/prod/%f.ctl'; CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/rman_backup/prod/%d_%s_%p.bak'; CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/rman_backup/prod/snap_control_prod.f'; RMAN> backup database; Starting backup at 11-JAN-07 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=154 devtype=disk channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset

26 input datafile fno=00001 name=/oratest/oradata/prod/system01.dbf input datafile fno=00002 name=/oratest/oradata/prod/undotbs01.dbf input datafile fno=00003 name=/oratest/oradata/prod/sysaux01.dbf input datafile fno=00005 name=/oratest/oradata/prod/catalog01.dbf input datafile fno=00004 name=/oratest/oradata/prod/users01.dbf channel ORA_DISK_1: starting piece 1 at 11-JAN-07 channel ORA_DISK_1: finished piece 1 at 11-JAN-07 piece handle=/rman_backup/prod/prod_20_1.bak tag=tag t comment=none channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45 Finished backup at 11-JAN-07 Starting Control File Autobackup at 11-JAN-07 piece handle=/rman_backup/prod/c ctl comment=none Finished Control File Autobackup at 11-JAN-07 ############ 사전작업 ###################################################### Step 1) 새로운서버로 rman backup, archive 이동 Step 2) $ORACLE_HOME/dbs 에 initprod.ora 파라미터위치 Step 3) $ORACLE_HOME/network/admin에 tnsnames.ora 파일에 REPO DB에접속가능하도록설정 Step 4) rman backup의위치는원래백업했던경로와같아야함 archive는경로를마음대로해도되나 init파라미터에꼭설정해야함 Step 5) datafile을 restore할곳은 /oratest/oradata/prod 에서 /oratest/oradata/new_prod로변경함즉, init파라미터에서 control_files 파라미터를 /oratest/oradata/new_prod/control01.ctl ~~ 으로변경해야함 새로운서버에서 PROD DB 를 nomount 상태로올림 SQL> startup nomount ORACLE instance started. Total System Global Area bytes Fixed Size bytes Variable Size bytes Database Buffers bytes Redo Buffers bytes Busan2 $ rman target / catalog rman/rman@resp busan2 에서작업을한다 ( 신규서버 ) Recovery Manager: Release Production on Thu Jan 11 14:13: Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: PROD (not mounted) connected to recovery catalog database RMAN> set dbid= dbid 는실 DB 의 v$database 를보면됨 restore하고자하는시간을확인 alert log를보니 archive가있다. 1시 12분 04초에생겼으니 time based로는이전까지로복구해야한다. 1시 12분 03초로한다. Fri Sep 22 01:12: ARC1: Evaluating archive log 2 thread 1 sequence

27 ARC1: Beginning to archive log 2 thread 1 sequence 296 Creating archive destination LOG_ARCHIVE_DEST_1: '/data/archive/1_296.arc' Fri Sep 22 01:12: Thread 1 advanced to log sequence 297 Current log# 3 seq# 297 mem# 0: /data/oradata/prod/redo03a.log controlfile을 restore수행후 DB를 mount상태로만듦 - 주의! init파라미터에설정된경로에 restore가되니 control_files파라미터를확인만약 LOG SEQUENCE NUMBER를통해서복구하고자한다면아래와같이 SET UNTIL을지정한다. SET UNTIL SEQUENCE 276 THREAD 1; 참고 ) LOG SEQUENCE NUMBER 를통해서복구하는방법 SET UNTIL SEQUENCE 276 THREAD 1; restore controlfile; SET UNTIL TIME "TO_DATE('2007/09/22 01:12:03','YYYY/MM/DD HH24:MI:SS')"; restore controlfile; executing command: SET until clause Starting restore at 22-SEP-06 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=12 devtype=disk channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: restoring controlfile output filename=/oratest/oradata /NEW_PROD/control01.ctl channel ORA_DISK_1: restored backup piece 1 piece handle=/backup/rman/c ctl tag=null params=null channel ORA_DISK_1: restore complete replicating controlfile input filename=/oratest/oradata /NEW_PROD/control01.ctl output filename=/oratest/oradata /NEW_PROD/control02.ctl Finished restore at 22-SEP-06 RMAN> alter database mount; SET UNTIL TIME "TO_DATE('2007/09/22 01:12:03','YYYY/MM/DD HH24:MI:SS')"; set newname for datafile '/oratest/oradata /PROD/system01.dbf' to '/oratest/oradata /NEW_PROD/system01.dbf'; set newname for datafile '/oratest/oradata /PROD/undotbs01.dbf' to '/oratest/oradata /NEW_PROD/undotbs01.dbf'; set newname for datafile '/oratest/oradata /PROD/user01.dbf' to '/oratest/oradata /NEW_PROD/users01.dbf'; restore database; switch datafile all ; recover database; sql 'alter database open resetlogs'; executing command: SET until clause executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME

28 Starting restore at 22-SEP-06 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile to /oratest/oradata /NEW_PROD/system01.dbf restoring datafile to /oratest/oradata /NEW_PROD/undotbs01.dbf restoring datafile to /oratest/oradata /NEW_PROD/users01.dbf channel ORA_DISK_1: restored backup piece 1 piece handle=/rmna_backup/prod/prod_13_1.bak tag=tag t params=null channel ORA_DISK_1: restore complete Finished restore at 22-SEP-07 Starting recover at 22-SEP-07 using channel ORA_DISK_1 starting media recovery archive log thread 1 sequence 296 is already on disk as file /data/archive/1_296.arc archive log filename=/data/archive/1_296.arc thread=1 sequence=296 media recovery complete Finished recover at 22-SEP-07 sql statement: alter database open resetlogs 7. Rman Backup 을위한 Script create Create or Replace Script Recovery Catalog 내에 script 형태로저장이되어지는것으로 stored procedure 형태로불러서사용할수있다. 조회는 RC_STORED_SCRIPT 와 RC_STORED_SCRIPT_LINE 에서할수있다. RMAN> create script backup_db_full { 2> allocate channel c1 type disk; 3> backup 4> full 5> tag full_db_sunday_night 6> format '/rman_backup/prod/db_t%t_s%s_p%p' 7> (database); 8> release channel c1; 9> created script backup_db_full Execute Script run 이란명령어를통해서저장된 Script 를실행한다

29 RMAN> run{ execute script backup_db_full; executing script: backup_db_full Delete Script 저장된 Script 를 Delete 시킨다. RMAN> run{ delete script backup_db_full; deleted script: backup_db_full OS 상에서실행이하는방법 OS 의 file 형태로존재하는 Script 를실행하는방법 busan1 $ cat db_full.rcv run { execute script backup_db_full; busan1 $ rman target / catalog log full_backup.log 위 script 를쉘파일로작성한후 OS 의 Cron 명령어로도실행가능함. busan1 $ cat full_backup.log 백업로그로서완료여부를확인가능하다. Recovery Manager: Release Production on Tue Jan 9 00:49: Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: PROD (DBID= ) connected to recovery catalog database 2> execute script backup_db_full; 3> 4> 5> executing script: backup_db_full allocated channel: c1 channel c1: sid=143 devtype=disk Starting backup at 09-JAN-07 channel c1: starting full datafile backupset channel c1: specifying datafile(s) in backupset input datafile fno=00001 name=/oratest/oradata/prod/system01.dbf 중략 channel c1: finished piece 1 at 09-JAN-07 piece handle=/rman_backup/prod/db_t _s19_p1 tag=full_db_sunday_night comment=none channel c1: backup set complete, elapsed time: 00:00:

30 Finished backup at 09-JAN-07 released channel: c1 Recovery Manager complete. 8. Rman Repository 의유지관리 8.1. Removing Obsolete Backupsets 파일이존재하지않으면 EXPIRED 로갱신 RMAN> allocate channel for maintenance type disk; channel 을할당한다. allocated channel: ORA_MAINT_DISK_2 channel ORA_MAINT_DISK_2: sid=139 devtype=disk RMAN> crosscheck backup; 불필요한 backup 들을 Crosscheck 한다. crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rman_backup/prod/df_prod_06i71a4d recid=6 stamp= crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rman_backup/prod/cf_t _s7_p1 recid=7 stamp= crosschecked backup piece: found to be 'AVAILABLE' 중략 backup piece handle=/rman_backup/prod/log_t _s9_p1 recid=9 stamp= crosschecked backup piece: found to be 'AVAILABLE' crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rman_backup/prod/db_t _s19_p1 recid=19 stamp= Crosschecked 14 objects crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/rman_backup/prod/db_t _s3_p1 recid=3 stamp= crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/rman_backup/prod/db_t _s4_p1 recid=4 stamp= crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/rman_backup/prod/tbs_users_t _s5 recid=5 stamp= Crosschecked 3 objects RMAN> delete expired backup; Expired 된것에대해서삭제를한다. List of Backup Pieces BP Key BS Key Pc# Cp# Status Device Type Piece Name EXPIRED DISK /rman_backup/prod/db_t _s3_p EXPIRED DISK /rman_backup/prod/db_t _s4_p EXPIRED DISK /rman_backup/prod/tbs_users_t _s5 Do you really want to delete the above objects (enter YES or NO)? yes deleted backup piece backup piece handle=/rman_backup/prod/db_t _s3_p1 recid=3 stamp= deleted backup piece backup piece handle=/rman_backup/prod/db_t _s4_p1 recid=4 stamp= deleted backup piece backup piece handle=/rman_backup/prod/tbs_users_t _s5 recid=5 stamp= Deleted 3 EXPIRED objects

31 9. RAC 환경에서의 RMAN Backup Setup 양쪽노드에 remote_login_passwordfile='exclusive' 를설정한다.(target Database 로접속할때 internal user 로 connect 해야하기때문에반드시 setting 이되어있어야한다. busan1 $ crs_stat -t Name Type Target State Host ora...g1.inst application ONLINE ONLINE busan1 ora...g2.inst application ONLINE ONLINE busan2 ora.ora10g.db application ONLINE ONLINE busan1 ora...n1.lsnr application ONLINE ONLINE busan1 ora.busan1.gsd application ONLINE ONLINE busan1 ora.busan1.ons application ONLINE ONLINE busan1 ora.busan1.vip application ONLINE ONLINE busan1 ora...n2.lsnr application ONLINE ONLINE busan2 ora.busan2.gsd application ONLINE ONLINE busan2 ora.busan2.ons application ONLINE ONLINE busan2 ora.busan2.vip application ONLINE ONLINE busan2 busan1 $ rman target / catalog rman/rman@resp Recovery Manager: Release Production on Tue Jan 9 19:19: Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: ORA10G (DBID= ) connected to recovery catalog database RMAN> create catalog; 이미다른 DB를위해 rman이사용중이라면생략 recovery catalog already exists RMAN> register database; RAC DB를위해 register한다. database registered in recovery catalog starting full resync of recovery catalog full resync complete RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 2; 몇개의 Channel을설정할것인가에따라 PARALLELISM의값을반드시맞춰주어야합니다. 이것을맞춰주지않으면 Error가발생하면서다른 Node의 archive file들을인식하지못하게될수도있음.( 실제로 Archived file들은정상적으로존재합니다 ) new RMAN configuration parameters: CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET; new RMAN configuration parameters are successfully stored starting full resync of recovery catalog full resync complete RMAN> configure default device type to disk; new RMAN configuration parameters: CONFIGURE DEFAULT DEVICE TYPE TO DISK; new RMAN configuration parameters are successfully stored starting full resync of recovery catalog full resync complete RMAN> configure channel 1 device type disk connect 'SYS/oracle@ORA10g1'; 각노드별로 configure 를

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

슬라이드 1

슬라이드 1 사례를통해본 RMAN (RMAN Case Study) 2013. 02. Seungtaek Lee( 放浪 A) RMAN 백업 Server-Managed Backup(RMAN) Components Target : 백업대상 Catalog : 백업정보가저장되는 RMAN Repository Auxiliary : 백업또는 Target 를 Restore하여여러가지용도로사용하는

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

<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

목차 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

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

세미나(장애와복구-수강생용).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

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

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

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

목 차

목      차 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

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

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

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

Tina Admin

Tina Admin 유니원아이앤씨 DB 기술지원팀 2015 년 09 월 09 일 문서정보 프로젝트명 TTS (Transportable Tablespace) 서브시스템명 버전 1.0 문서명 TTS (Transportable Tablespace) 작성일 2015-08-16 작성자 김성한 최종수정일 2015-09-09 문서번호 UNIONE-201509091051-KSH 재개정이력 일자내용수정인버전

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

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

오라클 데이터베이스 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

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

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

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

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

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

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

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

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

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

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

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

슬라이드 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

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

목차 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

소개 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

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

13주-14주proc.PDF

13주-14주proc.PDF 12 : Pro*C/C++ 1 2 Embeded SQL 3 PRO *C 31 C/C++ PRO *C NOT! NOT AND && AND OR OR EQUAL == = SQL,,, Embeded SQL SQL 32 Pro*C C SQL Pro*C C, C Pro*C, C C 321, C char : char[n] : n int, short, long : float

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

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

10X56_NWG_KOR.indd

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

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

슬라이드 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

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

본교재는수업용으로제작된게시물입니다. 영리목적으로사용할경우저작권법제 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

본문서는 초급자들을 대상으로 최대한 쉽게 작성하였습니다. 본문서에서는 설치방법만 기술했으며 자세한 설정방법은 검색을 통하시기 바랍니다. 1. 설치개요 워드프레스는 블로그 형태의 홈페이지를 빠르게 만들수 있게 해 주는 프로그램입니다. 다양한 기능을 하는 플러그인과 디자인

본문서는 초급자들을 대상으로 최대한 쉽게 작성하였습니다. 본문서에서는 설치방법만 기술했으며 자세한 설정방법은 검색을 통하시기 바랍니다. 1. 설치개요 워드프레스는 블로그 형태의 홈페이지를 빠르게 만들수 있게 해 주는 프로그램입니다. 다양한 기능을 하는 플러그인과 디자인 스마일서브 CLOUD_Virtual 워드프레스 설치 (WORDPRESS INSTALL) 스마일서브 가상화사업본부 Update. 2012. 09. 04. 본문서는 초급자들을 대상으로 최대한 쉽게 작성하였습니다. 본문서에서는 설치방법만 기술했으며 자세한 설정방법은 검색을 통하시기 바랍니다. 1. 설치개요 워드프레스는 블로그 형태의 홈페이지를 빠르게 만들수 있게

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

Microsoft Word - CNVZNGWAIYSE.docx

Microsoft Word - CNVZNGWAIYSE.docx Print Date: 2010-12-17 Oracle Database Net Service DATE : 2010-12-12 06:25 Writer : 박상수 License : 개인자료 - 본문서는모든사람에게열람및수정모두가능합니다 - 버전수정일작성자변경내역 1.0 2010/12/02 박상수 Oracle Net 제목 : Oracle Database Net Service...

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

단계

단계 본문서에서는 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

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

휠세미나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

Sena Device Server Serial/IP TM Version

Sena Device Server Serial/IP TM Version Sena Device Server Serial/IP TM Version 1.0.0 2005. 3. 7. Release Note Revision Date Name Description V1.0.0 2005-03-7 HJ Jeon Serial/IP 4.3.2 ( ) 210 137-130, : (02) 573-5422 : (02) 573-7710 email: support@sena.com

More information

Copyright 2012, Oracle and/or its affiliates. All rights reserved.,.,,,,,,,,,,,,.,...,. U.S. GOVERNMENT END USERS. Oracle programs, including any oper

Copyright 2012, Oracle and/or its affiliates. All rights reserved.,.,,,,,,,,,,,,.,...,. U.S. GOVERNMENT END USERS. Oracle programs, including any oper Windows Netra Blade X3-2B( Sun Netra X6270 M3 Blade) : E37790 01 2012 9 Copyright 2012, Oracle and/or its affiliates. All rights reserved.,.,,,,,,,,,,,,.,...,. U.S. GOVERNMENT END USERS. Oracle programs,

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

Intra_DW_Ch4.PDF

Intra_DW_Ch4.PDF The Intranet Data Warehouse Richard Tanler Ch4 : Online Analytic Processing: From Data To Information 2000. 4. 14 All rights reserved OLAP OLAP OLAP OLAP OLAP OLAP is a label, rather than a technology

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

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

(SW3704) Gingerbread Source Build & Working Guide

(SW3704) Gingerbread Source Build & Working Guide (Mango-M32F4) Test Guide http://www.mangoboard.com/ http://cafe.naver.com/embeddedcrazyboys Crazy Embedded Laboratory www.mangoboard.com cafe.naver.com/embeddedcrazyboys CRZ Technology 1 Document History

More information

ODS-FM1

ODS-FM1 OPTICAL DISC ARCHIVE FILE MANAGER ODS-FM1 INSTALLATION GUIDE [Korean] 1st Edition (Revised 4) 상표 Microsoft, Windows 및 Internet Explorer는 미국 및 / 또는 다른 국가에서 Microsoft Corporation 의 등록 상표입 Intel 및 Intel Core

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

Assign an IP Address and Access the Video Stream - Installation Guide

Assign an IP Address and Access the Video Stream - Installation Guide 설치 안내서 IP 주소 할당 및 비디오 스트림에 액세스 책임 본 문서는 최대한 주의를 기울여 작성되었습니다. 잘못되거나 누락된 정보가 있는 경우 엑시스 지사로 알려 주시기 바랍니다. Axis Communications AB는 기술적 또는 인쇄상의 오류에 대해 책 임을 지지 않으며 사전 통지 없이 제품 및 설명서를 변경할 수 있습니다. Axis Communications

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

R50_51_kor_ch1

R50_51_kor_ch1 S/N : 1234567890123 Boot Device Priority NumLock [Off] Enable Keypad [By NumLock] Summary screen [Disabled] Boor-time Diagnostic Screen [Disabled] PXE OPROM [Only with F12]

More information

PRO1_04E [읽기 전용]

PRO1_04E [읽기 전용] Siemens AG 1999 All rights reserved File: PRO1_04E1 Information and S7-300 2 S7-400 3 EPROM / 4 5 6 HW Config 7 8 9 CPU 10 CPU : 11 CPU : 12 CPU : 13 CPU : / 14 CPU : 15 CPU : / 16 HW 17 HW PG 18 SIMATIC

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

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

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

목차 BUG DEQUEUE 의 WAIT TIME 이 1 초미만인경우, 설정한시간만큼대기하지않는문제가있습니다... 3 BUG [qp-select-pvo] group by 표현식에있는컬럼을참조하는집합연산이존재하지않으면결괏값오류가발생할수있습니다... 4

목차 BUG DEQUEUE 의 WAIT TIME 이 1 초미만인경우, 설정한시간만큼대기하지않는문제가있습니다... 3 BUG [qp-select-pvo] group by 표현식에있는컬럼을참조하는집합연산이존재하지않으면결괏값오류가발생할수있습니다... 4 ALTIBASE HDB 6.5.1.5.10 Patch Notes 목차 BUG-46183 DEQUEUE 의 WAIT TIME 이 1 초미만인경우, 설정한시간만큼대기하지않는문제가있습니다... 3 BUG-46249 [qp-select-pvo] group by 표현식에있는컬럼을참조하는집합연산이존재하지않으면결괏값오류가발생할수있습니다... 4 BUG-46266 [sm]

More information

슬라이드 1

슬라이드 1 / 유닉스시스템개요 / 파일 / 프로세스 01 File Descriptor file file descriptor file type unix 에서의파일은단지바이트들의나열임 operating system 은파일에어떤포맷도부과하지않음 파일의내용은바이트단위로주소를줄수있음 file descriptor 는 0 이나양수임 file 은 open 이나 creat 로 file

More information

chapter4

chapter4 Basic Netw rk 1. ก ก ก 2. 3. ก ก 4. ก 2 1. 2. 3. 4. ก 5. ก 6. ก ก 7. ก 3 ก ก ก ก (Mainframe) ก ก ก ก (Terminal) ก ก ก ก ก ก ก ก 4 ก (Dumb Terminal) ก ก ก ก Mainframe ก CPU ก ก ก ก 5 ก ก ก ก ก ก ก ก ก ก

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

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

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

thesis-shk

thesis-shk DPNM Lab, GSIT, POSTECH Email: shk@postech.ac.kr 1 2 (1) Internet World-Wide Web Web traffic Peak periods off-peak periods peak periods off-peak periods 3 (2) off-peak peak Web caching network traffic

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

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

강의10

강의10 Computer Programming gdb and awk 12 th Lecture 김현철컴퓨터공학부서울대학교 순서 C Compiler and Linker 보충 Static vs Shared Libraries ( 계속 ) gdb awk Q&A Shared vs Static Libraries ( 계속 ) Advantage of Using Libraries Reduced

More information

Copyright 2012, Oracle and/or its affiliates. All rights reserved.,,,,,,,,,,,,,.,..., U.S. GOVERNMENT END USERS. Oracle programs, including any operat

Copyright 2012, Oracle and/or its affiliates. All rights reserved.,,,,,,,,,,,,,.,..., U.S. GOVERNMENT END USERS. Oracle programs, including any operat Sun Server X3-2( Sun Fire X4170 M3) Oracle Solaris : E35482 01 2012 9 Copyright 2012, Oracle and/or its affiliates. All rights reserved.,,,,,,,,,,,,,.,..., U.S. GOVERNMENT END USERS. Oracle programs, including

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

문서 제목

문서 제목 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

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

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

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

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

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

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

시스코 무선랜 설치운영 매뉴얼(AP1200s_v1.1)

시스코 무선랜 설치운영 매뉴얼(AP1200s_v1.1) [ Version 1.3 ] Access Point,. Access Point IP 10.0.0.1, Subnet Mask 255.255.255.224, DHCP Client. DHCP Server IP IP,, IP 10.0.0.X. (Tip: Auto Sensing Straight, Cross-over.) step 1]. step 2] LAN. step

More information

DocsPin_Korean.pages

DocsPin_Korean.pages Unity Localize Script Service, Page 1 Unity Localize Script Service Introduction Application Game. Unity. Google Drive Unity.. Application Game. -? ( ) -? -?.. 준비사항 Google Drive. Google Drive.,.. - Google

More information

Windows 네트워크 사용 설명서

Windows 네트워크 사용 설명서 Windows 네트워크 사용 설명서 (Wireless Manager mobile edition 5.5) 그림의 예로 사용된 프로젝터는 PT-FW300NTEA 입니다. 한국어 TQBH0205-5 (K) 목차 소프트웨어 라이센스 계약 3 무선 연결 사용 시 참고 사항 4 보안 관련 참고 사항 6 소프트웨어 요구 사항 12 시스템 요구 사항 12 Wireless

More information

vm-웨어-앞부속

vm-웨어-앞부속 VMware vsphere 4 This document was created using the official VMware icon and diagram library. Copyright 2009 VMware, Inc. All rights reserved. This product is protected by U.S. and international copyright

More information

4 CD Construct Special Model VI 2 nd Order Model VI 2 Note: Hands-on 1, 2 RC 1 RLC mass-spring-damper 2 2 ζ ω n (rad/sec) 2 ( ζ < 1), 1 (ζ = 1), ( ) 1

4 CD Construct Special Model VI 2 nd Order Model VI 2 Note: Hands-on 1, 2 RC 1 RLC mass-spring-damper 2 2 ζ ω n (rad/sec) 2 ( ζ < 1), 1 (ζ = 1), ( ) 1 : LabVIEW Control Design, Simulation, & System Identification LabVIEW Control Design Toolkit, Simulation Module, System Identification Toolkit 2 (RLC Spring-Mass-Damper) Control Design toolkit LabVIEW

More information

歯sql_tuning2

歯sql_tuning2 SQL Tuning (2) SQL SQL SQL Tuning ROW(1) ROW(2) ROW(n) update ROW(2) at time 1 & Uncommitted update ROW(2) at time 2 SQLDBA> @ UTLLOCKT WAITING_SESSION TYPE MODE_REQUESTED MODE_HELD LOCK_ID1

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

DBMS & SQL Server Installation Database Laboratory

DBMS & SQL Server Installation Database Laboratory DBMS & 조교 _ 최윤영 } 데이터베이스연구실 (1314 호 ) } 문의사항은 cyy@hallym.ac.kr } 과제제출은 dbcyy1@gmail.com } 수업공지사항및자료는모두홈페이지에서확인 } dblab.hallym.ac.kr } 홈페이지 ID: 학번 } 홈페이지 PW:s123 2 차례 } } 설치전점검사항 } 설치단계별설명 3 Hallym Univ.

More information

SQL Developer Connect to TimesTen 유니원아이앤씨 DB 기술지원팀 2010 년 07 월 28 일 문서정보 프로젝트명 SQL Developer Connect to TimesTen 서브시스템명 버전 1.0 문서명 작성일 작성자

SQL Developer Connect to TimesTen 유니원아이앤씨 DB 기술지원팀 2010 년 07 월 28 일 문서정보 프로젝트명 SQL Developer Connect to TimesTen 서브시스템명 버전 1.0 문서명 작성일 작성자 SQL Developer Connect to TimesTen 유니원아이앤씨 DB 팀 2010 년 07 월 28 일 문서정보 프로젝트명 SQL Developer Connect to TimesTen 서브시스템명 버전 1.0 문서명 작성일 2010-07-28 작성자 김학준 최종수정일 2010-07-28 문서번호 20100728_01_khj 재개정이력 일자내용수정인버전

More information

USER GUIDE

USER GUIDE Solution Package Volume II DATABASE MIGRATION 2010. 1. 9. U.Tu System 1 U.Tu System SeeMAGMA SYSTEM 차 례 1. INPUT & OUTPUT DATABASE LAYOUT...2 2. IPO 중 VB DATA DEFINE 자동작성...4 3. DATABASE UNLOAD...6 4.

More information

solution map_....

solution map_.... SOLUTION BROCHURE RELIABLE STORAGE SOLUTIONS ETERNUS FOR RELIABILITY AND AVAILABILITY PROTECT YOUR DATA AND SUPPORT BUSINESS FLEXIBILITY WITH FUJITSU STORAGE SOLUTIONS kr.fujitsu.com INDEX 1. Storage System

More information

歯FDA6000COP.PDF

歯FDA6000COP.PDF OPERATION MANUAL AC Servo Drive FDA6000COP [OPERATION UNIT] Ver 1.0 (Soft. Ver. 8.00 ~) FDA6000C Series Servo Drive OTIS LG 1. 1.1 OPERATION UNIT FDA6000COP. UNIT, FDA6000COP,,,. 1.1.1 UP DOWN ENTER 1.1.2

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

RVC Robot Vaccum Cleaner

RVC Robot Vaccum Cleaner RVC Robot Vacuum 200810048 정재근 200811445 이성현 200811414 김연준 200812423 김준식 Statement of purpose Robot Vacuum (RVC) - An RVC automatically cleans and mops household surface. - It goes straight forward while

More information