Define redo logs, Database Management System

 

 Redo Logs:Any database must have minimum two redo logs. These are the rules for the database; the redo logs record all modifies to the system objects or user objects. If any type of failure happens, modifies recorded in the redo logs may be used to bring the database to a proper state without losing any committed operations. In the case of non-data loss failure, Oracle may accept the information in the redo logs automatically without intervention from the DBA. The redo log files are fixed in shape and size and never show dynamically from the size at which they were prepared.

 

Posted Date: 7/30/2012 3:10:35 AM | Location : United States







Related Discussions:- Define redo logs, Assignment Help, Ask Question on Define redo logs, Get Answer, Expert's Help, Define redo logs Discussions

Write discussion on Define redo logs
Your posts are moderated
Related Questions
What is the difference between SQL Server 2000 complete and differential backups? A complete backup makes a copy of the whole database. A differential backup creates a copy of

Explain Dynamic Two-Phase Locking Here a transaction locks a data item instantly earlier than any operation is applied on the data item.  After finishing all the operations on

Give Concurrent sub states diagram for the classroom and exam held. In Figure, simultaneous substrates have been taken. After passing Minor 1 test you could give Minor 2 test. T

Support by Adding Indexes Multiple indexes can be used to access a data file by multiple access paths. In such a scheme only single copy of the data is consider, only the numbe

What do you mean through integrity constraints? Integrity Constraints -An integrity constraint is a condition specified on a database schema and restricts the data in which

A database is a set of data. But, is the data kept in a database trustworthy? To answer that query we must first answer the question. What is integrity? Integrity simply means t

Define Two phase commit Two phase commit: To make sure atomicity, all the sites where a transaction is being executed must agree on the final outcome of the execution. The tran

You are required to write a report which evaluates two of the following issues in relation to your case study database: a. Security issues b. Performance issues c. Backup


In an organisation various projects are undertaken. Each projects can employ one or more employees. Every employee can work on one or more projects. Each project is undertaken on