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

oracle imp\exp Óï·¨¼ò½é3

1¡¢Êý¾Ý¿âµ¼³öÃüÁî
exp wesoftwcp/wesoft@oradb file=f:\backup\%date:~0,10%.dmp log=f:\backup\%date:~0,10%.log
compress=n buffer=8092 consistent=y direct=n constraints=y feedback=10000  grants=y record=y indexes=y triggers=y rows=y
 
2¡¢Êý¾Ý¿âµ¼ÈëÃüÁî
set UserName=wesoftwcp
set Passwd=wesoft
set DBName=@oradb
#set LogName=%UserName%gz.log
set fromUser=wesoftwcp
set ToUser=wesoftwcp
set FileName=F:\backup\2009-12-03.dmp
imp %UserName%/%Passwd%%DBName% fromuser=%fromUser% touser=%ToUser% file=%FileName%
pause


Ïà¹ØÎĵµ£º

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
  
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆð£¬¾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......

Oracle RACÕæºÃÍæ

Õâ¶Îʱ¼ä£¬½ÓµÄ¶àÊÇRACµÄά»¤ºÍ»Ö¸´ÎÊÌâ¡£ËùÒÔÿÌì¶¼ÊÇÔÚºÍRAC´ò½»µÀ¡£
RACÕæµÄºÜºÃÍæ¡£
´ó¼ÒÓжÔRAC¸ÐÐËȤµÄÓÐÎÊÌâµÄ£¬»òÕßÊÇÓöµ½RACά»¤ÉÏÃæµÄ³öÏÖÎÊÌâµÄ£¬¿ÉÒÔ·¢ÓʼþÖÁinthirties@gmail.comÒ»Æð½»Á÷Ñо¿¡£
ÕæµÄºÜÏ£ÍûÍæOracle ......

Oracle DBA£º±Ø±¸16´ó¼¼Äܺ;­µäÊé¼®»ã×Ü

Ò»¸ö³ÆÖ°µÄÊý¾Ý¿âDBA½ö½öÈ¡µÃORACLE³§¼ÒÈÏÖ¤ÊDz»¹»µÄ£¬¹Ø¼üÊÇÕæÊµ»·¾³µÄÀúÁ·£¬±ÊÕß´ÓÊÂORACLE DBA¶àÄ꣬¾­ÀúORACLE°æ±¾´Ó8iµ½10g(×¢£º¶ÔÓÚÒ»¸ö¹«Ë¾»òµ¥Î»µÄÕæÊµ»·¾³£¬¶ÔÓÚ°æ±¾µÄ×·ÇóÊ×ÒªµÄ£¬¹Ø¼üµÄÎȶ¨ÐÔ)£¬²Ù×÷ϵͳ´Ówindows µ¥»ú¡¢Ë«»úµ½Ö÷Á÷IBM¡¢HPµÄUNIX²Ù×÷ϵͳ£¬ÒÔÏÂÊDZÊÕß¶àÄê´ÓÊÂORACLE DBAµÄһЩÐĵã¬Ï£ÍûÄܸø³õÑ ......

¡¾×ª¡¿OracleÖеÄÓ²½âÎöÓëÈí½âÎö

OracleÖеÄSQLÔÚÖ´ÐÐ֮ǰ½øÐнâÎö£¬Ò»¸öÓ²½âÎö°üÀ¨ÏÂÃæµÄ²½Ö裺
¼ÓÔØµ½¹²Ïí³ØÖÐ - SQLÔ´´úÂë±»¼ÓÔØµ½ÄÚ´æÖС£
Óï·¨½âÎö - Oracle¼ì²éÓ﷨ƴд´íÎó¡£
ÓïÒå½âÎö - OracleÑéÖ¤À´×ÔÊý¾Ý×ÖµäµÄËùÓбíÃûºÍÁÐÃû²¢ÇÒÑéÖ¤ÄãÊÇ·ñÓÐȨ·ÃÎÊÕâЩÊý¾Ý¡£
²éѯת»» - Èç¹ûÔÊÐí(query_rewrite=true)£¬oracle½«°Ñ¸´ÔÓµÄSQLת»»ÎªµÈ¼ÛµÄ¼òµ ......

Oracle RMAN±¸·ÝÖÐcatalogºÍnocatalogÇø±ð

nocatalog·½Ê½¾ÍÊÇÓÃcontrol file×÷Ϊcatalog£¬Ã¿Ò»´Î±¸·Ý¶¼ÒªÍù¿ØÖÆÎļþÀïÃæÐ´ºÃ¶à±¸·ÝÐÅÏ¢£¬¿ØÖÆÎļþÀïÃæ»áÓÐÔ½À´Ô½¶àµÄ±¸·ÝÐÅÏ¢£¬¼´RMANµÄ±¸·ÝÐÅϢдÔÚ±¾µØ¿ØÖÆÎļþÀïÃæ¡£
ÈôΪcatalogÔò±ØÐëÒªÊ×ÏÈÒª´´½¨Ä¿Â¼±¸·ÝÊý¾Ý¿â£¬½¨Á¢»Ö¸´Ä¿Â¼£¬¼´Êý¾Ý¿âµÄ±¸·ÝÐÅϢдµ½»Ö¸´Ä¿Â¼ÀïÃæ¡£
µ±Í¨¹ýrman nocatalog·½Ê½±¸·ÝOracleÊý¾Ý¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ