Oracle：DUMP数据文件头信息
需求如题所示。
我们这里通过Oracle的时间跟踪DUMP出我们需要的信息。
具体如下：
（数据库状态至少要MOUNT，才能执行以下操作）
执行跟踪，并找出产生的TRACE文件：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 |
[oracle@rhel69 ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Fri Mar 15 16:46:43 2019 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select dbid,name from v$database; DBID NAME ---------- --------- 13087093 ORCL SQL> select instance_name,status from v$instance; INSTANCE_NAME STATUS ---------------- ------------ ORCL MOUNTED SQL> SQL> alter system set events 'immediate trace name file_hdrs level 3'; System altered. SQL> SQL> oradebug setmypid; Statement processed. SQL> SQL> oradebug tracefile_name; /u01/app/oracle/admin/ORCL/udump/ORCL_ora_218915.trc SQL> |
可以看到，我们生成的[……]
