Posts

Duplicating a PDB into Another CDB

By -
  In Oracle Database 12c , it is possible to use the DUPLICATE command at the PDB level. However, there is a limitation: a new CDB must also be created as part of the duplication process. Otherwise, the operation fails with an error. [oracle @cdb2 ~] $ rman target sys/sys @cdb1 auxiliary sys/sys @cdb2 connected to target database: cdb1 ( DBID = 4178530773 ) connected to auxiliary database: cdb2 ( DBID = 839691519 ) RMAN > DUPLICATE DATABASE TO CDB2 PLUGGABLE DATABASE pdb12c; RMAN - 05500 : the auxiliary database must be not mounted when issuing a DUPLICATE command Starting with Oracle Database 18c , a PDB can be duplicated into an existing CDB . This is a new capability in Oracle Database 18c. The following example demonstrates how to perform this operation. In this example, the PDB18C PDB in CDB1 is duplicated into CDB2. During the duplication process, changes may occur in the source PDB ( CDB1 ). At the end of the duplication, these changes are applied to the tar...
Post a Comment
Read more

Migrating PostgreSQL 14 to 18 Using pg_dumpall

By -
  A major PostgreSQL version upgrade is not only a matter of installing the new server. The migration also requires a clear understanding of the existing environment, a verified backup, careful restoration, and post-upgrade validation. In this article, I walk through a PostgreSQL 14 to PostgreSQL 18 migration using pg_dumpall, based on a real environment. 1. Review the Current PostgreSQL 14 Environment Before starting the upgrade, I record the current PostgreSQL version, data directory, databases, database sizes, tables, indexes, and installed extensions. These checks give me a reference point for validating the PostgreSQL 18 environment later. --Current version: postgres = # select version(); version ----------------------------------------------------------------------------------------------------------- PostgreSQL 14.19 on x86_64 - pc - linux - gnu, compiled by gcc (GCC) 11.5 .0 20240719 (Red Hat 11.5 .0 -5 ), 64 - bit ( ...
Post a Comment
Read more