Oracle 9i User-Managed Backup and Recovery Guide (Part No by Ashdown L.

By Ashdown L.

Show description

Read Online or Download Oracle 9i User-Managed Backup and Recovery Guide (Part No A90134-01) (Release 9 0 1) (2001) PDF

Best databases books

Teradata RDBMS SQL/Data Dictionary Quick Reference

This e-book is a short reference for the SQL dialect supported through the Teradata Relational Database administration approach. The e-book is usually a short connection with the supported info description words for the Teradata RDBMS and the knowledge Dictionary. The viewers for this quickly reference is all clients of Teradata SQL who want fast, non-detailed information regarding easy methods to constitution a SQL assertion.

Access Forms & Reports For Dummies

Create queries that make kinds and stories priceless enhance types to entry the information you wish and make stories that make experience! if you happen to notion you needed to use a spreadsheet application to provide reviews and varieties, bet what! entry can prove great-looking varieties and studies that truly convey what is going on together with your information -- if you happen to know the way to invite it well.

Additional info for Oracle 9i User-Managed Backup and Recovery Guide (Part No A90134-01) (Release 9 0 1) (2001)

Sample text

You can use either RMAN or user-managed methods to create backup scripts. If you set persistent configurations using RMAN’s CONFIGURE command, however, then you should not typically need to write extensive scripts. You can regularly run BACKUP DATABASE PLUS ARCHIVELOG. See Also: Oracle9i Recovery Manager User’s Guide and Reference to learn how to create, delete, replace, and print stored scripts Performing Backups Before and After You Make Structural Changes Administrators as well as users make changes to a database.

Table 1–1 describes the version and system requirements for the Oracle backup and recovery methods. 0 and higher Third-party media manager (only if backing up to tape) Operating System Physical All versions Operating system backup utility (for example, UNIX cp) Export Logical All versions N/A Feature Comparison of Backup Methods Besides being limited by system requirements, the backup and recovery solution you choose should be driven by the features that you want. Table 1–2 compares the features of the different backup methods.

Can use archived logs as well as the online logs. ■ Requires explicit invocation by a user. ■ ■ Does not detect media failure (that is, the need to restore a backup) automatically. After a backup has been restored, however, detection of the need to recover it through media recovery is automatic. Has a recovery time governed solely by user policy (for example, frequency of backups, parallel recovery parameters) rather than by Oracle internal mechanisms. The database cannot be opened if any of the online datafiles needs media recovery, nor can a datafile that needs media recovery be brought online until media recovery has been executed.

Download PDF sample

Rated 4.20 of 5 – based on 32 votes