Directory
- Boot to Nomount State
- Set Trace
- Start the database to mount State and open
- Check Trace
- Another way to look up the trace V$diag_info view
The demo is as follows:
Boot to Nomount State
[email protected]> startup nomount;ORACLE instance started.Total System Global Area 1720328192 bytesFixed Size 2253944 bytesVariable Size 754977672 bytesDatabase Buffers 956301312 bytesRedo Buffers 6795264 bytes
Set Trace
[email protected]> oradebug setmypid;Statement processed.[email protected]> oradebug tracefile_name;/oracle/app/oracle/diag/rdbms/kyeupdbfs/kyeupdbfs/trace/kyeupdbfs_ora_13343.trc[email protected]> alter session set events ‘10046 trace name context forever,level 12‘;Session altered.
Start the database to mount State and open
[email protected]> alter database mount;Database altered.[email protected]> alter database open;Database altered.
Check Trace
路径:/oracle/app/oracle/diag/rdbms/kyeupdbfs/kyeupdbfs/trace/kyeupdbfs_ora_13343.trc
Another way to look up the trace V$diag_info view
[email protected]> select * from v$diag_info where name like ‘%Trace%‘; INST_ID NAME VALUE---------- -------------------- -------------------------------------------------- 1 Diag Trace /oracle/app/oracle/diag/rdbms/kyeupdbfs/kyeupdbfs/ trace 1 Default Trace File /oracle/app/oracle/diag/rdbms/kyeupdbfs/kyeupdbfs/ trace/kyeupdbfs_ora_13343.trc
Oracle Trace Analytics database Start-up stages