用sys用户进入oracle
archive log list 归档模式的设置查看
数据库日志模式 非存档模式
自动存档 禁用
存档终点 D:\oracle\ora92\RDBMS
最早的概要日志序列 10
当前日志序列 12
1.shutdown immediate 关闭例程
2.startup pfile=D:\oracle\admin\fishlu\pfile\init.ora mount; 启动例程
3.alter database archivelog or alter database noarchivelog 归档模式和非归档模式的切换
4.alter database open 打开数据库
5.archive log start 自动归档模式
6.archive log stop 关闭自动归档模式
next
all
exec dbms_logmnr_d.build(dictionary_filename=>'dict.ora', dictionary_location=>'D:\oracle\'); --创建数据字典
exec dbms_logmnr.add_logfile(logfilename => 'D:\ORACLE\ORADATA\FISHLU\REDO01.LOG',options => dbms_logmnr.new); --创建日志文件
exec dbms_logmnr.add_logfile(logfilename => 'D:\ORACLE\ORADATA\FISHLU\REDO02.LOG',options => dbms_logmnr.addfile);--加载日志文件
exec dbms_logmnr.add_logfile(logfilename => 'D:\ORACLE\ORADATA\FISHLU\REDO03.LOG',options => dbms_logmnr.addfile);--加载日志文件
exec dbms_logmnr.start_logmnr(dictfilename=>'D:\oracle\dict\dict.ora',starttime=>to_date('2006-01-18 13:00:00','YYYY-MM-DD HH24:MI:SS'),endtime=>to_date('2006-01-18 14:10:00','YYYY-MM-DD HH24:MI:SS'));--设置时间段
select sql_redo,sql_undo from v$logmnr_contents where username = 'FISHLU';--查看日志数据
问题
1.增加日志文件
show parameter fast;
show parameter log_checkpoint;
alter system switch logfile;
alter system checkpoint;
加载组和加载组文件
alter database add logfile group 5 ('D:\oracle\oradata\fishlu\REDO04a.ora','D:\oracle\oradata\fishlu\REDO04b.ora') size 10m;
加载组文件
alter database add logfile member 'D:\oracle\oradata\fishlu\REDO04c.ora' to group 5;
删除日记文件组
alter datebase drop logfile group 5
删除组文件
alter database drop logfile member 'D:\ORACLE\ORADATA\FISHLU\REDO05B.ORA';
清空日记组
alter database clear unarchived logfile group 1;
alter database clear logfile group 3;
alter database add logfile group 4 ('D:\oracle\oradata\fishlu\REDO05a.ora','D:\oracle\oradata\fishlu\REDO05b.ora') size 10m;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/109975/viewspace-604092/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/109975/viewspace-604092/