Solved

view control file

Posted on 2013-06-26
4
221 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
  • 2
4 Comments
 
LVL 76

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 500 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 76

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

930 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now