
Oracle Database Administration Fundamentals II
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.
Course content
Welcome6 lessons
Introducing Oracle Net Services15 lessons
- What is Oracle Net Services?1:401 credit or ad
- Three Basic Configurations2:411 credit or ad
- Managing Oracle Database Networks3:151 credit or ad
- Local Versus Centralized Naming2:571 credit or ad
- Simple Server Configuration3:121 credit or ad
- Oracle Shared Servers or MTS pt. 10:511 credit or ad
- Oracle Shared Servers or MTS pt. 20:431 credit or ad
- Simple Client Configuration3:311 credit or ad
- Connection Profiles3:171 credit or ad
- Introducing Naming Options pt. 11:231 credit or ad
- Introducing Naming Options pt. 23:411 credit or ad
- Oracle Connection Manager1:191 credit or ad
- Net Configuration Assistant2:011 credit or ad
- Net Manager1:161 credit or ad
- Using Oracle Enterprise Manager0:551 credit or ad
Introducing Backup/Recovery Options/Utilities13 lessons
- Different Backup and Recovery Options4:461 credit or ad
- Import and Export1:451 credit or ad
- Cold Backups (Offline)2:361 credit or ad
- Hot Tablespace Backups (Online)2:261 credit or ad
- RMAN or Recovery Manager3:401 credit or ad
- Recovery2:481 credit or ad
- Standby Databases3:401 credit or ad
- Physical Standby Databases0:441 credit or ad
- Logical Standby Databases1:341 credit or ad
- Replication1:491 credit or ad
- Replication by Other Means1:231 credit or ad
- What are Transportable Tablespaces?1:211 credit or ad
- What is SQL*Loader?2:111 credit or ad
Oracle Net Services Architecture7 lessons
- Oracle Net Services Architecture1:011 credit or ad
- The Open Systems Interconnection (OSI) Model5:341 credit or ad
- Oracle OSI Model4:161 credit or ad
- Protocols4:391 credit or ad
- Net Services Communication2:231 credit or ad
- Dedicated and Shared Connections3:081 credit or ad
- Shared Server Processes and Dispatchers2:501 credit or ad
Configuring a Simple Connection7 lessons
- The Listener Configuration File3:091 credit or ad
- The TNS Names Configuration File2:161 credit or ad
- The Profile Parameters File1:021 credit or ad
- Basic Database Configuration Parameters pt. 13:511 credit or ad
- Basic Database Configuration Parameters pt. 22:381 credit or ad
- Using the Net Configuration Assistant pt. 12:401 credit or ad
- Using the Net Configuration Assistant pt. 21:001 credit or ad
The Listener13 lessons
- What is the Listener? pt. 11:211 credit or ad
- What is the Listener? pt. 20:551 credit or ad
- Basic Listener Configuration3:321 credit or ad
- The Listener Control Utility3:271 credit or ad
- Service Registration1:361 credit or ad
- Listener Queue Size1:401 credit or ad
- Switching Off Listener Logging and Tracing3:031 credit or ad
- Timeouts0:501 credit or ad
- Multiple Listeners pt. 12:451 credit or ad
- Multiple Listeners pt. 22:021 credit or ad
- Connection Load Balancing and Failover3:111 credit or ad
- The Session Data Unit Buffer (SDU)2:401 credit or ad
- Connection Profile Configuration1:461 credit or ad
Connection Strings and Naming Methods8 lessons
Oracle Shared Servers5 lessons
Connection Manager4 lessons
Other Oracle Net Services Utilities1 lessons
Oracle Net Services Advanced Features4 lessons
Oracle Net Services Metadata1 lessons
Backup and Recovery12 lessons
- What is Backup and Recovery?1:511 credit or ad
- Why Backup and Recovery?0:501 credit or ad
- Things to Remember3:021 credit or ad
- Things to Consider with Datafiles0:451 credit or ad
- Redo Logs3:121 credit or ad
- Controlfiles2:411 credit or ad
- Archive Logs0:541 credit or ad
- More Things to Consider3:231 credit or ad
- Yet More Things to Consider2:371 credit or ad
- Importance of Backup and Recovery2:081 credit or ad
- Points of Failure6:191 credit or ad
- Backup Strategy6:361 credit or ad
How Backup and Recovery Works4 lessons
Archive Configuration7 lessons
- Basic Archive Configuration Parameters3:431 credit or ad
- Archive Log Mode Configuration pt. 13:141 credit or ad
- Archive Log Mode Configuration pt. 23:321 credit or ad
- Multiple Archiving Processes3:301 credit or ad
- Multiple Archive Destinations1:551 credit or ad
- Standby Archiving pt. 12:261 credit or ad
- Standby Archiving pt. 23:461 credit or ad
Logical Backups Using Exports7 lessons
Physical Backup/Restore/Recovery8 lessons
- Cold Backups2:591 credit or ad
- Hot Backups4:251 credit or ad
- Verify Backups Using DBVERIFY4:091 credit or ad
- Recovering using Offline Physical Backups1:061 credit or ad
- Recovering using Online Physical Backups6:031 credit or ad
- Read Only Tablespaces1:051 credit or ad
- Incomplete Recovery0:401 credit or ad
- Scripting Hot Backups3:251 credit or ad
RMAN (Recovery Manager)24 lessons
- What is RMAN?3:121 credit or ad
- Repository and Catalog2:251 credit or ad
- The Recovery Catalog1:411 credit or ad
- RMAN Architecture1:361 credit or ad
- What is a Channel?1:181 credit or ad
- Allocating and Releasing Channels1:041 credit or ad
- Creating an RMAN Database2:591 credit or ad
- Creating a Repository2:381 credit or ad
- Connecting to RMAN2:541 credit or ad
- Registering Databases with the Repository2:491 credit or ad
- Viewing the Repository3:001 credit or ad
- Backup Sets1:411 credit or ad
- Types of Backups0:551 credit or ad
- Controlfile Backups1:521 credit or ad
- Datafile Backups1:441 credit or ad
- Tablespace Backups1:111 credit or ad
- Archive Log Backups1:471 credit or ad
- Binary Parameter File Backups0:251 credit or ad
- Database Backups2:591 credit or ad
- Incremental Backups4:061 credit or ad
- Restore and Recovery1:191 credit or ad
- Restore and Recovery in Action4:231 credit or ad
- Scripts and RMAN2:111 credit or ad
- Deleting RMAN Backups4:231 credit or ad
Oracle Enterprise Manager Backup and Recovery6 lessons
Backup and Recovery Metadata1 lessons
Transportable Tablespaces7 lessons
SQL*Loader20 lessons
- What is SQL*Loader?1:311 credit or ad
- The Control File and Complexity1:511 credit or ad
- Input Data File0:351 credit or ad
- Input Data File Structures4:451 credit or ad
- How Rows are Loaded1:311 credit or ad
- Multiple Tables and Formats2:401 credit or ad
- Column Delimiters4:251 credit or ad
- NULL Values1:051 credit or ad
- Load Filtering1:361 credit or ad
- Filler Fields1:281 credit or ad
- Data Types4:261 credit or ad
- Conditional Replacement2:051 credit or ad
- Using SQL2:531 credit or ad
- Generating Data Not in Input Files0:551 credit or ad
- Executing SQL*Loader2:451 credit or ad
- Conventional Versus Direct1:191 credit or ad
- The Parameter File0:531 credit or ad
- A Simple Example Load pt. 14:521 credit or ad
- A Simple Example Load pt. 23:311 credit or ad
- Oracle Enterprise Manager2:091 credit or ad