Overview of Installing Oracle Database Software and Creating a Database
- Checking Prerequisites
- Deciding on Installation Choices
- Install Options
- Installation Method
- Installation Type
- Software Installation Directories
- Database File Location
- Database Identifiers
- About Advanced Installation
- Installing Oracle Database Software
- Creating and Managing a Database with DBCA
- Starting DBCA
- Creating a Database Using DBCA
- Step Database Templates
- Step Database Identification
- Step Management Options
- Step Database Credentials
- Step Database File Locations
- Step Recovery Configuration
- Step Database Content
- Step Initialization Parameters
- Memory
- Sizing
- Character Sets
- Connection Mode
- Step Database Storage
- Step Creation Options
- Changing the Configuration of a Database Using DBCA
- Deleting a Database Using DBCA
- Managing Templates with DBCA
- Advantages of Using Templates
- Types of Templates
- DBCA Templates Provided by Oracle
- Creating Templates Using DBCA
- Deleting Templates
Getting Started with Database Administration
- Managing Your Database: A Roadmap (these topics can’t be covered practically.will send the doc)
- Introduction to Oracle Enterprise Manager Database Control
- Configuring the Operating System Environment Variables
- Starting and Stopping the Database Control Console Process
- Accessing the Database Home Page
- Granting Access to Database Control for Nonadministrative Users
- Creating Database Control Administrative Users
- Setting Database Control Preferences
- About Database Control Preferences
- Defining Blackout Periods
- Setting Preferred Credentials
- Administering the Database with SQLBased Management Tools
- About SQL
- About SQL*Plus
- Starting SQL*Plus and Connecting to the Database
Configuring the Network Environment
- Understanding Network Configuration
- Oracle Net Listener Configuration
- Client Connections
- Tools for Network Configuration
- Viewing Listener Configuration
- Starting and Stopping the Listener
- Connecting to an Oracle Database from a Client Computer
Managing the Oracle Instance
- Overview of the Oracle Instance and Instance Management
- About Initialization Parameters
- About Background Processes
- About Server and Client Processes
- About Instance Memory Structure
- System Global Area
- Program Global Area
- About Instance Startup and Shutdown
- About Administration Privileges for Startup and Shutdown
- About Instance Startup
- About Instance Shutdown
- 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 the Windows Services Program
- Viewing and Modifying Initialization Parameters
- Managing Memory
- About Memory Management
- Enabling Automatic Memory Management
- Modifying Memory Settings – Automatic Memory Management
- Modifying Memory Settings – Automatic Shared Memory Management
- Modifying Memory Settings – Automatic PGA Memory Management
Managing Database Storage Structures
- About Database Storage Structures
- About Control Files
- About Online Redo Log Files
- About Archived Redo Log Files
- About Rollback Segments
- About Data Files
- About Tablespaces
- Locally Managed Tablespaces
- Tablespace Types
- Tablespace Status
- Autoextend Tablespace
- Encrypted Tablespaces
- About Other Storage Structures
- Viewing Database Storage Structure Information
- Viewing Control File Information
- Viewing Online Redo Log File Information
- Viewing Archived Redo Log File Information
- Viewing Data File Information
- Viewing Tablespace Information
- Performing Common Database Storage Tasks
- Creating a Tablespace vi
- Modifying a Tablespace
- Setting a Tablespace to Automatically Extend
- Changing Space Usage Alert Thresholds for a Tablespace
- Taking a Tablespace Offline
- Dropping a Tablespace
- Reclaiming Unused Space
- Managing the Online Redo Log
- Multiplexing the Online Redo Log
- Switching a Log File
- Viewing Undo Information
Administering User Accounts and Security
- About User Accounts
- About User Privileges and Roles
- About Administrative Accounts and Privileges
- SYS and SYSTEM Users
- SYSDBA and SYSOPER System Privileges
- Administering Roles
- Viewing Roles
- Example: Creating a Role
- Example: Modifying a Role
- Deleting a Role
- Administering Database User Accounts
- Viewing User Accounts
- Example: Creating a User Account
- Creating a New User Account by Duplicating an Existing User Account
- Example: Granting Privileges and Roles to a User Account
- Example: Assigning a Tablespace Quota to a User Account
- Example: Modifying a User Account
- Locking and Unlocking User Accounts
- Expiring a User Password
- Example: Deleting a User Account
- Setting the Database Password Policy
- About Password Policies
- Modifying the Default Password Policy
Managing Schema Objects
- About Schema Objects
- About Schema Object Management Privileges
- Managing Tables
- About Tables
- About Table Types
- About Table Column Attributes
- Data Type
- NOT NULL Column Constraint
- Default Value
- Encryption
- About TableLevel Constraints
- Other Table Creation Considerations
- UserDefined Types and Large Objects (LOBs)
- Partitioned Tables and Indexes
- Physical Storage Attributes
- Compressed Tables
- Viewing Tables
- Viewing Table Data
- Example: Creating a Table
- Modifying Table Attributes
- Example: Adding Table Columns
- Example: Deleting a Table Column
- Example: Adding a New Table Constraint
- Example: Modifying an Existing Table Constraint
- Example: Deleting a Table Constraint
- Example: Loading Data into a Table
- Deleting a Table
- Managing Indexes
- About Indexes
- Indexes and Performance
- Index Attributes
- Viewing Indexes
- Example: Creating an Index
- Example: Deleting an Index
- Managing Views
- About Views
- Displaying Views
- Example: Creating a View
- Example: Deleting a View
- Managing Program Code Stored in the Database
- About Program Code Stored in the Database
- Validating (Compiling) Invalid Schema Objects
- Working with Other Schema Objects
Performing Backup and Recovery
- Overview of Database Backup and Recovery
- Database Backup and Recovery Concepts
- Consistent and Inconsistent Backups
- Media Recovery
- Fast Recovery Area
- RMAN Repository
- Configuring Your Database for Basic Backup and Recovery
- Specifying Credentials for Backup and Recovery Using Database Control
- Planning Space Usage and Location for the Fast Recovery Area
- About the Backup Retention Policy and the Fast Recovery Area
- About the Fast Recovery Area Size
- Configuring Recovery Settings
- Monitoring Fast Recovery Area Usage
- Configuring Backup Settings
- About RMAN Backups
- Configuring Backup Device Settings
- Configuring Backup Policy Settings
- Backing Up Your Database
- RMAN Backup Concepts
- Full Backups of Data Files
- Incremental Backups of Data Files
- Incrementally Updated Backups: Rolling Forward Image Copies of Data Files
- Backup Tags
- Performing and Scheduling Backups Using Database Control
- Performing a Whole Database Backup
- Using the Oracle Suggested Backup Strategy
- About the Oracle Suggested Backup Strategy
- Backing Up Your Database Using the Oracle Suggested Disk Backup Strategy
- Scheduling Miscellaneous Backup Tasks
- Validating Backups and Testing Your Backup Strategy
- Validating Selected Backups
- Validating Backups for Restore Operations
- Displaying Backup Reports
- Managing Backups
- About Backup Management
- CrossChecking Backups
- Deleting Expired Backups
- Marking Backups as Available or Unavailable
- Deleting Obsolete Backups
- Performing Oracle Advised Recovery
- About Data Recovery Advisor
- Using Data Recovery Advisor
- Performing UserDirected Recovery
- Rewinding a Table Using Oracle Flashback Table
- Enabling Row Movement on a Table
- Performing a Flashback Table Operation ix
- Recovering a Dropped Table Using Oracle Flashback Drop
- Dropping a Table
- Retrieving a Dropped Table
- Rewinding a Database Using Oracle Flashback Database
- Restoring and Recovering the Database
- Backup and Recovery: Oracle By Example Series
Database cloning
- Database cloning using the backup
- Database cloning from active database
Dataguard:
- Dataguard setup using db backup
- Dataguard setup from active database
- Difference between physical and logical standby
- Switchover and failover
- Different protection modes
- Dgbroker overview
Overview of Highavailability:
- RAC introduction
- Difference between RAC and standalone database
Performance tuning basics:
- Generating ASH and AWR report
- How to take trace
- Difference performance views DBA_HIST