Database Backup Replication with Tape Type Override
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional database backup methods require temporary unavailability of the database system, leading to prolonged downtime and issues with control data alteration or loss during backup creation, especially when creating multiple backups for redundancy or testing purposes. Additionally, existing TAPE-TYPE-OVERRIDE mechanisms fail to effectively manage tape type overrides in replicate commands, particularly for commands using multiple reels or different drive types.
Innovation Solution
A method and system for managing tape-type overrides by determining the type of override command (single or double) and ensuring its proper application, replacing tape type identification based on read or write operations in subsequent commands, and alerting users to override restrictions, allowing for seamless replication and backup operations without interrupting database availability.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If multiple backups are created from the database system, then data safety and redundancy are improved, but database system unavailability is prolonged
Solution Approach 1:
The patent applies preliminary action by creating backups during database unavailability windows and using incremental replication techniques that prepare backup data in advance. The system performs backup operations during scheduled maintenance windows and uses change data capture to replicate only modified records, reducing the time required for each backup operation and allowing multiple backups to be created without proportionally increasing total downtime.
Solution Approach 2:
The patent implements continuity of useful action through incremental backup mechanisms that continue backup operations without requiring complete database shutdowns. The system maintains continuous replication of changed data records and uses streaming backup techniques that allow backup processes to run concurrently with database operations, ensuring that backup creation does not fully interrupt database availability.
2Adaptability or versatility
If TAPE-TYPE-OVERRIDE is applied to both source and destination in replicate commands, then tape compatibility is improved, but drive assignment flexibility is reduced
Solution Approach 1:
The patent applies local quality by enabling selective tape type override application to either source or destination tape devices independently. The system allows different override configurations for source and destination tapes based on specific drive assignments and compatibility requirements, rather than applying the same override to both. This enables flexible drive assignment where source and destination can have different tape types while maintaining compatibility where needed.
Solution Approach 2:
The patent implements dynamics by making the tape type override configuration flexible and adaptable based on the specific replicate command parameters. The system dynamically determines which tape devices require override based on their types and assignments, allowing administrators to configure overrides only where necessary rather than applying them universally. This dynamic approach maintains compatibility while preserving drive assignment flexibility.
Data Source
AI summary
Database performance may be improved by creating additional backups from an existing backup, rather than the original database or audit log source. A second backup may be created from a first backup by copying the files from the first backup to the second backup. The replication from a first backup to a second backup with modification of the file history information allows identical backups to exist on different types of storage devices, including virtual storage devices. Continue functionality may be implemented during a move function to restart replication at a new starting point while retaining the existing move set. Tape-type-override functionality may be implemented during the replication to replace the tape type for the backups with another compatible type while retaining the original type for history file entries, tape trailers, and messages.


