Backup and Recovery in Oracle Database
Although the backup Oracle database may be time-consuming, but the fear of loss than the transaction, revenue loss and customer dissatisfaction, this time-consuming and the insignificant. Therefore, the backup Oracle database in today is becoming a backup / storage administrator can do the most important task. Users can look at a few common Oracle backup problems. First of all, back up the Oracle database, including not only the physical data backup (a copy of the database files), but also the backup logical data --- data with the SQL command to export and in the redo log files in the cache that has been submitted and not submitted changes. When the oracle database failure, the need to restore the relevant database files. Recovery operations need to use the redo data will be updated to a new backup point in time, and the database transaction does not roll back to a consistent state before its error-free. If the database or IT system administrators are already using a database s...