oracle ÔöÁ¿±¸·Ý½Å±¾
OS :RHEL AS 4 oracle 10g
0±¸·Ý½Å±¾
#!/bin/bash
# incremental level 0 backup script
source /home/oracle/.bash_profile
current_day=`date +%Y%m%d`
mkdir /home/oracle/RMANBACKUP/$current_day
rman target / <<EOF
run
{
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/RMANBACKUP/$current_day/PID-%F';
allocate channel dev1 type disk;
allocate channel dev2 type disk;
allocate channel dev3 type disk;
backup incremental level 0 tag='db0'
format '/home/oracle/RMANBACKUP/$current_day/%n_%T_%U' database;
sql 'alter system archive log current';
backup archivelog all format '/home/oracle/RMANBACKUP/$current_day/arc_%n_%T_%U' delete all input;
release channel dev1;
release channel dev2;
release channel dev3;
}
EOF
1¼¶ÀÛ»ýÔöÁ¿½Å±¾
#!/bin/bash
# incremental level 1 backup script
source /home/oracle/.bash_profile
current_day=`date +%Y%m%d`
incr_day=incr$current_day
mkdir /home/oracle/RMANBACKUP/$incr_day
rman target / <<EOF
run
{
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/RMANBACKUP/$incr_day/PID-%F';
allocate channel dev1 type disk;
allocate channel dev2 type disk;
&
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
¡¡¡¡Sun±¾À´¾ÍºÜÀ÷º¦£¬Î޷ǽüÄêÀ´Ó¯ÀûÄÜÁ¦ÓÐËùϽµ£¬Oracle¿¿Êý¾Ý¿â׬ÁË´ó°Ñ³®Æ±¡£Á½¼ÒÁªºÏÒÔºóÐγɓCPU-¸ß¶ËÖ÷»ú-²Ù×÷ϵͳ-¿ª·¢»·¾³-Êý¾Ý¿â-ÓïÑÔ-Ó¦ÓÃÈí¼þ”Ò»ÌõÁú²úÆ·Ïߣ¬´ËǰÓдËÄÜÁ¦µÄÖ»ÓÐIBM¡£
¡¡¡¡Á½¼Ò½ñºóµÄÕÐÅÆ²úÆ·¶Ô±ÈÈçÏ£º
SUN&Oracle IBM
CPU Ultra Power
Ö÷»ú UltraϵÁÐ RS,ASµÈPowerϵÁ ......
1.¿Í»§¶ËÁ¬½ÓÖÁoralce:
Ê×Ïȿͻ§¶ËÁ¬½ÓÖÁoracleµÄ¼àÌýÆ÷,È»ºó¼àÌýÆ÷·ÖÅäÒ»¸öÊý¾Ý¿âʵÀý(ÕâÀïµÄÊÇʵÀý)¸ø¿Í»§¶Ë,È»ºó¿Í»§¶ËÒÔºó¾ÍÖ±½ÓÓëÕâ¸öÊý¾Ý¿âʵÀý½øÐÐÁ¬½Ó,Ö±ÖÁ¶Ï¿ªÓëoracleµÄÁ¬½Ó.
2.Ìá½»sql:
(1)¿Í»§¶ËÓû§Ìá½»Ò»¸ösql ......
C#Á¬½ÓOracleÊý¾Ý¿â×Ö·û´®
http://developer.51cto.com
2009-08-20 17:55 ØýÃû °Ù¶È¿Õ¼ä ÎÒÒªÆÀÂÛ(
0
)
C#Á¬½ÓOracleÊý¾Ý¿âÒÔ¼°C#Á¬½ÓOracleÊý¾Ý¿â×Ö·û´®µÈÄÚÈݽ«ÔÚ±¾ÎÄÖÐÕ¹ÏÖ£¬Ï£Íû±¾ÎÄÄܶԴó¼ÒÁ˽âC#Á¬½ÓÊý¾Ý¿âÓÐËù°ïÖú¡£
C#Á¬½ÓOracleÊý¾Ý¿â×Ö·û´®£¨²éѯÊý¾Ý£©
using
Syst ......
ÖØ×öÈÕÖ¾ÎļþÊÇOracleÊý¾Ý¿âÖÐÒ»Öַdz£ÖØÒªµÄÈÕÖ¾Îļþ£¬Ò²ÊÇÆäÒ»¸öºÜÓÐÌØÉ«µÄ¹¦ÄÜ¡£ÖØ×öÈÕÖ¾Îļþ»á¼Í¼¶ÔÓÚÊý¾Ý¿âµÄÈκβÙ×÷£¬ÈçÀûÓÃDMLÓï¾ä»òÕßDDLÓï¾ä¶ÔÊý¾Ý½øÐиü¸Ä£¬»òÕßÊý¾Ý¿â¹ÜÀíÔ±¶ÔÊý¾Ý¿â½á¹¹½øÐиü¸Ä£¬¶¼»áÔÚÖØ×öÈÕÖ¾ÖнøÐмǼ¡£
¡¡¡¡¿É¼û£¬µ±Êý¾Ý±»ÒâÍâµÄɾ³ý»òÕßÐ޸ģ¬ÎÒÃÇ¿ÉÒÔÀûÓÃÖØÐÂÈÕÖ¾Îļþ½øÐлָ´; µ±³ö ......