Edit D:\rfid\database\database\doc\server.112\e10897\toc.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html lang="en" xml:lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Language" content="en" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <meta name="robots" content="all" scheme="http://www.robotstxt.org/" /> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = document) - Version 5.1" /> <meta name="Date" content="2009-09-09T22:35:16Z" /> <meta name="doctitle" content="Oracle® Database 2 Day DBA 11g Release 2 (11.2)" /> <meta name="partno" content="E10897-02" /> <meta name="docid" content="ADMQS" /> <link rel="Start" href="../../index.htm" title="Home" type="text/html" /> <link rel="Copyright" href="../../dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="Stylesheet" href="../../dcommon/css/blafdoc.css" title="Default" type="text/css" /> <script type="text/javascript" src="../../dcommon/js/doccd.js"> </script> <link rel="Index" href="index.htm" title="Index" type="text/html" /> <link rel="Next" href="lof.htm" title="Next" type="text/html" /> <link rel="alternate" href="../e10897.pdf" title="PDF version" type="application/pdf" /> <title>Contents</title> </head> <body> <div class="header"> <div class="zz-skip-header"><a name="top" id="top" href="#BEGIN">Skip Headers</a></div> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <tr> <td align="left" valign="top"><b>Oracle® Database 2 Day DBA<br /> 11<i>g</i> Release 2 (11.2)</b><br /> Part Number E10897-02</td> <td valign="bottom" align="right"> <table class="icons oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="196"> <tr> <td align="center" valign="top"><a href="../../index.htm"><img width="24" height="24" src="../../dcommon/gifs/doclib.gif" alt="Go to Documentation Home" /><br /> <span class="icon">Home</span></a></td> <td align="center" valign="top"><a href="../../nav/portal_booklist.htm"><img width="24" height="24" src="../../dcommon/gifs/booklist.gif" alt="Go to Book List" /><br /> <span class="icon">Book List</span></a></td> <td align="center" valign="top"><a href="index.htm"><img width="24" height="24" src="../../dcommon/gifs/index.gif" alt="Go to Index" /><br /> <span class="icon">Index</span></a></td> <td align="center" valign="top"><a href="../../dcommon/html/feedback.htm"><img width="24" height="24" src="../../dcommon/gifs/feedbck2.gif" alt="Go to Feedback page" /><br /> <span class="icon">Contact Us</span></a></td> </tr> </table> </td> </tr> </table> <hr /> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <tr> <td align="left" valign="top"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="49"> <tr> <td align="center" valign="top"><a href="lof.htm"><img width="24" height="24" src="../../dcommon/gifs/rightnav.gif" alt="Go to next page" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </td> <td align="right" valign="top" style="font-size: 90%"><a href="../e10897.pdf">View PDF</a></td> </tr> </table> <a name="BEGIN" id="BEGIN"></a></div> <div class="IND"><!-- End Header --> <h1 class="toc">Contents</h1> <h2 class="tocheader"><a href="lof.htm">List of Figures</a></h2> <h2 class="tocheader"><a href="lot.htm">List of Tables</a></h2> <h2 class="tocheader"><a href="title.htm">Title and Copyright Information</a></h2> <h2 class="tocheader"><a href="preface.htm#sthref2">Preface</a></h2> <ul style="list-style-type:none"> <li><a href="preface.htm#i972205">Audience</a></li> <li><a href="preface.htm#sthref3">Documentation Accessibility</a></li> <li><a href="preface.htm#i972232">Related Documentation</a></li> <li><a href="preface.htm#CHDBJAGI">Conventions</a></li> </ul> <h2 class="tocheader"><a href="intro.htm#CIHHJGJD"><span class="secnum">1</span> Introduction</a></h2> <ul style="list-style-type:none"> <li><a href="intro.htm#BABGFFHA">About This Guide</a> <ul style="list-style-type:none"> <li><a href="intro.htm#sthref7">What This Guide Is Not</a></li> <li><a href="intro.htm#sthref8">How to Use This Guide with Related Material</a></li> </ul> </li> <li><a href="intro.htm#BHCCGABJ">About Oracle Database</a></li> <li><a href="intro.htm#CIHDHEEH">Common Oracle DBA Tasks</a></li> <li><a href="intro.htm#BHCCGJAJ">Tools for Administering the Database</a></li> </ul> <h2 class="tocheader"><a href="install.htm#CHDGJGHB"><span class="secnum">2</span> Installing Oracle Database and Creating a Database</a></h2> <ul style="list-style-type:none"> <li><a href="install.htm#CHDIHEFC">Overview of Installing Oracle Database Software and Creating a Database</a> <ul style="list-style-type:none"> <li><a href="install.htm#CIHBECHA">Checking Prerequisites</a></li> <li><a href="install.htm#CHDIHHJB">Deciding on Installation Choices</a> <ul style="list-style-type:none"> <li><a href="install.htm#CHDICDHE">Install Options</a></li> <li><a href="install.htm#CHDHAFJB">Installation Method</a></li> <li><a href="install.htm#g1110927">Installation Type</a></li> <li><a href="install.htm#CHDIDDBB">Software Installation Directories</a></li> <li><a href="install.htm#CHDHAFHH">Database File Location</a></li> <li><a href="install.htm#CHDCFBDE">Database Identifiers</a></li> <li><a href="install.htm#CBHFDDFE">About Advanced Installation</a></li> </ul> </li> </ul> </li> <li><a href="install.htm#CHDCDIIE">Installing Oracle Database Software</a></li> <li><a href="install.htm#BABEIAID">Creating and Managing a Database with DBCA</a> <ul style="list-style-type:none"> <li><a href="install.htm#BABBBHJB">Starting DBCA</a></li> <li><a href="install.htm#BABCABGJ">Creating a Database Using DBCA</a> <ul style="list-style-type:none"> <li><a href="install.htm#BABGFHDG">Step 2 - Database Templates</a></li> <li><a href="install.htm#BABEFIIF">Step 3 - Database Identification</a></li> <li><a href="install.htm#BABBBJDC">Step 4 - Management Options</a></li> <li><a href="install.htm#BABBGDAJ">Step 5 - Database Credentials</a></li> <li><a href="install.htm#BABEDFCI">Step 6 - Database File Locations</a></li> <li><a href="install.htm#BABGFDAG">Step 7 - Recovery Configuration</a></li> <li><a href="install.htm#BABDHGAI">Step 8 - Database Content</a></li> <li><a href="install.htm#BABJGJFC">Step 9 - Initialization Parameters</a></li> <li><a href="install.htm#CHDFEFFF">Step 10 - Database Storage</a></li> <li><a href="install.htm#BABDBHCI">Step 11 - Creation Options</a></li> </ul> </li> <li><a href="install.htm#BABCBGAE">Changing the Configuration of a Database Using DBCA</a></li> <li><a href="install.htm#BABJIDJI">Deleting a Database Using DBCA</a></li> <li><a href="install.htm#BABEGFCG">Managing Templates with DBCA</a> <ul style="list-style-type:none"> <li><a href="install.htm#sthref96">Advantages of Using Templates</a></li> <li><a href="install.htm#sthref97">Types of Templates</a></li> <li><a href="install.htm#sthref99">DBCA Templates Provided by Oracle</a></li> <li><a href="install.htm#sthref101">Creating Templates Using DBCA</a></li> <li><a href="install.htm#sthref102">Deleting Templates</a></li> </ul> </li> </ul> </li> <li><a href="install.htm#CIHFEJCJ">Installation: Oracle By Example Series</a></li> </ul> <h2 class="tocheader"><a href="em_manage.htm#CACHGFFI"><span class="secnum">3</span> Getting Started with Database Administration</a></h2> <ul style="list-style-type:none"> <li><a href="em_manage.htm#BABDIGDJ">Managing Your Database: A Roadmap</a></li> <li><a href="em_manage.htm#BABCGBJF">Introduction to Oracle Enterprise Manager Database Control</a></li> <li><a href="em_manage.htm#CACHIJDC">Configuring the Operating System Environment Variables</a></li> <li><a href="em_manage.htm#BABBAIHD">Starting and Stopping the Database Control Console Process</a></li> <li><a href="em_manage.htm#BABHJAGE">Accessing the Database Home Page</a></li> <li><a href="em_manage.htm#BABHCDGA">Granting Access to Database Control for Nonadministrative Users</a></li> <li><a href="em_manage.htm#CACFCDBE">Creating Database Control Administrative Users</a></li> <li><a href="em_manage.htm#BABDJJFF">Setting Database Control Preferences</a> <ul style="list-style-type:none"> <li><a href="em_manage.htm#BABEGIII">About Database Control Preferences</a></li> <li><a href="em_manage.htm#g1092839">Defining Blackout Periods</a></li> <li><a href="em_manage.htm#g1092758">Setting Preferred Credentials</a></li> </ul> </li> <li><a href="em_manage.htm#BABGJCIB">Administering the Database with SQL-Based Management Tools</a> <ul style="list-style-type:none"> <li><a href="em_manage.htm#BABICEGA">About SQL</a></li> <li><a href="em_manage.htm#BABCGECF">About SQL*Plus</a></li> <li><a href="em_manage.htm#BABDJBCJ">Starting SQL*Plus and Connecting to the Database</a></li> <li><a href="em_manage.htm#BABGEGFB">About SQL Developer</a></li> </ul> </li> <li><a href="em_manage.htm#CACDGDHG">Getting Started with Oracle Enterprise Manager: Oracle By Example Series</a></li> </ul> <h2 class="tocheader"><a href="network.htm#CHDFHIFE"><span class="secnum">4</span> Configuring the Network Environment</a></h2> <ul style="list-style-type:none"> <li><a href="network.htm#CHDBHJGJ">Understanding Network Configuration</a> <ul style="list-style-type:none"> <li><a href="network.htm#BHCCGBAJ">Oracle Net Listener Configuration</a></li> <li><a href="network.htm#BHCCFDCF">Client Connections</a></li> <li><a href="network.htm#BHCCCFJH">Tools for Network Configuration</a></li> </ul> </li> <li><a href="network.htm#BHCGGHDA">Viewing Listener Configuration</a></li> <li><a href="network.htm#CIHHJEDF">Starting and Stopping the Listener</a></li> <li><a href="network.htm#CIHJHJGJ">Connecting to an Oracle Database from a Client Computer</a></li> <li><a href="network.htm#BABIGFGD">Networking: Oracle By Example Series</a></li> </ul> <h2 class="tocheader"><a href="instance.htm#CACFBJED"><span class="secnum">5</span> Managing the Oracle Instance</a></h2> <ul style="list-style-type:none"> <li><a href="instance.htm#CACEIBFA">Overview of the Oracle Instance and Instance Management</a> <ul style="list-style-type:none"> <li><a href="instance.htm#CACGGCJJ">About Initialization Parameters</a></li> <li><a href="instance.htm#CIHIICAI">About Background Processes</a></li> <li><a href="instance.htm#CIHIEBEB">About Server and Client Processes</a></li> <li><a href="instance.htm#CIHJHIJD">About Instance Memory Structure</a> <ul style="list-style-type:none"> <li><a href="instance.htm#CHDEDFFG">System Global Area</a></li> <li><a href="instance.htm#CHDCBGJH">Program Global Area</a></li> </ul> </li> <li><a href="instance.htm#CIHJIJGE">About Instance Startup and Shutdown</a> <ul style="list-style-type:none"> <li><a href="instance.htm#CHDDECFF">About Administration Privileges for Startup and Shutdown</a></li> <li><a href="instance.htm#CIHEDGEA">About Instance Startup</a></li> <li><a href="instance.htm#CHDCJJIH">About Instance Shutdown</a></li> </ul> </li> </ul> </li> <li><a href="instance.htm#CACCCCBC">Shutting Down and Starting Up the Oracle Instance</a> <ul style="list-style-type:none"> <li><a href="instance.htm#CHDHBIIE">Shutting Down and Starting Up Using Oracle Enterprise Manager Database Control</a></li> <li><a href="instance.htm#CHDEFDDI">Shutting Down and Starting Up Using the Windows Services Program</a></li> </ul> </li> <li><a href="instance.htm#CACDDIID">Viewing and Modifying Initialization Parameters</a></li> <li><a href="instance.htm#CACBFIED">Managing Memory</a> <ul style="list-style-type:none"> <li><a href="instance.htm#CHDHBJDJ">About Memory Management</a></li> <li><a href="instance.htm#CHDGEFIA">Enabling Automatic Memory Management</a></li> <li><a href="instance.htm#CHDBDJAJ">Modifying Memory Settings – Automatic Memory Management</a></li> <li><a href="instance.htm#CHDCBBHF">Modifying Memory Settings – Automatic Shared Memory Management</a></li> <li><a href="instance.htm#CHDBCDCC">Modifying Memory Settings – Automatic PGA Memory Management</a></li> </ul> </li> <li><a href="instance.htm#CIABDFIH">Instances: Oracle By Example Series</a></li> </ul> <h2 class="tocheader"><a href="storage.htm#CHDIFFDC"><span class="secnum">6</span> Managing Database Storage Structures</a></h2> <ul style="list-style-type:none"> <li><a href="storage.htm#CACECHEH">About Database Storage Structures</a> <ul style="list-style-type:none"> <li><a href="storage.htm#CACBFEHH">About Control Files</a></li> <li><a href="storage.htm#CACDFFGG">About Online Redo Log Files</a></li> <li><a href="storage.htm#CACGGFIC">About Archived Redo Log Files</a></li> <li><a href="storage.htm#CACBAJHJ">About Rollback Segments</a></li> <li><a href="storage.htm#CACJHGAA">About Data Files</a></li> <li><a href="storage.htm#CACDCJHD">About Tablespaces</a> <ul style="list-style-type:none"> <li><a href="storage.htm#CACEBGEH">Locally Managed Tablespaces</a></li> <li><a href="storage.htm#CACGHABE">Tablespace Types</a></li> <li><a href="storage.htm#CACGJHJC">Tablespace Status</a></li> <li><a href="storage.htm#CACIHFAE">Autoextend Tablespace</a></li> <li><a href="storage.htm#CHDCGHJF">Encrypted Tablespaces</a></li> </ul> </li> <li><a href="storage.htm#CACIIFCD">About Other Storage Structures</a></li> </ul> </li> <li><a href="storage.htm#CACEABCJ">Viewing Database Storage Structure Information</a> <ul style="list-style-type:none"> <li><a href="storage.htm#CACJBFBD">Viewing Control File Information</a></li> <li><a href="storage.htm#CACFFHCB">Viewing Online Redo Log File Information</a></li> <li><a href="storage.htm#CACBCFDA">Viewing Archived Redo Log File Information</a></li> <li><a href="storage.htm#CACDEIBG">Viewing Data File Information</a></li> <li><a href="storage.htm#CACHCBHF">Viewing Tablespace Information</a></li> </ul> </li> <li><a href="storage.htm#CHDJAAFF">Performing Common Database Storage Tasks</a> <ul style="list-style-type:none"> <li><a href="storage.htm#CHDEHEIG">Creating a Tablespace</a></li> <li><a href="storage.htm#BABDIAAI">Modifying a Tablespace</a> <ul style="list-style-type:none"> <li><a href="storage.htm#CACFHABF">Setting a Tablespace to Automatically Extend</a></li> <li><a href="storage.htm#CACDFDGJ">Changing Space Usage Alert Thresholds for a Tablespace</a></li> <li><a href="storage.htm#CACBJEGH">Taking a Tablespace Offline</a></li> </ul> </li> <li><a href="storage.htm#CACJAJAJ">Dropping a Tablespace</a></li> <li><a href="storage.htm#BABHEBCJ">Reclaiming Unused Space</a> <ul style="list-style-type:none"> <li><a href="storage.htm#BABHGIAG">About Reclaimable Unused Space</a></li> <li><a href="storage.htm#BABDCGBB">About the Segment Advisor</a></li> <li><a href="storage.htm#CACJGCJA">Viewing Segment Advisor Recommendations and Reclaiming Space</a></li> <li><a href="storage.htm#CACIHABF">Running the Segment Advisor Manually</a></li> </ul> </li> </ul> </li> <li><a href="storage.htm#CACDDADD">Managing the Online Redo Log</a> <ul style="list-style-type:none"> <li><a href="storage.htm#CACGBBGJ">Multiplexing the Online Redo Log</a></li> <li><a href="storage.htm#CACCHCJD">Switching a Log File</a></li> </ul> </li> <li><a href="storage.htm#CACJFFJI">Managing Undo Data</a> <ul style="list-style-type:none"> <li><a href="storage.htm#CHDFJHBI">About Undo Data</a></li> <li><a href="storage.htm#BABHGEEH">About Managing Undo Data</a></li> <li><a href="storage.htm#CHDBAEDB">Viewing Undo Information</a></li> <li><a href="storage.htm#BABDJDBF">Computing the Minimum Undo Tablespace Size Using the Undo Advisor</a></li> <li><a href="storage.htm#BABEAIHJ">Changing the Undo Tablespace to a Fixed Size</a></li> </ul> </li> <li><a href="storage.htm#CACHDCBJ">Storage: Oracle By Example Series</a></li> </ul> <h2 class="tocheader"><a href="users_secure.htm#CHDJBHHI"><span class="secnum">7</span> Administering User Accounts and Security</a></h2> <ul style="list-style-type:none"> <li><a href="users_secure.htm#CHDDDEBI">About User Accounts</a></li> <li><a href="users_secure.htm#CHDEBFCC">About User Privileges and Roles</a></li> <li><a href="users_secure.htm#CHDFFCIG">About Administrative Accounts and Privileges</a> <ul style="list-style-type:none"> <li><a href="users_secure.htm#CHDBJCHH">SYS and SYSTEM Users</a></li> <li><a href="users_secure.htm#CHDECEBA">SYSDBA and SYSOPER System Privileges</a></li> </ul> </li> <li><a href="users_secure.htm#CHDBHDCF">Administering Roles</a> <ul style="list-style-type:none"> <li><a href="users_secure.htm#CHDIGAFJ">Viewing Roles</a></li> <li><a href="users_secure.htm#g1101992">Example: Creating a Role</a></li> <li><a href="users_secure.htm#CHDGCEGB">Example: Modifying a Role</a></li> <li><a href="users_secure.htm#BGBEABDI">Deleting a Role</a></li> </ul> </li> <li><a href="users_secure.htm#CHDEBHDE">Administering Database User Accounts</a> <ul style="list-style-type:none"> <li><a href="users_secure.htm#CHDJEBDG">Viewing User Accounts</a></li> <li><a href="users_secure.htm#CHDDCIGA">Example: Creating a User Account</a></li> <li><a href="users_secure.htm#CHDJGCHH">Creating a New User Account by Duplicating an Existing User Account</a></li> <li><a href="users_secure.htm#CHDBDBGI">Example: Granting Privileges and Roles to a User Account</a></li> <li><a href="users_secure.htm#CHDGIACA">Example: Assigning a Tablespace Quota to a User Account</a></li> <li><a href="users_secure.htm#CHDFGCCA">Example: Modifying a User Account</a></li> <li><a href="users_secure.htm#CHDCCDGE">Locking and Unlocking User Accounts</a></li> <li><a href="users_secure.htm#CHDJCIFG">Expiring a User Password</a></li> <li><a href="users_secure.htm#CHDHHGAF">Example: Deleting a User Account</a></li> </ul> </li> <li><a href="users_secure.htm#CHDDADDJ">Setting the Database Password Policy</a> <ul style="list-style-type:none"> <li><a href="users_secure.htm#CHDBAFJD">About Password Policies</a></li> <li><a href="users_secure.htm#CHDIJGHE">Modifying the Default Password Policy</a></li> </ul> </li> <li><a href="users_secure.htm#CFHGEBDE">Users: Oracle By Example Series</a></li> </ul> <h2 class="tocheader"><a href="schema.htm#CFHJAHAA"><span class="secnum">8</span> Managing Schema Objects</a></h2> <ul style="list-style-type:none"> <li><a href="schema.htm#CFHHBEGH">About Schema Objects</a></li> <li><a href="schema.htm#CBBCIEEJ">About Schema Object Management Privileges</a></li> <li><a href="schema.htm#CFHEIBFG">Managing Tables</a> <ul style="list-style-type:none"> <li><a href="schema.htm#CBBGHBEG">About Tables</a> <ul style="list-style-type:none"> <li><a href="schema.htm#CBBHFAJH">About Table Types</a></li> <li><a href="schema.htm#CBBICGAD">About Table Column Attributes</a></li> <li><a href="schema.htm#BGBDDJDG">About Table-Level Constraints</a></li> <li><a href="schema.htm#CBBDGEJE">Other Table Creation Considerations</a></li> </ul> </li> <li><a href="schema.htm#BGBBAHAG">Viewing Tables</a></li> <li><a href="schema.htm#CBBJDBGB">Viewing Table Data</a></li> <li><a href="schema.htm#BEABGHHE">Example: Creating a Table</a></li> <li><a href="schema.htm#CBBJGEIJ">Modifying Table Attributes</a> <ul style="list-style-type:none"> <li><a href="schema.htm#BGBCIIJE">Example: Adding Table Columns</a></li> <li><a href="schema.htm#CBBBHAFJ">Example: Deleting a Table Column</a></li> <li><a href="schema.htm#CBBEEEAJ">Example: Adding a New Table Constraint</a></li> <li><a href="schema.htm#CBBJAFAA">Example: Modifying an Existing Table Constraint</a></li> <li><a href="schema.htm#CBBCDICH">Example: Deleting a Table Constraint</a></li> </ul> </li> <li><a href="schema.htm#CFHGBGCB">Example: Loading Data into a Table</a></li> <li><a href="schema.htm#CBBIAAFF">Deleting a Table</a></li> </ul> </li> <li><a href="schema.htm#BGBDBDFB">Managing Indexes</a> <ul style="list-style-type:none"> <li><a href="schema.htm#CBBCBFJA">About Indexes</a> <ul style="list-style-type:none"> <li><a href="schema.htm#CBBFBHJG">Indexes and Performance</a></li> <li><a href="schema.htm#CBBEBGAD">Index Attributes</a></li> </ul> </li> <li><a href="schema.htm#CBBDDCBC">Viewing Indexes</a></li> <li><a href="schema.htm#CBBHCDHB">Example: Creating an Index</a></li> <li><a href="schema.htm#CBBGHDBG">Example: Deleting an Index</a></li> </ul> </li> <li><a href="schema.htm#BGBICDFE">Managing Views</a> <ul style="list-style-type:none"> <li><a href="schema.htm#CBBCIEFC">About Views</a></li> <li><a href="schema.htm#CBBCGCAJ">Displaying Views</a></li> <li><a href="schema.htm#CBBFFJGA">Example: Creating a View</a></li> <li><a href="schema.htm#CBBBCJGH">Example: Deleting a View</a></li> </ul> </li> <li><a href="schema.htm#CHDHDBID">Managing Program Code Stored in the Database</a> <ul style="list-style-type:none"> <li><a href="schema.htm#CBBBDEBH">About Program Code Stored in the Database</a></li> <li><a href="schema.htm#CBBGDCEF">Validating (Compiling) Invalid Schema Objects</a></li> </ul> </li> <li><a href="schema.htm#BGBBGEBF">Working with Other Schema Objects</a></li> <li><a href="schema.htm#CHDJGIIH">Schemas: Oracle By Example Series</a></li> </ul> <h2 class="tocheader"><a href="backrest.htm#i1004902"><span class="secnum">9</span> Performing Backup and Recovery</a></h2> <ul style="list-style-type:none"> <li><a href="backrest.htm#i1006198">Overview of Database Backup and Recovery</a></li> <li><a href="backrest.htm#CHDHEJBA">Database Backup and Recovery Concepts</a> <ul style="list-style-type:none"> <li><a href="backrest.htm#CHDIJGIJ">Consistent and Inconsistent Backups</a></li> <li><a href="backrest.htm#CHDFIGIE">Media Recovery</a></li> <li><a href="backrest.htm#CHDJABGG">Fast Recovery Area</a></li> <li><a href="backrest.htm#CHDIDCBI">RMAN Repository</a></li> </ul> </li> <li><a href="backrest.htm#i1006225">Configuring Your Database for Basic Backup and Recovery</a> <ul style="list-style-type:none"> <li><a href="backrest.htm#CIHFCDIE">Specifying Credentials for Backup and Recovery Using Database Control</a></li> <li><a href="backrest.htm#CHDEFIHF">Planning Space Usage and Location for the Fast Recovery Area</a> <ul style="list-style-type:none"> <li><a href="backrest.htm#CHDDAIFI">About the Backup Retention Policy and the Fast Recovery Area</a></li> <li><a href="backrest.htm#CHDIEDBA">About the Fast Recovery Area Size</a></li> </ul> </li> <li><a href="backrest.htm#CHDJHFDB">Configuring Recovery Settings</a></li> <li><a href="backrest.htm#CHDDDDEA">Monitoring Fast Recovery Area Usage</a></li> <li><a href="backrest.htm#CHDEHDHC">Configuring Backup Settings</a> <ul style="list-style-type:none"> <li><a href="backrest.htm#CHDBCGGB">About RMAN Backups</a></li> <li><a href="backrest.htm#CHDFAFII">Configuring Backup Device Settings</a></li> <li><a href="backrest.htm#CHDJGJBF">Configuring Backup Policy Settings</a></li> </ul> </li> </ul> </li> <li><a href="backrest.htm#i1006298">Backing Up Your Database</a> <ul style="list-style-type:none"> <li><a href="backrest.htm#CHDBAGGE">RMAN Backup Concepts</a> <ul style="list-style-type:none"> <li><a href="backrest.htm#CHDIJEFE">Full Backups of Data Files</a></li> <li><a href="backrest.htm#CHDCCDIG">Incremental Backups of Data Files</a></li> <li><a href="backrest.htm#CHDDJJAD">Incrementally Updated Backups: Rolling Forward Image Copies of Data Files</a></li> <li><a href="backrest.htm#CHDGACCG">Backup Tags</a></li> </ul> </li> <li><a href="backrest.htm#i1006310">Performing and Scheduling Backups Using Database Control</a> <ul style="list-style-type:none"> <li><a href="backrest.htm#CIHCBBFC">Performing a Whole Database Backup</a></li> <li><a href="backrest.htm#BABFEJGA">Using the Oracle Suggested Backup Strategy</a></li> <li><a href="backrest.htm#CHDHGJBJ">Scheduling Miscellaneous Backup Tasks</a></li> </ul> </li> <li><a href="backrest.htm#BHAGJJGC">Validating Backups and Testing Your Backup Strategy</a> <ul style="list-style-type:none"> <li><a href="backrest.htm#CHDFDJIF">Validating Selected Backups</a></li> <li><a href="backrest.htm#BHAJJHBG">Validating Backups for Restore Operations</a></li> </ul> </li> </ul> </li> <li><a href="backrest.htm#BHAHGCGE">Displaying Backup Reports</a></li> <li><a href="backrest.htm#admqs_backrest_mgbackup">Managing Backups</a> <ul style="list-style-type:none"> <li><a href="backrest.htm#CHDGDGEJ">About Backup Management</a></li> <li><a href="backrest.htm#CHDGIDEE">Cross-Checking Backups</a></li> <li><a href="backrest.htm#CHDIDAFI">Deleting Expired Backups</a></li> <li><a href="backrest.htm#CHDHIEFG">Marking Backups as Available or Unavailable</a></li> <li><a href="backrest.htm#CHDJCHDD">Deleting Obsolete Backups</a></li> </ul> </li> <li><a href="backrest.htm#CHDFJGHE">Performing Oracle Advised Recovery</a> <ul style="list-style-type:none"> <li><a href="backrest.htm#CHDFFGGI">About Data Recovery Advisor</a></li> <li><a href="backrest.htm#CHDCBAID">Using Data Recovery Advisor</a></li> </ul> </li> <li><a href="backrest.htm#CIHHBDDG">Performing User-Directed Recovery</a> <ul style="list-style-type:none"> <li><a href="backrest.htm#CHDDIFGJ">Rewinding a Table Using Oracle Flashback Table</a> <ul style="list-style-type:none"> <li><a href="backrest.htm#CHDFJJJH">Enabling Row Movement on a Table</a></li> <li><a href="backrest.htm#CHDGIIDD">Performing a Flashback Table Operation</a></li> </ul> </li> <li><a href="backrest.htm#CHDBDGHF">Recovering a Dropped Table Using Oracle Flashback Drop</a> <ul style="list-style-type:none"> <li><a href="backrest.htm#CHDBJHIA">Dropping a Table</a></li> <li><a href="backrest.htm#CHDBBAJI">Retrieving a Dropped Table</a></li> </ul> </li> <li><a href="backrest.htm#CHDBHFJG">Rewinding a Database Using Oracle Flashback Database</a></li> <li><a href="backrest.htm#CHDIIIAB">Restoring and Recovering the Database</a></li> </ul> </li> <li><a href="backrest.htm#BHADAIJJ">Backup and Recovery: Oracle By Example Series</a></li> </ul> <h2 class="tocheader"><a href="montune.htm#CHDDAFBD"><span class="secnum">10</span> Monitoring and Tuning the Database</a></h2> <ul style="list-style-type:none"> <li><a href="montune.htm#CHDBIGAD">Proactive Database Monitoring</a> <ul style="list-style-type:none"> <li><a href="montune.htm#CBBGDIBJ">About Alerts</a></li> <li><a href="montune.htm#CHDEBIHB">Performance Self-Diagnostics: Automatic Database Diagnostic Monitor</a></li> <li><a href="montune.htm#CBBCFEDB">Monitoring General Database State and Workload</a></li> <li><a href="montune.htm#CACCIHAB">Managing Alerts</a> <ul style="list-style-type:none"> <li><a href="montune.htm#CBBFIECF">Viewing Metrics and Thresholds</a></li> <li><a href="montune.htm#CBBDGAAA">Setting Metric Thresholds</a></li> <li><a href="montune.htm#CBBGJAFJ">About Responding to Alerts</a></li> <li><a href="montune.htm#CBBCAJGB">Clearing Alerts</a></li> <li><a href="montune.htm#CBBDBJFI">Setting Up Direct Alert Notification</a></li> </ul> </li> </ul> </li> <li><a href="montune.htm#CHDJDDBC">Diagnosing Performance Problems Using ADDM</a> <ul style="list-style-type:none"> <li><a href="montune.htm#CBBJAGFJ">Viewing a Summary of ADDM Performance Findings</a></li> <li><a href="montune.htm#CBBFEBAG">Responding to ADDM Performance Findings</a></li> <li><a href="montune.htm#CBBDAIDI">Running ADDM Manually</a></li> <li><a href="montune.htm#CBBDBGAD">Modifying AWR Snapshot Frequency and Retention</a></li> </ul> </li> <li><a href="montune.htm#CHDGFCFJ">Using Advisors to Optimize Database Performance</a> <ul style="list-style-type:none"> <li><a href="montune.htm#CBBECIIF">About Advisors</a></li> <li><a href="montune.htm#CBBFAEDH">About the SQL Advisors</a></li> <li><a href="montune.htm#CBBFAAFI">About the Automatic SQL Tuning Advisor</a></li> <li><a href="montune.htm#CBBGIBCB">Configuring the Automatic SQL Tuning Advisor</a></li> <li><a href="montune.htm#CBBIBHJJ">Viewing Automatic SQL Tuning Results</a></li> <li><a href="montune.htm#CBBGIAHI">Running the SQL Tuning Advisor</a></li> <li><a href="montune.htm#CHDEAJCC">Running the SQL Access Advisor</a></li> <li><a href="montune.htm#CBBGHHJI">Optimizing Memory Usage with the Memory Advisors</a> <ul style="list-style-type:none"> <li><a href="montune.htm#CBBJDCBB">About the Memory Advisors</a></li> <li><a href="montune.htm#CBBHDIGA">Example: Obtaining Memory Sizing Advice for ASMM</a></li> </ul> </li> </ul> </li> <li><a href="montune.htm#CACJFCDI">Monitoring and Tuning: Oracle By Example Series</a></li> </ul> <h2 class="tocheader"><a href="problems.htm#CHDGJDHG"><span class="secnum">11</span> Investigating, Reporting, and Resolving Problems</a></h2> <ul style="list-style-type:none"> <li><a href="problems.htm#CHDFEDGJ">About Database Problems and Incidents</a></li> <li><a href="problems.htm#CHDJDBCH">Investigating, Reporting, and Resolving a Problem</a> <ul style="list-style-type:none"> <li><a href="problems.htm#CHDFBGHF">Roadmap: Investigating, Reporting, and Resolving a Problem</a></li> <li><a href="problems.htm#CHDBFADF">Task 1 – View Critical Error Alerts in Enterprise Manager</a></li> <li><a href="problems.htm#CHDJBEHD">Task 2 – View Problem Details</a></li> <li><a href="problems.htm#CHDDCGCA">Task 3 – (Optional) Create a Service Request</a></li> <li><a href="problems.htm#CHDCAECH">Task 4 – Package and Upload Diagnostic Data to Oracle Support Services</a></li> <li><a href="problems.htm#CHDFGDGB">Task 5 – Track the Service Request and Implement Any Repairs</a></li> <li><a href="problems.htm#CHDHJHCD">Task 6 – Close Incidents</a></li> </ul> </li> <li><a href="problems.htm#CHDBCHID">Viewing Problems Using the Enterprise Manager Support Workbench</a></li> </ul> <h2 class="tocheader"><a href="software.htm#CHDBJFDC"><span class="secnum">12</span> Managing Oracle Database Software</a></h2> <ul style="list-style-type:none"> <li><a href="software.htm#g1012444">About Software Management and Patch Releases</a></li> <li><a href="software.htm#g1086288">Patching the Oracle Software</a> <ul style="list-style-type:none"> <li><a href="software.htm#g1012460">Determining Your Oracle Database Environment</a></li> <li><a href="software.htm#g1085244">Setting Your My Oracle Support Credentials</a></li> <li><a href="software.htm#BABGJDJA">Configure the Software Library</a></li> <li><a href="software.htm#g1085253">Staging and Applying Patches and Patch Sets</a></li> </ul> </li> <li><a href="software.htm#BABCGAJE">Viewing Critical Patch Advisories</a></li> <li><a href="software.htm#CIHHCEHC">Upgrading a Database</a> <ul style="list-style-type:none"> <li><a href="software.htm#CHDEAJIA">Overview of Database Upgrade Assistant</a></li> <li><a href="software.htm#CHDGHCCI">Database Versions Supported by DBUA</a></li> <li><a href="software.htm#CHDDBDHC">Starting DBUA</a></li> <li><a href="software.htm#BABEAGDG">Upgrading a Database Using DBUA</a></li> </ul> </li> <li><a href="software.htm#CACJFCDZ">Managing Oracle Software: Oracle By Example Series</a></li> </ul> <h2 class="tocheader"><a href="asm.htm#BABCAJCG"><span class="secnum">A</span> Administering Oracle Automatic Storage Management</a></h2> <ul style="list-style-type:none"> <li><a href="asm.htm#CIADJDJF">About Oracle Automatic Storage Management</a></li> <li><a href="asm.htm#CIACIEGC">Overview of Disks, Disk Groups, and Failure Groups</a></li> <li><a href="asm.htm#CIAGIIDJ">Installing Oracle Automatic Storage Management</a></li> <li><a href="asm.htm#CIAFIGDB">Accessing the Oracle Automatic Storage Management Home Page</a> <ul style="list-style-type:none"> <li><a href="asm.htm#BABDHBCH">Accessing the Oracle ASM Home Page on a Single-Instance System</a></li> <li><a href="asm.htm#BABHEIGD">Accessing the Oracle ASM Home Page on an Oracle RAC System</a></li> </ul> </li> <li><a href="asm.htm#BABIBEGJ">Monitoring Disk Group Space Usage</a></li> <li><a href="asm.htm#CIADICDC">Creating a Disk Group</a></li> <li><a href="asm.htm#CIACBDEJ">Dropping a Disk Group</a></li> <li><a href="asm.htm#CIAEDBGF">Adding Disks to a Disk Group</a></li> <li><a href="asm.htm#CIABDHEH">Dropping Disks from a Disk Group</a></li> <li><a href="asm.htm#CIAJDCDF">Backing Up Oracle ASM-Managed Files</a></li> <li><a href="asm.htm#BABHJJID">Oracle Automatic Storage Management: Oracle By Example Series</a></li> </ul> <h2 class="tocheader"><a href="index.htm">Index</a></h2> </div> <!-- class="ind" --> <div class="footer"> <hr /> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="33%" /> <col width="*" /> <col width="33%" /> <tr> <td align="left"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="49"> <tr> <td align="center" valign="top"><a href="lof.htm"><img width="24" height="24" src="../../dcommon/gifs/rightnav.gif" alt="Go to next page" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </td> <td style="font-size: 90%" align="center" class="copyrightlogo"><img width="144" height="18" src="../../dcommon/gifs/oracle.gif" alt="Oracle" /><br /> Copyright © 2004, 2009, Oracle and/or its affiliates. All rights reserved.<br /> <a href="../../dcommon/html/cpyr.htm">Legal Notices</a></td> <td align="right"> <table class="icons oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="196"> <tr> <td align="center" valign="top"><a href="../../index.htm"><img width="24" height="24" src="../../dcommon/gifs/doclib.gif" alt="Go to Documentation Home" /><br /> <span class="icon">Home</span></a></td> <td align="center" valign="top"><a href="../../nav/portal_booklist.htm"><img width="24" height="24" src="../../dcommon/gifs/booklist.gif" alt="Go to Book List" /><br /> <span class="icon">Book List</span></a></td> <td align="center" valign="top"><a href="index.htm"><img width="24" height="24" src="../../dcommon/gifs/index.gif" alt="Go to Index" /><br /> <span class="icon">Index</span></a></td> <td align="center" valign="top"><a href="../../dcommon/html/feedback.htm"><img width="24" height="24" src="../../dcommon/gifs/feedbck2.gif" alt="Go to Feedback page" /><br /> <span class="icon">Contact Us</span></a></td> </tr> </table> </td> </tr> </table> </div> <noscript> <p>Scripting on this page enhances content navigation, but does not change the content in any way.</p> </noscript> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de