view control file

I cannot see the controfile

.ctl is not viewable

It is not in readable format
The purpose is to run the controlfile script
walkerdbaAsked:
Who is Participating?
 
DavidConnect With a Mentor Senior Oracle Database AdministratorCommented:
To view a copy:
ALTER DATABASE backup controlfile to trace;

Find the trace file and view the readable output.
0
 
slightwv (䄆 Netminder) Commented:
Oracle control files are binary.  You should NEVER try to edit one.

What are you trying to do?
0
 
slightwv (䄆 Netminder) Commented:
If you use the above code, it's a pain to track down the correct trace file.

You can simplify it by providing the path.

For example in Unix:
ALTER DATABASE backup controlfile to trace '/tmp/myfile.txt';
0
 
walkerdbaAuthor Commented:
yes
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.