Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ......

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

MS SQL 2005Á´½Ó·þÎñÆ÷Á¬½ÓÔ¶³ÌORACLEÈ«¹ý³Ì

µÚÒ»²½:ÏÂÔØ°²×°Oracle 10g Release 2 ¿Í»§¶ËÈí¼þ,ÏÂÔØÁ¬½ÓÊÇ:
http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip
ÏÂÔØºó°²×°
 
 
 
µÚ¶þ²½:ÏÂÔØ°²×°Oracle ODAC,ÏÂÔØÁ¬½ÓÊÇ:
http://download.oracle.com/otn/other/ole-oo4o/ODAC1020221.exe
 
µÚÈý²½: ÖØÆôMS SQ ......

ORACLE ±¸·Ý²ßÂÔ

Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¡¡¡¡¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆð£¬¾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ¼ÆËã»úÒÔÆäÇ¿´óµÄËÙ¶È´¦ÀíÄÜÁ¦£¬È¡´úÁ˺ܶàÈËΪµÄ¹¤×÷£¬µ«ÊÇ£¬ÍùÍùºÜ¶àʱºò£¬ËüÓÖÊÇÄÇôÈõ²»½û·ç£¬Ö÷°åÉϵÄоƬ¡¢Ö÷°åµç·¡¢ÄÚ´æ¡¢µçÔ´µÈÈκÎÒ»Ïî²»ÄÜÕý³£¹¤×÷£¬¶¼»áµ¼Ö¼ÆËã»úϵͳ²»ÄÜÕý³£¹¤×÷¡£µ±È»£¬ÕâЩË𻵿ÉÒÔÐÞ¸´£¬²»»áµ¼ÖÂÓ¦Óú ......

Oracle ±Ê¼Ç


          µÚ1Ò³
 
1. Oracle µÄʹÓÃ
1.1. SQLPLUS µÄÃüÁî
³õʼ»¯±íµÄλÖãº
set
NLS_LANG=american_america.us7ascii  (ÉèÖñàÂë²Å¿ÉÒÔʹÓÃÏÂÃæ½Å±¾)
cd
$ORACLE_HOME/rdbms   cd demo     summit2.sql
********* ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ