oracle里的常用命令

《oracle里的常用命令》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、oracle里的常用命令第一部分第一章：日志管理1.forcinglogswitchessql>altersystemswitchlogfile;2.forcingcheckpointssql>altersystemcheckpoint;3.addingonlineredologgroupssql>alterdatabaseaddlogfile[group4]sql>('/disk3/log4a.rdo','/disk4/log4b.rdo')size1m;4.addingonlineredologmemberssql>alterdatabasead

2、dlogfilemembersql>'/disk3/log1b.rdo'togroup1,sql>'/disk4/log2b.rdo'togroup2;5.changesthenameoftheonlineredologfilesql>alterdatabaserenamefile'c:/oracle/oradata/oradb/redo01.log'sql>to'c:/oracle/oradata/redo01.log';6.droponlineredologgroupssql>alterdatabasedroplogfilegroup3;7.dr

3、oponlineredologmemberssql>alterdatabasedroplogfilemember'c:/oracle/oradata/redo01.log';8.clearingonlineredologfilessql>alterdatabaseclear[unarchived]logfile'c:/oracle/log2a.rdo';9.usinglogmineranalyzingredologfilesa.intheinit.oraspecifyutl_file_dir=''b.sql>executedbms_logmnr_d.

4、build('oradb.ora','c:oracleoradblog');c.sql>executedbms_logmnr_add_logfile('c:oracleoradataoradbredo01.log',sql>dbms_logmnr.new);d.sql>executedbms_logmnr.add_logfile('c:oracleoradataoradbredo02.log',sql>dbms_logmnr.addfile);e.sql>executedbms_logmnr.start_logmnr(dictf

5、ilename=>'c:oracleoradblogoradb.ora');f.sql>select*fromv$logmnr_contents(v$logmnr_dictionary,v$logmnr_parametersoracle里的常用命令第一部分第一章：日志管理1.forcinglogswitchessql>altersystemswitchlogfile;2.forcingcheckpointssql>altersystemcheckpoint;3.addingonlineredologgroupssql>alterdatabas

6、eaddlogfile[group4]sql>('/disk3/log4a.rdo','/disk4/log4b.rdo')size1m;4.addingonlineredologmemberssql>alterdatabaseaddlogfilemembersql>'/disk3/log1b.rdo'togroup1,sql>'/disk4/log2b.rdo'togroup2;5.changesthenameoftheonlineredologfilesql>alterdatabaserenamefile'c:/oracle/oradata/or

7、adb/redo01.log'sql>to'c:/oracle/oradata/redo01.log';6.droponlineredologgroupssql>alterdatabasedroplogfilegroup3;7.droponlineredologmemberssql>alterdatabasedroplogfilemember'c:/oracle/oradata/redo01.log';8.clearingonlineredologfilessql>alterdatabaseclear[unarchived]logfile'c:/or

8、acle/log2a.rdo';9.usinglogmineranalyzingredologfilesa.