Category: Switching Containers

Recovery Catalog Versions – RMAN Backups and Reporting

19/07/2024

I recommend that you create a recovery catalog for each version of the target databases that you are backing up. Doing so will save you some headaches with compatibility issues and upgrades. I have found it easier to use a recovery catalog when the database version of the rman client is the same version used…
Read More: Recovery Catalog Versions – RMAN Backups and Reporting
Put It Together in a Script – RMAN Backups and Reporting

19/03/2024

An RMAN script can pull of these configurations together and automate the backup job. The following is an instructional script that shows how these components work together. This gives a basic script for a starting point to understanding the RMAN recommendations and be able to implement them. There is also a good chance that a…
Read More: Put It Together in a Script – RMAN Backups and Reporting
Determine the Location for the Snapshot Control File – RMAN Backups and Reporting

19/11/2023

RMAN requires a read-consistent view of the control file for the following tasks: • Synchronizing with the recovery catalog • Backing up the current control file RMAN creates a snapshot copy of the current control file that it uses as a read-consistent copy while it is performing these tasks. This ensures that RMAN is working…
Read More: Determine the Location for the Snapshot Control File – RMAN Backups and Reporting
Starting RMAN – RMAN Backups and Reporting

19/08/2023

There are several components and terms to understand; however, running the backup using RMAN is fairly straightforward. With this understanding, you have all of these options depending on your database. If you are maintaining a database that has 24/7 requirements, you need to be able to effectively back up and restore the database. To connect…
Read More: Starting RMAN – RMAN Backups and Reporting
Understanding RMAN- RMAN Backups and Reporting

19/06/2023

The RMAN ecosystem consists of many different components. Figure 13-1 shows the interactions of the main RMAN pieces. Refer to this diagram when reading this section. Figure13-1.RMAN architectural components The following list describes the RMAN architectural components and definitions: • DBA: This is the human interaction to ensure successful backups and restores. • Target database:…
Read More: Understanding RMAN- RMAN Backups and Reporting
Dropping a PDB- Large Objects

19/05/2023

Occasionally, you may need to drop a PDB. You may want to do so because you do not need the PDB anymore or because you are transferring (unplugging/plugging) to a different CDB and you want to drop the PDB from the original CDB. If you need to remove a PDB, you can do it in…
Read More: Dropping a PDB- Large Objects
Administrating Pluggable Databases- Large Objects

19/01/2023

We have already covered many administration tasks for CDBs and PDBs. The PDBs are considered application databases or configured for user objects and data. You still have administrative tasks that need to be performed while connected directly to the PDB. You can open/close a PDB, check its status, show currently connected users, and so on.…
Read More: Administrating Pluggable Databases- Large Objects
Refreshable Clone- Large Objects

19/10/2022

In creating a clone, it is a copy as of that point in time. A refreshable clone can sync back to the source PDB. This makes this clone useful for testing upgrades, making changes, and even switching the roles of a sourcing PDB and its refreshable clone. This can be useful for resources and possible…
Read More: Refreshable Clone- Large Objects
Open Order for PDBs- Containers and Pluggables

19/08/2022

New in 23c, you can define an open order for the PDBs. This gives priority to mission-critical PDBs so that they are started first. The priority is for opening and upgrades. Priority values are lower to higher values, with the lower values being processed first. Values can be the same but will be processed in…
Read More: Open Order for PDBs- Containers and Pluggables
Create Common Users- Containers and Pluggables

19/06/2022

There are two types of users in a pluggable environment: local and common. A local user is nothing more than a regular user that is created in a PDB. The local type of user in a PDB behaves the same as a user in a non-CDB environment. There is nothing special about administering local users;…
Read More: Create Common Users- Containers and Pluggables