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

lakshmi143.e

 Profile Answers by lakshmi143.e Questions by lakshmi143.e

• Oct 14th, 2009

SQL> ALTER DATABASE BACKUP controlfile TO trace;
You can find the trace file which is backup of control file in udump directory.

narendra05

 Profile Answers by narendra05 Questions by 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 th...

Answer Question  Select Best Answer

sudhakar

• Sep 25th, 2011

1- When BEGIN BACKUP is issued: The hot backup flag in the datafile headers is set, so that the copy is identified to be a hot backup copy. This is to manage the backup consistency issue when the cop...

tykarthick

 Profile Answers by tykarthick Questions by tykarthick

• Oct 6th, 2009

Sql>alter database begin backup;The above query is used to freeze the header of all datafiles belongs to tablespace in that particular database.Freeze means lock i.e during backup no data's wil...

Answer Question  Select Best Answer