Purchase Solution

Recovering crashed and unmirrored centralized multi-user database

Not what you're looking for?

Ask Custom Question

A centralized multi-user database has a log file and was backed up yesterday. The hard drive on which the database is stored crashes while being used. The disk was not mirrored. Explain how this database should be recovered. Be specific.

Purchase this Solution
Solution Summary

This response looks at how to recover data from a hard drive which has crashed.

Solution Preview

Backup of data is a process that copies the data. The copy of data contains important parts of the database, including data files that contain user data and server parameter file. The control file contains configuration information.

The main purpose of the backup is a safeguard against unexpected data loss and application errors. For example, the hard drive can fail causing a loss of data files. You can restore a backup of data and reconstruct the lost data files through media recovery. Media recovery refers to the operations involved in restoring, rolling forward, and rolling back a backup of database files.

Oracle Database create files in flash recovery area and deleted files from flash recovery area that are obsolete, redundant, or ...

Purchase this Solution
Free BrainMass Quizzes
C# variables and classes

This quiz contains questions about C# classes and variables.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Basic Networking Questions

This quiz consists of some basic networking questions.

View More Free Quizzes
Related BrainMass Solutions

  • Centralized & distributed models, and pointing devices.

    The database is run on a central server and each part of the centralized database is critical to its overall operation. The biggest disadvantage is the "single point of failure issue" (Quality by Vision, 2012).

  • Distributed Database Architecture

    The prime disadvantages of a distributed database are cost, complexity and security. A distributed system, which hides its distributed nature from the end user, is more complex than a centralized system.

  • What are the Advantages of Client/Server Database Systems?

    It also encourages the separation of user based code and data based code. An additional advantage is that it prevents centralized failure and supports more secure transaction over internet or WAN.

  • the use of databases

    These are used for storage for large multi-user software where it is essential to coordinate the actions of several users.

  • Analyze & Select a DBMS for company

    Bead Bar must ensure security of their database. Since security threats sometimes come from people within an organization and from outside sources database security is essential. 4. Allow for multi-user access 5.

  • Linux versus Windows Server 2003

    Multi-user operating systems have a user account database, which defines the rights that users have on certain resources. Multi-user Operating System A multi-user operating system lets more than one user access the computer system at one time.

  • Multi-User Databases Management

    83382 Multi-User Databases Management 1. Explain the difference between an exclusive lock and a shared lock. 2. Explain the difference between optimistic locking and pessimistic locking. 3. What is deadlock? How can it be avoided?

  • Front-End Application to SQL Server

    A web based user interface can be accessed from any location with centralized database making sales manager at various locations to update the inventory, customer information, demand and supply etc. 3.

  • Information Security Policy Building

    With the successful implementation of a WAN solution, all stores will have the ability to access a centralized database for inventory and dynamically reorder stock based on sales.

View More Related Solutions