alter session set events语句dump 控制文件头信息示例
来源:互联网 发布:赵薇被处罚知乎 编辑:程序博客网 时间:2024/05/27 14:12
alter session set events 'immediate trace name controlf level 1';中level n的意义如下:
1 控制文件中的文件头信息2 level 1 + 文件头信息
3 level 2 + 数据文件头信息
10 level 3
更详细的alter session set events--oracle -Oracle跟踪事件简介见http://blog.csdn.net/q947817003/article/details/16369041 第2小节。
个人见解:
在需要DBID进行数据恢复时,alter system dump logfile 'filename';明显适合更复杂的场景。
ALTER SYSTEM DUMP LOGFILE 'filename' DBA MIN fileno blockno DBA MAX fileno blockno;
详见:http://blog.csdn.net/q947817003/article/details/16370203本实验命令如下:
SYS@ bys3>alter session set events 'immediate trace name controlf level 1'; --同样要求数据库是MOUNT/OPEN状态可执行语句Session altered.
SYS@ bys3>oradebug setmypid; --此语句要用SYSDBA权限执行,普通DBA用户会报错:ORA-01031: insufficient privileges
Statement processed.
SYS@ bys3>oradebug tracefile_name --找出产生的TRACE文件名
/u01/app/oracle/product/11.2.0/dbhome_1/log/diag/rdbms/bys3/bys3/trace/bys3_ora_1788.trc
################################################################
查看产生的TRACE文件信息 --因只DUMP了控制文件头的信息,所以内容并不多。
Trace file /u01/app/oracle/product/11.2.0/dbhome_1/log/diag/rdbms/bys3/bys3/trace/bys3_ora_1788.trcOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1
System name: Linux
Node name: bys3.bys.com
Release: 2.6.32-200.13.1.el5uek
Version: #1 SMP Wed Jul 27 20:21:26 EDT 2011
Machine: i686
Instance name: bys3
Redo thread mounted by this instance: 1
Oracle process number: 17
Unix process pid: 1788, image: oracle@bys3.bys.com (TNS V1-V3)
*** 2013-11-17 15:08:09.573
*** SESSION ID:(43.881) 2013-11-17 15:08:09.573
*** CLIENT ID:() 2013-11-17 15:08:09.573
*** SERVICE NAME:(SYS$USERS) 2013-11-17 15:08:09.573
*** MODULE NAME:(sqlplus@bys3.bys.com (TNS V1-V3)) 2013-11-17 15:08:09.573
*** ACTION NAME:() 2013-11-17 15:08:09.573
DUMP OF CONTROL FILES, Seq # 1596 = 0x63c DUMP的控制文件
V10 STYLE FILE HEADER:
Compatibility Vsn = 186646528=0xb200000
Db ID=3358363031=0xc82c8d97, Db Name='BYS3' ---数据库的DBID和DB_NAME信息
Activation ID=0=0x0
Control Seq=1596=0x63c, File size=604=0x25c
File Number=0, Blksiz=16384, File Type=1 CONTROL
*** END OF DUMP ***
*** 2013-11-17 15:08:13.584
Processing Oradebug command 'setmypid'
*** 2013-11-17 15:08:13.585
Oradebug command 'setmypid' console output: <none>
*** 2013-11-17 15:08:16.701
Processing Oradebug command 'tracefile_name'
*** 2013-11-17 15:08:16.701
Oradebug command 'tracefile_name' console output:
/u01/app/oracle/product/11.2.0/dbhome_1/log/diag/rdbms/bys3/bys3/trace/bys3_ora_1788.trc
- alter session set events语句dump 控制文件头信息示例
- alter session set events语句dump REDO日志文件头信息示例
- alter session set events
- alter session set events
- 对alter session set events语句基本意思的说明
- alter session set events 详解
- alter system|session set events
- alter session|system set events
- alter system|session set events转储
- alter system/session set events详解
- alter system/session set events相关知识
- alter system|session set events转储
- 通过 alter system dump logfile语句dump REDO及归档日志信息示例
- alter system set events
- alter system set events
- ALTER SESSION SET EVENTS 'immediate trace name controlf level 3';
- alter session set events相关知识(二)
- alter session set events 'immediate trace name controlf level 8'
- mysql的cursor使用(游标)脚本创建
- 1060. Are They Equal (25)
- JDBC链接数据库版本三,使用C3P0,使用jar文件两个
- hdu Ecoding .
- 守破离
- alter session set events语句dump 控制文件头信息示例
- hdu4786Fibonacci Tree
- 神秘博士1-6季电影种子
- ViewFlipper的使用
- Cannot use web cam, since the user has not authorized this
- 进程组和会话组
- Linux commands
- Ubuntu 12.10安装低版本gcc和g++编译器
- cocos2d-x 更换场景