English Oracle Read-Only ORACLE_HOME: Architecture and Activation
As a feature designed to significantly improve operational management efficiency and enhance security for Oracle Databas...
RMAN
English English How to Duplicate a Database Based on Backups (duplicate database)
Duplicating an Oracle database is an extremely useful feature for development, verification, and testing purposes. In th...
Datapump_en Practical Steps to Extract Transportable Tablespaces with RMAN and Import via SQL Script
— Smart Migration using Automatically Generated Scripts instead of Data Pump —Oracle's Transportable Tablespace (TTS) is...
Datapump_en Comprehensive Guide to Transportable Tablespaces (TTS) via Data Pump and RMAN
When migrating massive amounts of data—ranging from several GBs to multiple TBs—between Oracle databases, standard expdp...
English Procedures for Executing Flashback Database Using a Guaranteed Restore Point
When updating a system or applying large-scale data patches, the anxiety of "what if it fails?" is always present. In su...
English Flashback Database: Construction Procedures and Operational Secrets
One of the most powerful "insurance policies" in operating Oracle Database is Flashback Database. When a user accidental...
English How to Perform Table-Level Recovery Using Oracle RMAN
When you accidentally delete (DROP) a table, you may want to restore only that specific table without reverting the enti...
English Recovery Procedures for Oracle Tablespace Failures: Recovery Flow Using RMAN
In Oracle Database operations, if a failure occurs in a specific tablespace, it is possible to recover only that tablesp...
English Complete Recovery Procedures for Oracle Database: Recovery Flow Using RMAN
When a failure occurs in an Oracle Database, a "Complete Recovery"—restoring the database to the state immediately prece...
English Recovery Procedures for Corrupted Blocks Using Oracle Data Recovery Advisor
In Oracle Database operations, data corruption is a situation you want to avoid; however, should the need arise, the Ora...
English How to Repair Corrupted Blocks in Oracle
When data block corruption occurs in an Oracle database, you can use RMAN (Recovery Manager) to accurately identify the ...
ASM_en Complete Guide to ASM Metadata Backup
In an Oracle Automatic Storage Management (ASM) environment, metadata is the most critical information as it manages the...
English Detecting and Repairing Oracle Data Block Corruption
In Oracle Database operations, data block corruption not only compromises data integrity but can also lead to critical i...
English Utilizing the Oracle VALIDATE Command and V$DATABASE_BLOCK_CORRUPTION
In Oracle Database administration, detecting data block corruption in advance is critical. This article provides a detai...
Data Dictionary Internals_en Preventing Oracle Block Corruption: Configuring DB_BLOCK_CHECKSUM and DB_BLOCK_CHECKING
In Oracle Database, physical or logical corruption of data blocks can trigger errors such as ORA-01578, leading to sever...
English [Complete Guide] Oracle Archived Redo Log Backup and Operational Management
In an Oracle Database, managing Archived Redo Logs is the lifeline for achieving "Complete Recovery," ensuring zero data...
Control Files_en The Core of Oracle Database: Control File Backup Procedures
In an Oracle Database, the Control File acts as both the "family tree" and the "map" of the database, making it one of t...
English Archive Backups Using the Oracle RMAN BACKUP KEEP Command
The BACKUP KEEP command in Oracle Recovery Manager (RMAN) is a powerful feature for managing specific backups outside th...
English Oracle RMAN Multiplexing Backupset: Mechanism and Utilization
In Oracle Recovery Manager (RMAN) backup operations, one of the critical concepts that determines performance is "Multip...
English Accelerating Large File Backups with Oracle RMAN Multisection Backup
Multisection Backup in Oracle Recovery Manager (RMAN) is a feature that virtually divides a single, massive data file in...