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;
Ïà¹ØÎĵµ£º
--¶¨ÒåÀàÐÍ
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 ÔöÁ¿±¸·Ý½Å±¾
¡¡¡¡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µÄѧϰ
»Ø¹ö¶Î
¿É
ÒÔ˵ÊÇÓÃÀ´±£³ÖÊý¾Ý±ä»¯Ç°Ó³Ïó¶øÌṩһÖ¶ÁºÍ±£ÕÏÊÂÎñÍêÕûÐÔµÄÒ»¶Î´ÅÅÌ´æ´¢ÇøÓò¡£µ±Ò»¸öÊÂÎñ¿ªÊ¼µÄʱºò£¬»áÊ×ÏȰѱ仯ǰµÄÊý¾ÝºÍ±ä»¯ºóµÄÊý¾ÝÏÈдÈëÈÕÖ¾»º
³åÇø£¬È»ºó°Ñ±ä»¯Ç°µÄÊý¾ÝдÈë»Ø¹ö¶Î£¬×îºó²ÅÔÚÊý¾Ý»º³åÇøÖÐÐ޸ģ¨ÈÕÖ¾»º³åÇøÄÚÈÝÔÚÂú×ãÒ»¶¨µÄÌõ¼þºó¿ÉÄܱ»Ð´Èë´ÅÅÌ£¬µ«ÔÚÊ ......
º¬Òå½âÊÍ£º
ÎÊ£ºÊ²Ã´ÊÇNULL£¿
´ð£ºÔÚÎÒÃDz»ÖªµÀ¾ßÌåÓÐʲôÊý¾ÝµÄʱºò£¬Ò²¼´Î´Öª£¬¿ÉÒÔÓÃNULL£¬ÎÒÃdzÆËüΪ¿Õ£¬ORACLEÖУ¬º¬ÓпÕÖµµÄ±íÁ㤶ÈΪÁã¡£
ORACLEÔÊÐíÈκÎÒ»ÖÖÊý¾ÝÀàÐ͵Ä×Ö¶ÎΪ¿Õ£¬³ýÁËÒÔÏÂÁ½ÖÖÇé¿ö£º
1¡¢Ö÷¼ü×ֶΣ¨primary key£©£¬
2¡¢¶¨ÒåʱÒѾ¼ÓÁËNOT NULLÏÞÖÆÌõ¼þµÄ×Ö¶Î
˵Ã÷£º
1¡¢µÈ¼ÛÓÚûÓÐÈκ ......
ǰÁ½Ì죬ÔÚ¿Í»§µÄÐéÄâ»úÉϰ²×°oracleÈí¼þÓÃÓÚ²¿Êð×Ô¼ºµÄÓ¦ÓᣲÅ×°ºÃ²»¾Ã£¬ÓÉÓÚÐèÒªÅäÖÃÍøÂ簲ȫ£¬°ÑÕû¸öÐéÄâ»ú¶¼²ùµô£¬¿Ë¡Á˸öÅäÖúÃÍøÂ簲ȫµÄÐéÄâ»ú¸øÎÒÃÇʹÓã¬Ö»µÃ֨װoracle 10g¡£
µ±µÚ¶þ´ÎÔÚÐéÄâ»úÉϰ²×°oracleʱ£¬Êý¾Ý¿âÃûºÍϵͳÕ˺ŵÄÃÜÂë¶¼×öÁ˸͝£¬½á¹ûÖ±½Óµ¼ÖÂÔÚ´´½¨oracleʵÀýʱµ¯³öora-12154´íÎó¡£Ñ¡Ôñ¡¾º ......