Peakin

Menu
Register For Demo Session

Oracle DBA

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