OracleÓû§¹ÜÀí
Ò»£¬OracleÊý¾Ý¿âÓû§¼ò½é
ÔÚOracleÊý¾Ý¿âÖÐÈκζÔÏó¶¼ÊôÓÚÒ»¸öÌض¨Óû§£¬»òÕß˵һ¸öÓû§ÓëͬÃûµÄģʽÏà¹ØÁª¡£
ÒªÁ¬½Óµ½OracleÊý¾Ý¿âÐèÒªÒ»¸öÓû§ÕÊ»§£¬¸ù¾ÝÐèÒªÊÚÓèµÄ²Ù×÷ȨÏÞ¡£
1£¬Ä¬ÈÏÊý¾Ý¿âÓû§Ä£Ê½£º
Sys:Êý¾Ý¿â×ֵ䣨´æ´¢±»¹ÜÀí¶ÔÏóËùÓÐÐÅÏ¢£©ºÍÊÓͼ´æ´¢ÔÚ¸ÃģʽÖС£ÏµÍ³¼¶Óû§¡£
System:ĬÈÏϵͳ¹ÜÀíÔ±£¨DBAȨÏÞ£©Óû§¡£ÏµÍ³¼¶Óû§¡£
Scott:Êý¾Ý¿âʾ·¶Óû§£¬Ä¬ÈÏ¿ÚÁîtiger¡£²»Í¬°æ±¾²»Í¬¡£
2£¬Ê²Ã´ÊÇȨÏÞ£¿
¹ÜÀíÓû§¶ÔÊý¾Ý¿â¶¨Ò壨DDL£©ºÍ·ÃÎÊÊý¾Ý¿â£¨DML£©µÄ²Ù×÷¡£
¢ÙϵͳȨÏÞ£º¹ÜÀíÊý¾Ý¿â²Ù×÷DDL£¬½øÐÐϵͳ¼¶»î¶¯µÄÄÜÁ¦¡£
¢Ú¶ÔÏóȨÏÞ£º¹ÜÀí¶ÔÏó½øÐвÙ×÷DML¡£
3£¬Ê²Ã´ÊǽÇÉ«£¿
¢Ù¹ÜÀíÓû§¶ÔÊý¾Ý¿â½øÐв»Í¬¼¶±ðµÄ·ÃÎÊ¡£
¢Ú½ÇÉ«ÊÇÒ»×éȨÏ޵ļ¯ºÏ£¬½«½ÇÉ«¸³¸øÒ»¸öÓû§£¬Õâ¸öÓû§¾ÍÓµÓÐÁËÕâ¸ö½ÇÉ«ÖеÄËùÓÐȨÏÞ¡£
Ö»ÒªµÚÒ»´Î½«½ÇÉ«¸³¸øÕâÒ»×éÓû§£¬½ÓÏÂÀ´¾ÍÖ»ÒªÕë¶Ô½ÇÉ«½øÐйÜÀí¾Í¿ÉÒÔÁË¡£
¶þ£¬Óû§Óë±í¿Õ¼äµÄ¹Øϵ
1£¬Ã¿¸öÓû§¶¼ÓÐÒ»¸öĬÈϱí¿Õ¼ä£¨Ä¬ÈÏΪSystem£©ºÍÒ»¸öÁÙʱ±í¿Õ¼ä£¨Ä¬ÈÏΪTemp£©;
2£¬±í¿Õ¼ä×÷ÓÃ;
¢Ù.¾ö¶¨Êý¾Ý¿âʵÌåµÄ¿Õ¼ä·ÖÅä;
¢Ú.ÉèÖÃÊý¾Ý¿âÓû§µÄ¿Õ¼ä·Ý¶î;
¢Û.¿ØÖÆÊý¾Ý¿â²¿·ÖÊý¾ÝµÄ¿ÉÓÃÐÔ;
¢Ü.·Ö²¼Êý¾ÝÓÚ²»Í¬µÄÉ豸֮¼äÒÔ¸ÄÉÆÐÔÄÜ;
3£¬´´½¨±í¿Õ¼ä(TableSpace)
Óï·¨¸ñʽ:
CREATE TABLESPACE ±í¿Õ¼äÃû
DATAFILE Îļþ±êʶ·û [,Îļþ±êʶ·û]
[SIZEÕûÊý [K\M] ]
[AUTOEXTEND] [ON | OFF]
;
ÆäÖÐ:Îļþ±êʶ·û=’ÎļþÃû’
Àý×Ó£º
Create TableSpace ts5_11
DataFile ‘E:\OracleTableSpace\05_11\ts1.DBF’, ‘E:\OracleTableSpace\05_11\ts2.DBF'
Size 10M;
4£¬Ð޸ıí¿Õ¼äÅäÖÃ
Óï·¨¸ñʽ:
ALTER TABLESPCE ±í¿Õ¼äÃû
(ADD DATAFILE Îļþ±êʶ·û[,Îļþ±êʶ·û]
| RENAME DATAFILE ’ÎļþÃû’[,’ÎļþÃû’]
TO ’ÎļþÃû’[,’ÎļþÃû’]
);
Èý£¬Óû§µÄ´´½¨ºÍ¹ÜÀí
1£¬´´½¨Êý¾Ý¿âÓû§£¨User£©
Óï·¨¸ñʽ:
Ïà¹ØÎĵµ£º
1 ²Ù×÷ϵͳ±¸·Ý
²Ù×÷ϵͳ±¸·ÝºÍ»Ö¸´ÊµÊ©ÆðÀ´±È½Ï¼òµ¥£¬µ±È»Ò²±È½Ï·Ñʱ£¬ÒªÇóϵͳֹͣʹÓ㬴˹ý³Ì°üÀ¨¹Ø±ÕÊý¾Ý¿â²¢´ÓϵͳÉÏ×¢ÏúËùÓÐÓû§¡£ËùÓзÃÎʱ»½â³ýÖ®ºó£¬ÏµÍ³¹Ø±Õ²¢ÒÔµ¥Óû§·½Ê½ÖØÐÂÆô¶¯£¬¿ØÖÆȨ½»¸øϵͳ¹ÜÀíÔ±£¬ÕâÒ»²½È·±£Ã»ÓÐÓû§Ó¦ÓóÌÐòÈí¼þÔËÐУ¬±ÜÃâÐÞ¸ÄÓ²ÅÌÉϵÄÊý¾Ý¡£Èç¹ûÕâ¸ö±¸·ÝÓÃÓÚ»Ö¸´Êý¾Ý¿âϵͳ£¬ÄÇôϵ ......
Ò»¡¢Ð½¨databack.shÎļþ£¬´æ·ÅĿ¼/opt/databack/
#Êý¾Ý¿âÓû§×ÊÁÏ
USERNAME=Êý¾Ý¿âÓû§Ãû(ÐÅÏ¢Òþ²Ø)
PASSWORD=Êý¾Ý¿âÃÜÂë(ÐÅÏ¢Òþ²Ø)
#FTP·þÎñÆ÷ÐÅÏ¢
FTP_SERV=FTP·þÎñÆ÷(ÐÅÏ¢Òþ²Ø)
FTP_USER=FTPÓû§Ãû(ÐÅÏ¢Òþ²Ø)
FTP_PASS=FTPÃÜÂë(ÐÅÏ¢Òþ²Ø)
FTP_DIR=FTPĿ¼(ÐÅÏ¢Òþ²Ø)
#±¸·ÝĿ¼
BACKUP_DIR=/opt/databack
#¸ ......
Èç¹ûweb·½Ê½µÄem£¬isqlplus·ÃÎʲ»ÁË¡£
1. ¼ì²éÖ÷»úÃû/IP¡¢¶Ë¿ÚÊÇ·ñÕýÈ·
°²×°Ê±µÄÖ÷»úÃû/IP¡¢¶Ë¿Ú¼Ç¼ÔÚ$ORACLE_HOME/install/portlist.ini ÎļþÖС£
ȱʡÊÇ£º
Ò»°ãÓû§ http://ip:5560/isqlplus
DBAÓû§ &nb ......
ÔÚOracleÖн¨¿â£¬Í¨³£ÓÐÁ½ÖÖ·½·¨¡£Ò»ÊÇʹÓÃOracleµÄ½¨¿â¹¤
ÇÒDBCA£¬ÕâÊÇÒ»¸öͼÐνçÃ湤ÇÒ£¬Ê¹ÓÃÆðÀ´·½±ãÇÒºÜÈÝÒ×Àí½â£¬ÒòΪËüµÄ½çÃæÓѺá¢ÃÀ¹Û£¬¶øÇÒÌáʾҲ±È½ÏÆëÈ«¡£ÔÚ£×indowsϵͳÖУ¬Õâ¸ö¹¤¾ß¿ÉÒÔÔÚOracle³ÌÐò×éÖдò¿ª£¨”¿ªÊ¼”—“³ÌÐò”—“ Oracle OraDb10g_home1”&mdash ......