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 06:11 AM.
why would you want more than 8 control files?
No I dont want more than 8 files.I want to know what is the reason for only 8...?
becuase it is 8, someone set a limit.
any more than 8 just sounds stupid
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.
Originally Posted by tmgsam
Yes, CHKPTing or SCN info, log sequence,info abt datafiles and redo files,etc form the non reusable part.
Click Here to Expand Forum to Full Width