Oracle logo Oracle 12.1 → 23ai · On-prem, OCI & Autonomous

Oracle Database Backup Tool

Back up Oracle Database schemas automatically to local drives, NAS, Amazon S3, S3-compatible cloud or SFTP servers — with nothing to install on the database host and no Oracle Instant Client on your PC.

Choose a readable SQL export or Oracle’s own Data Pump format, schedule it, and every copy is compressed and protected with AES-256 encryption before it leaves your machine.

Free Download See how it works
oracle database backup tool running a scheduled schema backup
HR · backed up 2 min ago
DBMS_METADATA/ Data Pump/ schema export/ no Instant Client/ streaming gzip/ AES-256-GCM/ Amazon S3/ SFTP/

Everything You Need for Reliable Oracle Database Backup

12.1 → 23ai
Oracle Versions
2 formats
SQL export & Data Pump
AES-256
Encryption Security
Automated
Scheduled Backup
Video tutorial

Watch How to Automate Oracle Database Backup

Free Download Watch on YouTube
Why It Matters

Why Use an Oracle Database Backup Tool

Oracle powers ERP, finance, HR and customer systems — the data a business cannot afford to lose. Yet many Oracle backups still depend on a DBA remembering to run expdp, on scripts nobody maintains, or on RMAN jobs only a specialist can restore. A scheduled, encrypted schema backup you can restore from a desktop app closes that gap.

⚠️

Human Error

A DROP TABLE on the wrong schema, an UPDATE without a WHERE clause or a script run against production instead of test removes records in seconds. With a schema backup from last night you restore the data instead of reconstructing it by hand.

💽

Hardware & Server Failure

Disks, SSDs, virtual machines and whole hosts fail without warning, and an Oracle instance on a dead server is inaccessible until it is rebuilt. A copy stored on another machine, a NAS or a cloud bucket lets you bring the schema back elsewhere and keep working.

🛡️

Ransomware Attacks

Attackers who reach a database server encrypt or delete what they find and ask for payment. Backups that were encrypted with your key and stored outside the server give you a clean copy to restore from — without negotiating with anyone.

🔄

Upgrades, Patches & Migrations

Moving from 19c to 23ai, applying a patch set or migrating to Oracle Cloud can go wrong halfway. A backup taken just before the change is the rollback plan: if the upgrade fails, the previous state of every schema is one restore away.

📋

Compliance & Audit Requirements

Financial, HR and customer records often have to be kept and reproducible for years. Retention tiers keep daily, weekly, monthly and yearly copies of each schema automatically, so an auditor’s request is answered from storage, not from memory.

🧑‍💻

Key-Person Dependency

When only one DBA knows how the export scripts work, every holiday is a risk. A backup job configured once in a wizard, visible on a dashboard and restorable in four clicks means anyone on the team can recover a schema.

Key Features

Oracle Backup Software - Key Features

Everything you need to back up Oracle Database schemas automatically and keep them recoverable.

No Oracle Client Software Needed

Most Oracle tools make you install Instant Client, sqlplus or expdp first. This tool speaks Oracle’s native protocol directly, so nothing is installed on your PC or on the database host — enter host, port, service name and credentials, and it connects.

SQL Export or Data Pump

Pick the format per job. A SQL export is a readable, portable .sql file any Oracle tool can load. Data Pump is Oracle’s own binary format — faster on large schemas and the right choice for XMLType, Spatial and other types a text export cannot reproduce. Both work against remote and cloud servers.

Pick the Schemas You Need

Oracle organises data in schemas inside a pluggable database, so the wizard lists the schemas after a successful connection test and lets you tick exactly the ones to protect — HR and SALES tonight, FINANCE in a separate job with its own schedule.

Automatic Scheduled Backup

Set a run time and switch on the daily, weekly, monthly or yearly tiers you want. Each tier is also its retention: keep the last 7 daily and 4 weekly copies, and the tool prunes older files for you. Once saved, the job runs on its own from the system tray.

Flexible Storage Options

Store Oracle backups on your PC, an external drive, a NAS share, OneDrive, Amazon S3, Wasabi, Backblaze B2, Cloudflare R2, MinIO, SFTP or FTP — and add a secondary destination so every run is copied to two places at once.

Backup Compression

Schema exports compress extremely well. Files are gzipped as they stream, typically shrinking 70–80%, which saves storage, speeds up uploads and makes it cheap to keep more history.

Strong AES-256 Encryption

After compression the file is encrypted with AES-256-GCM using a key derived from your password. Whoever gets hold of the file — on a lost USB drive or in a shared bucket — cannot read a single row without it.

Safe Storage of Credentials

Oracle always needs a username and password, and they are never written to a plain-text file. Credentials go into the Windows Credential Manager; the job only stores a reference, and the optional cloud monitoring only ever sees job status.

15-Day Free Trial

Try every feature of the Oracle backup software free for 15 days — no credit card, no hidden charges. If it fits your workflow, continue for just $9 per month, billed annually, with a 14-day money-back guarantee.

How It Works

How to Backup Oracle Database Automatically?

The Oracle Backup Tool turns a schema export into a four-step wizard: connect to the pluggable database, choose where the backup goes, set the plan, and the software handles every run from then on.

select oracle database in the backup wizard connect to oracle pluggable database and list schemas select the destination to store oracle backup set oracle backup format, schedule and encryption

The software exports each selected schema, compresses and encrypts it, and stores it at the chosen location on every scheduled run.

Full step-by-step guide

Works Everywhere Oracle Runs

Choose where your Oracle database lives

Connect the tool to an Oracle pluggable database wherever it is hosted — on-premises, in Oracle Cloud, in a container or on a developer PC. Only a host, a port, a service name and a login are needed:

Self-Hosted Oracle Oracle Cloud (OCI) Autonomous Database Oracle Free on this PC Docker Oracle Virtual Machines Remote Oracle Server

Self-Hosted Oracle

Oracle Database 12.1, 19c, 21c or 23ai running on your own server or VPS. Connect to the pluggable database by its service name and back up any schema in it.

Step 2 Connection
Hostora01.acme.internal
Port1521
Service nameERPPDB
Usernamebackup_svc
Password••••••••••
Test & list databases Connected

Oracle Cloud Infrastructure

Base Database or Exadata services on OCI expose a service name just like an on-premises server. Open port 1521 to your PC (or connect through your VPN) and back up schemas the same way.

Step 2 Connection
Hostdb.sub01.acmevcn.oraclevcn.com
Port1521
Service namepdb1.sub01.acmevcn.oraclevcn.com
Usernamebackup_svc
Password••••••••••
Test & list databases Connected

Use the full service name shown in the OCI console for the pluggable database.

Autonomous Database

Autonomous Database connections are encrypted end to end. Point the tool at the TLS endpoint and service name from the console and it exports schemas with no wallet software to install.

Step 2 Connection
Hostadb.eu-frankfurt-1.oraclecloud.com
Port1522
Service nameab1cd2ef_acmeadb_high.adb.oraclecloud.com
UsernameADMIN
Password••••••••••
Test & list databases Connected

Data Pump exports run inside the Autonomous instance and stream back over the same connection.

Oracle Database Free on this PC

Running Oracle Database Free (or XE) locally for development? Its pluggable database is called FREEPDB1 — connect to localhost and back up your schemas before every experiment.

Step 2 Connection
Hostlocalhost
Port1521
Service nameFREEPDB1
Usernameappdev
Password••••••••••
Test & list databases Connected

Oracle always needs a username and password, even on this PC — there is no Windows Authentication.

Docker Oracle

Oracle Free or XE inside a Docker container works the same way — use the port you mapped to the host and the container’s pluggable database service name.

Step 2 Connection
Hostlocalhost
Port1521
Service nameFREEPDB1
Usernamesystem
Password••••••••••
Test & list databases Connected

Backups are taken over the network, so nothing needs to be mounted into the container.

Virtual Machines

Oracle on a Windows or Linux virtual machine — VMware, Hyper-V, VirtualBox or Proxmox — is reachable by its IP address and backed up like any other server.

Step 2 Connection
Host192.168.1.60
Port1521
Service nameORCLPDB1
Usernamebackup_svc
Password••••••••••
Test & list databases Connected

Remote Oracle Server

A colocated or partner-hosted Oracle server is backed up over the network from your PC. Grant a read-only backup user SELECT ANY TABLE and SELECT_CATALOG_ROLE, and keep the export off the production host.

Step 2 Connection
Hostoracle.example.com
Port1521
Service namePRODPDB
Usernamebackup_ro
Password••••••••••
Test & list databases Connected
Inside Oracle Backup Utility

Oracle Database Backup Workflow

Every backup follows the same simple, secure workflow. From connecting to the pluggable database to storing the encrypted file, each step is designed to keep your schemas safe and restorable.

1 · Export
DBMS_METADATA + rows
2 · Compress
70-80% smaller
3 · Encrypt
AES-256
4 · Store
retention & logs

Export the schema

The tool connects to the pluggable database over Oracle’s native protocol and exports one schema at a time. Oracle itself generates production-grade DDL through DBMS_METADATA.GET_DDL — tables, indexes, sequences, views, triggers — and every row is written as INSERT statements, with large LOBs handled in PL/SQL blocks. Choose Data Pump instead and the export runs server-side through DBMS_DATAPUMP, then the .dmp file streams back to your PC over the same connection, so it works with remote and cloud databases too.

# what the app runs — no sqlplus, no expdp, no Instant Client connect ora01.acme.internal:1521/ERPPDB as backup_svc DBMS_METADATA.GET_DDL → tables, indexes, sequences, views… rows → INSERT … → HR_full_01-15-00.sql

Compress Backup

Before saving, the export is compressed in a stream, typically by 70–80%. It is never loaded into memory as a whole, so a multi-gigabyte schema is handled with the same small footprint as a tiny one.

# streamed in chunks — never loaded into RAM HR_full_01-15-00.sql → HR_full_01-15-00.sql.gz 186 MB → 41 MB (78% smaller)

AES-256 Encryption

After compression the backup is encrypted with AES-256-GCM, using a key derived from your password with scrypt. Every 64 KB chunk gets its own nonce and authentication tag, so tampering is detected and the file is unreadable without the key.

key = scrypt(password, salt) # AES-256-GCM · 64 KB chunks · unique nonce each

Store and Retention

The encrypted file is uploaded to your chosen destination (and to the secondary one, if set), verified by checksum, and logged. Retention tiers delete outdated copies automatically so storage never fills up with files nobody needs.

upload → s3://acme-prod-backups/Oracle_ERP_nightly/HR/… prune: keep 7 daily · 4 weekly · 6 monthly · write log

The app runs this for you — there is nothing to type.

The part that matters

A backup you can't restore is just wasted disk

Recovering an Oracle schema takes four steps in the app: choose the job, choose the point in time, choose what to do with it, review. The tool downloads the file, decrypts it, decompresses it and replays the SQL export into the target schema — or hands a Data Pump file to DBMS_DATAPUMP with TABLE_EXISTS_ACTION=REPLACE. Press play to watch every step.

Restoring into a different schema? Data Pump restores support REMAP_SCHEMA, so a copy of SALES can land in SALES_TEST for a safe rehearsal without touching production.

Restore: HR from Amazon S3
Locate backupfind the key in the destination
Downloadpull the encrypted object · 41 MB
Decrypt & verifyAES-256-GCM integrity check
Decompressrestore the original export · 186 MB
Replay into HRrun the SQL export against ERPPDB
sqlbackup · encrypt · oracle
PlaintextHR_full_20260825.sql.gz
scrypt(password, salt) → 256-bit key · fresh nonce
Ciphertext…
FormatMAGIC(9) · SALT(16) · [ LEN · NONCE(12) · CT+TAG ] × N
256-bitAES key
96-bitnonce / chunk
64 KBchunk size
Security

Watch How Oracle Backup Tool Protects Your Database Backups

Your Oracle backups contain the data your business runs on, so protecting them through the whole backup journey matters. Here, every file is compressed, checksummed and encrypted on your PC before it leaves, and stays protected while it is transferred and stored.

Secure Credential Storage

Your Oracle credentials and connection details are kept in the Windows Credential Manager, never in a plain-text configuration file. The settings file only stores a reference to the entry, which keeps passwords out of reach of anyone browsing the disk.

Backup Integrity Verification

When a Oracle backup is created and sent to a storage location (local, NAS, cloud, SFTP), things can still go wrong on the way:

  • Part of the backup file may be damaged in transit.
  • The file may be stored incompletely because of a network problem.
  • Someone may have modified the backup file without permission.

Checksum verification compares the stored file against the one that was written. If it is corrupted, incomplete or altered, the job is flagged as failed instead of quietly succeeding — so the Oracle backup you rely on is one that will actually restore.

Direct Backup Flow — No Third-Party Servers

The Oracle backup never passes through any of our servers. Everything happens between your machine and the storage location you chose, and the file is encrypted before it leaves. You keep full control over where your backups live and who can open them.

Your data, your storage

Your data. Your choice.
Your storage.

The Oracle backup tool is a desktop application, not a hosted service — it runs on your machine and writes each backup straight to the storage you picked. Nobody charges you per gigabyte, and no copy of your Oracle data ever sits on somebody else’s server.

Choose any destination — or several at once
This PCany folder
External driveUSB or disk
NASnetwork share
OneDriveyour account
Amazon S3your own bucket
S3-compatibleWasabi · B2 · R2 · MinIO
FTPyour own server
SFTPyour own server
No per-GB fee from us Encrypted before it leaves Send to several at once

No storage bill from us

You pay us once for the software — never for gigabytes. Point a job at a folder on your own PC or NAS and the storage costs nothing at all. Prefer the cloud? Use your own Amazon S3, Wasabi, Backblaze B2, Cloudflare R2, MinIO or OneDrive account and pay their rate directly, with no markup in between. Back up 10 GB or 10 TB — the price of the software does not move.

Your Oracle data never passes through us

This is a desktop application. It runs on your machine, connects straight to your Oracle server and writes the backup straight to the destination you chose. Nothing is uploaded to our servers on the way, so we never hold a copy of your data — and it is encrypted with AES-256 before it leaves, so even the storage provider only ever sees ciphertext.

Your passwords stay on your machine

Database passwords are never written into a configuration file and never sent anywhere. They are kept in the Windows Credential Manager, and the settings file only stores a reference to the entry. If you switch on the optional online monitoring, it reports job status only — name, success or failure, size and duration. Never your data, never your credentials.

How It Compares

Oracle Backup Tool vs Other Tools

CapabilityPrapl SQL Backup ToolOther Tools
Backup Automation Automatically ScheduledRequire manual setup
Deployment Support On-premises, OCI, Autonomous, Docker & remote — no client installLimited
Storage Destination Local/NAS, OneDrive, S3, Wasabi, Backblaze, R2, MinIO, SFTP & FTPLimited storage options
Data security AES-256 before the file leaves your PCGood
Backup Compression YesSupported but limited
Backup Monitoring Dashboard, email & cloud alerts No
Setup Process Simple wizard, four stepsComplex
You hold the keys Always No
Storage cost Your own storage · no per-GB feeOften rented per GB
Why Trust This Oracle Backup Tool with Your Critical Data

Built to Keep Your Schemas Recoverable

Designed for Real Backup Challenges

Oracle sits under applications where downtime and data loss have real consequences. This backup tool exists to make regular backups effortless, remove the manual steps people forget, and make sure a restorable copy of your data is always within reach when something goes wrong.

01. Experience

Transparent Backup Process

You should always know how your backups are made and protected. The Oracle backup workflow is simple, documented on this page step by step, and built on Oracle’s own, publicly documented interfaces rather than on anything proprietary or hidden.

02. Authoritativeness

Powered by Trusted Technologies

Every backup is made with interfaces Oracle documents and supports: DDL comes from DBMS_METADATA, Data Pump exports run through DBMS_DATAPUMP, and the connection uses Oracle’s native protocol. On top of that the tool adds streaming compression and AES-256-GCM encryption before the file reaches its destination.

03. Expertise

Your Backup & Your Encryption Key

Your Oracle backup belongs to you, not to the software. Files are encrypted before they are stored and only your key can unlock them. The tool keeps no password and no hidden access to your backups — they remain under your control, wherever you decide to keep them.

04. Trustworthiness

Sources & further reading

SQLBackup builds directly on Oracle’s own, documented packages. Verify our approach against the official docs:

Client Feedback

What Clients Are Saying After Using the Oracle Backup Tool

Who It's For

Designed for Every Oracle Environment

🏦

Finance & ERP Teams

General ledger, payroll and order data in Oracle schemas gets a nightly, encrypted copy with a retention history that answers audit questions without a DBA on call.

🏢

Software Companies

Whether your product runs on one Oracle instance or many customer PDBs, keep every schema’s backups organised, encrypted and visible from a single dashboard.

🛡️

Security-Focused Organizations

Backups are encrypted with your key before they leave the PC, credentials stay in the Windows Credential Manager, and nothing is uploaded to a third-party service.

🧪

Development & Testing Teams

Take a Data Pump backup of production and restore it into SALES_TEST with REMAP_SCHEMA to get a realistic environment for QA, migrations and performance testing — without touching live data.

🖥️

Infrastructure & Database Administrators

Replace hand-written expdp and cron scripts with scheduled jobs, checksum verification, retention tiers and alerts, for on-premises, VM, Docker and cloud instances alike.

🤝

Managed Service Providers (MSPs)

Create one job per client schema with its own schedule and destination. Backups for different clients stay separated, encrypted and monitored in one place.

Technical specs

System Requirement & Basic Information

Storage Required
500 MB Minimum (1 GB Recommended)
RAM
1 GB Minimum (2 GB Recommended)
Versions
Oracle Database 12.1 → 23ai · on-premises, Oracle Cloud (OCI), Autonomous Database, Docker · no Instant Client required
Backup format
SQL export (.sql) — readable and portable · Data Pump (.dmp) via DBMS_DATAPUMP, streamed from DATA_PUMP_DIR
Backup types
Full (per schema) · RMAN-style incrementals are not offered because they need Oracle binaries on the database host
Compression
Streaming gzip — constant memory, no temp bloat · or password-protected ZIP
Encryption
AES-256-GCM, key via scrypt, per-file salt, per-chunk nonce · secrets in the Windows Credential Manager
Destinations
Local / NAS, OneDrive, Amazon S3, S3-compatible (Wasabi, Backblaze B2, Cloudflare R2, MinIO), SFTP, FTP · optional secondary copy
Scheduling & retention
Manual / daily / weekly / monthly / yearly tiers · keep-last-N per tier · checksum verification
Platforms
Windows 10/11 · desktop app, runs from the system tray
Questions & Answers

Frequently Asked Questions

Follow the steps below to store a Oracle backup on your computer:
  1. Run Prapl SQL Backup Tool on your PC.
  2. Click on New Backup and select Oracle.
  3. Enter the host, port, service name, username and password of the pluggable database, click Test & list databases and tick the schemas to back up.
  4. Choose the Local/NAS option and enter the folder to save the backup in.
  5. Set the plan and click Save & run now.

No. The Oracle backup tool talks to the database over Oracle’s native protocol from the app itself. You do not install Instant Client, sqlplus, expdp or anything else on your PC or on the database server.

Oracle Database 12.1 and newer — 12c, 18c, 19c, 21c and 23ai — on-premises, in Oracle Cloud and as Autonomous Database. Older servers (11g and earlier) use a protocol the tool cannot speak and must be backed up with Oracle’s own utilities.

A SQL export is a readable .sql file containing the DDL and the data as INSERT statements — portable and restorable by any Oracle tool. Data Pump is Oracle’s own binary format produced by DBMS_DATAPUMP: faster for large schemas and able to carry XMLType, Spatial and other types a text export cannot reproduce. You choose the format on step 4 of the wizard.

Yes. Enter the host, port and service name shown in the Oracle Cloud console together with a database user and password. Data Pump exports run inside the cloud instance and the file streams back to your PC over the same connection, so no server-side file access is needed.

No — each run is a full backup of the selected schemas. Incremental backups in Oracle mean RMAN level 0/1, which needs Oracle binaries and operating-system access on the database host. Compression and retention tiers keep full backups small and manageable instead.

No. When you choose AES-256 protection the backup is encrypted before it is stored, and it can only be opened with the encryption password. Without it the file is unreadable ciphertext — on your PC, on a NAS or in a cloud bucket.

Backup time depends on the size of the data, the speed of the server and of the destination, and whether compression and encryption are enabled. Small databases finish in seconds or minutes; large ones take longer but stream in the background without freezing your PC, and the Dashboard shows live progress and speed.
One tool, every database

Also backs up your other databases

One flat price covers every engine on the machine. Explore the others:

PostgreSQL

pg_dump / pg_restore

MySQL

mysqldump

MariaDB

mariadb-dump

SQL Server

BACKUP DATABASE

Oracle

You're here

SQLite

online backup API

MongoDB

mongodump

Redis

SCAN + DUMP / RESTORE

ClickHouse

HTTP · FORMAT Native

Elasticsearch

search_after + _bulk

Automate Oracle Database Backup

Create a backup of your Oracle data and save it to local or cloud storage. Download the Oracle Backup Tool and use every feature free for 15 days — no credit card required. If it fits, subscribe for just $9/month with a 14-day money-back guarantee.

Free Download Buy Now
15-day free trial 14-day money-back No auto-renewal