peru_edaite_enti Posted April 1, 2013 Report Posted April 1, 2013 [quote name='STFU' timestamp='1364842055' post='1303522710'] [url="http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup004.htm"]http://docs.oracle.c...192/bkup004.htm[/url] [b] 4.4.4 Improving Incremental Backup Performance: Change Tracking[/b] [font=Tahoma, sans-serif]Change tracking is disabled by default, because it does introduce some [b]minimal performance overhead on your database during normal operations[/b]. However, the benefits of avoiding full datafile scans during backup are considerable, especially if only a small percentage of data blocks are changed between backups. If your backup strategy involves incremental backups, then you should enable change tracking.[/font] [/quote] hmm... idi edo think seyalsina visayam.. kaani performance overhead aite pakka untundi ante expect chesa.. but veedu mari minimal antunnadu ante, maa retail transactions ki adi koddiga ekkuve untadi.. right now, maku 10 TB sizes prod db's unnai.. vati ki backups oka 11.30 hours close to 12 hours tesukuntadi.... okasari test env lo chusi check cheyali 1
peru_edaite_enti Posted April 1, 2013 Report Posted April 1, 2013 [quote name='STFU' timestamp='1364842259' post='1303522750'] A services create chesava ?? [/quote] maa footprint lo rac levu baa..
KOTC Posted April 1, 2013 Author Report Posted April 1, 2013 [quote name='CBZ' timestamp='1364842886' post='1303522844'] hmm... idi edo think seyalsina visayam.. kaani performance overhead aite pakka untundi ante expect chesa.. but veedu mari minimal antunnadu ante, maa retail transactions ki adi koddiga ekkuve untadi.. right now, maku 10 TB sizes prod db's unnai.. vati ki backups oka 11.30 hours close to 12 hours tesukuntadi.... okasari test env lo chusi check cheyali [/quote] meru incremental backups level 1 cheste advantage untndi.
peru_edaite_enti Posted April 1, 2013 Report Posted April 1, 2013 [quote name='STFU' timestamp='1364846206' post='1303523232'] meru incremental backups level 1 cheste advantage untndi. [/quote] incremental level 0 backup aite?
Gachibowli_Diwakar Posted April 1, 2013 Report Posted April 1, 2013 [quote name='CBZ' timestamp='1364842886' post='1303522844'] hmm... idi edo think seyalsina visayam.. kaani performance overhead aite pakka untundi ante expect chesa.. but veedu mari minimal antunnadu ante, maa retail transactions ki adi koddiga ekkuve untadi.. right now, maku 10 TB sizes prod db's unnai.. vati ki backups oka 11.30 hours close to 12 hours tesukuntadi.... okasari test env lo chusi check cheyali [/quote] yup .. impact will be very minimal .. 18TB OLTP db ki enable chesam .. we never ran into any performance issues
KOTC Posted April 1, 2013 Author Report Posted April 1, 2013 [quote name='CBZ' timestamp='1364849069' post='1303523643'] incremental level 0 backup aite? [/quote] light bhayya.incremental 0 (full DB backup type)ala aithe database motham rman backup cheyalisinde,( neku already telusu emo.nenu general ga cheptuna))) incremental 1 ante last backup jarge changes ni backup cheydam.a block tracking enable cheste so a changes ni backup chestundi rman.appudu prathi datafile lo ki veli search cheyalisina avasram ledhu e datafile lo changes ayinai kaledha ani.a time save avutundi me environment level 0 weekly, every day level 1 petukoni unte.level 1 backups chesinapudu block trackin useful avutundi ala less time lo backup finish avutundi.
peru_edaite_enti Posted April 1, 2013 Report Posted April 1, 2013 [quote name='STFU' timestamp='1364852634' post='1303524022'] light bhayya.incremental 0 (full DB backup type)ala aithe database motham rman backup cheyalisinde, incremental 1 ante last backup jarge changes ni backup cheydam.a block tracking enable cheste so a changes ni backup chestundi rman.appudu prathi datafile lo ki veli search cheyalisina avasram ledhu e datafile change ayinda kaledha ani.a time save avutundi me environment level 0 weekly every day level 1 petukoni.backups cheste appudu a level 1 backup chesinapudu block trackin useful avutundi. [/quote] Dis explains
KOTC Posted April 1, 2013 Author Report Posted April 1, 2013 [quote name='Silence..Please' timestamp='1364851364' post='1303523903'] yup .. impact will be very minimal .. 18TB OLTP db ki enable chesam .. we never ran into any performance issues [/quote] bhayya nuv service create chesava RAC lo?? srvctl use chesi
peru_edaite_enti Posted April 1, 2013 Report Posted April 1, 2013 [quote name='Silence..Please' timestamp='1364851364' post='1303523903'] yup .. impact will be very minimal .. 18TB OLTP db ki enable chesam .. we never ran into any performance issues [/quote] maadi tokkalo hardware le.. aix 5.2 level lo inka maintain settunnaru... upgrade seyyadaniki onukutunnaru ibm ollu..
KOTC Posted April 2, 2013 Author Report Posted April 2, 2013 http://askdba.org/weblog/oracle11g/11g-rac/applying-psu-11-2-0-3-5-to-grid-infrastructure-and-db-home/ evaru ayina [b] Applying PSU 11.2.0.3.5 to Grid Infrastructure and DB Home[/b] cheste paina link lo laga cheyali anthe plus catbundle anthe kadha inka catalog use cheste upgrade cheyali anthe kadha? cd $ORACLE_HOME/rdbms/admin sqlplus /nolog SQL> CONNECT / AS SYSDBA SQL> STARTUP SQL> @catbundle.sql psu apply [color=#000000]SQL> QUIT[/color] inka em ayina points unnai travtha unte zara chepandi vayya calling silence please
peru_edaite_enti Posted April 2, 2013 Report Posted April 2, 2013 [quote name='STFU' timestamp='1364939181' post='1303530485'] http://askdba.org/weblog/oracle11g/11g-rac/applying-psu-11-2-0-3-5-to-grid-infrastructure-and-db-home/ evaru ayina [b] Applying PSU 11.2.0.3.5 to Grid Infrastructure and DB Home[/b] cheste paina link lo laga cheyali anthe plus catbundle anthe kadha inka catalog use cheste upgrade cheyali anthe kadha? cd $ORACLE_HOME/rdbms/admin sqlplus /nolog SQL> CONNECT / AS SYSDBA SQL> STARTUP SQL> @catbundle.sql psu apply [color=#000000]SQL> QUIT[/color] inka em ayina points unnai travtha unte zara chepandi vayya calling silence please [/quote] Mee no avidea
Gachibowli_Diwakar Posted April 2, 2013 Report Posted April 2, 2013 [quote name='STFU' timestamp='1364939181' post='1303530485'] [url="http://askdba.org/weblog/oracle11g/11g-rac/applying-psu-11-2-0-3-5-to-grid-infrastructure-and-db-home/"]http://askdba.org/we...re-and-db-home/[/url] evaru ayina [b] Applying PSU 11.2.0.3.5 to Grid Infrastructure and DB Home[/b] cheste paina link lo laga cheyali anthe plus catbundle anthe kadha inka catalog use cheste upgrade cheyali anthe kadha? cd $ORACLE_HOME/rdbms/admin sqlplus /nolog SQL> CONNECT / AS SYSDBA SQL> STARTUP SQL> @catbundle.sql psu apply [color=#000000]SQL> QUIT[/color] inka em ayina points unnai travtha unte zara chepandi vayya calling silence please [/quote]psu download chesthe .. andhulo readme untundi .. go thru that.. each n every psu ki installation instructions different ga untay
dkchinnari Posted April 2, 2013 Report Posted April 2, 2013 [quote name='Silence..Please' timestamp='1364944251' post='1303530956'] psu download chesthe .. andhulo readme untundi .. go thru that.. each n every psu ki installation instructions different ga untay [/quote]call seyi..neetho pani undhi..number lekapothe telsuko
KOTC Posted April 3, 2013 Author Report Posted April 3, 2013 [quote name='Silence..Please' timestamp='1364944251' post='1303530956'] psu download chesthe .. andhulo readme untundi .. go thru that.. each n every psu ki installation instructions different ga untay [/quote] ok bhayya chadivanu process undi but just evaru ayina chesina varu unara ani
KOTC Posted April 8, 2013 Author Report Posted April 8, 2013 [color=#282828][font=helvetica, arial, sans-serif]dba_registry gurchi evarki ayina idea undha?[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]everytime patches apply chese mundu plus ayyaka chudali anta? nenu patches apply chesaka koni components invalid ayayi anukunta.[/font][/color] evariki ayina in depth knowledge undha dba_registry meda
Recommended Posts