Oracle命令1

 Oracle命令全集
第一章：日志管理
第二章：表空间管理
第三章：表
第四章：索引
第五章：约束
第六章：LOAD数据
第七章：reorganizing data
第八章： managing password security and resources
第九章：Managing users
第十章：managing privileges
第十一章： manager role
第十二章: BACKUP and RECOVERY
Oracle命令全集
第一章：日志管理
1.forcing log switches
    sql> alter system switch logfile;
    2.forcing checkpoints
    sql> alter system checkpoint;
    3.adding online redo log groups
    sql> alter database add logfile [group 4]
    sql> ('/disk3/log4a.rdo','/disk4/log4b.rdo') size 1m;
    4.adding online redo log members
    sql> alter database add logfile member
    sql> '/disk3/log1b.rdo' to group 1,
    sql> '/disk4/log2b.rdo' to group 2;
    5.changes the name of the online redo logfile
    sql> alter database rename file 'c:/oracle/oradata/oradb/redo01.log'
    sql> to 'c:/oracle/oradata/redo01.log';
    6.drop online redo log groups
    sql> alter database drop logfile group 3;
    7.drop online redo log members
    sql> alter database drop logfile member 'c:/oracle/oradata/redo01.log';
    8.clearing online redo log files
    sql> alter database clear [unarchived] logfile 'c:/oracle/log2a.rdo';
    9.using logminer analyzing redo logfiles
    a. in the init.ora specify utl_file_dir = ' '
    b. sql> execute dbms_logmnr_d.build('oradb.ora','c:oracleoradblog');
    c. sql> execute dbms_logmnr_add_logfile('c:oracleoradataoradbredo01.log',
    sql> dbms_logmnr.new);
    d. sql> execute dbms_logmnr.add_logfile('c:oracleoradataoradbredo02.log',
    sql> dbms_logmnr.addfile);
    e. sql> execute dbms_logmnr.start_