By Ashdown L.
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
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.
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.
- Relational Database Design and Implementation: Clearly Explained (3rd Edition)
- CouchDB: The Definitive Guide: Time to Relax
- ACTUALTESTS ORACLE 1Z0-301 EXAMCHEATSHEET V10 14 04
- Microsoft Office Access 2003: professional results
- Oracle 9i. Application Developers Guide - Large Objects (LOBs) using COBOL (Pro COBOL)
- Microsoft Office Access 2007: The Complete Reference
Additional info for Oracle 9i User-Managed Backup and Recovery Guide (Part No A90134-01) (Release 9 0 1) (2001)
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.