DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: control files

  1. #1
    Join Date
    Apr 2003
    Posts
    46

    control files

    hi

    when we create database through dbca by default it creates 3 control files. do all these control files contain the same data or are they different.because when i startup my database with only one file it starts my db but does not allow me to work further.

    another query regarding controfiles is that through oem if u check :
    database/storage/controlfile and in the right pane the record section tab
    it gives some details regarding record size, record total. for eg.
    database record size is 192, record total is 1 , records used is 1.
    what does these parameters signify.

    another doubt if i were to view the contents of controlfile , how would it be possible.

    another query, how would i reduce the size of my control files , when i went through the manuals the maxlogfiles, maxlogmembers etc. influence in the size of control files. and there is no other way to give size for my control files. i want to compare the physical size of my control files with these parameters that we provide while creating database.is it possible. how.


    thanks
    ser
    Last edited by ser; 05-21-2003 at 05:18 AM.

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    These are some of the very basic things and you find answers to all your questions in manual. So please read the friendly manual.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    Re: control files

    Originally posted by ser
    hi

    when we create database through dbca by default it creates 3 control files. do all these control files contain the same data or are they different.because when i startup my database with only one file it starts my db but does not allow me to work further.
    They are all identical.

    Originally posted by ser

    another query regarding controfiles is that through oem if u check :
    database/storage/controlfile and in the right pane the record section tab it gives some details regarding record size, record total. for eg.
    database record size is 192, record total is 1 , records used is 1.
    what does these parameters signify.
    This is basically v$controlfile_record_section. Read the Manuls to understand what control files contains.

    Originally posted by ser

    another doubt if i were to view the contents of controlfile , how would it be possible.
    look at v$controlfile_record_section. controlfile is binary file, so dont try to open it using any text editor.

    Originally posted by ser

    another query, how would i reduce the size of my control files , when i went through the manuals the maxlogfiles, maxlogmembers etc. influence in the size of control files. and there is no other way to give size for my control files. i want to compare the physical size of my control files with these parameters that we provide while creating database.is it possible. how.
    thanks
    ser
    How does a 2MB approx. file bother your physical size. Don't waste time on control file sizes. There are other things to look around for estimating physical size.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  4. #4
    Join Date
    May 2001
    Posts
    736
    To view the contents of controlfile,take its backup to trace.
    Alter database backup controlfile to trace;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width