OracleÖØ×öÈÕÖ¾Îļþ³£ÓòÙ×÷
Ç¿ÖÆÇл»ÖØ×öÈÕÖ¾
ALTER SYSTEM SWITCH LOGFILE; Ç¿ÖƲúÉú¼ì²éµã
ALTER SYSTEM CHECKPOINT; ¼ä½Ó²úÉú¼ì²éµã(É趨ʵÀý»Ö¸´Ê±¼ä²»³¬¹ýmmÃë,Ò༴ִÐмì²éµãÖ®ºóÔËÐг¬¹ýÕâ¸öʱ¼ä¾ÍÔÙ´ÎÖ´Ðмì²éµã)
ALTER SYSTEM SET FAST_START_MTTR_TARGET = ÃëÊý; »ñÈ¡ÖØ×öÈÕÖ¾ÎļþÐÅÏ¢
SELECT group#, sequence#, members, bytes, status, archived from v$log;
ÅäºÏ
SELECT * from v$logfile; Ìí¼ÓÖØ×öÈÕÖ¾×é
ALTER DATABASE ADD LOGFILE GROUP 5 ('a:\nihao.log', 'b:\zaijian.log') SIZE 20M;
ÆäÖÐGROUP¶Î¿ÉÒÔûÓÐ,еÄ×éºÅ×Ô¶¯²úÉú,¼´µ±Ç°×î´ó×éºÅ+1 ɾ³ýÖØ×öÈÕÖ¾×é
ALTER DATABASE DROP LOGFILE GROUP 5;
×¢Òâ: µ±Ç°ÖØ×öÈÕÖ¾×é²»¿Éɾ³ý,±¾É¾³ý²¢Î´ÕæÕýµÄɾ³ýÓ²ÅÌÉϵÄÎļþ. Ìí¼ÓÖØ×öÈÕÖ¾³ÉÔ±
ALTER DATABASE ADD LOGFILE MEMBER 'a:\nihao.log' TO GROUP 5, 'b:\zaijian.log' TO GROUP 6; ɾ³ýÖØ×öÈÕÖ¾³ÉÔ±
ALTER DATABASE DROP LOGFILE MEMBER 'a:\nihao.log', 'b:\zaijian.log';
×¢Òâ:²»ÄÜɾ³ýµ±Ç°ÈÕÖ¾×éºÍINVALID״̬µÄ³ÉÔ±. ÿ¸öÖØ×öÈÕÖ¾×éµÄ×îºóÒ»¸öÓÐЧ³ÉÔ±²»Äܱ»É¾³ý,¹éµµÄ£Ê½ÏÂδ¹éµµÍêµÄ³ÉÔ±Ò²²»ÄÜɾ³ý. ±¾É¾³ý²¢Î´ÕæÕýµÄɾ³ýÓ²ÅÌÉϵÄÎļþ Çå³ýÖØ×öÈÕÖ¾×é.(É÷ÓÃ)
ALTER DATABASE CLEAR LOGFILE GROUP 5
»ò Çå³ý±ÀÀ£²»Äܹ鵵µÄÎļþ
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 5
Ö´Ðб¾ÃüÁîÇ°ºóÓ¦×öÊý¾Ý¿âÈ«±¸·Ý.ÒòΪִÐкóÖØ×öÈÕÖ¾Îļþ±àºÅ½«»á¶Ìʱ¼ä²»Á¬¹á,Òò¶ø²»ÄÜÖ´Ðлָ´.ÒÔÇ°µÄ±¸·ÝÒ²²»ÔÙ¿ÉÓÃ. ±¾É¾³ý²¢Î´ÕæÕýµÄɾ³ýÓ²ÅÌÉϵÄÎļþ ʹÓÃOMF(Oracle×Ô¶¯Îļþ¹Ü¿Ø)¹ÜÀíÁª»úÖØ×öÈÕÖ¾Îļþ
a.)Ê×ÏÈÉ趨ÈÕÖ¾ÎļþÄ¿µÄµØĿ¼,×î¶à¿ÉÒÔÓÐ5¸ö
ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_1 = 'a:\';
ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_2 = 'b:\';
b.)Ìí¼ÓÒ»×éÖØ×öÈÕÖ¾
ALTER DATABASE ADD LOGFILE;
Á½¸öÎļþ·Ö±ð×Ô¶¯Ìí¼Óµ½Ö¸¶¨Ä¿Â¼. Oracle»á×Ô¶¯Éú³Éϼ¶Ä¿Â¼ºÍÎļþÃû
c.)ɾ³ýÒ»×éÖØ×öÈÕÖ¾
ALTER DATABASE DROP LOGFILE GROUP 5;
½û¼ÉͬÉÏ. Or
Ïà¹ØÎĵµ£º
Oracle 9i±È8i¶àÁËÄÄЩÐÂÌØÐÔ£¿
¼òҪ˵£º
9i¸üÒ×ÓÚ¹ÜÀí¡£
Ïêϸ˵£º
²¢·¢¼¯Èº£¬8i OPSÉý¼¶Îª9i RAC£¬8i½áµã¼äÓÃÓ²Å̽»»»ÐÅÏ¢£¬9i½áµã¼ä²ÉÓøßËÙÍøÏߵĻº´æÈÛºÏ(Cache Fusion)¼¼Êõ½»»»ÐÅÏ¢£¬½»»»ËÙ¶ÈÌá¸ß100±¶ÒÔÉÏ¡£
9i¿ÉÒÔÔÚÏßÐÞ¸ÄÄں˲ÎÊýºÍÄÚ´æ·ÖÅä£ ......
£¨1£©ÒÔSYSÉí·ÝµÇ½
conn sys/sysem_pwd as sysdba;
£¨2£©´´½¨amlyÓû§
create user amly identified by 9imly;
£¨3£©´´½¨±í¿Õ¼ä
create tablespace ts_amly datafile 'd:\amlyfile\test.dbf' size 100M;
£¨4£©½«±í¿Õ¼ä·ÖÅä¸øÓû§
alter user amly default tablespace ts_amly;
£¨5£©¸øÓû§ÊÚȨ
grant create sess ......
¸Ãº¯ÊýÓÃÀ´·µ»ØÒ»¸öËÄÉáÎåÈëºóµÄÖµ
SELECT ROUND( number, [ decimalplaces ] ) from DUAL
參數:
±ØÌîÏnumber : Òª´¦ÀíµÄÊýÖµ(ÊýÖµ±í´ïʽ)
¿ÉÑ¡Ïdecimalplaces : ËÄÉáÎåÈëʱȡµÄСÊýµÄλÊý£¬²»ÌîÔò·µ»ØÕûÊý
Sample :
select round(123.456) from dual;& ......
1.OSÈÏÖ¤
Oracle°²×°Ö®ºóĬÈÏÇé¿öÏÂÊÇÆôÓÃÁËOSÈÏÖ¤µÄ£¬ÕâÀïÌáµ½µÄosÈÏÖ¤ÊÇÖ¸·þÎñÆ÷¶ËosÈÏÖ¤¡£OSÈÏÖ¤µÄÒâ˼°ÑµÇ¼Êý¾Ý¿âµÄÓû§ºÍ¿ÚÁîУÑé·ÅÔÚÁ˲Ù×÷ϵͳһ¼¶¡£Èç¹ûÒÔ°²×°OracleʱµÄÓû§µÇ¼OS£¬ÄÇô´ËʱÔڵǼOracleÊý¾Ý¿âʱ²»ÐèÒªÈκÎÑéÖ¤£¬È磺
SQL> connect /as sysdba
ÒÑÁ¬½Ó¡£
SQL> connect sys/aaa@te ......
OracleÖÐstart with...connect by prior×Ó¾äÓ÷¨
connect by Êǽṹ»¯²éѯÖÐÓõ½µÄ£¬Æä»ù±¾Óï·¨ÊÇ£º
select ... from tablename start with Ìõ¼þ1
connect by Ìõ¼þ2
where Ìõ¼þ3;
Àý£º
select * from table
start with org_id = 'HBHqfWGWPy'
connect by prior org_id = parent_id;
¼òµ ......