Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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 ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

oracle ±í¿Õ¼ä½¨Òé

¡¡¡¡OracleÊý¾Ý¿âÖУ¬±íÊÇ×î»ù±¾µÄÄÚÈÝ¡£¿ÉÒÔ˵£¬±íÉè¼ÆµÄºÃ»µÖ±½Ó¸úÊý¾Ý¿âµÄÐÔÄÜÏà¹Ø¡£ËùÒÔ£¬ÔÚÉè¼Æ±íµÄʱºò£¬³ýÁËÒª×ñÑ­Æä¹ÌÓеÄÊý¾Ý¿â×¼ÔòÖ®Í⣬»¹ÐèÒª¿´¸öÈ˵ÄÊý¾Ý¿â¹ÜÀí¾­Ñé¡£ÏÂÃæÎҾͰÑÕâЩ¾­Ñé·ÖÏíһϣ¬»òÐí¶Ô´ó¼ÒÓÐËù°ïÖú¡£
¡¡¡¡Ò»¡¢ ±í¸Ã´æ·ÅÔÚÄÄÀï?
¡¡¡¡ÎÒÃǶ¼ÖªµÀ£¬ÔÚOracleÊý¾Ý¿âÖУ¬Ê¹ÀûÓÿռäÕâ¸ö¸ÅÄîÀ´¹Ü ......

oracleµÄÕýÔò±í´ïʽ(regular expression)¼òµ¥½éÉÜ

Ŀǰ£¬ÕýÔò±í´ïʽÒѾ­ÔںܶàÈí¼þÖеõ½¹ã·ºµÄÓ¦Ó㬰üÀ¨*nix£¨Linux, UnixµÈ£©£¬HPµÈ²Ù×÷ϵͳ£¬PHP£¬C#£¬JavaµÈ¿ª·¢»·¾³¡£
 
Oracle 10gÕýÔò±í´ïʽÌá¸ßÁËSQLÁé»îÐÔ¡£ÓÐЧµÄ½â¾öÁËÊý¾ÝÓÐЧÐÔ£¬ ÖØ¸´´ÊµÄ±æÈÏ, Î޹صĿհ׼ì²â£¬»òÕß·Ö½â¶à¸öÕýÔò×é³É
µÄ×Ö·û´®µÈÎÊÌâ¡£
 
Oracle 10gÖ§³ÖÕýÔò±í´ïʽµÄËĸöк¯Êý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ