小弟求RMAN备份的完整步骤和LOGMINER的完整步骤,最好详细些,不要链接,谢谢了,分不够再加 RT 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 我自己测试的logminer:SQL> @$ORACLE_HOME/rdbms/admin/dbmslm.sql;Package created.Grant succeeded.SQL> @$ORACLE_HOME/rdbms/admin/dbmslmd.sql;Package created.SQL> alter system set utl_file_dir = '/export/home/oracle/oradata/orcl/logs' scope = spfile;System altered.SQL> shutdown;Database closed.Database dismounted.ORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area 629145600 bytesFixed Size 1281792 bytesVariable Size 490733824 bytesDatabase Buffers 134217728 bytesRedo Buffers 2912256 bytesDatabase mounted.Database opened.SQL> startup;....SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIV STATUS FIRST_CHANGE# FIRST_TIME---------- ---------- ---------- ---------- ---------- ------ -------------------------------- ------------- ------------ 1 1 938 52428800 1 NO INACTIVE 17445492 30-NOV-08 2 1 939 52428800 1 NO INACTIVE 17494420 01-DEC-08 3 1 940 52428800 1 NO CURRENT 17508573 01-DEC-08SQL> exec dbms_logmnr.add_logfile('/export/home/oracle/oradata/orcl/redo03.log', dbms_logmnr.new);PL/SQL procedure successfully completed.SQL> exec dbms_logmnr.start_logmnr(DictFileName=>'/export/home/oracle/oradata/orcl/logs/testlogmnr.ora');PL/SQL procedure successfully completed.SQL> select count(*) from V$LOGMNR_CONTENTS; COUNT(*)---------- 5363SQL> exec dbms_logmnr.end_logmnr;PL/SQL procedure successfully completed. 进入google里面查: oracle 备份与恢复有一个实例蛮不错的,冷备份\热备份\RMAN备份都有这里我就不帖出来了 我继2楼兄弟。再给个自己写的logminer的。很早的时候看教程自己记得。如有疏漏请见谅。oracle版本 10.2.0 路径d:\oracle1.在d:\oracle目录下新建文件夹logs2 sqlplus /nologconn / as sysdba 登录成功后执行@d:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\dbmslm.sql@d:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\dbmslmd.sql修改utl_file_diralter system set utl_file_dir='d:\oracle\logs' scope=spfile; alter database add supplemental log data (primary key, unique index) columns;重启数据库:shutdown immediate;startup;创建字典:execute dbms_logmnr_d.build('shwdict.ora','D:\oracle\logs'); 成功完成后。3 将要分析的日志文件加入要分析的log list中,(一次添加一个为宜)察看有哪些日志文件可以用select * from v$logfile;查询已经加入那些可以用如下注:----具体redo日志存放路径需修改 execute dbms_logmnr.add_logfile(LogFileName=>'D:\oracle\product\10.2.0\oradata\testing\REDO01.LOG',Options =>dbms_logmnr.new); execute dbms_logmnr.add_logfile(LogFileName=>'D:\oracle\product\10.2.0\oradata\testing\REDO02.LOG',Options =>dbms_logmnr.new); execute dbms_logmnr.add_logfile(LogFileName=>'D:\oracle\product\10.2.0\oradata\testing\REDO02.LOG',Options =>dbms_logmnr.new);4更改会话时间表达方式alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';5执行分析exec dbms_logmnr.start_logmnr(dictfilename=>'D:\oracle\logs\shwdict.ora'); 可加入以下参数-starttime => '2008-07-15 09:39:00',endtime => '2008-07-15 14:45:00');【参数不对,没研究出正确的】PL/SQL procedure successfully completed. 跟据需要加入参数,起始时间结束时间。6查询分析。Select SCN,timestamp, session# session_num, sql_redoFrom V$LOGMNR_CONTENTS where timestamp>to_date('2008-11-19 09:30:00','yyyy-mm-dd hh24:mi:ss');查询增删改的日志:Select SCN,timestamp, session# ,COMMIT_TIMESTAMP,SEG_TYPE_NAME ,OPERATION,SQL_REDO From V$LOGMNR_CONTENTS where timestamp between to_date('2008-11-19 09:30:00','yyyy-mm-dd hh24:mi:ss') and to_date('2008-11-19 09:40:00','yyyy-mm-dd hh24:mi:ss') and OPERATION in ('DELETE','INSERT','UPDATE');至于rman的可以下个三思笔记一步一步学rman linzhangs什么时候把dataguard的教程贴出来共享下啊 自己做过简单的。刚放到这里了。http://hi.baidu.com/linzhangs/blog/item/75c59a4a09e5682b08f7ef55.html 年前做的现在估计也忘记了哈哈 谢谢各位前辈,小弟向DBA的道路上准备着,以后还请各位前辈多多指教 oracle中从一张表中减去与另一张表中相同的数据? 请问我用PROC插入数据怎么会失败? sqlplus脚本 导出数据库出现快照过旧,如何解决? “将表BASE_DOC_ITEM_RL的外键FK_BASE_DOC_ITEM_RL1设置为Cascade” 使用 row_number() over 进行分页显示的奇怪问题. DataGuard搭建问题。求助 归档模式下,对表进行DML操作,是否可以不产生日志? oracle安装 请教关于ORACLE表锁定的问题!谢谢 请教一个Oracle的时间格式问题. 关于dmp文件的导入问题
Grant succeeded.SQL> @$ORACLE_HOME/rdbms/admin/dbmslmd.sql;Package created.SQL> alter system set utl_file_dir = '/export/home/oracle/oradata/orcl/logs' scope = spfile;System altered.SQL> shutdown;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.Total System Global Area 629145600 bytes
Fixed Size 1281792 bytes
Variable Size 490733824 bytes
Database Buffers 134217728 bytes
Redo Buffers 2912256 bytes
Database mounted.
Database opened.SQL> startup;
....SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIV STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- ------ -------------------------------- ------------- ------------
1 1 938 52428800 1 NO INACTIVE 17445492 30-NOV-08
2 1 939 52428800 1 NO INACTIVE 17494420 01-DEC-08
3 1 940 52428800 1 NO CURRENT 17508573 01-DEC-08SQL> exec dbms_logmnr.add_logfile('/export/home/oracle/oradata/orcl/redo03.log', dbms_logmnr.new);PL/SQL procedure successfully completed.SQL> exec dbms_logmnr.start_logmnr(DictFileName=>'/export/home/oracle/oradata/orcl/logs/testlogmnr.ora');PL/SQL procedure successfully completed.SQL> select count(*) from V$LOGMNR_CONTENTS; COUNT(*)
----------
5363SQL> exec dbms_logmnr.end_logmnr;PL/SQL procedure successfully completed.
有一个实例蛮不错的,
冷备份\热备份\RMAN备份都有这里我就不帖出来了
oracle版本 10.2.0 路径d:\oracle
1.
在d:\oracle目录下新建文件夹logs
2 sqlplus /nolog
conn / as sysdba
登录成功后执行
@d:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\dbmslm.sql
@d:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\dbmslmd.sql
修改utl_file_dir
alter system set utl_file_dir='d:\oracle\logs' scope=spfile;
alter database add supplemental log data (primary key, unique index) columns;
重启数据库:
shutdown immediate;
startup;
创建字典:
execute dbms_logmnr_d.build('shwdict.ora','D:\oracle\logs');
成功完成后。3 将要分析的日志文件加入要分析的log list中,(一次添加一个为宜)察看有哪些日志文件可以用select * from v$logfile;查询已经加入那些可以用如下注:----具体redo日志存放路径需修改
execute dbms_logmnr.add_logfile(LogFileName=>'D:\oracle\product\10.2.0\oradata\testing\REDO01.LOG',Options =>dbms_logmnr.new);
execute dbms_logmnr.add_logfile(LogFileName=>'D:\oracle\product\10.2.0\oradata\testing\REDO02.LOG',Options =>dbms_logmnr.new);
execute dbms_logmnr.add_logfile(LogFileName=>'D:\oracle\product\10.2.0\oradata\testing\REDO02.LOG',Options =>dbms_logmnr.new);4更改会话时间表达方式
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';5执行分析
exec dbms_logmnr.start_logmnr(dictfilename=>'D:\oracle\logs\shwdict.ora');
可加入以下参数
-starttime => '2008-07-15 09:39:00',endtime => '2008-07-15 14:45:00');【参数不对,没研究出正确的】PL/SQL procedure successfully completed.
跟据需要加入参数,起始时间结束时间。
6查询分析。
Select SCN,timestamp, session# session_num, sql_redo
From V$LOGMNR_CONTENTS where timestamp>to_date('2008-11-19 09:30:00','yyyy-mm-dd hh24:mi:ss');
查询增删改的日志:
Select SCN,timestamp, session# ,COMMIT_TIMESTAMP,SEG_TYPE_NAME ,OPERATION,SQL_REDO
From V$LOGMNR_CONTENTS where timestamp between to_date('2008-11-19 09:30:00','yyyy-mm-dd hh24:mi:ss') and to_date('2008-11-19 09:40:00','yyyy-mm-dd hh24:mi:ss') and OPERATION in ('DELETE','INSERT','UPDATE');至于rman的可以下个三思笔记一步一步学rman
http://hi.baidu.com/linzhangs/blog/item/75c59a4a09e5682b08f7ef55.html 年前做的现在估计也忘记了哈哈