|
Course Outline For:
Oracle Database Administration Fundamentals II
Start learning Oracle Database Administration Fundamentals II right away, Free!
Click on the highlighted lesson links below to view the lessons immediately. You will require Quicktime. If you have any problems
viewing the lessons, click here Welcome Introducing Oracle Net Services Introducing Backup/Recovery Options/Utilities More lessons below ...
Would you like to continue? You can have instant access to the rest of this training for just $30.00
|
Oracle Net Services Architecture  Net Services Architecture The Open Systems Interconnection (OSI) Model Oracle OSI Model Protocols Net Services Communication Dedicated and Shared Connections Shared Server Processes and Dispatchers Configuring a Simple Connection Listener Configuration File The TNS Names Configuration File The Profile Parameters File Basic Database Configuration Parameters pt. 1 Basic Database Configuration Parameters pt. 2 Using the Net Configuration Assistant pt. 1 Using the Net Configuration Assistant pt. 2 The Listener What is the Listener? pt. 1 What is the Listener? pt. 2 Basic Listener Configuration The Listener Control Utility Service Registration Listener Queue Size Switching Off Listener Logging and Tracing Timeouts Multiple Listeners pt. 1 Multiple Listeners pt. 2 Connection Load Balancing and Failover The Session Data Unit Buffer (SDU) Connection Profile Configuration Connection Strings and Naming Methods Connection Strings Naming Methods Local Naming Using TNS Host Naming External Naming Directory Naming pt. 1 Directory Naming pt. 2 Oracle Names Server Oracle Shared Servers Multithreaded Server Introducing Dispatchers Dispatchers and Connection Pooling Other Shared Server Parameters Overriding Shared Servers Connection Manager What is Connection Manager? Connection Concentration Multiple Protocol Support Configuring Connection Manager Other Oracle Net Services Utilities Other Oracle Net Services Utilities Oracle Net Services Advanced Features What is TAF? TAF Parameters Configuring TAF Non-Oracle Database Connections Oracle Net Services Metadata Performance Views Backup and Recovery What is Backup and Recovery? Why Backup and Recovery? Things to Remember Things to Consider with Datafiles Redo Logs Controlfiles Archive Logs More Things to Consider Yet More Things to Consider Importance of Backup and Recovery Points of Failure 1312 Backup Strategy How Backup and Recovery Works Processes/Memory Structures/Checkpoints All the Files SCNs Restore and Recovery Archive Configuration Basic Archive Configuration Parameters Archive Log Mode Configuration pt. 1 Archive Log Mode Configuration pt. 2 Multiple Archiving Processes Multiple Archive Destinations Standby Archiving pt. 1 Standby Archiving pt. 2 Logical Backups Using Exports Full Exports and Imports Schemas Multiple Schemas Importing to a Different Schema Tables The Parameter File Export and Import Options Physical Backup/Restore/Recovery Cold Backups Hot Backups Verify Backups Using DBVERIFY Recovering using Offline Physical Backups Recovering using Online Physical Backups Read Only Tablespaces Incomplete Recovery Scripting Hot Backups RMAN (Recovery Manager) What is RMAN? Repository and Catalog The Recovery Catalog RMAN Architecture What is a Channel? Allocating and Releasing Channels Creating an RMAN Database Creating a Repository Connecting to RMAN Registering Databases with the Repository Viewing the Repository Backup Sets Types of Backups Controlfile Backups Datafile Backups Tablespace Backups Archive Log Backups Binary Parameter File Backups Database Backups Incremental Backups Restore and Recovery Restore and Recovery in Action Scripts and RMAN Deleting RMAN Backups Oracle Enterprise Manager Backup and Recovery Configuring Oracle Enterprise Manager Communications Win2K Log on as Batch Job Export Import Backup and Recovery Backup and Recovery Metadata Performance Views Transportable Tablespaces What are Transportable Tablespaces? Uses of Transportable Tablespaces Limitations Tablespace Sets Tablespace Set Verification Transporting a Tablespace Set Plug In SQL*Loader What is SQL*Loader? The Control File and Complexity Input Data File Input Data File Structures How Rows are Loaded Multiple Tables and Formats Column Delimiters NULL Values Load Filtering Filler Fields Data Types Conditional Replacement Using SQL Generating Data Not in Input Files Executing SQL*Loader Conventional Versus Direct The Parameter File A Simple Example Load pt. 1 A Simple Example Load pt. 2 Oracle Enterprise Manager | 
Learn Oracle Database Administration Fundamentals II
