Download Oracle 8i Backup Guide PDF

Read Online or Download Oracle 8i Backup Guide PDF

Best databases books

Database Design: Know It All

This booklet brings all the parts of database layout jointly in one quantity, saving the reader the time and cost of creating a number of purchases. It consolidates either introductory and complicated issues, thereby protecting the gamut of database layout method ? from ER and UML ideas, to conceptual facts modeling and desk transformation, to storing XML and querying relocating items databases.

Oracle Call Interface. Programmer's Guide

The Oracle name Interface (OCI) is an program programming interface (API) that enables functions written in С or C++ to have interaction with a number of Oracle database servers. OCI offers your courses the aptitude to accomplish the whole diversity of database operations which are attainable with an Oracle database server, together with SQL assertion processing and item manipulation.

Oracle Warehouse Builder 11g: Getting Started

This easy-to-understand instructional covers Oracle Warehouse Builder from the floor up, and faucets into the author's vast event as a software program and database engineer. Written in a peaceful sort with step by step causes, plenty of screenshots are supplied in the course of the e-book. there are various assistance and precious tricks all through that aren't present in the unique documentation.

Additional info for Oracle 8i Backup Guide

Example text

Typically, your only media recovery option is to restore the whole database. You lose all changes made after the last whole database backup. Because no archived redo log is created, no additional administration is necessary. Note: The only time you can recover a database while operating in NOARCHIVELOG mode is when you have not already overwritten the online log files that were current at the time of the most recent backup. See Also: "Managing the Archived Redo Logs" on page 2-14 for more information on archiving redo logs, and Oracle8i Standby Database Concepts and Administration for more information about the standby database option.

To make a consistent database backup current or to take it to a non-current point in time, perform media recovery. If you use a current control file for recovery, Oracle starts media recovery beginning at the lowest checkpoint SCN in the datafile headers. If you use a backup control file, then Oracle starts media recovery using the lowest of the following: the control file SCN and the lowest SCN in the datafile headers. To perform media recovery either apply archived redo logs or, if you are using Recovery Manager, apply incremental backups and/or archived logs.

If you run your database in NOARCHIVELOG mode, only back it up when you have closed it cleanly using the IMMEDIATE or NORMAL options. Inconsistent whole database backups of databases running in NOARCHIVELOG mode are usable only if the redo logs containing the changes made prior to the backup are available when you restore it—an unlikely occurrence. The reason that NOARCHIVELOG inconsistent backups are not recommended is that the datafile headers of the backed up files contain different SCNs (a normal shutdown guarantees the consistency of these SCNs), and because the database is in NOARCHIVELOG mode, no archived redo logs are available to apply the lost 1-18 Oracle8i Backup and Recovery Guide Understanding Basic Backup Strategy changes.

Download PDF sample

Rated 4.45 of 5 – based on 42 votes