Bondu_Babu Posted February 12, 2013 Report Posted February 12, 2013 vuuu...........[img]http://lh4.ggpht.com/-EvZDi_RGHQo/T-eItSQ_32I/AAAAAAAAHCE/BB7TuWcYTgc/s150/PK-21.gif[/img]
Joey_Tribbiani Posted February 12, 2013 Report Posted February 12, 2013 [quote name='Silence..Please' timestamp='1360697722' post='1303267529'] database level lo hard limit untundi .. ([color=#333333][font=Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif][size=3][background=rgb(250, 250, 250)]MAXDATAFILES default value entho undhi ) u can change that value to whatever you want .. kani that requires db bounce .. tablespace level lo hard limit aah ... this is something very new to me .. also oka tablespace to 1023 data-files aah [/background][/size][/font][/color][color=#333333][font=Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif][size=3][background=rgb(250, 250, 250)] [/background][/size][/font][/color] [/quote] MAXDATAFILES is limit on complete database bhayya !! This is for single table space .. Maadi 9TB database .. em chestaam
Joey_Tribbiani Posted February 12, 2013 Report Posted February 12, 2013 [quote name='KOTC' timestamp='1360697717' post='1303267528'] [b] How many Maximum Datafiles can there be in an Oracle Database[/b] [color=#204063][font=Helvetica, Arial, Verdana,]How many Maximum Datafiles can there be in an Oracle Database? When starting an Oracle Database instance, the DB_FILES initialization parameter indicates the amount of SGA space to reserve for datafile information and thus, the maximum number of datafiles that can be created for the instance. This limit applies for the life of the instance. You can change the value of DB_FILES (by changing the initialization parameter setting), but the new value does not take effect until you shut down and restart the instance. You can add datafiles to traditional smallfile tablespaces, subject to the following limitations: • Operating systems often impose a limit on the number of files a process can open simultaneously. More datafiles cannot be created when the operating system limit of open files is reached. • Operating systems impose limits on the number and size of datafiles. • The database imposes a maximum limit on the number of datafiles for any Oracle Database opened by any instance. This limit is operating system specific. • You cannot exceed the number of datafiles specified by the DB_FILES initialization parameter. • When you issue CREATE DATABASE or CREATE CONTROLFILE statements, the MAXDATAFILES parameter specifies an initial size of the datafile portion of the control file. However, if you attempt to add a new file whose number is greater than MAXDATAFILES, but less than or equal to DB_FILES, the control file will expand automatically so that the datafiles section can accommodate more files.[/font][/color] [color=#204063][font=Helvetica, Arial, Verdana,]source :http://oracledbainterviewquestions.blogspot.com/2008/09/how-many-maximum-datafiles-can-there-be.html[/font][/color] [/quote] all they talking about MAX datafiles per database , i am talking about MAXDATAFILES for Tablespace !! http://docs.oracle.com/cd/B19306_01/server.102/b14237/limits002.htm Database files Maximum per tablespace Operating system dependent; usually 1022 Maximum per database 65533 May be less on some operating systems Limited also by size of database blocks and by the DB_FILES initialization parameter for a particular instance
bmwx3 Posted February 12, 2013 Report Posted February 12, 2013 [quote name='Joey_Tribbiani' timestamp='1360698046' post='1303267581'] MAXDATAFILES is limit on complete database bhayya !! [b]This is for single table space [/b].. Maadi 9TB database .. em chestaam [/quote] ade kada cheppedi..tbs ki datafiles limit enti kothaga..max.number of datafiles=size of tbs
Gachibowli_Diwakar Posted February 12, 2013 Report Posted February 12, 2013 [quote name='Joey_Tribbiani' timestamp='1360698046' post='1303267581'] MAXDATAFILES is limit on complete database bhayya !! This is for single table space .. Maadi 9TB database .. em chestaam [/quote] nenu 27TB database meedha kuda work chesa .. we never reached that limit aina 32G is the max for each datafile that it can extend to.. alantapudu 3-4G tho data-file undatam enti .. resize cheyandi ..
Joey_Tribbiani Posted February 12, 2013 Report Posted February 12, 2013 [quote name='bmwx3' timestamp='1360698217' post='1303267601'] ade kada cheppedi..tbs ki datafiles limit enti kothaga..max.number of datafiles=size of tbs [/quote] See this bhayya .. its limited by operating system ... [url="http://docs.oracle.com/cd/B19306_01/server.102/b14237/limits002.htm"]http://docs.oracle.c...7/limits002.htm[/url]
Joey_Tribbiani Posted February 12, 2013 Report Posted February 12, 2013 [quote name='Silence..Please' timestamp='1360698283' post='1303267609'] nenu 27TB database meedha kuda work chesa .. we never reached that limit aina 32G is the max for each datafile that it can extend to.. alantapudu 3-4G tho data-file undatam enti .. resize cheyandi .. [/quote] yeah doing that now .. is there any way to break that hardlimit of 1022 ani checking bhayya
Gachibowli_Diwakar Posted February 12, 2013 Report Posted February 12, 2013 [quote name='Joey_Tribbiani' timestamp='1360698335' post='1303267617'] yeah doing that now .. is there any way to break that hardlimit of 1022 ani checking bhayya [/quote] no idea .. aina tablespace level lo break cheyandi app ni .. anni users and their objects ni okka tablespace lo create cheyatam enti .. Oracle support ni consult chesina.. they will say the same .. they will not take out that hard-limit
Joey_Tribbiani Posted February 12, 2013 Report Posted February 12, 2013 [quote name='Silence..Please' timestamp='1360698571' post='1303267647'] no idea .. aina tablespace level lo break cheyandi app ni .. anni users and their objects ni okka tablespace lo create cheyatam enti .. Oracle support ni consult chesina.. they will say the same .. they will not take out that hard-limit [/quote] SAP to message open chesaam . they suggested to go with RESIZE !! prastutaaniki ade chestunnam .. planning to split TS .. but downtime kavali kada .. bhayya general Question , nee exp lo 9TB database ni export/import cheydaaniki entha time pattiddi
Gachibowli_Diwakar Posted February 12, 2013 Report Posted February 12, 2013 [quote name='Joey_Tribbiani' timestamp='1360698799' post='1303267665'] SAP to message open chesaam . they suggested to go with RESIZE !! prastutaaniki ade chestunnam .. planning to split TS .. but downtime kavali kada .. bhayya general Question , nee exp lo 9TB database ni export/import cheydaaniki entha time pattiddi [/quote] forget about expdp/impdp .. entha gigabit ethernet cable unna kuda u r looking about 24hrs emo .. no idea best thing to do is .. to create standby for that database, and on the cut-over night activate the standby as primary ..
Joey_Tribbiani Posted February 12, 2013 Report Posted February 12, 2013 [quote name='Silence..Please' timestamp='1360698922' post='1303267673'] forget about expdp/impdp .. entha gigabit ethernet cable unna kuda u r looking about 24hrs emo .. no idea best thing to do is .. to create standby for that database, and on the cut-over night activate the standby as primary .. [/quote] Ok , lets say nenu standby server lo naa DB up chesi i did conversion from LOB==>LONG ... Tarvata primary dtaabase archivelogs teesukochi standby ni point in time ki recovory cheyocha after structure change ?
Gachibowli_Diwakar Posted February 12, 2013 Report Posted February 12, 2013 [quote name='Joey_Tribbiani' timestamp='1360699022' post='1303267681'] Ok , lets say nenu standby server lo naa DB up chesi i did conversion from LOB==>LONG ... Tarvata primary dtaabase archivelogs teesukochi standby ni point in time ki recovory cheyocha after structure change ? [/quote] LOB to Long enti ? u mean endian conversion aah nuvu cheppedhi ? migration annaav .. from which platform to which platform ? endian difference unte .. asalu standby create cheyalevu .. primary db's archive logs ni apply cheyyalevu standby lo .. bottom line is.. endian difference unte .. u can not have an associated standby database for the primary transportable tablespace use chesi migrate cheyali db ni .. aah process lo ne endian conversion chestharu .. transportable tablespace risky anukunte.. inka export/import ye dhikku
Bondu_Babu Posted February 12, 2013 Report Posted February 12, 2013 [quote name='Joey_Tribbiani' timestamp='1360698799' post='1303267665'] SAP to message open chesaam . they suggested to go with RESIZE !! prastutaaniki ade chestunnam .. planning to split TS .. but downtime kavali kada .. bhayya general Question , nee exp lo 9TB database ni export/import cheydaaniki entha time pattiddi [/quote] 9TB aa 50GB ki 4 to 5 hours teesukuntadhi
Gachibowli_Diwakar Posted February 12, 2013 Report Posted February 12, 2013 [quote name='Bondu_Babu' timestamp='1360699573' post='1303267735'] 9TB aa 50GB ki 4 to 5 hours teesukuntadhi [/quote] it all depends on system resources le ..
Recommended Posts