?
Solved

view control file

Posted on 2013-06-26
4
Medium Priority
?
227 Views
Last Modified: 2013-07-13
I cannot see the controfile

.ctl is not viewable

It is not in readable format
The purpose is to run the controlfile script
0
Comment
Question by:walkerdba
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39279909
Oracle control files are binary.  You should NEVER try to edit one.

What are you trying to do?
0
 
LVL 23

Accepted Solution

by:
David earned 2000 total points
ID: 39279930
To view a copy:
ALTER DATABASE backup controlfile to trace;

Find the trace file and view the readable output.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39279936
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
 

Author Closing Comment

by:walkerdba
ID: 39324249
yes
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the dā€¦
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to recover a database from a user managed backup
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question