Sign In

Database Backup and Recovery User's Guide

Opens a new window

Opens a new window

Opens a new window

Opens a new window

Page 4 of 48

Search

Subject

From
Anonymous (or Sign In)

Comments, corrections, and suggestions are forwarded to authors every week. By submitting, you confirm you agree to the terms and conditions. Use the OTN forums Opens a new window for product questions. For support or consulting, file a service request through My Oracle Support.

Thank you for your feedback!

Opens a new window

- best for offline viewing and printing

Share to:

Categories

Home
Master Index
Master Glossary
Data Dictionary
SQL Keywords
Acronyms
Initialization Parameters
Error Messages

4/48

List of Tables

1-1 Feature Comparison of Backup Techniques
2-1 Common Backup Options
2-2 FOR RECOVER OF COPY Options
2-3 LIST Options for Backups
2-4 Additional LIST Options
2-5 REPORT Options
3-1 Components of the RMAN Environment
4-1 Overview of RMAN Database Connections
5-1 Commands to Configure the Default Device Type
5-2 Files in the Fast Recovery Area
5-3 Initialization Parameters for the Fast Recovery Area
5-4 Criteria to Determine an Identical File
5-5 Effect of Redundancy Setting on Backup Optimization
6-1 Channel Control Options
7-1 V$SYSSTAT Statistics
9-1 Sample Archived Redo Log Records
9-2 Effect of Basic Script When Run Daily
9-3 Effect of Advanced Script When Run Daily
10-1 Effects of Daily and Weekly Scripts
10-2 BACKUP ... SKIP Options
11-1 LIST Objects
11-2 Most Common LIST Options
11-3 REPORT Options
12-1 RMAN Deletion Commands
13-1 Typical Recovery Catalog Space Requirements for 1 Year
16-1 Detection, Repair, and Monitoring of Block Corruption
21-1 RMAN TSPITR Entities
21-2 TS_PITR_OBJECTS_TO_BE_DROPPED View
21-3 Order of Precedence for Naming Files
21-4 Default Initialization Parameters for the RMAN-Managed Auxiliary Database
21-5 Initialization Parameters in a User-Managed Auxiliary Database
23-1 Data File Read Buffer Sizing Algorithm
23-2 Columns of V$SESSION_LONGOPS Relevant for RMAN
23-3 Adjusting the Level of Multiplexing
24-1 Types of Message Output
24-2 RMAN Error Message Ranges
24-3 Media Manager Error Message Ranges
24-4 Useful V$ Views for Troubleshooting
25-1 Options to Duplicate PDBs
26-1 Substitution Variables for SET NEWNAME
26-2 Results from SET NEWNAME FOR DATABASE Command
26-3 Initialization Parameters for Oracle Managed Files
26-4 Initialization Parameter Restrictions for Oracle Managed Files
26-5 Auxiliary Instance Initialization Parameters
26-6 Options to Specify Subsets of Tablespaces for the Duplicate Database
27-1 Default Initialization Parameters for the Auxiliary Instance
28-1 CHECK_DB Function Parameters
29-1 Aspects of the Database Important for dd Usage
29-2 Options for dd Command
29-3 Scenarios Involving dd Backups
29-4 OCOPY Options
30-1 User-Managed Restore Operations
30-2 Loss of Archived Redo Logs
30-3 Inconsistencies Between Data Dictionary and Control File
30-4 Media Recovery Problems
30-5 Media Recovery Solutions
30-6 Guidelines for Allowing Recovery to Permit Corrupt Blocks
31-1 Scenarios When Control Files Are Lost
31-2 Options for Creating the Control File
31-3 STATUS Column of V$LOG
31-4 Recovering After the Loss of an Online Redo Log Group

Opens a new window

Page 4 of 48

Opens a new window

About Oracle
Contact Us
Legal Notices
Terms of Use
Your Privacy Rights

Copyright © 2015, Oracle and/or its affiliates. All rights reserved.