How to view the content of the Oracle control file: Dump

SQL> select name from V $ controlfile//View the storage path of the Control File
 
 

 
Log on firstSQL * Plus, I useSystem/system @ TestLogin, after entering:
 

 
SQL>

   

    
     
Conn

    

   /As sysdba
 

 
Connected
 

 
SQL> oradebug setmyid
 

 
SQL> oradebug dump controlf 3
 
 

 
In this caseControl File dumpToUser_dump_destUnder the directory specified by the initialization parameter,
 

 
ViewUser_dump_destInitialize parameters:
 

SQL> show parameter user_dump_dest
 

 
Name type value
-----------------------------------------------------------------------------
User_dump_dest string c: \ oracle \ product \ 10.1.0 \ admin
\ Video \ udump
 




 




In the specified directory, the generatedTRCFile. We can see from the date that it was just generated.
 
 
 
Find information:
 
 
SQL> oradebug help//You can viewOradebugAll commands and explanations
 
 
SQL> oradebug help setmypid
 
 
SetmypidDebug current process
 
 
It indicates debugging the current process.
 
 
SQL> oradebug help dump
 
Dump<Dump_name> <LVL> [ADDR]Invoke named dump
 
 
Call and copy the file.3Yes. It is used to control the downloaded content.
 
 
Available onlineOradebugDownload the explanatory document:
 
 
Http://www.itpub.net/477123.html
------------------------------------------------------------
Or:
Two methods:
1. Alter Database Backup controlfile to trace
View the <Sid> _ ora _ <pid>. TRC file in the udmp directory

2. Alter Databse backup controlfiel to file name
Query this file