KOTC Posted April 23, 2013 Author Report Posted April 23, 2013 http://www.keplerinfotech.com/blog/2013/01/16/awr-addm-ash-and-statspack-tuning/
Gachibowli_Diwakar Posted April 24, 2013 Report Posted April 24, 2013 [img]http://lh4.ggpht.com/-35aTPSwXFCg/UTttW-29qZI/AAAAAAAAKXQ/8OzaiDDWnXs/s180/GD-1.gif[/img]
KOTC Posted April 24, 2013 Author Report Posted April 24, 2013 load test eppudu chestaru enduku chestaru? koni examples ivandi vayya telisite necrhukuntuna dani meda issue em ledhu.evaru ayina chesara load test?? http://www.nocoug.org/download/2012-08/Noelle_Stimely_Load_Testing_Paper.pdf idi dorkindi kani evaru ayina chesina valu unnara>?
Anta Assamey Posted April 24, 2013 Report Posted April 24, 2013 [img]http://www.brahmanandamgifs.com/Images/GIFs/Anandam/2.gif[/img]
KOTC Posted April 24, 2013 Author Report Posted April 24, 2013 [b] Data Pump Monitoring[/b] [color=#343434][font=proxima-nova, Verdana, Arial, sans-serif][url="http://www.pythian.com/blog/data-pump-monitoring/"]http://www.pythian.c...ump-monitoring/[/url][/font][/color] [color=#000000][font=Tahoma, Verdana, Helvetica, sans-serif][b][right]DataPump Export And Import Job And Attached Client Sessions [ID 262557.1][/right][/b][/font][/color]
KOTC Posted April 24, 2013 Author Report Posted April 24, 2013 [quote name='Brahmanandam_AFDB' timestamp='1366820185' post='1303656338'] [img]http://www.brahmanandamgifs.com/Images/GIFs/Anandam/2.gif[/img] [/quote] endi vayya ?
Anta Assamey Posted April 24, 2013 Report Posted April 24, 2013 [quote name='STFU' timestamp='1366820505' post='1303656381'] endi vayya ? [/quote] Oka rakamga LTT chesanu....[img]http://www.brahmanandamgifs.com/Images/GIFs/Anandam/2.gif[/img]
KOTC Posted April 24, 2013 Author Report Posted April 24, 2013 [quote name='Brahmanandam_AFDB' timestamp='1366820534' post='1303656387'] Oka rakamga LTT chesanu....[img]http://www.brahmanandamgifs.com/Images/GIFs/Anandam/2.gif[/img] [/quote] [img]http://www.brahmanandamgifs.com/Images/GIFs/Anandam/2.gif[/img]
KOTC Posted April 24, 2013 Author Report Posted April 24, 2013 Can Full Backup be performed when the database is open? No. [color=#000000][font=Tahoma, Helvetica, sans-serif][size=3]NO, we can't. cuz Full Backup means consistent backup and we can take this backup only when our database is close.[/size][/font][/color]
Bondu_Babu Posted April 24, 2013 Report Posted April 24, 2013 [quote name='STFU' timestamp='1366822018' post='1303656614'] Can Full Backup be performed when the database is open? No. [color=#000000][font=Tahoma, Helvetica, sans-serif][size=3]NO, we can't. cuz Full Backup means consistent backup and we can take this backup only when our database is close.[/size][/font][/color] [/quote]nvu cheppindhi cold back up, data base run avutunnappudu kuda full back teesukovachu adi hot back.
KOTC Posted April 24, 2013 Author Report Posted April 24, 2013 [quote name='Bondu_Babu' timestamp='1366822522' post='1303656685'] nvu cheppindhi cold back up, data base run avutunnappudu kuda full back teesukovachu adi hot back. [/quote] Database run ayinapudu tesukune di full database backup kadhu it's not consistent. [size=4][font=arial,helvetica,sans-serif][b] Consistent Backups[/b] You can use the [url="http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta007.htm#RCMRF107"]BACKUP[/url] command to make consistent and inconsistent backups of the database. A [b]consistent backup[/b] occurs when the database is in a consistent state. A database is in a consistent state after being shut down with the [url="http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta045.htm#RCMRF155"]SHUTDOWN[/url] NORMAL,SHUTDOWN IMMEDIATE, or SHUTDOWN TRANSACTIONAL commands. A consistent shutdown guarantees that all redo has been applied to the datafiles. If you mount the database and make a backup at this point, then you can restore the [url="http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmcncpt.htm#"]database backup[/url]later and open it without performing media recovery. Inconsistent Backups Any database backup that is not consistent is an [b]inconsistent backup[/b]. A backup made when the database is open is inconsistent, as is a backup made after an instance failure or SHUTDOWN ABORT command. When a database is restored from an inconsistent backup, Oracle must perform media recovery before the database can be opened, applying any pending changes from the redo logs. [b]Note:[/b]RMAN does not permit you to make inconsistent backups when the database is in NOARCHIVELOGmode. If you employ user-managed backup techniques for a NOARCHIVELOG database, then you must not make inconsistent backups of this database.[/font][/size] http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmcncpt.htm#BABIHBBE
Gachibowli_Diwakar Posted April 24, 2013 Report Posted April 24, 2013 [quote name='STFU' timestamp='1366823785' post='1303656843'] Database run ayinapudu tesukune di full database backup kadhu it's not consistent. [font=arial,helvetica,sans-serif][b] Consistent Backups[/b] You can use the [url="http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta007.htm#RCMRF107"]BACKUP[/url] command to make consistent and inconsistent backups of the database. A [b]consistent backup[/b] occurs when the database is in a consistent state. A database is in a consistent state after being shut down with the [url="http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta045.htm#RCMRF155"]SHUTDOWN[/url] NORMAL,SHUTDOWN IMMEDIATE, or SHUTDOWN TRANSACTIONAL commands. A consistent shutdown guarantees that all redo has been applied to the datafiles. If you mount the database and make a backup at this point, then you can restore the [url="http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmcncpt.htm#"]database backup[/url]later and open it without performing media recovery. Inconsistent Backups Any database backup that is not consistent is an [b]inconsistent backup[/b]. A backup made when the database is open is inconsistent, as is a backup made after an instance failure or SHUTDOWN ABORT command. When a database is restored from an inconsistent backup, Oracle must perform media recovery before the database can be opened, applying any pending changes from the redo logs. [b]Note:[/b]RMAN does not permit you to make inconsistent backups when the database is in NOARCHIVELOGmode. If you employ user-managed backup techniques for a NOARCHIVELOG database, then you must not make inconsistent backups of this database.[/font] [url="http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmcncpt.htm#BABIHBBE"]http://docs.oracle.c...pt.htm#BABIHBBE[/url] [/quote]consistent kadhu kabatte ga.. archive logs kuda backup theeskuni .. consistent state dhaaka recover chesedhi .. after restoring
KOTC Posted April 24, 2013 Author Report Posted April 24, 2013 [quote name='Silence..Please' timestamp='1366824010' post='1303656872'] consistent kadhu kabatte ga.. archive logs kuda backup theeskuni .. consistent state dhaaka recover chesedhi .. after restoring [/quote] [color=#282828][font=helvetica, arial, sans-serif]Can Full Backup be performed when the database is open?[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]deniki ans?????????????[/font][/color]
Gachibowli_Diwakar Posted April 24, 2013 Report Posted April 24, 2013 [quote name='STFU' timestamp='1366824200' post='1303656905'] [color=#282828][font=helvetica, arial, sans-serif]Can Full Backup be performed when the database is open?[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]deniki ans?????????????[/font][/color] [/quote] yes, you can [url="http://docs.oracle.com/cd/A57673_01/DOC/server/doc/SCN73/ch23.htm"]http://docs.oracle.com/cd/A57673_01/DOC/server/doc/SCN73/ch23.htm[/url]
nexus Posted April 24, 2013 Report Posted April 24, 2013 using RMAN - Yes, provided you have the archivelog mode on. using cold cold backup- No Looks like that was an interview question pre-RMAN era
Recommended Posts