Oracle® Database 2 Day DBA
Oracle® Database 2 Day DBA
Preface
“Preface”
Audience
“Audience”
Documentation Accessibility
“Documentation Accessibility”
Accessibility of Code Examples in Documentation
“Accessibility of Code Examples in Documentation”
Accessibility of Links to External Web Sites in Documentation
“Accessibility of Links to External Web Sites in Documentation”
Access to Oracle Support for Hearing-Impaired Customers
“Access to Oracle Support for Hearing-Impaired Customers”
Related Documentation
“Related Documentation”
Conventions
“Conventions”
Introduction
“Introduction”
About This Guide
“About This Guide”
What This Guide Is Not
“What This Guide Is Not”
How to Use This Guide with Related Material
“How to Use This Guide with Related Material”
About Oracle Database
“About Oracle Database”
Common Oracle DBA Tasks
“Common Oracle DBA Tasks”
Tools for Administering the Database
“Tools for Administering the Database”
Installing Oracle Database and Creating a Database
“Installing Oracle Database and Creating a Database”
Overview of Installing Oracle Database Software and Creating a Database
“Overview of Installing Oracle Database Software and Creating a Database”
Checking Prerequisites
“Checking Prerequisites”
Deciding on Installation Choices
“Deciding on Installation Choices”
Install Options
“Install Options”
Installation Method
“Installation Method”
Installation Type
“Installation Type”
Software Installation Directories
“Software Installation Directories”
Database File Location
“Database File Location”
Database Identifiers
“Database Identifiers”
About Advanced Installation
“About Advanced Installation”
Installing Oracle Database Software
“Installing Oracle Database Software”
To perform a basic installation:
“To perform a basic installation:”
Creating and Managing a Database with DBCA
“Creating and Managing a Database with DBCA”
Starting DBCA
“Starting DBCA”
To start DBCA:
“To start DBCA:”
Creating a Database Using DBCA
“Creating a Database Using DBCA”
To create a database using DBCA:
“To create a database using DBCA:”
Step 2 - Database Templates
“Step 2 - Database Templates”
Step 3 - Database Identification
“Step 3 - Database Identification”
Step 4 - Management Options
“Step 4 - Management Options”
Step 5 - Database Credentials
“Step 5 - Database Credentials”
Step 6 - Database File Locations
“Step 6 - Database File Locations”
Step 7 - Recovery Configuration
“Step 7 - Recovery Configuration”
Step 8 - Database Content
“Step 8 - Database Content”
Step 9 - Initialization Parameters
“Step 9 - Initialization Parameters”
Memory
“Memory”
Sizing
“Sizing”
Character Sets
“Character Sets”
Connection Mode
“Connection Mode”
Step 10 - Database Storage
“Step 10 - Database Storage”
Step 11 - Creation Options
“Step 11 - Creation Options”
Changing the Configuration of a Database Using DBCA
“Changing the Configuration of a Database Using DBCA”
To change the configuration of a database using DBCA:
“To change the configuration of a database using DBCA:”
Deleting a Database Using DBCA
“Deleting a Database Using DBCA”
To delete a database using DBCA:
“To delete a database using DBCA:”
Managing Templates with DBCA
“Managing Templates with DBCA”
Advantages of Using Templates
“Advantages of Using Templates”
Types of Templates
“Types of Templates”
DBCA Template Types
“DBCA Template Types”
DBCA Templates Provided by Oracle
“DBCA Templates Provided by Oracle”
Oracle-Provided DBCA Templates and Their Corresponding Workloads
“Oracle-Provided DBCA Templates and Their Corresponding Workloads”
Creating Templates Using DBCA
“Creating Templates Using DBCA”
To create templates:
“To create templates:”
Deleting Templates
“Deleting Templates”
To delete a template:
“To delete a template:”
Installation: Oracle By Example Series
“Installation: Oracle By Example Series”
Getting Started with Database Administration
“Getting Started with Database Administration”
Managing Your Database: A Roadmap
“Managing Your Database: A Roadmap”
To manage your Oracle database:
“To manage your Oracle database:”
Introduction to Oracle Enterprise Manager Database Control
“Introduction to Oracle Enterprise Manager Database Control”
Database Home Page
“Database Home Page”
Online Help
“Online Help”
Navigation
“Navigation”
Configuring the Operating System Environment Variables
“Configuring the Operating System Environment Variables”
To configure operating system environment variables for your database instance on Linux and UNIX systems:
“To configure operating system environment variables for your database instance on Linux and UNIX systems:”
To configure operating system environment variables for your database instance on Windows systems:
“To configure operating system environment variables for your database instance on Windows systems:”
Starting and Stopping the Database Control Console Process
“Starting and Stopping the Database Control Console Process”
To start or stop, or to view the status of the dbconsole process from the command line:
“To start or stop, or to view the status of the dbconsole process from the command line:”
To start or stop dbconsole as a service on Microsoft Windows:
“To start or stop dbconsole as a service on Microsoft Windows:”
Accessing the Database Home Page
“Accessing the Database Home Page”
To access the Database Home page:
“To access the Database Home page:”
Granting Access to Database Control for Nonadministrative Users
“Granting Access to Database Control for Nonadministrative Users”
Creating Database Control Administrative Users
“Creating Database Control Administrative Users”
To create a Database Control administrative user:
“To create a Database Control administrative user:”
Setting Database Control Preferences
“Setting Database Control Preferences”
About Database Control Preferences
“About Database Control Preferences”
Notification
“Notification”
Blackout Administration
“Blackout Administration”
Preferred Credentials
“Preferred Credentials”
Defining Blackout Periods
“Defining Blackout Periods”
To define a blackout period:
“To define a blackout period:”
Setting Preferred Credentials
“Setting Preferred Credentials”
To set preferred credentials for the database:
“To set preferred credentials for the database:”
Administering the Database with SQL-Based Management Tools
“Administering the Database with SQL-Based Management Tools”
About SQL
“About SQL”
About SQL*Plus
“About SQL*Plus”
Starting SQL*Plus and Connecting to the Database
“Starting SQL*Plus and Connecting to the Database”
To start SQL*Plus and connect to the database from the command line:
“To start SQL*Plus and connect to the database from the command line:”
To start SQL*Plus and connect to the database from the Windows Start menu:
“To start SQL*Plus and connect to the database from the Windows Start menu:”
About SQL Developer
“About SQL Developer”
Getting Started with Oracle Enterprise Manager: Oracle By Example Series
“Getting Started with Oracle Enterprise Manager: Oracle By Example Series”
Configuring the Network Environment
“Configuring the Network Environment”
Understanding Network Configuration
“Understanding Network Configuration”
Oracle Net Listener Configuration
“Oracle Net Listener Configuration”
Client Connections
“Client Connections”
Connect Descriptors
“Connect Descriptors”
Connection Requests
“Connection Requests”
Naming Methods
“Naming Methods”
Tools for Network Configuration
“Tools for Network Configuration”
Net Configuration Assistant
“Net Configuration Assistant”
Oracle Enterprise Manager
“Oracle Enterprise Manager”
Oracle Net Manager
“Oracle Net Manager”
Viewing Listener Configuration
“Viewing Listener Configuration”
To view information about the listener with Database Control:
“To view information about the listener with Database Control:”
To view information about the listener at the command line:
“To view information about the listener at the command line:”
Starting and Stopping the Listener
“Starting and Stopping the Listener”
To stop the listener with Database Control:
“To stop the listener with Database Control:”
To start the listener with Database Control:
“To start the listener with Database Control:”
To start or stop the listener at the command line:
“To start or stop the listener at the command line:”
Connecting to an Oracle Database from a Client Computer
“Connecting to an Oracle Database from a Client Computer”
To connect to an Oracle database from a client computer using easy connect naming:
“To connect to an Oracle database from a client computer using easy connect naming:”
Networking: Oracle By Example Series
“Networking: Oracle By Example Series”
Managing the Oracle Instance
“Managing the Oracle Instance”
Overview of the Oracle Instance and Instance Management
“Overview of the Oracle Instance and Instance Management”
About Initialization Parameters
“About Initialization Parameters”
About Background Processes
“About Background Processes”
Oracle Database Background Processes
“Oracle Database Background Processes”
About Server and Client Processes
“About Server and Client Processes”
About Instance Memory Structure
“About Instance Memory Structure”
System Global Area
“System Global Area”
SGA Components
“SGA Components”
Program Global Area
“Program Global Area”
About Instance Startup and Shutdown
“About Instance Startup and Shutdown”
About Administration Privileges for Startup and Shutdown
“About Administration Privileges for Startup and Shutdown”
About Instance Startup
“About Instance Startup”
About Instance Shutdown
“About Instance Shutdown”
Shutting Down and Starting Up the Oracle Instance
“Shutting Down and Starting Up the Oracle Instance”
Shutting Down and Starting Up Using Oracle Enterprise Manager Database Control
“Shutting Down and Starting Up Using Oracle Enterprise Manager Database Control”
To shut down and start the Oracle instance using Database Control:
“To shut down and start the Oracle instance using Database Control:”
Shutting Down and Starting Up Using the Windows Services Program
“Shutting Down and Starting Up Using the Windows Services Program”
To start or stop Oracle Database services:
“To start or stop Oracle Database services:”
Viewing and Modifying Initialization Parameters
“Viewing and Modifying Initialization Parameters”
To view or modify initialization parameters:
“To view or modify initialization parameters:”
Managing Memory
“Managing Memory”
About Memory Management
“About Memory Management”
Oracle Database Memory Management Modes
“Oracle Database Memory Management Modes”
Enabling Automatic Memory Management
“Enabling Automatic Memory Management”
To enable automatic memory management:
“To enable automatic memory management:”
Modifying Memory Settings – Automatic Memory Management
“Modifying Memory Settings – Automatic Memory Management”
To modify total memory size (new value does not exceed maximum memory size):
“To modify total memory size (new value does not exceed maximum memory size):”
To modify total memory size (new value exceeds maximum memory size):
“To modify total memory size (new value exceeds maximum memory size):”
Modifying Memory Settings – Automatic Shared Memory Management
“Modifying Memory Settings – Automatic Shared Memory Management”
To modify the total SGA memory size:
“To modify the total SGA memory size:”
Modifying Memory Settings – Automatic PGA Memory Management
“Modifying Memory Settings – Automatic PGA Memory Management”
To modify the instance PGA size:
“To modify the instance PGA size:”
Instances: Oracle By Example Series
“Instances: Oracle By Example Series”
Managing Database Storage Structures
“Managing Database Storage Structures”
About Database Storage Structures
“About Database Storage Structures”
Oracle Database Storage Structures
“Oracle Database Storage Structures”
Storage Options
“Storage Options”
About Control Files
“About Control Files”
About Online Redo Log Files
“About Online Redo Log Files”
Online Redo Log Groups and Their Members
“Online Redo Log Groups and Their Members”
About Archived Redo Log Files
“About Archived Redo Log Files”
About Rollback Segments
“About Rollback Segments”
About Data Files
“About Data Files”
About Tablespaces
“About Tablespaces”
Tablespaces and Descriptions
“Tablespaces and Descriptions”
Locally Managed Tablespaces
“Locally Managed Tablespaces”
Tablespace Types
“Tablespace Types”
Tablespace Status
“Tablespace Status”
Autoextend Tablespace
“Autoextend Tablespace”
Encrypted Tablespaces
“Encrypted Tablespaces”
About Other Storage Structures
“About Other Storage Structures”
Initialization Parameter File
“Initialization Parameter File”
Password File
“Password File”
Backup Files
“Backup Files”
Viewing Database Storage Structure Information
“Viewing Database Storage Structure Information”
Viewing Control File Information
“Viewing Control File Information”
To view control file information:
“To view control file information:”
Viewing Online Redo Log File Information
“Viewing Online Redo Log File Information”
To view online redo log file information:
“To view online redo log file information:”
Viewing Archived Redo Log File Information
“Viewing Archived Redo Log File Information”
To view archived redo log file information:
“To view archived redo log file information:”
Viewing Data File Information
“Viewing Data File Information”
To view data file information:
“To view data file information:”
Viewing Tablespace Information
“Viewing Tablespace Information”
To view tablespace information:
“To view tablespace information:”
Performing Common Database Storage Tasks
“Performing Common Database Storage Tasks”
Creating a Tablespace
“Creating a Tablespace”
To create a tablespace:
“To create a tablespace:”
Tablespaces Page
“Tablespaces Page”
Modifying a Tablespace
“Modifying a Tablespace”
Setting a Tablespace to Automatically Extend
“Setting a Tablespace to Automatically Extend”
To set a tablespace to automatically extend:
“To set a tablespace to automatically extend:”
Changing Space Usage Alert Thresholds for a Tablespace
“Changing Space Usage Alert Thresholds for a Tablespace”
To change space usage alert thresholds for tablespaces:
“To change space usage alert thresholds for tablespaces:”
Taking a Tablespace Offline
“Taking a Tablespace Offline”
To take a tablespace offline:
“To take a tablespace offline:”
Dropping a Tablespace
“Dropping a Tablespace”
To drop a tablespace:
“To drop a tablespace:”
Reclaiming Unused Space
“Reclaiming Unused Space”
About Reclaimable Unused Space
“About Reclaimable Unused Space”
About the Segment Advisor
“About the Segment Advisor”
Segment Advisor Recommendations
“Segment Advisor Recommendations”
Viewing Segment Advisor Recommendations and Reclaiming Space
“Viewing Segment Advisor Recommendations and Reclaiming Space”
To view Segment Advisor recommendations and reclaim space:
“To view Segment Advisor recommendations and reclaim space:”
Home Page Space Summary Section
“Home Page Space Summary Section”
Segment Advisor Recommendations Page
“Segment Advisor Recommendations Page”
Recommendation Details for Tablespace Page
“Recommendation Details for Tablespace Page”
Running the Segment Advisor Manually
“Running the Segment Advisor Manually”
Managing the Online Redo Log
“Managing the Online Redo Log”
Multiplexing the Online Redo Log
“Multiplexing the Online Redo Log”
To multiplex the online redo log:
“To multiplex the online redo log:”
Switching a Log File
“Switching a Log File”
To switch a log file:
“To switch a log file:”
Managing Undo Data
“Managing Undo Data”
About Undo Data
“About Undo Data”
Undo Tablespace
“Undo Tablespace”
Undo Retention
“Undo Retention”
About Managing Undo Data
“About Managing Undo Data”
Viewing Undo Information
“Viewing Undo Information”
To view undo information:
“To view undo information:”
Computing the Minimum Undo Tablespace Size Using the Undo Advisor
“Computing the Minimum Undo Tablespace Size Using the Undo Advisor”
To compute the minimum undo tablespace size using the Undo Advisor:
“To compute the minimum undo tablespace size using the Undo Advisor:”
Changing the Undo Tablespace to a Fixed Size
“Changing the Undo Tablespace to a Fixed Size”
To change the undo tablespace to a fixed size:
“To change the undo tablespace to a fixed size:”
Storage: Oracle By Example Series
“Storage: Oracle By Example Series”
Administering User Accounts and Security
“Administering User Accounts and Security”
About User Accounts
“About User Accounts”
Predefined User Accounts
“Predefined User Accounts”
About User Privileges and Roles
“About User Privileges and Roles”
Oracle Database Predefined Roles
“Oracle Database Predefined Roles”
About Administrative Accounts and Privileges
“About Administrative Accounts and Privileges”
SYS and SYSTEM Users
“SYS and SYSTEM Users”
SYSDBA and SYSOPER System Privileges
“SYSDBA and SYSOPER System Privileges”
Administering Roles
“Administering Roles”
Viewing Roles
“Viewing Roles”
Example: Creating a Role
“Example: Creating a Role”
System Privileges Granted to the APPDEV Role
“System Privileges Granted to the APPDEV Role”
Example: Modifying a Role
“Example: Modifying a Role”
Deleting a Role
“Deleting a Role”
Administering Database User Accounts
“Administering Database User Accounts”
Viewing User Accounts
“Viewing User Accounts”
Example: Creating a User Account
“Example: Creating a User Account”
Creating a New User Account by Duplicating an Existing User Account
“Creating a New User Account by Duplicating an Existing User Account”
Example: Granting Privileges and Roles to a User Account
“Example: Granting Privileges and Roles to a User Account”
Example: Assigning a Tablespace Quota to a User Account
“Example: Assigning a Tablespace Quota to a User Account”
Example: Modifying a User Account
“Example: Modifying a User Account”
Locking and Unlocking User Accounts
“Locking and Unlocking User Accounts”
Expiring a User Password
“Expiring a User Password”
Example: Deleting a User Account
“Example: Deleting a User Account”
Setting the Database Password Policy
“Setting the Database Password Policy”
About Password Policies
“About Password Policies”
Modifying the Default Password Policy
“Modifying the Default Password Policy”
Users: Oracle By Example Series
“Users: Oracle By Example Series”
Managing Schema Objects
“Managing Schema Objects”
About Schema Objects
“About Schema Objects”
Naming Schema Objects
“Naming Schema Objects”
The Show SQL Button
“The Show SQL Button”
About Schema Object Management Privileges
“About Schema Object Management Privileges”
Managing Tables
“Managing Tables”
About Tables
“About Tables”
About Table Types
“About Table Types”
About Table Column Attributes
“About Table Column Attributes”
Data Type
“Data Type”
Common Data Types
“Common Data Types”
NOT NULL Column Constraint
“NOT NULL Column Constraint”
Default Value
“Default Value”
Encryption
“Encryption”
About Table-Level Constraints
“About Table-Level Constraints”
Other Table Creation Considerations
“Other Table Creation Considerations”
User-Defined Types and Large Objects (LOBs)
“User-Defined Types and Large Objects (LOBs)”
Partitioned Tables and Indexes
“Partitioned Tables and Indexes”
Physical Storage Attributes
“Physical Storage Attributes”
Compressed Tables
“Compressed Tables”
Viewing Tables
“Viewing Tables”
To view tables:
“To view tables:”
Viewing Table Data
“Viewing Table Data”
To view table data:
“To view table data:”
Example: Creating a Table
“Example: Creating a Table”
To create the PURCHASE_ORDERS table in the NICK schema:
“To create the PURCHASE_ORDERS table in the NICK schema:”
Modifying Table Attributes
“Modifying Table Attributes”
Example: Adding Table Columns
“Example: Adding Table Columns”
To add columns to the PURCHASE_ORDERS table:
“To add columns to the PURCHASE_ORDERS table:”
Example: Deleting a Table Column
“Example: Deleting a Table Column”
To delete the PO_REQUESTOR_NAME column:
“To delete the PO_REQUESTOR_NAME column:”
Example: Adding a New Table Constraint
“Example: Adding a New Table Constraint”
To add a table constraint to the PURCHASE_ORDERS table:
“To add a table constraint to the PURCHASE_ORDERS table:”
Example: Modifying an Existing Table Constraint
“Example: Modifying an Existing Table Constraint”
To disable a constraint for the PURCHASE_ORDERS table:
“To disable a constraint for the PURCHASE_ORDERS table:”
Example: Deleting a Table Constraint
“Example: Deleting a Table Constraint”
To delete a constraint from the PURCHASE_ORDERS table:
“To delete a constraint from the PURCHASE_ORDERS table:”
Example: Loading Data into a Table
“Example: Loading Data into a Table”
To load data into the PURCHASE_ORDERS table:
“To load data into the PURCHASE_ORDERS table:”
Deleting a Table
“Deleting a Table”
To delete a table:
“To delete a table:”
Managing Indexes
“Managing Indexes”
About Indexes
“About Indexes”
Indexes and Performance
“Indexes and Performance”
Index Attributes
“Index Attributes”
Standard (B-tree) and Bitmap
“Standard (B-tree) and Bitmap”
Ascending and Descending
“Ascending and Descending”
Column and Functional
“Column and Functional”
Single-Column and Concatenated
“Single-Column and Concatenated”
Nonpartitioned and Partitioned
“Nonpartitioned and Partitioned”
Viewing Indexes
“Viewing Indexes”
To view indexes:
“To view indexes:”
Example: Creating an Index
“Example: Creating an Index”
To create a supplier index on the SH.PRODUCTS table:
“To create a supplier index on the SH.PRODUCTS table:”
Example: Deleting an Index
“Example: Deleting an Index”
To delete the supplier index on the SH.PRODUCTS table:
“To delete the supplier index on the SH.PRODUCTS table:”
Managing Views
“Managing Views”
About Views
“About Views”
Static Data Dictionary Views
“Static Data Dictionary Views”
Dynamic Performance Views
“Dynamic Performance Views”
Displaying Views
“Displaying Views”
To display views:
“To display views:”
Example: Creating a View
“Example: Creating a View”
To create the KING_VIEW view on the HR.EMPLOYEES table:
“To create the KING_VIEW view on the HR.EMPLOYEES table:”
To test the new KING_VIEW view:
“To test the new KING_VIEW view:”
Example: Deleting a View
“Example: Deleting a View”
To delete the HR.KING_VIEW view:
“To delete the HR.KING_VIEW view:”
Managing Program Code Stored in the Database
“Managing Program Code Stored in the Database”
About Program Code Stored in the Database
“About Program Code Stored in the Database”
Validating (Compiling) Invalid Schema Objects
“Validating (Compiling) Invalid Schema Objects”
To validate schema objects starting from an alert:
“To validate schema objects starting from an alert:”
To validate a schema object starting from an object page:
“To validate a schema object starting from an object page:”
Working with Other Schema Objects
“Working with Other Schema Objects”
Schemas: Oracle By Example Series
“Schemas: Oracle By Example Series”
Performing Backup and Recovery
“Performing Backup and Recovery”
Overview of Database Backup and Recovery
“Overview of Database Backup and Recovery”
Database Backup and Recovery Concepts
“Database Backup and Recovery Concepts”
Consistent and Inconsistent Backups
“Consistent and Inconsistent Backups”
Media Recovery
“Media Recovery”
Fast Recovery Area
“Fast Recovery Area”
RMAN Repository
“RMAN Repository”
Configuring Your Database for Basic Backup and Recovery
“Configuring Your Database for Basic Backup and Recovery”
Specifying Credentials for Backup and Recovery Using Database Control
“Specifying Credentials for Backup and Recovery Using Database Control”
To enter credentials for backup and recovery tasks:
“To enter credentials for backup and recovery tasks:”
Planning Space Usage and Location for the Fast Recovery Area
“Planning Space Usage and Location for the Fast Recovery Area”
About the Backup Retention Policy and the Fast Recovery Area
“About the Backup Retention Policy and the Fast Recovery Area”
About the Fast Recovery Area Size
“About the Fast Recovery Area Size”
Configuring Recovery Settings
“Configuring Recovery Settings”
To configure a fast recovery area and put the database in ARCHIVELOG mode:
“To configure a fast recovery area and put the database in ARCHIVELOG mode:”
Monitoring Fast Recovery Area Usage
“Monitoring Fast Recovery Area Usage”
To monitor available space in the fast recovery area:
“To monitor available space in the fast recovery area:”
Configuring Backup Settings
“Configuring Backup Settings”
About RMAN Backups
“About RMAN Backups”
Configuring Backup Device Settings
“Configuring Backup Device Settings”
To configure backup settings for disk:
“To configure backup settings for disk:”
Configuring Backup Policy Settings
“Configuring Backup Policy Settings”
To configure the backup policy settings:
“To configure the backup policy settings:”
Backing Up Your Database
“Backing Up Your Database”
RMAN Backup Concepts
“RMAN Backup Concepts”
Full Backups of Data Files
“Full Backups of Data Files”
Incremental Backups of Data Files
“Incremental Backups of Data Files”
Incrementally Updated Backups: Rolling Forward Image Copies of Data Files
“Incrementally Updated Backups: Rolling Forward Image Copies of Data Files”
Backup Tags
“Backup Tags”
Performing and Scheduling Backups Using Database Control
“Performing and Scheduling Backups Using Database Control”
Performing a Whole Database Backup
“Performing a Whole Database Backup”
To perform a whole database backup when the database is open:
“To perform a whole database backup when the database is open:”
To perform a whole database backup when the database is closed:
“To perform a whole database backup when the database is closed:”
Using the Oracle Suggested Backup Strategy
“Using the Oracle Suggested Backup Strategy”
About the Oracle Suggested Backup Strategy
“About the Oracle Suggested Backup Strategy”
Backing Up Your Database Using the Oracle Suggested Disk Backup Strategy
“Backing Up Your Database Using the Oracle Suggested Disk Backup Strategy”
To backup your database using the Oracle-suggested disk backup strategy:
“To backup your database using the Oracle-suggested disk backup strategy:”
Scheduling Miscellaneous Backup Tasks
“Scheduling Miscellaneous Backup Tasks”
To schedule miscellaneous backup tasks:
“To schedule miscellaneous backup tasks:”
Validating Backups and Testing Your Backup Strategy
“Validating Backups and Testing Your Backup Strategy”
Validating Selected Backups
“Validating Selected Backups”
To validate selected backups:
“To validate selected backups:”
Validating Backups for Restore Operations
“Validating Backups for Restore Operations”
To verify whether specified database files can be restored:
“To verify whether specified database files can be restored:”
Displaying Backup Reports
“Displaying Backup Reports”
To display backup reports:
“To display backup reports:”
Managing Backups
“Managing Backups”
About Backup Management
“About Backup Management”
Cross-Checking Backups
“Cross-Checking Backups”
To cross-check individual files:
“To cross-check individual files:”
To cross-check all files:
“To cross-check all files:”
Deleting Expired Backups
“Deleting Expired Backups”
To delete expired backups:
“To delete expired backups:”
Marking Backups as Available or Unavailable
“Marking Backups as Available or Unavailable”
To mark backups as available or unavailable:
“To mark backups as available or unavailable:”
Deleting Obsolete Backups
“Deleting Obsolete Backups”
To delete obsolete backups:
“To delete obsolete backups:”
Performing Oracle Advised Recovery
“Performing Oracle Advised Recovery”
About Data Recovery Advisor
“About Data Recovery Advisor”
Using Data Recovery Advisor
“Using Data Recovery Advisor”
To use the Oracle advised recovery strategy:
“To use the Oracle advised recovery strategy:”
Performing User-Directed Recovery
“Performing User-Directed Recovery”
Rewinding a Table Using Oracle Flashback Table
“Rewinding a Table Using Oracle Flashback Table”
Enabling Row Movement on a Table
“Enabling Row Movement on a Table”
To enable row movement on a table:
“To enable row movement on a table:”
Performing a Flashback Table Operation
“Performing a Flashback Table Operation”
To perform the Flashback Table operation:
“To perform the Flashback Table operation:”
Recovering a Dropped Table Using Oracle Flashback Drop
“Recovering a Dropped Table Using Oracle Flashback Drop”
Dropping a Table
“Dropping a Table”
To create and then drop a table:
“To create and then drop a table:”
Retrieving a Dropped Table
“Retrieving a Dropped Table”
To perform the Flashback Drop operation:
“To perform the Flashback Drop operation:”
Rewinding a Database Using Oracle Flashback Database
“Rewinding a Database Using Oracle Flashback Database”
To perform a Flashback Database operation:
“To perform a Flashback Database operation:”
Restoring and Recovering the Database
“Restoring and Recovering the Database”
To restore and recover the entire database:
“To restore and recover the entire database:”
Backup and Recovery: Oracle By Example Series
“Backup and Recovery: Oracle By Example Series”
Monitoring and Tuning the Database
“Monitoring and Tuning the Database”
Proactive Database Monitoring
“Proactive Database Monitoring”
About Alerts
“About Alerts”
Performance Self-Diagnostics: Automatic Database Diagnostic Monitor
“Performance Self-Diagnostics: Automatic Database Diagnostic Monitor”
Monitoring General Database State and Workload
“Monitoring General Database State and Workload”
Database Home Page
“Database Home Page”
To monitor the general database state and workload:
“To monitor the general database state and workload:”
To view database performance over time:
“To view database performance over time:”
Managing Alerts
“Managing Alerts”
Viewing Metrics and Thresholds
“Viewing Metrics and Thresholds”
To view metrics for your database:
“To view metrics for your database:”
Alerts Section of Database Home Page
“Alerts Section of Database Home Page”
Setting Metric Thresholds
“Setting Metric Thresholds”
To set metric thresholds:
“To set metric thresholds:”
About Responding to Alerts
“About Responding to Alerts”
Clearing Alerts
“Clearing Alerts”
To clear or purge an alert:
“To clear or purge an alert:”
Setting Up Direct Alert Notification
“Setting Up Direct Alert Notification”
To set up your e-mail information:
“To set up your e-mail information:”
Diagnosing Performance Problems Using ADDM
“Diagnosing Performance Problems Using ADDM”
Viewing a Summary of ADDM Performance Findings
“Viewing a Summary of ADDM Performance Findings”
To view a summary of ADDM performance findings:
“To view a summary of ADDM performance findings:”
Responding to ADDM Performance Findings
“Responding to ADDM Performance Findings”
To respond to ADDM performance findings:
“To respond to ADDM performance findings:”
Running ADDM Manually
“Running ADDM Manually”
To run ADDM manually:
“To run ADDM manually:”
Modifying AWR Snapshot Frequency and Retention
“Modifying AWR Snapshot Frequency and Retention”
To modify AWR snapshot frequency and retention:
“To modify AWR snapshot frequency and retention:”
Using Advisors to Optimize Database Performance
“Using Advisors to Optimize Database Performance”
About Advisors
“About Advisors”
Performance Advisors
“Performance Advisors”
Other Advisors
“Other Advisors”
About the SQL Advisors
“About the SQL Advisors”
SQL Tuning Advisor
“SQL Tuning Advisor”
SQL Access Advisor
“SQL Access Advisor”
Statement Tuning and Workload Tuning
“Statement Tuning and Workload Tuning”
About the Automatic SQL Tuning Advisor
“About the Automatic SQL Tuning Advisor”
Configuring the Automatic SQL Tuning Advisor
“Configuring the Automatic SQL Tuning Advisor”
To configure the Automatic SQL Tuning Advisor:
“To configure the Automatic SQL Tuning Advisor:”
Viewing Automatic SQL Tuning Results
“Viewing Automatic SQL Tuning Results”
To view automatic SQL tuning results:
“To view automatic SQL tuning results:”
Running the SQL Tuning Advisor
“Running the SQL Tuning Advisor”
To run the SQL Tuning Advisor:
“To run the SQL Tuning Advisor:”
Running the SQL Access Advisor
“Running the SQL Access Advisor”
To run the SQL Access Advisor:
“To run the SQL Access Advisor:”
Optimizing Memory Usage with the Memory Advisors
“Optimizing Memory Usage with the Memory Advisors”
About the Memory Advisors
“About the Memory Advisors”
Example: Obtaining Memory Sizing Advice for ASMM
“Example: Obtaining Memory Sizing Advice for ASMM”
To obtain memory sizing advice for ASMM:
“To obtain memory sizing advice for ASMM:”
SGA Size Advice
“SGA Size Advice”
Monitoring and Tuning: Oracle By Example Series
“Monitoring and Tuning: Oracle By Example Series”
Investigating, Reporting, and Resolving Problems
“Investigating, Reporting, and Resolving Problems”
About Database Problems and Incidents
“About Database Problems and Incidents”
Investigating, Reporting, and Resolving a Problem
“Investigating, Reporting, and Resolving a Problem”
Roadmap: Investigating, Reporting, and Resolving a Problem
“Roadmap: Investigating, Reporting, and Resolving a Problem”
Workflow for Investigating, Reporting, and Resolving a Problem
“Workflow for Investigating, Reporting, and Resolving a Problem”
Task 1 – View Critical Error Alerts in Enterprise Manager
“Task 1 – View Critical Error Alerts in Enterprise Manager”
To view critical error alerts:
“To view critical error alerts:”
Task 2 – View Problem Details
“Task 2 – View Problem Details”
To view problem details:
“To view problem details:”
Task 3 – (Optional) Create a Service Request
“Task 3 – (Optional) Create a Service Request”
To create a service request:
“To create a service request:”
Task 4 – Package and Upload Diagnostic Data to Oracle Support Services
“Task 4 – Package and Upload Diagnostic Data to Oracle Support Services”
To package and upload diagnostic data to Oracle Support:
“To package and upload diagnostic data to Oracle Support:”
Task 5 – Track the Service Request and Implement Any Repairs
“Task 5 – Track the Service Request and Implement Any Repairs”
Oracle Advisors that Help Repair Critical Errors
“Oracle Advisors that Help Repair Critical Errors”
Task 6 – Close Incidents
“Task 6 – Close Incidents”
To close incidents:
“To close incidents:”
Viewing Problems Using the Enterprise Manager Support Workbench
“Viewing Problems Using the Enterprise Manager Support Workbench”
To access the Support Workbench home page:
“To access the Support Workbench home page:”
To view details for a particular problem:
“To view details for a particular problem:”
Managing Oracle Database Software
“Managing Oracle Database Software”
About Software Management and Patch Releases
“About Software Management and Patch Releases”
Patching the Oracle Software
“Patching the Oracle Software”
Determining Your Oracle Database Environment
“Determining Your Oracle Database Environment”
To determine the Oracle Database version:
“To determine the Oracle Database version:”
To determine the location of your Oracle home:
“To determine the location of your Oracle home:”
To view information about your hardware configuration:
“To view information about your hardware configuration:”
Setting Your My Oracle Support Credentials
“Setting Your My Oracle Support Credentials”
To set your My Oracle Support login credentials:
“To set your My Oracle Support login credentials:”
Configure the Software Library
“Configure the Software Library”
To configure the Software Library before using the Patch Interface of Database Control:
“To configure the Software Library before using the Patch Interface of Database Control:”
Staging and Applying Patches and Patch Sets
“Staging and Applying Patches and Patch Sets”
To stage and apply patches and patch sets using the Patching wizard:
“To stage and apply patches and patch sets using the Patching wizard:”
Viewing Critical Patch Advisories
“Viewing Critical Patch Advisories”
To view the critical patch advisories and other recommended patches:
“To view the critical patch advisories and other recommended patches:”
Upgrading a Database
“Upgrading a Database”
Overview of Database Upgrade Assistant
“Overview of Database Upgrade Assistant”
Pre-Upgrade Checks
“Pre-Upgrade Checks”
Automated Upgrade Tasks
“Automated Upgrade Tasks”
Support for Oracle Real Application Clusters
“Support for Oracle Real Application Clusters”
About Upgrading Oracle Automatic Storage Management
“About Upgrading Oracle Automatic Storage Management”
Support for Silent Mode
“Support for Silent Mode”
Database Versions Supported by DBUA
“Database Versions Supported by DBUA”
Starting DBUA
“Starting DBUA”
To start DBUA on Microsoft Windows:
“To start DBUA on Microsoft Windows:”
To start DBUA on any supported platform:
“To start DBUA on any supported platform:”
Upgrading a Database Using DBUA
“Upgrading a Database Using DBUA”
To upgrade a database using DBUA:
“To upgrade a database using DBUA:”
Managing Oracle Software: Oracle By Example Series
“Managing Oracle Software: Oracle By Example Series”
Administering Oracle Automatic Storage Management
“Administering Oracle Automatic Storage Management”
About Oracle Automatic Storage Management
“About Oracle Automatic Storage Management”
The Oracle ASM Instance
“The Oracle ASM Instance”
Administering Oracle ASM
“Administering Oracle ASM”
Overview of Disks, Disk Groups, and Failure Groups
“Overview of Disks, Disk Groups, and Failure Groups”
Installing Oracle Automatic Storage Management
“Installing Oracle Automatic Storage Management”
Accessing the Oracle Automatic Storage Management Home Page
“Accessing the Oracle Automatic Storage Management Home Page”
Accessing the Oracle ASM Home Page on a Single-Instance System
“Accessing the Oracle ASM Home Page on a Single-Instance System”
To access the Oracle ASM Home page on a single-instance system:
“To access the Oracle ASM Home page on a single-instance system:”
Accessing the Oracle ASM Home Page on an Oracle RAC System
“Accessing the Oracle ASM Home Page on an Oracle RAC System”
To access the Oracle ASM Home page on an Oracle RAC system:
“To access the Oracle ASM Home page on an Oracle RAC system:”
Monitoring Disk Group Space Usage
“Monitoring Disk Group Space Usage”
To view Oracle Automatic Storage Management (Oracle ASM) disk group usage and free space:
“To view Oracle Automatic Storage Management (Oracle ASM) disk group usage and free space:”
Creating a Disk Group
“Creating a Disk Group”
To create a disk group:
“To create a disk group:”
Dropping a Disk Group
“Dropping a Disk Group”
To drop a disk group:
“To drop a disk group:”
Adding Disks to a Disk Group
“Adding Disks to a Disk Group”
To add one or more disks to a disk group:
“To add one or more disks to a disk group:”
Dropping Disks from a Disk Group
“Dropping Disks from a Disk Group”
To drop one or more disks from a disk group:
“To drop one or more disks from a disk group:”
Backing Up Oracle ASM-Managed Files
“Backing Up Oracle ASM-Managed Files”
Oracle Automatic Storage Management: Oracle By Example Series
“Oracle Automatic Storage Management: Oracle By Example Series”