Showing posts with label Oracle Clone. Show all posts
Showing posts with label Oracle Clone. Show all posts

Monday, 6 January 2025

Cold Backup Based Duplication in Oracle Database

A cold backup method is the fastest way of duplicating any oracle database and creating its replica. Here I am going to create a new database with separate DB NAME using a source database.

Also, the source database is a CDB with 1 PDB attached but it won't make that much of difference for non-cdb databases as well. It's just few less actions for non-cdb.

Prerequisites:

  • pfile backup of source database
  • controlfile backup as trace from source database
  • source datafiles copy when database is in mount/shutdown state. Do not copy a source database when it's running.