DL DoolyLabs Request Access

Learning Plan

6 Days. From first login
to production discipline.

A structured curriculum covering OpenVMS fundamentals through Oracle Rdb administration — DCL, file security, command procedures, database integrity, backup and recovery, journaling, and live troubleshooting. The same material used in one-on-one mentorship sessions.

6

Days Total

2 + 4

Days: VMS / Rdb

18

Modules Covered

OpenVMS

Day 1 5 modules

No.	Topic	Sub-Topics
01	Introduction to OpenVMS	History of OpenVMS Basic characteristics and configurations of OpenVMS System environment concepts OpenVMS configurations
02	Getting Started	Logging into the system OpenVMS passwords Exiting the system
03	DCL Command Interpreter	Digital Command Language DCL command features Getting online help Getting information from the system
04	Process Concepts	Processes Displaying processes Changing process information
05	Directory and Files	File specification Directory structure

Day 2 4 modules

No.	Topic	Sub-Topics
06	File Manipulation Commands	Confirm and log qualifiers Create, type, append, copy, rename, delete, purge, sort, and merge files Search files Choosing the appropriate editor Editing files
07	File and Directory Security	Definitions Protecting your data UIC-based security More detailed protection using ACLs File encryption
08	Logicals, Symbols	Locality of reference Creating symbols to use command synonyms Using symbols Displaying symbols Creating custom commands Deleting symbols Logical names Using logical name tables
09	Command Procedures	Introduction to command procedures Debugging command procedures Using symbols in command procedures Controlling the flow of execution Lexical functions I/O handling Sending mail from a command procedure Error handling PIPE command

Oracle Rdb Administration

Day 3 3 modules

No.	Topic	Sub-Topics
01	Opening and Closing a Database	Creating the database Domains, datatypes, tables, constraints, triggers, indexes Opening a database Using the RMU Open command Attaching to a database Closing a database Closing a database and using SQL Using the Noabort qualifier to close a database
02	Verifying the Integrity of an Oracle Rdb Database	Why you should verify your database Causes of database corruption What happens when you verify your database What the full verify operation checks What problems the full verify operation can detect Interaction of RMU Verify command qualifiers Measuring and improving verification performance Examples of verify operations on the mf_personnel sample Troubleshooting suspected problems Using a checksum verification to detect page corruption Detecting a data integrity corruption Summary of RMU Verify command qualifiers for troubleshooting
03	Correcting Problems Detected by Verify (Altering a Database)	Attaching to a database Clearing a corruption flag Selecting the area page for altering Displaying page contents Changing page contents Moving database files Moving data Using the RMU Alter command to remove references to RUJ files Verifying alterations Completing transactions Accessing online information

Day 4 1 module

No.	Topic	Sub-Topics
04	Backing Up a Database	Introduction to database backup How Oracle RMU backs up a database Oracle RMU default backup operation Oracle RMU parallel backup operation Invoking the RMU Backup command What Oracle RMU backs up Writing the backup output file Protection Why not use other backup utilities Database backup strategies Determining how frequently you need to back up your database Requirements for using a full and complete backup operation Guidelines for choosing a full versus an incremental backup operation Guidelines for choosing a ByArea backup operation strategy Command qualifiers Guidelines for performing online versus offline backup Guidelines for choosing parallel backup operations Implementing a reliable database backup procedure Recommendations Sample backup procedure Computing working set requirements for OpenVMS Checking the database page checksum during a backup to disk Performing full and complete database backup operations Performing an incremental database backup operation Starting an incremental backup operation Monitoring the progress of a parallel backup operation Performing online backup operations Displaying database backup information

Day 5 2 modules

No.	Topic	Sub-Topics
05	Restoring a Database	Preparing to restore a database Access privileges for a restored database Full database restore operations Incremental restore operations A sample restore procedure Performing ByArea restore operations Performing an online ByArea restore operation on one storage area Performing ByPage restore operations Restoring only the root file from a database backup file Exceeded quotas during a database restore or backup operation Modifying database characteristics during a restore operation Modifying After Image Journaling characteristics Modifying SPAM threshold values Modifying blocks per page Restoring list storage areas to WORM optical or read/write disk devices Performing additional tasks during a restore operation Using an options file to restore a database Creating a duplicate database during a restore operation Moving database files Moving and updating Data Dictionary information Using the SQL EXPORT and IMPORT statements
06	After Image Journaling and Recovery	Introduction Recommended and required usage Information written to the After Image Journal file Journaling strategy Displaying After Image Journaling performance Enabling After Image Journaling Disabling After Image Journaling The After Image Journal (AIJ) file Location and accessibility Extensible and fixed-size journal files Setting the allocation size Setting the extent size for an extensible journal file Backing up After Image Journal files Backup and recovery strategy Disk and tape backup media Reusing disk and tape backup media Scheduling Transaction sequence numbers (TSN) Backup termination or failure Backing up a single extensible journal file Backing up multiple fixed-size journal files Automatic and manual backup operations Writing a customized backup procedure Journal switchover Reasons why After Image Journal file switchover suspends Avoiding journal file switchover suspension Determining if journal file switchover is suspended Resuming After Image Journaling operations Manually performing a full or BySequence After Image Journal backup Adding a new After Image Journal file Recovering the database Recovering transactions from journal files Recovering a lost extensible journal file Recovering a lost fixed-size journal file Displaying the contents of a journal file Example of database backup, recover, and restore journaling

Day 6 3 modules

No.	Topic	Sub-Topics
07	Recovery Unit Journaling and Recovery	The Recovery Unit Journal file Directory location Recovery for update transactions Improving performance of the automatic recovery process Setting the number of database buffers Adjusting the number of recovery buffers
08	Displaying Root Files, Storage Areas, and Snapshot Files	Using the RMU Dump command Data structures Storage areas with uniform page format Storage areas with mixed page format Displaying data storage files Displaying logical areas Displaying snapshot files Snapshot page tail
09	Monitoring and Troubleshooting Oracle Rdb Databases	The Oracle Rdb Monitor process Starting and stopping the Monitor process interactively Renaming the Monitor log file Changing the Monitor process priority Reopening the Monitor log file Reading the Monitor log file Listing active user information Displaying clusterwide user information Displaying database characteristics Troubleshooting

A Note on This Page

This curriculum was cleaned up from the original outline: a missing topic number under Day 3 was restored (the original "Topic 2" actually contained two distinct topics — verifying database integrity, and separately, correcting problems detected by verify — now split into Topics 2 and 3, renumbering Backing Up through 4–9 accordingly), and recurring typos were fixed throughout ("AfterI mage" → "After Image", "FixedSize" → "Fixed-Size", "mf_pe rsonnel" → "mf_personnel", "Buffer s" → "Buffers", "RecoveryUnit" → "Recovery Unit").

Ready to Start?

Six days. One clear path from zero to operational.

Every module above is taught hands-on, in the same lab environments shown elsewhere on this site.

Start a Conversation →