Explore BrainMass

Explore BrainMass

    Recovering crashed and unmirrored centralized multi-user database

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com December 24, 2021, 11:40 pm ad1c9bdddf

    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 ...

    Solution Summary

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