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...
English 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 Oracle Flashback Drop: The “Magic Command” to Rescue Deleted Tables from the Recycle Bin
In Oracle Database operations, one of the most heart-stopping moments is realizing you have accidentally executed a DROP...
English Undo Specific Changes: Oracle Flashback Transaction Techniques
When you accidentally commit an incorrect update in Oracle Database, using "Flashback Table" to revert an entire table c...
English Rewinding Time with SCN! A Guide to Using Oracle FLASHBACK TABLE
When operating an Oracle Database, you may encounter a situation where you accidentally delete important records and com...
English What is Oracle Flashback Data Archive? The Definitive Guide to History Management
Have you ever needed to "verify specific data from several years ago" or "track deleted records" in Oracle Database? Typ...
English What is Oracle Flashback Transaction Query?
When you perform an erroneous update or deletion in an Oracle Database, there are times when you want to accurately iden...
English Oracle Flashback Version Query
When operating an Oracle Database, there are times when you want to track the history of "when, by which transaction, an...
English Oracle Flashback Query (Specifying SCN vs. Timestamp)
When operating an Oracle Database, you often encounter situations where you need to "immediately check data before an up...
English What is Oracle Flashback Technology?
— The Savior from Human Error: Explaining Oracle's Powerful Rewind Feature —Oracle Database is equipped with a magical f...
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...