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

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 10g undo±í¿Õ¼äʹÓÃÂʾӸ߲»ÏÂbug

¶ÔÓÚUNDO
±í¿Õ¼ä´óСµÄ¶¨ÒåÐèÒª¿¼ÂÇUNDO_RETNETION
²ÎÊý¡¢²úÉúµÄUNDO BLOCKS/
Ãë¡¢UNDO BLOCK
µÄ´óС¡£undo_retention
£º¶ÔÓÚUNDO
±í¿Õ¼äµÄÊý¾ÝÎļþÊôÐÔΪautoextensible,
Ôòundo_retenion
²ÎÊý±ØÐëÉèÖã¬UNDO
ÐÅÏ¢½«ÖÁÉÙ±£ÁôÖÁundo_retention
²ÎÊýÉ趨µÄÖµÄÚ£¬µ«UNDO
±í¿Õ¼ä½«»á×Ô¶¯À©Õ¹¡£¶ÔÓڹ̶¨UNDO
±í¿Õ¼ä ......

ORACLE¸´Ï°(¶þ)

Èý¡¢     PL/SQL³ÌÐòµ¥Ôª
1¡¢ÎÞÂÛÊǵ¥¶ÀµÄ¹ý³Ì/º¯Êý£¬»¹ÊǰüÖеĹý³Ì/º¯Êý£¬¶¼Í³³ÆÎª×Ó³ÌÐò¡£
2¡¢¹ý³Ì
 
1)       Òì³£´¦Àí²¿·ÖÊÇ¿ÉÑ¡µÄ¡£
2)       ¹ý³ÌÃûÓ¦¸ÃÓö¯´Ê£¬ÒòΪ¹ý³Ìͨ³£ÊÇÖ´ÐÐijÖÖ¶¯×÷¡£¹ý³Ì²¢²»Ò»¶¨¾ßÓвÎÊý¡£µ±´ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ