Reading Oracle Control file content

Can we read Control file? If yes, then how?

Questions by gbansal4   answers by gbansal4

Showing Answers 1 - 21 of 21 Answers

senapati99

  • Dec 17th, 2007
 

Issue the following commands
sql>alter database backup controlfile to '/usr/u06/--';
sql>alter database backup controlfile to trace;
u can view the controlfile in bdump
regds

  Was this answer useful?  Yes

santhanamuthu

  • May 29th, 2008
 

Yes, We can read control file
first we have to transfer it to text file.

sql> alter database backup controlfile to trace,

we can view the controlfile from user_dump_test.

  Was this answer useful?  Yes

narendra05

  • Oct 2nd, 2009
 

Control file is the metadata of data and the information is stored in binary format. Some part of the control file can be seen by tracing it to trace (struncture of database can be seen by tracing the control file)

Alter database backup controlfile to 'c:control.txt';

--- Please change path to respective directory.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions