Download e-book for kindle: Oracle9i Recovery Manager Reference by Ashdown L.

By Ashdown L.

This advisor comprises command syntax, restoration catalog perspectives descriptions, and comparable reference information regarding the restoration supervisor utility.This handbook is meant for database directors who practice the next tasks:■ again up, fix, and recuperate Oracle databases■ practice upkeep on backups and copies of database filesTo use this record, you want to understand the following:■ Relational database strategies and easy database management as defined in Oracle9i Database suggestions and the Oracle9i Database Administrator's Guide■ simple backup and restoration techniques and techniques as defined within the Oracle9i Backup and restoration Concepts■ simple RMAN suggestions and initiatives as defined in Oracle9i restoration supervisor User's Guide■ The working approach surroundings below that you are working Oracle"

Show description

Read Online or Download Oracle9i Recovery Manager Reference PDF

Best databases books

New PDF release: The New Relational Database Dictionary: Terms, Concepts, and

It doesn't matter what DBMS you're using—Oracle, DB2, SQL Server, MySQL, PostgreSQL—misunderstandings can regularly come up over the appropriate meanings of phrases, misunderstandings which may have a significant influence at the good fortune of your database initiatives. for instance, listed here are a few universal database phrases: characteristic, BCNF, consistency, denormalization, predicate, repeating crew, subscribe to dependency.

Extra info for Oracle9i Recovery Manager Reference

Sample text

If the number of format values is less than the number of copies, then RMAN reuses the format values, starting with the first one. Specify FORMAT in any of these places, listed in order of precedence: 1. The backupSpec clause 2. The BACKUP command 3. The ALLOCATE CHANNEL command 4. The CONFIGURE CHANNEL command If specified in more than one of these places, then RMAN searches for the FORMAT parameter in the order shown. Note that the entire FORMAT string is processed in a port-specific manner by the target instance to derive the final backup piece name.

If SINCE TIME is not specified, then only those files that have never been backed up will be backed up. This option is a convenient way to back up new files after adding them to the database. This clause is a useful way to back up files that were not backed up during a previous aborted backup. For example, you back up the database, but the instance crashes halfway through. You can then restart the backup by using the NOT BACKUP UP clause and avoid backing up those files that you already backed up.

If backing up to disk, then any legal disk filename is allowed, provided it is unique. If you do not specify the FORMAT parameter, RMAN stores the backup pieces in a port-specific directory ($ORACLE_HOME/dbs on UNIX). You can specify up to four FORMAT strings. RMAN uses the second, third, and fourth values only when BACKUP COPIES, SET BACKUP COPIES, or CONFIGURE ... BACKUP COPIES is in effect. When choosing the format for each backup piece, RMAN uses the first format value for copy 1, the second format value for copy 2, and so on.

Download PDF sample

Rated 4.02 of 5 – based on 24 votes