Skip to content

Root Fan

Oracle & Postgresql DBA Blog

  • Home
  • Contact
  • About
  • Index
  • Services

Tag: backup

Posted on September 12, 2024March 10, 2026

Oracle 19c RMAN Duplicate Database From Backup

snow top mountain under clear sky

To duplicate an Oracle database with backups you have taken with RMAN there are several ways to do it.

Make sure to have a full backup of the source database.

The backups are located at: /home/oracle/backup

The first method I will show you is with a minimal pfile, only the db_name.

The second method will be with more info in the pfile.

Continue reading “Oracle 19c RMAN Duplicate Database From Backup”
Posted on August 25, 2024August 25, 2024

RMAN Script to Take Full Database Backup Plus Archivelog

photo of thunderstorm

You can use this RMAN script to create a backup of an Oracle database and save it to a specified destination.

It is important that the BACKUP_BASE_PATH exists and the ORACLE_SID is replaced in the script.

The script will create a folder inside of BACKUP_BASE_PATH with the ORACLE_SID.

Continue reading “RMAN Script to Take Full Database Backup Plus Archivelog”

Posts pagination

Page 1 Page 2 Next page

Unmissable Posts

  • Copy Password File From Primary ASM to Standby ASM on Oracle 19c
  • Oracle Exadata vs ExaCC vs ExaCS
  • PostgreSQL High Availability with Patroni, etcd, HAProxy and keepalived
  • Oracle 19c Data Guard Configuration Step by Step
  • Top 7 Oracle Wait Events Explained

Recent Posts

  • Oracle to Postgres Migration: CO Schema Issues and Fixes
  • Oracle to Postgres Migration Step by Step: The SH Schema (Partitions, Materialized Views, Bitmap Indexes)
  • ora2pg Migration Example: Oracle HR Schema to PostgreSQL
  • The Complete Oracle-to-PostgreSQL Data Type Mapping Guide
  • PostgreSQL Tools List: The Essential Stack for Production DBAs

Categories

  • Apache
  • Exadata
  • Firewall
  • Linux
  • Oracle
  • Oracle to PostgreSQL
  • Postfix
  • PostgreSQL
  • Security
  • Ubuntu

Unmissable posts

  • ora2pg Migration Example: Oracle HR Schema to PostgreSQL
  • Oracle to Postgres Migration: CO Schema Issues and Fixes
  • PostgreSQL High Availability with Patroni, etcd, HAProxy and keepalived
  • Oracle to Postgres Migration Step by Step: The SH Schema (Partitions, Materialized Views, Bitmap Indexes)
  • Top 7 Oracle Wait Events Explained
  • Oracle to Postgres Migration: CO Schema Issues and Fixes
  • Oracle to Postgres Migration Step by Step: The SH Schema (Partitions, Materialized Views, Bitmap Indexes)
  • ora2pg Migration Example: Oracle HR Schema to PostgreSQL
  • The Complete Oracle-to-PostgreSQL Data Type Mapping Guide
  • PostgreSQL Tools List: The Essential Stack for Production DBAs

Categories

  • Apache
  • Exadata
  • Firewall
  • Linux
  • Oracle
  • Oracle to PostgreSQL
  • Postfix
  • PostgreSQL
  • Security
  • Ubuntu

EN
EN
ES FR

  • Facebook
  • Twitter
  • Email
Privacy Policy Proudly powered by WordPress