Oracle Êý¾Ý¿âµÄ±¸·ÝÓë»Ö¸´£¨Âß¼¡¢Àä¡¢ÈÈ£©
½ñÌì¿´µ½Ò»Æª¹ØÓÚORCLEµÄÂß¼±¸·Ý£¬Àä¡¢Èȱ¸·ÝµÄÌû×Ó½²µÄͦºÃµÄ£¬²»¹ýÕâƪÎÄÕÂÊÇÒÔORACLE 7ΪÀý×Ó£¬ËäÈ»ÏÖÔÚÒѾÓкܺúÜÇ¿´óµÄRMAN£¬µ«»¹ÊǾõµÃÓбØҪת¹ýÀ´£¬²»ÄÜϲÐÂÑá¾ÉÂï¡£
==================================================================================
OracleÊý¾Ý¿âµÄ±¸·ÝÓë»Ö¸´
---- µ±ÎÒÃÇʹÓÃÒ»¸öÊý¾Ý¿âʱ£¬×ÜÏ£ÍûÊý¾Ý¿âµÄÄÚÈÝÊÇ¿É¿¿µÄ¡¢ÕýÈ·µÄ£¬µ«ÓÉÓÚ¼ÆËã»úϵͳµÄ¹ÊÕÏ£¨°üÀ¨»úÆ÷¹ÊÕÏ¡¢½éÖʹÊÕÏ¡¢Îó²Ù×÷µÈ£©£¬Êý¾Ý¿âÓÐʱҲ¿ÉÄÜÔâµ½ÆÆ»µ£¬ÕâʱÈçºÎ¾¡¿ì»Ö¸´Êý¾Ý¾Í³ÉΪµ±ÎñÖ®¼±¡£Èç¹ûƽʱ¶ÔÊý¾Ý¿â×öÁ˱¸·Ý£¬ÄÇô´Ëʱ»Ö¸´Êý¾Ý¾ÍÏԵúÜÈÝÒס£Óɴ˿ɼû£¬×öºÃÊý¾Ý¿âµÄ±¸·ÝÊǶàôµÄÖØÒª£¬ÏÂÃæ±ÊÕß¾ÍÒÔORACLE7ΪÀý£¬À´½²ÊöÒ»ÏÂÊý¾Ý¿âµÄ±¸·ÝºÍ»Ö¸´¡£ORACLE Êý¾Ý¿âÓÐÈýÖÖ±ê×¼µÄ±¸·Ý·½·¨£¬ËüÃÇ·Ö±ðΪµ¼³ö/µ¼È루EXPORT/IMPORT£©¡¢À䱸·Ý¡¢Èȱ¸·Ý¡£µ¼³ö±¸·ÝÊÇÒ»ÖÖÂß¼±¸·Ý£¬À䱸·ÝºÍÈȱ¸·ÝÊÇÎïÀí±¸·Ý¡£
---- Ò»¡¢ µ¼³ö/µ¼È루Export/Import£©
---- ÀûÓÃExport¿É½«Êý¾Ý´ÓÊý¾Ý¿âÖÐÌáÈ¡³öÀ´£¬ÀûÓÃImportÔò¿É½«ÌáÈ¡³öÀ´µÄÊý¾ÝËÍ»ØOracleÊý¾Ý¿âÖÐÈ¥¡£
---- 1. ¼òµ¥µ¼³öÊý¾Ý£¨Export£©ºÍµ¼ÈëÊý¾Ý£¨Import£©
---- OracleÖ§³ÖÈýÖÖÀàÐ͵ÄÊä³ö£º
---- £¨1£©±í·½Ê½£¨T·½Ê½£©£¬½«Ö¸¶¨±íµÄÊý¾Ýµ¼³ö¡£
---- £¨2£©Óû§·½Ê½£¨U·½Ê½£©£¬½«Ö¸¶¨Óû§µÄËùÓжÔÏó¼°Êý¾Ýµ¼³ö¡£
---- £¨3£©È«¿â·½Ê½£¨Full·½Ê½£©£¬½«Êý¾Ý¿âÖеÄËùÓжÔÏóµ¼³ö¡£
---- Êý¾Ýµ¼³ö£¨Import£©µÄ¹ý³ÌÊÇÊý¾Ýµ¼È루Export£©µÄÄæ¹ý³Ì£¬ËüÃǵÄÊý¾ÝÁ÷Ïò²»Í¬¡£
---- 2. ÔöÁ¿µ¼³ö/µ¼Èë
---- ÔöÁ¿µ¼³öÊÇÒ»ÖÖ³£ÓõÄÊý¾Ý±¸·Ý·½·¨£¬ËüÖ»ÄܶÔÕû¸öÊý¾Ý¿âÀ´ÊµÊ©£¬²¢ÇÒ±ØÐë×÷ΪSYSTEMÀ´µ¼³ö¡£ÔÚ½øÐдËÖÖµ¼³öʱ£¬ÏµÍ³²»ÒªÇó»Ø´ðÈκÎÎÊÌâ¡£µ¼³öÎļþÃûȱʡΪexport.dmp£¬Èç¹û²»Ï£Íû×Ô¼ºµÄÊä³öÎļþ¶¨ÃûΪexport.dmp£¬±ØÐëÔÚÃüÁîÐÐÖÐÖ¸³öÒªÓõÄÎļþÃû¡£
---- ÔöÁ¿µ¼³ö°üÀ¨Èý¸öÀàÐÍ£º
---- £¨1£©“ÍêÈ«”ÔöÁ¿µ¼³ö£¨Complete£©
---- ¼´±¸·ÝÕû¸öÊý¾Ý¿â£¬±ÈÈ磺
---- ¡çexp system/manager inctype=complete file=990702.dmp
---- £¨2£© “ÔöÁ¿ÐÍ”ÔöÁ¿µ¼³ö
---- ±¸·ÝÉÏÒ»´Î±¸·Ýºó¸Ä±äµÄÊý¾Ý¡£±ÈÈ磺
---- ¡çexp system/manager inctype=incremental file=990702.dmp
---- £¨3£© “ÀÛ¼ÆÐÍ”ÔöÁ¿µ¼³ö£¨Cumulative£©
---- ÀÛ¼ÆÐ͵¼³ö·½Ê½Ö»Êǵ¼³ö×ÔÉϴΓÍêÈ«” µ¼³öÖ®ºóÊý¾Ý¿âÖб仯Á˵ÄÐÅÏ¢¡£±ÈÈ磺
---- ¡çexp system/manager inctype=cumul
Ïà¹ØÎĵµ£º
´´½¨ÁÙʱ±í¿Õ¼ä
´´½¨ÁÙʱ±í¿Õ¼ä
CREATE TEMPORARY TABLESPACE test_temp
TEMPFILE 'C:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
´´½¨Óû§±í¿Õ¼ä
´´½¨Óû§±í¿Õ¼ä
CREATE TABLESPACE test_data
LOGGING ......
ÔÚoracleÊý¾Ý¿âÖвåÈëÊý¾Ýʱ£¬ÔËÐвåÈëÓï¾ä£¬ÏÈÊÇ°ÑÊý¾Ý·ÅÈëµ½»º´æÖУ¬ÕâʱÊý¾Ý²¢Ã»ÓÐÕæÕýµÄ½øÈëÊý¾Ý¿â£¬ÕâÊÇoracleÊý¾Ý¿â¸úÆäËüÊý¾Ý¿âÖеIJ»Í¬µã£¬ÕâÊÇÒªÔËÐÐcommitÕâ¸öÊÂÎñÌá½»£¬²ÅÄÜÕæÕýµÄ°ÑÊý¾Ý·Åµ½Êý¾Ý¿âÖС£ ......
INTÀàÐÍÊÇNUMBERÀàÐ͵Ä×ÓÀàÐÍ¡£
ÏÂÃæ¼òҪ˵Ã÷£º
£¨1£©NUMBER£¨P,S£©
¸ÃÊý¾ÝÀàÐÍÓÃÓÚ¶¨ÒåÊý×ÖÀàÐ͵ÄÊý¾Ý£¬ÆäÖÐP±íʾÊý×ÖµÄ×ÜλÊý£¨×î´ó×Ö½Ú¸öÊý£©£¬¶øSÔò±íʾСÊýµãºóÃæµÄλÊý¡£¼ÙÉ趨ÒåSALÁÐΪNUMBER£¨6,2£©ÔòÕûÊý×î´óλÊýΪ4루6-2=4£©£¬¶øСÊý×î´óλÊýΪ2λ¡£
£¨2£©INTÀàÐÍ
µ±¶¨ÒåÕûÊýÀàÐÍʱ£¬¿ÉÒÔÖ±½ÓʹÓÃNU ......
Applies to:
Oracle Server - Enterprise Edition - Version: 10.1.0.5.0
This problem can occur on any platform.
Symptoms:
The issue is that the following error was raised :
ORA-00600: internal error code, arguments: [kesutlGetBindValue-2], [], [], [], [], [], [], []
The recent changes ......
À´×Ôhttp://www.inthirties.com/thread-239-1-1.html
ÔÚÕâÀï»á½éÉÜUNDO£¬REDOÊÇÈçºÎ²úÉúµÄ£¬¶ÔTRANSACTIONSµÄÓ°Ï죬ÒÔ¼°ËûÃÇÖ®¼äÈçºÎÐͬ¹¤×÷µÄ¡£
ʲôÊÇREDO
REDO¼Ç¼transaction logs£¬·ÖΪonlineºÍarchived¡£ÒÔ»Ö¸´ÎªÄ¿µÄ¡£
±ÈÈ磬»úÆ÷Í£µç£¬ÄÇôÔÚÖØÆðÖ®ºóÐèÒªonline redo logsÈ¥»Ö¸´ÏµÍ³µ ......