https://www.adminschool.net/wiki/ 2026-04-22T04:57:07+00:00 https://www.adminschool.net/wiki/ https://www.adminschool.net/wiki/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2025-10-03T13:30:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=lec:oracle:11gadmin1&rev=1759498249&do=diff Oracle DataBase 11g Admin I 강의 17 8 pre-work SQL> create directory dpdata as '/home/oracle/dpdpata'; SQL> GRANT READ ON DIRECTORY dpdata to hr ; SQL> GRANT WRITE ON DIRECTORY dpdata to hr; expdp $ expdp hr/oracle directory=dpdata dumpfile=expdp_hr.dmp schemas=hr logfile=expdp_hr.log job_name=expdp_hr text/html 2025-10-03T13:30:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=lec:oracle:11gadmin2&rev=1759498249&do=diff Oracle DataBase 11g Admin II 강의 02 Oracle Database Recovery 28 Monitoring Fast Recovery Area Space Usage SELECT * FROM V$RECOVERY_FILE_DEST; SELECT * FROM V$RECOVERY_AREA_USAGE; 03 RMAN 7 Recovery Catalog 데이타베이스 구성 create database rcat; create tablespace rcat_ts datafile '/u01/app/oracle/oradata/rcat/rcat_ts01.dbf' size 15M autoextend on next 10m maxsize 1000M; text/html 2025-10-03T13:30:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=lec:oracle:20140926&rev=1759498249&do=diff Oracle Performance Tuning 준비물 * putty * sql developer * VMware 이미지 * VMware 프로그램 1일차 설치 및 설정 * VMware Network Editor * 리눅스 아이피 설정 # vi /etc/sysconfig/network-scrits/ifcfg-eth0 # /etc/init.d/network restart