Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Determinants of control file
Hi
Nirmal,
<SPAN
class=620094219-29112001>
<SPAN
class=620094219-29112001> Use
<SPAN
class=620094219-29112001>
<SPAN
class=620094219-29112001> alter database backup
controlfile to trace;
<SPAN
class=620094219-29112001>
<SPAN
class=620094219-29112001> You can find these details in the
trace file, that will be dumped to your udump destination.
<SPAN
class=620094219-29112001>
<SPAN
class=620094219-29112001>HTH
<SPAN
class=620094219-29112001>Srinivas.
<SPAN
class=620094219-29112001>
<SPAN
class=620094219-29112001>
-----Original Message-----From: Nirmal
Kumar Muthu Kumaran [mailto:NIRMALK_at_qtel.com.qa]Sent: Thursday,
November 29, 2001 7:52 AMTo: Multiple recipients of list
ORACLE-LSubject: Determinants of control file
Hi all,
The determinants(size) of control file are
maxdatafiles, maxlogfiles. maxlogmemebers, etc.,
But after creation of control files, where should i
get details about these parameter values?...
i checked in v$controlfile and v$database... i
didn't get enough info on it.
And i found controlfile_sequence# column i found in
v$database view. I multiplexed the control files. <FONT face=Arial
size=2>Where will i get the sequence# of other control files then...
Nirmal, Received on Thu Nov 29 2001 - 05:35:42 CST
![]() |
![]() |