[Oracle] the different types of restorations

Last update on July 31, 2009 12:37 PM by jak58
Published by jak58

[Oracle] the different types of restorations






Your restoration scheme will depends primarily on the backup methodology adopted, it also depends on what the database administrator wants to restore.

The various restorations are:
  • Restoration REDO LOG: online or offline
  • Restoration of Segment Recovery
  • Restoration of Tablespace
  • Restoration of tables
  • Restoring the database fully
  • Restoration of executables
  • Restoration of control files


The restoration may include one or more restorations methods listed above.
Restorations are usually used after physical alterations of file system of the database. The majority of internal errors are resolved automatically by

Oracle via REDO logs, ROLLBACK and data buffers.
Best answers for « the different types of restorations » in :
Types of networks Show Different types of networks Different types of (private) networks are distinguished based on their size (in terms of the number of machines), their data transfer speed, and their reach. Private networks are networks that belong to a single...
The different types of malicious programs Show The different types of malicious programs Malware Spyware Viruses Worms Trojans Keyloggers Dialer Rootkits Malware Regroups viruses, spyware, Trojans, and all sorts of small programs designed to harm your system, steal...
Jack Show Jack The "jack" is without a doubt the most commonly used connector for small-scale audio equipment. Jacks are normally divided into three different types, based on their diameter: 2.5 mm jack: The smallest jack; 3.5 mm jack: The traditional jack,...
How to crimp a cable RJ45 ? ShowHow to crimp a cable RJ45 ? What you need? How to proceed? Making a straight cable The standard EIA / TIA 568 (A & B) For crossover cable 10/100baseT To complete crossover cable or cross gigabit On Gbic 1000BaseT eg An image to better...
Identify the connectors of the power supply ShowIdentify the connectors of the power supply Connectors Notes A quick guide, allowing you to identify the different types of connectors of the power supply of your PC Description of the label The reference on...
Install FreeNX server ShowInstall FreeNX server Instruction for installation Clients NX NX is a system that enables you to access your desktop from another computer over the internet. There exist different types of NX server: NX Server and 2X for...
Download Multiple Database Query Analyzer Show
Download Sleep Moon Xpress ShowDescription: Sleep Moon Xpress is a powerful tool for automating tasks. Features: The application features alarm, logging, automatic shutdown, synchronization and much more. Advantages: There are 4 different types of triggers for action that...
Download GS-Base ShowIf you are in search of a customizable database, GS-Base can fulfill your desire. GS-base is a powerful database which can store thousands of folders, fields and tables in a single file. With this base, the management of your different types of...
Types of computers ShowTypes of computers There are several families of computers, depending on their format: Mainframes, computers which a great deal of computing power, enormous input-output capabilities and high level of reliability. Mainframes are used by large...
Data transmission - Cabling ShowCabling types Several physical data-transmission media are available to connect together the various devices on a network. One possibility is to use cables. There are many types of cables, but the most common are: Coaxial cable Double twisted...
Types of connectors Show5-pin DIN plugs A DIN (or DIN5) connector is a plug with 5 pins, formerly used to connect keyboards to computers: The DIN5 connector has been made obsolete by PS/2 and USB connectors. Pins Pin number Function 1 Reset...
They need your help