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

oracle ÈçºÎ°ÑÊý¾Ý¿â±äΪ·Ç¹éµµÈÕ־ģʽ

shutdown immediate
Ç¿Áв»½¨ÒéתΪ·Ç¹éµµÄ£Ê½
startup mount
alter database noarchivelog
alter database open
·Ç¹éµµ×ª¹éµµ
startup mount
alter database archivelog
alter database open
Ôڹ鵵ÈÕ־ģʽÏ£¬ÓпÉÄÜ»áÓöµ½¹éµµÈÕÖ¾´óС³¬¹ý×î´óÖµ¶ø³öÏÖÌÖÑáµÄORA-00257´íÎó£¬Ç°ÃæËµÁËÈçºÎ°Ñ¹éµµÈÕÖ¾¿Õ¼ä±ä´ó¡£¶øÔÚÆÕͨµÄ¿ª·¢»·¾³Ï£¬ÆäʵÊǸù±¾Óò»×Ź鵵ÈÕÖ¾µÄ£¬Éè¸öʱºòÎÒÃǾͰÑÊý¾Ý¿âµÄ¹éµµÈÕÖ¾¸ø½ûÓÃÁË£¬Ò²¾ÍÊÇ˵°ÑÊý¾Ý¿â±äΪ·Ç¹éµµÈÕ־ģʽ£¬Ó¦¸ÃÔõô×öÄØ¡£
ÔÚÕâÀïËùÓеIJÙ×÷ÒªÔÚÊý¾Ý¿âµÄÄÇ̨»úÆ÷ÉϲÙ×÷£¬ÓÃSYSÓû§½øÐеǼ£¬Ê×ÏÈÉèÖù鵵½ø³Ì¹Ø±Õ¡£
¡¡¡¡alter system set log_archive_start=false scope=spfile;
È»ºó¹Ø±ÕÊý¾Ý¿â
¡¡¡¡shutdown immediate
ÔÙºóÃæ°ÑÊý¾Ý¿âÆô¶¯µ½mountµÄģʽ
startup mount
¹Ø±ÕflashÉÁ»ØÊý¾Ý¿âģʽ£¬Èç¹û²»¹Ø±ÕµÄ»°£¬ÔÚºóÃæ¹Ø±Õ¹éµµÈÕÖ¾µÄʱºò¾Í»á³öÏÖÌÖÑáµÄORA-38774´íÎó¡£
¡¡¡¡alter database flashback off
½Ó×ŰÑÊý¾Ý¿â¸ÄΪ·Ç¹éµµÄ£Ê½
¡¡¡¡alter database noarchivelog;
¶¼Ð޸ĺÃÁËÒÔºó£¬È»ºó´ò¿ªÊý¾Ý¿â
¡¡¡¡Alter database open;
²ì¿´Ò»Ï¹鵵ÈÕÖ¾µÄ¿Õ¼ä´óС
¡¡¡¡select * from v$recovery_file_dest;
½Ó×Å¿´Ò»ÏÂlogÈÕÖ¾µÄ״̬
¡¡¡¡select * from v$log;
ÔÙ¿´Ò»ÏÂÉÁ»ØÈÕ־ʹÓÃ×´¿ö
¡¡¡¡select * from v$flash_recovery_area_usage;
ÕâЩ¶¼Ã»ÓÐÎÊÌâÒÔºó£¬Êý¾Ý¿âÎÊÌâ¾Í½â¾öÁË¡£


Ïà¹ØÎĵµ£º

oracle ±íÖвåÈë¶àÐÐ

·½·¨Ò»£º
SQL>create table aa(a number);
´´½¨³É¹¦¡£
SQL> select * from aa;
A
--------
2
SQL>
SQL> insert all
2 into aa values(1)
3 into aa values(2)
4 select * from dual;
ÒÑ´´½¨2ÐС£
SQL> commit;
Ìá½»Íê³É¡£
SQL> select * from aa;
A
----------
2
1
2
·½·¨¶þ£º
S ......

oracle ¼Ç¼ºÏ²¢

ÔÚÒ»¸ö±íÖУ¬ÆäÖм¸¸ö×ֶεÄÖµÊÇÒ»ÑùµÄ£¬°´ÕÕÕ⼸¸ö×ֶνøÐзÖ×é²¢ºÏ²¢Êý¾Ý¡£
±íA     id     name         role
          1     ÕÅÈý    &nb ......

oracleÌåϵ½á¹¹Ò»

        oracleÊÇÒ»ÖÖ´óÐ͵ġ¢¿ÉÒÆÖ²µÄ¶ÔÏó¹ØÏµÐÍÊý¾Ý¿â¡£ËüÔÚÏà¹ØµÄÿһ¸öƽ̨É϶¼¿ÉÒÔÔËÐУ¬Òò´ËoracleµÄÌåϵ½á¹¹ÔÚ²»Í¬µÄ²Ù×÷ϵͳÉÏÊÇÓÐËù²»Í¬µÄ¡£±ÈÈçÔÚUNIXϵͳÉÏ£¬ÒòΪUNIXϵͳÊǹ¤×÷ÔÚ¶à½ø³ÌµÄ»ù´¡ÉÏ£¬ËùÒÔoracleÔËÐÐʱÌåÏÖΪ¶à¸ö½ø³ÌÔÚÔËÐС£È»¶øÔÚwindowsϵͳÉÏ£¬windowsÏµÍ³Ê ......

OracleÊý¾Ý¿âÖмǼ±»ÁíÒ»¸öÓû§Ëø×¡

oracleÊý¾Ý¿âÖÐÐÞ¸ÄÊý¾ÝʱÌáʾ“¼Ç¼±»ÁíÒ»¸öÓû§Ëø×¡” ½â¾ö·½·¨£º
1>²é¿´Êý¾Ý¿âËø,Õï¶ÏËøµÄÀ´Ô´¼°ÀàÐÍ£º
¡¡¡¡select object_id,session_id,locked_mode from v$locked_object;
      »òÕßÓÃÒÔÏÂÃüÁ
      select b.owner,b.object_name,l.ses ......

ORACLE ´´½¨Êý¾Ý¿âÁ¬½ÓDBLink

CREATE PUBLIC DATABASE LINK ASXT_LINK ;
CONNECT TO ASXT IDENTIFIED BY PASSWORD ;
USING '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.0.100)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = AAA)))'; ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ