ORACLE 经常使用的命令工具-第一章:日志管理

0~3Fr2[gp5~0第一章:日志管理51Testing软件测试网 G
NC U[~1k{A`

　　1.forcing log switches

　　sql> alter system switch logfile;51Testing软件测试网"{+c"v;gQ@

　　2.forcing checkpoints

　　sql> alter system checkpoint;51Testing软件测试网W!R:q3XFV!yv

　　3.adding online redo log groups

　　sql> alter database add logfile [group 4]51Testing软件测试网 TcE6E ^b G

6KH]beK.u x:e"u0　　sql> ('/disk3/log4a.rdo','/disk4/log4b.rdo') size 1m;51Testing软件测试网!tL7R8Au
m

　　4.adding online redo log members

RQ.mk,gl0　　sql> alter database add logfile member

　　sql> '/disk3/log1b.rdo' to group 1,51Testing软件测试网/Ul0\2F3\&L

　　sql> '/disk4/log2b.rdo' to group 2;51Testing软件测试网'R(Y9HKRB

R+_'usx f1Pt0　　5.changes the name of the online redo logfile

_:t0hw~ n-G9y0　　sql> alter database rename file 'c:/oracle/oradata/oradb/redo01.log'51Testing软件测试网 ^v*lE0jE%y0pI

&eq#yF*];gGj3]0　　sql> to 'c:/oracle/oradata/redo01.log';51Testing软件测试网,Bwe E0E h2m

PAK6g0N@0　　6.drop online redo log groups

[DCO~N0　　sql> alter database drop logfile group 3;51Testing软件测试网P|F%q0M'y+g

HpB0H R7i.v0　　7.drop online redo log members51Testing软件测试网P/m#k-G2c&s+jO

　　sql> alter database drop logfile member 'c:/oracle/oradata/redo01.log';51Testing软件测试网-Z j#ZXJ av

　　8.clearing online redo log files

　　sql> alter database clear [unarchived] logfile 'c:/oracle/log2a.rdo';51Testing软件测试网%]2K*VSb2ow

　　9.using logminer analyzing redo logfiles51Testing软件测试网 hMK F5[a

　　a. in the init.ora specify utl_file_dir = ' '51Testing软件测试网)FD)[v jd O]%O

　　b. sql> execute dbms_logmnr_d.build('oradb.ora','c:\oracle\oradb\log');51Testing软件测试网M6h,z3_4y!^eC

c R}f7?-Sr0　　c. sql> execute dbms_logmnr_add_logfile('c:\oracle\oradata\oradb\redo01.log',51Testing软件测试网
E'bBd,r"q'U7n

.GhKWd3Vz0　　sql> dbms_logmnr.new);51Testing软件测试网 G0W6h6f:K3M9SbgZ-V

　　d. sql> execute dbms_logmnr.add_logfile('c:\oracle\oradata\oradb\redo02.log',

　　sql> dbms_logmnr.addfile);51Testing软件测试网^s,@&l0jO.P!N

　　e. sql> execute dbms_logmnr.start_logmnr(dictfilename=>'c:\oracle\oradb\log\oradb.ora');51Testing软件测试网]nF9D1BIY2p5t"[

"[jwO zI3P1n.I0Re[Vn0　　f. sql> select * from v$logmnr_contents(v$logmnr_dictionary,v$logmnr_parameters51Testing软件测试网'mW5j;h A^r4D
f5}G

　　sql> v$logmnr_logs);51Testing软件测试网'mpz}p,q};^8@
tX C:E

A[8Y?p@0x8Ud0　　g. sql> execute dbms_logmnr.end_logmnr;51Testing软件测试网5O0M`)ot(d