By Ashdown L.
This guide is meant for database directors who practice backup and restoration of an Oracle database server.To use this rfile, you want to be aware of the following:■ Relational database strategies and easy database management as defined in Oracle9i Database options and Oracle9i Database Administrator's Guide■ The working method surroundings less than that you are working Oracle"
Read or Download Oracle 9i. Backup and Recovery Concepts PDF
Similar databases books
This publication is a short reference for the SQL dialect supported via the Teradata Relational Database administration procedure. The publication can be a short connection with the supported info description words for the Teradata RDBMS and the information Dictionary. The viewers for this quickly reference is all clients of Teradata SQL who desire speedy, non-detailed information regarding find out how to constitution a SQL assertion.
Create queries that make varieties and reviews worthy boost kinds to entry the knowledge you would like and make studies that make experience! in case you notion you needed to use a spreadsheet application to provide stories and varieties, bet what! entry can end up great-looking kinds and reviews that really express what is going on together with your facts -- in the event you know the way to invite it properly.
- Datenbanksysteme. Eine Einführung
- SAS ACCESS 9.1 Interface to CA-Datacom DB: Reference
- Introduction to Oracle9i - PL SQL Student Guide Vol 2
- Oracle 8i Dev Guide Fundamental
Extra info for Oracle 9i. Backup and Recovery Concepts
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.