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

oracle dg µÄ»ù±¾ÃüÁî

1£¬²é¿´µ±Ç°µÄ±£»¤Ä£Ê½
 select DATABASE_ROLE,PROTECTION_MODE,PROTECTION_LEVEL from v$database;
2£¬²é¿´ÈÕÖ¾µÄ´«ËÍ·½Ê½£»
 select dest_name,archiver from v$archive_dest;
3£¬Í£Ö¹standbyµÄ×Ô¶¯»Ö¸´×´Ì¬
 alter database recover manager standby database finish;
4£¬Ìí¼Óstandby logfile
 alter database add standby logfile group 4('/oracle/product/10.2.0/db_1/oradata/sjh10g/redo04.log') size 50m;
5£¬¸ü¸Ä±£»¤Ä£Ê½
 alter database set standby database to maximize protextion;
 alter database set standby database to maximize availability;
 alter database set standby database to maximize performancen;
6£¬¸ü¸Ä´«Ê䷽ʽ
 alter system setlog_archive_dest_2='SERVICE=orcldg LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcldg';
 
7£¬½â¾ö·½Ê½£º½«Ö÷±¸¿âµÄflash back ´ò¿ª
 Æô¶¯µ½mount
 select FLASHBACK_ON from v$database;
 alter database flashback on;
8£¬È¡Ïû×Ô¶¯»Ö¸´Ä£Ê½
 alter database recover managed standby database cancel;
 alter database recover managed standby database finish;
 alter database recover managerd standby database finish force;


Ïà¹ØÎĵµ£º

Oracle²ð·Ö×Ö·û´®º¯Êý

--¶¨ÒåÀàÐÍ
CREATE OR REPLACE TYPE ty_str_split IS TABLE OF VARCHAR2(4000);
--´´½¨º¯Êý
CREATE OR REPLACE FUNCTION f_stringsplit (p_str IN VARCHAR2, p_delimiter IN VARCHAR2)
    RETURN ty_str_split PIPELINED
/*****
****×Ö·û´®²ð·Ö,Ï൱ÓÚjava.lang.StringÀàµÄsplit·½·¨
****×¢Òâ:ÐÂÔöt ......

oracle ÔöÁ¿±¸·Ý½Å±¾

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
¡¡¡¡{
¡¡¡¡CONFIG ......

Oracle UndoµÄѧϰ

Oracle UndoµÄѧϰ
 »Ø¹ö¶Î
¿É
ÒÔ˵ÊÇÓÃÀ´±£³ÖÊý¾Ý±ä»¯Ç°Ó³Ïó¶øÌṩһÖ¶ÁºÍ±£ÕÏÊÂÎñÍêÕûÐÔµÄÒ»¶Î´ÅÅÌ´æ´¢ÇøÓò¡£µ±Ò»¸öÊÂÎñ¿ªÊ¼µÄʱºò£¬»áÊ×ÏȰѱ仯ǰµÄÊý¾ÝºÍ±ä»¯ºóµÄÊý¾ÝÏÈдÈëÈÕÖ¾»º
³åÇø£¬È»ºó°Ñ±ä»¯Ç°µÄÊý¾ÝдÈë»Ø¹ö¶Î£¬×îºó²ÅÔÚÊý¾Ý»º³åÇøÖÐÐ޸ģ¨ÈÕÖ¾»º³åÇøÄÚÈÝÔÚÂú×ãÒ»¶¨µÄÌõ¼þºó¿ÉÄܱ»Ð´Èë´ÅÅÌ£¬µ«ÔÚÊ ......

Oracle NULL ¿Õ×Ö·û´®¡£¡£¡£¡£¡£¡£

º¬Òå½âÊÍ£º
ÎÊ£ºÊ²Ã´ÊÇNULL£¿
´ð£ºÔÚÎÒÃDz»ÖªµÀ¾ßÌåÓÐʲôÊý¾ÝµÄʱºò£¬Ò²¼´Î´Öª£¬¿ÉÒÔÓÃNULL£¬ÎÒÃdzÆËüΪ¿Õ£¬ORACLEÖУ¬º¬ÓпÕÖµµÄ±íÁ㤶ÈΪÁã¡£
ORACLEÔÊÐíÈκÎÒ»ÖÖÊý¾ÝÀàÐ͵Ä×Ö¶ÎΪ¿Õ£¬³ýÁËÒÔÏÂÁ½ÖÖÇé¿ö£º
1¡¢Ö÷¼ü×ֶΣ¨primary key£©£¬
2¡¢¶¨ÒåʱÒѾ­¼ÓÁËNOT NULLÏÞÖÆÌõ¼þµÄ×Ö¶Î
˵Ã÷£º
1¡¢µÈ¼ÛÓÚûÓÐÈκ ......

Ò»¸ö×Ö·ûµ¼ÖÂoracle°²×°³öÏÖora 12154

ǰÁ½Ì죬ÔÚ¿Í»§µÄÐéÄâ»úÉϰ²×°oracleÈí¼þÓÃÓÚ²¿Êð×Ô¼ºµÄÓ¦ÓᣲÅ×°ºÃ²»¾Ã£¬ÓÉÓÚÐèÒªÅäÖÃÍøÂ簲ȫ£¬°ÑÕû¸öÐéÄâ»ú¶¼²ùµô£¬¿Ë¡Á˸öÅäÖúÃÍøÂ簲ȫµÄÐéÄâ»ú¸øÎÒÃÇʹÓã¬Ö»µÃ֨װoracle 10g¡£
µ±µÚ¶þ´ÎÔÚÐéÄâ»úÉϰ²×°oracleʱ£¬Êý¾Ý¿âÃûºÍϵͳÕ˺ŵÄÃÜÂë¶¼×öÁ˸͝£¬½á¹ûÖ±½Óµ¼ÖÂÔÚ´´½¨oracleʵÀýʱµ¯³öora-12154´íÎó¡£Ñ¡Ôñ¡¾º ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ