Datafile — 3 Technical Articles

Sep 20, 2023 · Databases

OceanBase Datafile Shrink Procedure and Cluster Maintenance Guide

This article describes a real‑world OceanBase failure scenario where a core dump fills the data disk, and provides a step‑by‑step guide to shrink datafiles to 80% of disk capacity, adjust parameters, reduce tenant replicas, offline and reinstall OBServer instances, and finally restart the cluster.

ClusterDatafileOceanBase

0 likes · 11 min read

OceanBase Datafile Shrink Procedure and Cluster Maintenance Guide

ITPUB

Apr 25, 2016 · Databases

How to Move Oracle Tablespaces and Datafiles to a New Location

This guide explains step‑by‑step how to offline Oracle datafiles or tablespaces, copy them to a new directory, rename them, recover if needed, bring them back online, and safely shut down and restart the database to complete the migration.

DatafileMigrationOracle

0 likes · 4 min read

How to Move Oracle Tablespaces and Datafiles to a New Location

dbaplus Community

Apr 7, 2016 · Databases

Recover Deleted Oracle Datafiles Using Linux File Descriptors and BBED

This article walks through two unconventional Oracle recovery techniques—restoring a mistakenly deleted datafile by leveraging Linux file descriptors and bypassing a missing archive log with BBED—detailing the scenarios, analysis, step‑by‑step commands, and practical considerations.

BBEDDatabase RecoveryDatafile

0 likes · 9 min read

Recover Deleted Oracle Datafiles Using Linux File Descriptors and BBED