Database Admin - Reading Oracle Control file content

Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question

GeekInterview.com > Interview Questions > Database > Database Admin

Go To First | Previous Question | Next Question

Database Admin | Question 48 of 60

Print

Reading Oracle Control file content

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

Total Answers and Comments: 5

Last Update: September 23, 2008 Asked by: gbansal4

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

December 17, 2007 23:49:14

#1

Member Since: December 2007 Contribution: 3

RE: Reading Oracle Control file content

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

Is this answer useful? Yes | No

December 17, 2007 23:50:14

#2

Member Since: December 2007 Contribution: 3

RE: Reading Oracle Control file content

sql>alter database backup controlfile to trace;

Is this answer useful? Yes | No

May 29, 2008 06:20:01

#3

Member Since: May 2008 Contribution: 2

RE: Reading Oracle Control file content

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.

Is this answer useful? Yes | No

September 09, 2008 15:26:55

#4

Member Since: September 2008 Contribution: 3

RE: Reading Oracle Control file content

control file will be in Udump nt in bdump

Is this answer useful? Yes | No

September 23, 2008 06:31:20

#5

Member Since: September 2008 Contribution: 7

RE: Reading Oracle Control file content

No, reading of control file is not possible in ORACLE9i but u can read the trace file which is backup of control file situated in udump

Is this answer useful? Yes | No

Sponsored Links

Sponsored Links

Related Categories

—

About Us | Privacy Policy | Terms and Conditions | Contact | Site Map | Add Question | Propose Category | RSS Feeds | Articles Sitemap | Site Updates | Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved