Cover Image

Oracle RMAN for absolute beginners / Darl Kuhn.

Show other versions (2)

Oracle RMAN for Absolute Beginners is a gentle introduction to the use of Oracle's Recovery Manager software to make backups of an Oracle database, and to restore all or part of a database in the event that data loss occurs. It is often said that a database administrator's #1 job responsib...

Full description

Saved in:
Bibliographic Details
Online Access: Full Text (via O'Reilly/Safari)
Main Author: Kuhn, Darl (Author)
Format: eBook
Language:English
Published: Berkeley, CA : Apress, 2014.
Series:Expert's voice in Oracle.
Subjects:
Oracle (Computer file)
Data recovery (Computer science)
Database management.
Electronic data processing > Backup processing alternatives.
Database management
Electronic data processing > Backup processing alternatives
Table of Contents:
  • Machine generated contents note: ch. 1 Getting Started
  • Connecting to Your Database
  • Establishing OS Variables
  • Using OS Authentication
  • Using a Password File
  • Starting the Database
  • Stopping the Database
  • Summary
  • ch. 2 Files in Support of Backup and Recovery Operations
  • Managing Control Files
  • Viewing Control File Names and Locations
  • Adding a Control File
  • Moving a Control File
  • Removing a Control File
  • Managing Online Redo Logs
  • Displaying Online Redo Log Information
  • Determining the Optimal Size of Online Redo Log Groups
  • Determining the Optimal Number of Redo Log Groups
  • Adding Online Redo Log Groups
  • Resizing and Dropping Online Redo Log Groups
  • Adding Online Redo Log Files to a Group
  • Removing Online Redo Log Files from a Group
  • Moving or Renaming Redo Log Files
  • Implementing Archivelog Mode
  • Making Architectural Decisions
  • Setting the Archive Redo File Location
  • Enabling Archivelog Mode
  • Disabling Archivelog Mode
  • Reacting to a Lack of Disk Space in Your Archive Log Destination
  • Backing Up Archive Redo Log Files
  • Managing Tablespaces and Data files
  • Understanding the First Five
  • Understanding the Need for More
  • Creating Tablespaces
  • Renaming a Tablespace
  • Controlling the Generation of Redo
  • Changing a Tablespace's Write Mode
  • Dropping a Tablespace
  • Using Oracle Managed Files
  • Creating a Bigfile Tablespace
  • Enabling Default Table Compression within a Tablespace
  • Displaying Tablespace Size
  • Altering Tablespace Size
  • Toggling Data Files Offline and Online
  • Renaming or Relocating a Data File
  • Summary
  • ch. 3 User-Managed Backup and Recovery
  • Implementing a Cold-Backup Strategy for a Noarchivelog Mode Database
  • Making a Cold Backup of a Noarchivelog Mode Database
  • Restoring a Cold Backup in Noarchivelog Mode with Online Redo Logs
  • Restoring a Cold Backup in Noarchivelog Mode Without Online Redo Logs
  • Scripting a Cold Backup and Restore
  • Making a Cold Backup of an Archivelog Mode Database
  • Implementing a Hot Backup Strategy
  • Making a Hot Backup
  • Scripting Hot Backups
  • Understanding the Split-Block Issue
  • Understanding the Need for Redo Generated During Backup
  • Understanding That Data Files Are Updated
  • Performing a Complete Recovery of an Archivelog Mode Database
  • Restoring and Recovering with the Database Offline
  • Restoring and Recovering with a Database Online
  • Restoring Control Files
  • Performing an Incomplete Recovery of an Archivelog Mode Database
  • Summary
  • ch. 4 Configuring RMAN
  • Understanding RMAN
  • Starting RMAN
  • RMAN Architectural Decisions
  • 1. Running the RMAN Client Remotely or Locally
  • 2. Specifying the Backup User
  • 3. Using Online or Offline Backups
  • 4. Setting the Archive Redo Log Destination and File Format
  • 5. Configuring the RMAN Backup Location and File Format
  • 6. Setting the Autobackup of the Control File
  • 7. Specifying the Location of the Autobackup of the Control File
  • 8. Backing Up Archive Redo Logs
  • 9. Determining the Location for the Snapshot Control File
  • 10. Using a Recovery Catalog
  • 11. Using a Media Manager
  • 12. Setting the CONTROL_FILE_RECORD_KEEP_TIME Initialization Parameter
  • 13. Configuring RMAN's Backup Retention Policy
  • 14. Configuring the Archive Redo Logs' Deletion Policy
  • 15. Setting the Degree of Parallelism
  • 16. Using Backup Sets or Image Copies
  • 17. Using Incremental Backups
  • 18. Using Incrementally Updated Backups
  • 19. Using Block Change Tracking
  • 20. Configuring Binary Compression
  • 21. Configuring Encryption
  • 22. Configuring Miscellaneous Settings
  • 23. Configuring Informational Output
  • Segueing from Decision to Action
  • Summary
  • ch. 5 RMAN Backups and Reporting
  • Preparing to Run RMAN Backup Commands
  • Setting NLS_DATE_FORMAT
  • Setting ECHO Setting ECHO
  • Showing Variables
  • Running Backups
  • Backing Up the Entire Database
  • Backing Up Tablespaces
  • Backing Up Data Files
  • Backing Up the Control File
  • Backing up the spfile
  • Backing Up Archive Redo Logs
  • Backing Up FRA
  • Excluding Tablespaces from Backups
  • Backing Up Data Files Not Backed Up
  • Skipping Read-Only Tablespaces
  • Skipping Offline or Inaccessible Files
  • Backing Up Large Files in Parallel
  • Adding RMAN Backup Information to the Repository
  • Taking Backups of Pluggable Databases
  • While Connected to the Root Container
  • While Connected to a Pluggable Database
  • Creating Incremental Backups
  • Taking Incremental-Level Backups
  • Making Incrementally Updating Backups
  • Using Block Change Tracking
  • Checking for Corruption in Data Files and Backups
  • Using VALIDATE
  • Using BACKUP ... VALIDATE
  • Using RESTORE ... VALIDATE
  • Using a Recovery Catalog
  • Creating a Recovery Catalog
  • Registering a Target Database
  • Backing Up the Recovery Catalog
  • Synchronizing the Recovery Catalog
  • Recovery Catalog Versions
  • Dropping a Recovery Catalog
  • Logging RMAN Output
  • Redirecting Output to a File
  • Capturing Output with Linux/Unix Logging Commands
  • Logging Output to a File
  • Querying for Output in the Data Dictionary
  • RMAN Reporting
  • Using LIST
  • Using REPORT
  • Using SQL
  • Summary
  • ch. 6 RMAN Restore and Recovery
  • Determining if Media Recovery Is Required
  • Determining What to Restore
  • How the Process Works
  • Using Data Recovery Advisor
  • Using RMAN to Stop/Start Oracle
  • Shutting Down
  • Starting Up
  • Complete Recovery
  • Testing Restore and Recovery
  • Restoring and Recovering the Entire Database
  • Restoring and Recovering Tablespaces
  • Restoring Read-Only Tablespaces
  • Restoring Temporary Tablespaces
  • Restoring and Recovering Data Files
  • Restoring Data Files to Nondefault Locations
  • Performing Block-Level Recovery
  • Restoring a Container Database and Its Associated Pluggable Databases
  • Restoring Archive Redo Log Files
  • Restoring to the Default Location
  • Restoring to a Nondefault Location
  • Restoring a Control File
  • Using a Recovery Catalog
  • Using an Autobackup
  • Specifying a Backup File Name
  • Restoring the spfile
  • Incomplete Recovery
  • Determining the Type of Incomplete Recovery
  • Performing Time-Based Recovery
  • Performing Log Sequence-Based Recovery
  • Performing SCN-Based Recovery
  • Restoring to a Restore Point
  • Restoring Tables to a Previous Point
  • Flashing Back a Table
  • Flashback Table To Before Drop
  • Flashing Back a Table to a Previous Point in Time
  • Flashing Back a Database
  • Restoring and Recovering to Different Server
  • Step 1 Create an RMAN Backup on the Originating Database
  • Step 2 Copy the RMAN Backup to the Destination Server
  • Step 3 Ensure That Oracle Is Installed
  • Step 4 Source the Required OS Variables
  • Step 5 Create an init.ora File for the Database to Be Restored
  • Step 6 Create Any Required Directories for Data Files, Control Files, and Dump/Trace Files
  • Step 7 Start Up the Database in Nomount Mode
  • Step 8 Restore the Control File from the RMAN Backup
  • Step 9 Start Up the Database in Mount Mode
  • Step 10 Make the Control File Aware of the Location of the RMAN Backups
  • Step 11 Rename and Restore the Data Files to Reflect New Directory Locations
  • Step 12 Recover the Database
  • Step 13 Set the New Location for the Online Redo Logs
  • Step 14 Open the Database
  • Step 15 Add the Temp File
  • Step 16 Rename the Database
  • Summary
  • ch.
  • 7 Handling Online Redo Log Failures
  • Determining a Course of Action
  • Restoring After Losing One Member of Multiplexed Group
  • Recovering After Loss of All Members of Inactive Redo Log Group
  • Dropping a Log File Group
  • Recovering After Loss of All Members of Active Redo Log Group
  • Recovering After Loss of All Members of Current Redo Log Group
  • Summary
  • ch. 8 Data Pump
  • Data Pump Architecture
  • Getting Started
  • Taking an Export
  • Importing a Table
  • Using a Parameter File
  • Exporting and Importing with Granularity
  • Exporting and Importing an Entire Database
  • Schema Level
  • Table Level
  • Tablespace Level
  • Transferring Data
  • Exporting and Importing Directly Across the Network
  • Copying Data Files
  • Features for Manipulating Storage
  • Exporting Tablespace Metadata
  • Specifying Different Data File Paths and Names
  • Importing into a Tablespace Different from the Original
  • Changing the Size of Data Files
  • Changing Segment and Storage Attributes
  • Filtering Data and Objects
  • Specifying a Query
  • Exporting a Percentage of the Data
  • Excluding Objects from the Export File
  • Excluding Statistics
  • Including Only Specific Objects in an Export File
  • Exporting Table, Index, Constraint, and Trigger DDL
  • Excluding Objects from Import
  • Including Objects in Import
  • Common Data Pump Tasks
  • Estimating the Size of Export Jobs
  • Listing the Contents of Dump Files
  • Cloning a User
  • Creating a Consistent Export
  • Importing When Objects Already Exist
  • Renaming a Table
  • Remapping Data
  • Suppressing a Log File
  • Using Parallelism
  • Specifying Additional Dump Files
  • Reusing Output File Names
  • Creating a Daily DDL File
  • Compressing Output
  • Changing Table Compression Characteristics on Import
  • Encrypting Data
  • Exporting Views As Tables
  • Disabling Logging of Redo on Import
  • Interactive Command Mode
  • Entering Interactive Command Mode
  • Attaching to a Running Job
  • Stopping and Restarting a Job
  • Terminating a Data Pump Job.
  • Note continued: Monitoring Data Pump Jobs
  • Data Pump Log File
  • Data Dictionary Views
  • Database Alert Log
  • Status Table
  • Interactive Command Mode Status
  • OS Utilities
  • Data Pump Legacy Mode
  • Data Pump Mapping to the exp Utility
  • Data Pump Mapping to the imp Utility
  • Summary.

Similar Items