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

Thread: Control file multipexing....8...?

  1. #1
    Join Date
    Feb 2009
    Posts
    49

    Control file multipexing....8...?

    In 9i I read control file multiplexing can be only up to 8....Why....?...is there any specific reason.....?

    What is the limit in 8i and 10g...?

    One more doubt....I heard control file has two section usable and reusable....whether is it in control file header...?

    Control file reusable section contain rman information what is this non reusable section contains......is it....ckpt and scn informatio needed for recovery..?
    Last edited by tmgsam; 02-23-2009 at 07:11 AM.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    why would you want more than 8 control files?

  3. #3
    Join Date
    Feb 2009
    Posts
    49
    No I dont want more than 8 files.I want to know what is the reason for only 8...?

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    becuase it is 8, someone set a limit.

    any more than 8 just sounds stupid

  5. #5
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    Quote Originally Posted by tmgsam View Post
    Control file reusable section contain rman information what is this non reusable section contains......is it....ckpt and scn informatio needed for recovery..?
    There is One parameter CONTROL_FILE_RECORD_KEEP_TIME defines dat after this much time backup and recovery information will be overwritten. If before this time, new information is added, then controlfile grows in size upto max OS limit. This portion is resuable part.
    Yes, CHKPTing or SCN info, log sequence,info abt datafiles and redo files,etc form the non reusable part.
    lucky

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