O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Oracle Database Administration Fundamentals II

Video Description

Oracle Database Administration Fundamentals II is the third in a series of four courses covering Oracle Certification course #1Z0-032, and more. Like the other courses in this series of Oracle Certification titles, this course teaches and demonstrates by example using thoroughly tested examples. In this course, instructor Gavin Powell covers Oracle Net Services, Backup and Recovery including RMAN, Oracle Enterprise Manager, Transportable Tablespaces and SQL*Loader. In addition, there are small sections introducing other Oracle optional features such as Standby databases (both Logical and Physical) plus Replication (both traditional and using Streams). Net Services covers architecture, connection configuration, listener configuration (from basics to connection profiling and load balancing), all the facts about connection strings and Oracle Net Services naming methods, even introducing some advanced features. To get started today, simply click one of the links below.

Table of Contents

  1. Welcome
    1. Welcome 00:01:28
    2. Prerequisites for this Course 00:02:41
    3. About this Course 00:03:41
    4. Oracle Net Services on Technet 00:01:15
    5. Oracle Backup and Recovery on Technet 00:02:04
    6. Other Applicable Technet Options 00:01:39
  2. Introducing Oracle Net Services
    1. What is Oracle Net Services? 00:01:40
    2. Three Basic Configurations 00:02:42
    3. Managing Oracle Database Networks 00:03:15
    4. Local Versus Centralized Naming 00:02:57
    5. Simple Server Configuration 00:03:13
    6. Oracle Shared Servers or MTS pt. 1 00:00:51
    7. Oracle Shared Servers or MTS pt. 2 00:00:43
    8. Simple Client Configuration 00:03:31
    9. Connection Profiles 00:03:17
    10. Introducing Naming Options pt. 1 00:01:23
    11. Introducing Naming Options pt. 2 00:03:42
    12. Oracle Connection Manager 00:01:20
    13. Net Configuration Assistant 00:02:01
    14. Net Manager 00:01:16
    15. Using Oracle Enterprise Manager 00:00:55
  3. Introducing Backup/Recovery Options/Utilities
    1. Different Backup and Recovery Options 00:04:46
    2. Import and Export 00:01:45
    3. Cold Backups (Offline) 00:02:36
    4. Hot Tablespace Backups (Online) 00:02:26
    5. RMAN or Recovery Manager 00:03:41
    6. Recovery 00:02:48
    7. Standby Databases 00:03:40
    8. Physical Standby Databases 00:00:44
    9. Logical Standby Databases 00:01:34
    10. Replication 00:01:50
    11. Replication by Other Means 00:01:24
    12. What are Transportable Tablespaces? 00:01:21
    13. What is SQL*Loader? 00:02:11
  4. Oracle Net Services Architecture
    1. Oracle Net Services Architecture 00:01:01
    2. Open Systems Interconnection (OSI) Model 00:05:35
    3. Oracle OSI Model 00:04:16
    4. Protocols 00:04:39
    5. Net Services Communication 00:02:23
    6. Dedicated and Shared Connections 00:03:08
    7. Shared Server Processes and Dispatchers 00:02:50
  5. Configuring a Simple Connection
    1. The TNS Names Configuration File 00:02:16
    2. The Profile Parameters File 00:01:03
    3. Database Configuration Parameters pt. 1 00:03:51
    4. Database Configuration Parameters pt. 2 00:02:38
    5. Using the Net Configuration Assistant pt. 1 00:02:40
    6. Using the Net Configuration Assistant pt. 2 00:01:01
  6. The Listener
    1. What is the Listener? pt. 1 00:01:21
    2. What is the Listener? pt. 2 00:00:55
    3. Basic Listener Configuration 00:03:32
    4. The Listener Control Utility 00:03:27
    5. Service Registration 00:01:36
    6. Listener Queue Size 00:01:40
    7. Switching Off Listener Logging and Tracing 00:03:03
    8. Timeouts 00:00:50
    9. Multiple Listeners pt. 1 00:02:45
    10. Multiple Listeners pt. 2 00:02:03
    11. Connection Load Balancing and Failover 00:03:11
    12. The Session Data Unit Buffer (SDU) 00:02:40
    13. Connection Profile Configuration 00:01:46
  7. Connection Strings and Naming Methods
    1. Connection Strings 00:01:56
    2. Naming Methods 00:01:57
    3. Local Naming Using TNS 00:01:09
    4. Host Naming 00:01:46
    5. External Naming 00:00:52
    6. Directory Naming pt. 1 00:01:06
    7. Directory Naming pt. 2 00:02:37
    8. Oracle Names Server 00:05:26
  8. Oracle Shared Servers
    1. Multithreaded Server 00:04:32
    2. Introducing Dispatchers 00:01:32
    3. Dispatchers and Connection Pooling 00:02:54
    4. Other Shared Server Parameters 00:01:10
    5. Overriding Shared Servers 00:01:02
  9. Connection Manager
    1. What is Connection Manager? 00:01:40
    2. Connection Concentration 00:01:10
    3. Multiple Protocol Support 00:01:19
    4. Configuring Connection Manager 00:01:47
  10. Other Oracle Net Services Utilities
    1. Other Oracle Net Services Utilities 00:03:19
  11. Oracle Net Services Advanced Features
    1. What is TAF? 00:01:17
    2. TAF Parameters 00:01:47
    3. Configuring TAF 00:01:27
    4. Non-Oracle Database Connections 00:01:50
  12. Oracle Net Services Metadata
    1. Performance Views 00:04:18
  13. Backup and Recovery
    1. What is Backup and Recovery? 00:01:51
    2. Why Backup and Recovery? 00:00:51
    3. Things to Remember 00:03:03
    4. Things to Consider with Datafiles 00:00:45
    5. Redo Logs 00:03:12
    6. Controlfiles 00:02:42
    7. Archive Logs 00:00:54
    8. More Things to Consider 00:03:23
    9. Yet More Things to Consider 00:02:37
    10. Importance of Backup and Recovery 00:02:08
    11. Points of Failure 00:06:19
    12. Backup Strategy 00:06:36
  14. How Backup and Recovery Works
    1. Processes/Memory Structures/Checkpoints 00:02:43
    2. All the Files 00:01:47
    3. SCNs 00:01:50
    4. Restore and Recovery 00:03:26
  15. Archive Configuration
    1. Basic Archive Configuration Parameters 00:03:44
    2. Archive Log Mode Configuration pt. 1 00:03:14
    3. Archive Log Mode Configuration pt. 2 00:03:32
    4. Multiple Archiving Processes 00:03:31
    5. Multiple Archive Destinations 00:01:55
    6. Standby Archiving pt. 1 00:02:26
    7. Standby Archiving pt. 2 00:03:46
  16. Logical Backups Using Exports
    1. Full Exports and Imports 00:04:57
    2. Schemas 00:03:49
    3. Multiple Schemas 00:00:45
    4. Importing to a Different Schema 00:02:20
    5. Tables 00:02:17
    6. The Parameter File 00:01:25
    7. Export and Import Options 00:02:07
  17. Physical Backup/Restore/Recovery
    1. Cold Backups 00:03:00
    2. Hot Backups 00:04:25
    3. Verify Backups Using DBVERIFY 00:04:09
    4. Recovering Using Offline Physical Backups 00:01:06
    5. Recovering Using Online Physical Backups 00:06:03
    6. Read Only Tablespaces 00:01:06
    7. Incomplete Recovery 00:00:41
    8. Scripting Hot Backups 00:03:25
  18. RMAN (Recovery Manager)
    1. What is RMAN? 00:03:12
    2. Repository and Catalog 00:02:24
    3. The Recovery Catalog 00:01:41
    4. RMAN Architecture 00:01:36
    5. What is a Channel? 00:01:18
    6. Allocating and Releasing Channels 00:01:04
    7. Creating an RMAN Database 00:02:59
    8. Creating a Repository 00:02:38
    9. Connecting to RMAN 00:02:54
    10. Registering Databases with the Repository 00:02:50
    11. Viewing the Repository 00:03:00
    12. Backup Sets 00:01:41
    13. Types of Backups 00:00:55
    14. Controlfile Backups 00:01:52
    15. Datafile Backups 00:01:44
    16. Tablespace Backups 00:01:11
    17. Archive Log Backups 00:01:47
    18. Binary Parameter File Backups 00:00:25
    19. Database Backups 00:02:59
    20. Incremental Backups 00:04:06
    21. Restore and Recovery 00:01:19
    22. Restore and Recovery in Action 00:04:23
    23. Scripts and RMAN 00:02:11
    24. Deleting RMAN Backups 00:04:23
  19. Oracle Enterprise Manager Backup and Recovery
    1. Configuring Oracle Enterprise Manager 00:03:51
    2. Communications 00:03:10
    3. Win2K Log on as Batch Job 00:02:14
    4. Export 00:02:37
    5. Import 00:02:11
    6. Backup and Recovery 00:03:57
  20. Backup and Recovery Metadata
    1. Performance Views 00:04:43
  21. Transportable Tablespaces
    1. What are Transportable Tablespaces? 00:01:06
    2. Uses of Transportable Tablespaces 00:02:16
    3. Limitations 00:01:28
    4. Tablespace Sets 00:03:55
    5. Tablespace Set Verification 00:03:39
    6. Transporting a Tablespace Set 00:04:22
    7. Plug In 00:03:46
  22. SQL*Loader
    1. What is SQL*Loader? 00:01:31
    2. The Control File and Complexity 00:01:51
    3. Input Data File 00:00:35
    4. Input Data File Structures 00:04:45
    5. How Rows are Loaded 00:01:31
    6. Multiple Tables and Formats 00:02:40
    7. Column Delimiters 00:04:26
    8. NULL Values 00:01:05
    9. Load Filtering 00:01:36
    10. Filler Fields 00:01:28
    11. Data Types 00:04:26
    12. Conditional Replacement 00:02:05
    13. Using SQL 00:02:53
    14. Generating Data Not in Input Files 00:00:55
    15. Executing SQL*Loader 00:02:46
    16. Conventional Versus Direct 00:01:19
    17. The Parameter File 00:00:53
    18. A Simple Example Load pt. 1 00:04:52
    19. A Simple Example Load pt. 2 00:03:31
    20. Oracle Enterprise Manager 00:02:10
  23. Credits
    1. About this Author 00:02:00