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

¡¾Ô­´´¡¿oracleµÄ¹éµµÄ£Ê½

Ò»¡£²é¿´oracleÊý¾Ý¿âÊÇ·ñΪ¹éµµÄ£Ê½£º
1.select name,log_mode from v$database;
NAME               LOG_MODE
------------------ ------------------------
QUERY           NOARCHIVELOG
2.ʹÓÃARCHIVE LOG LIST ÃüÁî
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /data/oracle/product/10.2.0/db_1//dbs/arch
Oldest online log sequence     739
Current log sequence           741
¶þ¡£Ê²Ã´ÊÇOracle¹éµµÄ£Ê½£¿
¡¡¡¡OracleÊý¾Ý¿âÓÐÁª»úÖØ×öÈÕÖ¾£¬Õâ¸öÈÕÖ¾ÊǼǼ¶ÔÊý¾Ý¿âËù×öµÄÐ޸쬱ÈÈç²åÈ룬ɾ³ý£¬¸üÐÂÊý¾ÝµÈ£¬¶ÔÕâЩ²Ù×÷¶¼»á¼Ç¼ÔÚÁª»úÖØ×öÈÕÖ¾Àï¡£Ò»°ãÊý¾Ý¿âÖÁÉÙÒªÓÐ2¸öÁª»úÖØ×öÈÕÖ¾×é¡£µ±Ò»¸öÁª»úÖØ×öÈÕÖ¾×鱻дÂúµÄʱºò£¬¾Í»á·¢ÉúÈÕÖ¾Çл»£¬ÕâʱÁª»úÖØ×öÈÕÖ¾×é2³ÉΪµ±Ç°Ê¹ÓõÄÈÕÖ¾£¬µ±Áª»úÖØ×öÈÕÖ¾×é2дÂúµÄʱºò£¬ÓֻᷢÉúÈÕÖ¾Çл»£¬È¥Ð´Áª»úÖØ×öÈÕÖ¾×é1£¬¾ÍÕâÑù·´¸´½øÐС£
¡¡¡¡Èç¹ûÊý¾Ý¿â´¦Óڷǹ鵵ģʽ,Áª»úÈÕÖ¾ÔÚÇл»Ê±¾Í»á¶ªÆú. ¶øÔڹ鵵ģʽÏ£¬µ±·¢ÉúÈÕÖ¾Çл»µÄʱºò£¬±»Çл»µÄÈÕÖ¾»á½øÐй鵵¡£±ÈÈ磬µ±Ç°ÔÚʹÓÃÁª»úÖØ×öÈÕÖ¾1£¬µ±1дÂúµÄʱºò£¬·¢ÉúÈÕÖ¾Çл»£¬¿ªÊ¼Ð´Áª»úÖØ×öÈÕÖ¾2£¬ÕâʱÁª»úÖØ×öÈÕÖ¾1µÄÄÚÈݻᱻ¿½±´µ½ÁíÍâÒ»¸öÖ¸¶¨µÄĿ¼Ï¡£Õâ¸öĿ¼½Ð×ö¹éµµÄ¿Â¼£¬¿½±´µÄÎļþ½Ð¹éµµÖØ×öÈÕÖ¾¡£
¡¡¡¡Êý¾Ý¿âʹÓù鵵·½Ê½ÔËÐÐʱ²Å¿ÉÒÔ½øÐÐÔÖÄÑÐÔ»Ö¸´¡£
1.¹éµµÈÕ־ģʽºÍ·Ç¹éµµÈÕ־ģʽµÄÇø±ð
·Ç¹éµµÄ£Ê½Ö»ÄÜ×öÀ䱸·Ý,²¢ÇÒ»Ö¸´Ê±Ö»ÄÜ×öÍêÈ«±¸·Ý.×î½üÒ»´ÎÍêÈ«±¸·Ýµ½ÏµÍ³³ö´íÆÚ¼äµÄÊý¾Ý²»Äָܻ´.
¹éµµÄ£Ê½¿ÉÒÔ×öÈȱ¸·Ý,²¢ÇÒ¿ÉÒÔ×öÔöÁ¿±¸·Ý,¿ÉÒÔ×ö²¿·Ö»Ö¸´.
ÓÃARCHIVE LOG LIST ¿ÉÒԲ鿴ÆÚģʽ״̬ʱ¹éµµÄ£Ê½»¹ÊǷǹ鵵ģʽ.
Èý¡£ÅäÖÃÊý¾Ý¿âµÄ¹éµµÄ£Ê½
¸Ä±ä·Ç¹éµµÄ£Ê½µ½¹éµµÄ£Ê½:
1)SQL>SHUTDOWN NORMAL/IMMEDIATE;
2)SQL>START MOUNT;
3)SQL>ALTER DATABASE ARCHIVELOG;
4)SQL>ALTER DATABASE OPEN;
5)SQL>×öÒ»´ÎÍêÈ«±


Ïà¹ØÎĵµ£º

oracle rownumÎÊÌâ

½ñÌìͬÊÂÓöµ½ÁËÒ»¸öÎÊÌ⣬ԭÒòÊÇrownumµÄÎÊÌâ¡£
ÏÂÃæ×ªÒ»ÆªÎÄÕ£º
¶ÔÓÚOracleµÄrownumÎÊÌ⣬ºÜ¶à×ÊÁ϶¼Ëµ²»Ö§³Ö>£¬>=£¬=£¬between……and£¬Ö»ÄÜÓÃÒÔÉÏ·ûºÅ£¨<¡¢& lt;=¡¢£¡=£©£¬²¢·Ç˵ÓÃ>£¬>=£¬=£¬between……and ʱ»áÌáʾSQLÓï·¨´íÎ󣬶øÊǾ­³£ÊDz鲻³öÒ»Ìõ¼Ç¼À´£¬»¹»á³öÏÖË ......

ORACLE SQLÓÅ»¯ ORACLEÖ´Ðмƻ®

Last login: Mon Feb  8 14:13:19 2010 from 192.168.1.249
ipnet
-bash-3.00$
-bash-3.00$ ipnet
-bash: ipnet: command not found
-bash-3.00$ su - oracle
Password:
eastcsu: incorrect password
-bash-3.00$ eastcom
-bash: eastcom: command not found
-bash-3.00$ su - oracle
Password:
[oracl ......

ÅöÉÏoracle×Ö·û¼¯ÎÊÌâ

ǰ̨UI½ø³Ì£¨VC6±àд£©½«UTF-8ÖÐÎÄ·¢¸øºǫ́·þÎñ³ÌÐò£¨Linux GCC£©£¬ºǫ́ÔÙдÈëoracleÊý¾Ý¿â£¬È»ºóǰ̨ÔÙͨ¹ýºǫ́½«Êý¾ÝÈ¡³ö£¬²¢ÏÔʾ£»ºǫ́ûÓÐ×ö±à½âÂëת»»£¬Ç°Ì¨ÔòÔÚVCĬÈϵÄGBKÓëUTF-8Ö®¼ä×÷ת»»¡£
¿ªÊ¼Ê±ÏµÍ³³öÏÖÂÒÂ룬ºóÀ´Í¨¹ýÉèÖÃLinuxÒ»¸ö»·¾³±äÁ¿¡¢ÖØÆôºǫ́½ø³ÌÎÊÌâ½â¾ö£¨ÎÊÌâÊÇÔø¾­³¢ÊÔ¹ý¸ü¸Ä¸Ã»·¾³±äÁ¿£¬µ«ÂÒÂëÒÀ ......

oracle 10g °²×°¹ý³Ì

ÔڵǼemµÄʱºò¡£
²é¿´Ò»Ï emctl status dbconsole
ÕÒµ½urlµØÖ·
ÔÚÆô¶¯ºÍ¹Ø±ÕÊý¾Ý¿âµÄʱºò³öÏÖ
oracle 10g remoteoperationexception error wrong password for user
¿ÉÒÔÔÚ
×é²ßÂÔ -- >±¾µØ²ßÂÔ -->Óû§È¨ÀûÖ¸. -- >×÷ΪÅú´¦Àí×÷ÒµµÇ¼ÖмÓÈëÕâ¸öÓû§
¼´¿É. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ