ORACLE 经常使用的命令.docx

《ORACLE 经常使用的命令.docx》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、Oracle的常用命令详解  第一章:日志管理1.forcinglogswitches   sql>altersystemswitchlogfile;2.forcingcheckpoints   sql>altersystemcheckpoint;3.addingonlineredologgroups   sql>alterdatabaseaddlogfile[group4]   sql>('/disk3/log4a.rdo','/disk4/log4b.rdo')size1m;4.addingonlineredologmembers   sql>alterdatabaseaddlogfi

2、lemember   sql>'/disk3/log1b.rdo'togroup1,   sql>'/disk4/log2b.rdo'togroup2;5.changesthenameoftheonlineredologfile   sql>alterdatabaserenamefile'c:/oracle/oradata/oradb/redo01.log'   sql>to'c:/oracle/oradata/redo01.log';41/416.droponlineredologgroups   sql>alterdatabasedroplogfilegroup3;7.droponli

3、neredologmembers   sql>alterdatabasedroplogfilemember'c:/oracle/oradata/redo01.log';8.clearingonlineredologfiles   sql>alterdatabaseclear[unarchived]logfile'c:/oracle/log2a.rdo';9.usinglogmineranalyzingredologfilesa.intheinit.oraspecifyutl_file_dir=''b.    sql>executedbms_logmnr_d.build('oradb.ora

4、','c:oracleoradblog');c.    sql>executedbms_logmnr_add_logfile('c:oracleoradataoradbredo01.log',      sql>dbms_logmnr.new);d.    sql>executedbms_logmnr.add_logfile('c:oracleoradataoradbredo02.log',41/41      sql>dbms_logmnr.addfile);e.    sql>executedbms_logmnr.start_logmnr(dictfilename

5、=>'c:oracleoradblogoradb.ora');f.    sql>select*fromv$logmnr_contents(v$logmnr_dictionary,v$logmnr_parameters      sql>v$logmnr_logs);g.    sql>executedbms_logmnr.end_logmnr;第二章:表空间管理1.createtablespaces   sql>createtablespacetablespace_namedatafile'c:oracleoradatafile1.dbf'size100m,   sql>'

6、c:oracleoradatafile2.dbf'size100mminimumextent550k[logging/nologging]   sql>defaultstorage(initial500knext500kmaxextents500pctinccease0)   sql>[online/offline][permanent/temporary][extent_management_clause]41/412.locallymanagedtablespace   sql>createtablespaceuser_datadatafile'c:oracleoradata

7、user_data01.dbf'   sql>size500mextentmanagementlocaluniformsize10m;3.temporarytablespace   sql>createtemporarytablespacetemptempfile'c:oracleoradatatemp01.dbf'   sql>size500mextentmanagementlocaluniformsize10