In this article I'll explain on the backup of the Oracle database and recovery and it is not an article with different types of failure that may occur on your database. And also reality that all things happen around e.g. material for your database can go wrong or maybe you accidentally deleted the data file or perhaps an end-user accidentally drop a table that they need.
In order to plant for these disasters have ends. We need backups and you must also know how to treat these backups when something goes wrong, how to get back to the most recent State so why we must firs of all configure our database for log mode archive. Speaks a bit more on the various components you need to save it is not only the data, the files you need is also think that said archive logs, the password file in the control file. Network configuration files, so you do not have to recreate those and I have to deal with two different types of backup here, we have to full backups and incremental backups.
Full backups are just that work to back up all data files, as when in an incremental backup to save only the changes to the blocks. Since the full backup Oracle 10 g came out with something called the parcel tracking again where he keep a trace to a file of all the blocks that have changes since the last criminal day backup to save a lot of time when we perform the recovery and it also perform a hot upwards and a hot call backup savemeans that you upwards the day two days or particular table space so that operational databases and it is completely seamless and you think they will never know that you do.
A reminder is maximum when you set the database down and then you just go to the bone, and you can copy data files. There are three different types of failures. They are mainly the following:
Journal of the BufferBuffer CacheShared PoolLog buffer: whenever the changes that happened in the data of these changes, they will get tracked into the buffer and then eventually earning a checkpoint occurs. Who will get written to the writing of journals reviewed by a log buffer.Buffer cache: which contains blocks of database and server processes are go either to get its even a data from the files of data or more casual in fact tempted to buy for cache first and do not find it. It happens in the data files, then loaded in the cache. If the buffer cache finally gets written data files by the author of the database.Common pool: which are used for implementing caching of the instruction of the people and Peel blocks away. We also control files that these keep track of where your data files are where you are redo logs are and it also keeps track of the SCN number.We will provided that you have need of more data on the backup of the Oracle database and the Concepts of recovery. Please click on: ORACLE DBA TRAINING IN HYDERABAD. Note this ArticleBackup of database Oracle and ConceptsNot of recovery rated yet
Prasad Mynumpati has published 2 articles. Article submitted on 3 October 2013. Number of words: 500CheapTestInside provides high quality IT exam practice questions / answers. In particular, Cisco CCNA CCDA CCNP CCIE, 9i DBA Oracle 10g DBA, Nortel mnt NCSE SSCC, Checkpoint CCSE, certification practice tests CompTIA A + network + and so on.
Written by: CheaptestinisdeInformatica provides software for integration of data and services for businesses. As their only authorized training partners in India, NIIT offers a comprehensive portfolio of training on a variety of solutions Informatica.
Written by: Amy GibsonTraining Oracle benefits from companies and employees. Cloud computing ensures that the company's data are safe and also reduce expenditure. Employees who are well versed in Oracle not only earn greater benefits but also climb very fast enterprise-wide.
Written by: Pati PavanMath Abacus n prides itself on providing online learning worldwide through powered virtual college. The online training and development closely replicates the classes that take place in the traditional classroom.
Written by: Roger Lopez
No comments:
Post a Comment