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

Oracle¹éµµÃüÁî£¨×ªÔØ£©

Ê×ÏȲ鿴Êý¾Ý¿âÏÖÓÐģʽ¿ÉʹÓÃÒÔÏÂÓï¾ä
select name,log_mode from v$database;
Ò²¿ÉÒÔÓÃÏÂÃæµÄÓï¾ä
archive log list£»(¸Ã·½·¨ÐèÒªas sysdba)
¶ÔÓڷǹ鵵ģʽµÄÊý¾Ý¿â¸ÃΪ¹éµµÄ£Ê½£¨Ö÷ÒªÒÔOracle 10gΪ²Î¿¼£©Ê¹ÓÃÒÔϲ½Ö裺
1. SQL> alter system set log_archive_dest_1='location=/oracle/oracle10g/log/archive_log';
¸ÃÓï¾äº¬ÒåÊÇÈ·¶¨¹éµµÈÕÖ¾µÄ·¾¶£¬Êµ¼ÊÉÏOracle 10g¿ÉÒÔÉú³É¶à·ÝÒ»ÑùµÄÈÕÖ¾£¬±£´æ¶à¸öλÖã¬ÒÔ·À²»²â
ÀýÈçÔÙÌí¼ÓÒ»¸öÈÕ־λÖÿÉʹÓÃÒÔÏÂÓï¾ä
SQL>alter system set log_archive_dest_2='location=/oracle/oracle10g/log2/archive_log';
²é¿´¹éµµÈÕÖ¾µÄ·¾¶
SQL>show parameter db_recovery_file_dest
»òÕß
SQL>archive log list;
2.¹Ø±ÕÊý¾Ý¿â
SQL> shutdown immediate
3.Æô¶¯Êý¾Ýmount״̬£º
SQL> startup mount;
4¡¢ÐÞ¸ÄÊý¾Ý¿âΪ¹éµµÄ£Ê½£º
SQL> alter database archivelog;
5¡¢´ò¿ªÊý¾Ý¿â£¬²éѯ£º
SQL> alter database open;
ÐÞ¸ÄÈÕÖ¾ÎļþÃüÃû¸ñʽ£º
SQL> alter system set log_archive_max_processes = 5;
SQL> alter system set log_archive_format = "archive_%t_%s_%r.log" scope=spfile;


Ïà¹ØÎĵµ£º

oracle Êý¾Ý¿â¸Äoracle_sidµÄ²Ù×÷·½·¨

ÐÞ ¸Ä SID
°¸Àý: ¾ÉÊý¾Ý¿â(OLDDB)
        Îļþ´æ·Å(data files,redo files,control files,temp files, undo files)Ŀ¼ÊÇ
(/u01/OLDDB)
dumpÎļþĿ¼ÊÇ(/u01/dump)
       ÐÂÊý¾Ý¿â(NEWDB)
   ......

Oracle¼Ü¹¹ÈëÃż¶»ù´¡

ת×Ô£ºhttp://hong9270503.blog.163.com/blog/static/1272923200916112245844/
ѧϰoracle,×îºÃÊ×ÏÈÁ˽âOracleµÄ¿ò¼Ü¡£ÕâÑù¶ÔOracleÓÐÒ»¸öÕûÌåµÄÈÏʶ£¬ÓиßÎݽ¨ê²µÄ×÷Óá£
1¡¢ÎïÀí½á¹¹£¨ÓÉ
¿ØÖÆÎļþ¡¢Êý¾ÝÎļþ¡¢ÖØ×öÈÕÖ¾Îļþ¡¢²ÎÊýÎļþ¡¢¹éµµÎļþ¡¢¿ÚÁîÎļþ×é³É£©

¡¡¡¡
Ò»¸öÊý¾Ý¿âÖеÄÊý¾Ý´æ´¢ÔÚ´ÅÅÌÉÏÎïÀíÎļþ£¬ ......

ORACLE¸´Ï°(Ò»)

ºÜ¾ÃûÓÐÓõ½OracleÁË£¬Ç°Ð©ÈÕ×Óµ¥Î»½ÓÁËÒ»¸öOracleÊý¾Ý¿âµÄÏîÄ¿£¬×ÔÈ»ÐèÒª¸´Ï°Ò»Ï£¬ÏÖ½«¸´Ï°¹ý³ÌÖеÄһЩҪµã¼Ç¼ÏÂÀ´£¬ÒÔ±¸²éÔÄ¡£
Ò»¡¢     ±íÁÐÊý¾ÝÀàÐÍ
1¡¢×Ö·û
1)        VARCHAR2(n)£¬nÊDZØÐëµÄ£¬ÓÃÓÚ´æ´¢×Ϊ4000¸ö×Ö·ûµÄ×Ö·û´®¡£µ«ËüÊǿɱäµÄ£¬Ö»Ê¹Ó ......

»ùÓÚ OCI ʵÏÖµÄ oracle ×î¸ßЧdump³ÌÐò

»ùÓÚOCI ʵÏֵĠ×î¸ßЧdump³ÌÐò£¬ ±ÈOTL ÒÔ¼°ÆäËûµÄ½Ó¿Ú¶¼¿ìºÜ¶à
ÄÜÖ´ÐÐÈκÎsql , ×Ô¶¯Ê¶±ð×Ö¶ÎÃûºÍ×Ö¶ÎÀàÐÍ£¬½øÐÐÊä³öÊä³ö
/*
* oracle_dump.cpp
*
* Created on: 2010-2-1
* Author: clm971910@gmail.com
*
* ѹËõ
* 4216351 dump done
* ÍêÕû 106 Ãë
* д·Ö¸ô·û 8Ãë
* ѹËõд´Å ......

ÈçºÎÊÖ¹¤´´½¨OracleÊý¾Ý¿â

ÈçºÎÊÖ¹¤´´½¨OracleÊý¾Ý¿â
http://www.cnhacker.com/Security/System/200808/t20080818_6325.html
½ñÌ죬ÎÒÔÚ²âÊÔ»úÆ÷ÉÏÀ´Á˸öÎó²Ù×÷rm * backup/*,°ÑÕýÔÚÔËÐеÄÊý¾Ý¿âÖеÄÊý¾ÝÎļþÈ«²¿É¾³ýÁË£¬ÕæÊÇÓôÃÆ!»¹ºÃÕâ¸öÊǸøÎÒÃÇÐÂÈËÃDzâÊÔÍæµÄ£¬Òª²»È»¾ÍËÀ¶¨ÁË!ÔÚ´ËÒ²×öÒ»¸öÌáÐÑ£¬ÉíΪDBA£¬ÒªÓÀÔ¶¼ÇסʲôÉ÷ÓûòÕß½ûֹʹÓÃrmÃüÁ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ