Oracle Trace Analytics database Start-up stages

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