Category: Relocating a PDB
-
Recovery Catalog Versions – RMAN Backups and Reporting
Read More: Recovery Catalog Versions – RMAN Backups and ReportingI 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…
-
Creating a Recovery Catalog – RMAN Backups and Reporting
Read More: Creating a Recovery Catalog – RMAN Backups and ReportingWhen I use a recovery catalog, I prefer to have a dedicated database that is used only for the recovery catalog. This ensures that the recovery catalog is not affected by any maintenance or downtime required by another application (and vice versa). Listed next are the steps for creating a recovery catalog: 1. Create a…
-
Delete Backups, Based on Retention Policy – RMAN Backups and Reporting
Read More: Delete Backups, Based on Retention Policy – RMAN Backups and ReportingYou can report on backups that RMAN has determined to be obsolete per the retention policy, as follows: RMAN> report obsolete; To delete obsolete backups, run the DELETE OBSOLETE command: RMAN> delete obsolete; You are prompted with this: Do you really want to delete the above objects (enter YES or NO)? If you are scripting…
-
RMAN Architectural Decisions – RMAN Backups and Reporting
Read More: RMAN Architectural Decisions – RMAN Backups and ReportingArchiving should be enabled for your production database; otherwise, you will not be able to do a point-in-time recovery. You can use RMAN out of the box to run commands such as this to back up your entire target database: $ rman target / RMAN> backup database; If you run this command at the CDB…
-
Starting RMAN – RMAN Backups and Reporting
Read More: Starting RMAN – RMAN Backups and ReportingThere 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…
-
Types of Backups with RMAN – RMAN Backups and Reporting
Read More: Types of Backups with RMAN – RMAN Backups and ReportingThe are the different types of backups: • Full backup: All modified blocks associated with the data file are backed up. A full backup is not a backup of the entire database. For example, you can make a full backup of one data file. • Incremental level 0 backup: This backs up the same blocks…
-
Modifying Initialization Parameters Specific to a PDB- Large Objects
Read More: Modifying Initialization Parameters Specific to a PDB- Large ObjectsOracle allows some initialization parameters to be modified while connected as a privileged user to a PDB. You can view these parameters via the following query: SQL> select name from v$parameter where ispdb_modifiable=’TRUE’ order by name; Here is a snippet of the output: NAME sort_area_size sql_trace sqltune_category star_transformation_enabled statistics_level When you make initialization parameter changes…
-
Unplugging a PDB from a CDB- Large Objects
Read More: Unplugging a PDB from a CDB- Large ObjectsBefore plugging a PDB into another CDB, it must first be unplugged. Unplugging translates to disassociating a PDB from a CDB and generating an XML file that describes the PDB being unplugged. This XML file can be used in the future to plug the PDB into another CDB. Before going down this path, however, consider…
-
Open Order for PDBs- Containers and Pluggables
Read More: Open Order for PDBs- Containers and PluggablesNew 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…
-
Switching Containers- Containers and Pluggables
Read More: Switching Containers- Containers and PluggablesOnce you connect as a common user to any container within the database (either the root or a PDB), you can use the ALTER SESSION command to switch to another container for which you have been granted access. For example, to set the current container to a PDB named SALESPDB, you would do as follows:…
Search
Popular Posts
-
Recovery Catalog Versions – RMAN Backups and Reporting
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…
-
Registering a Target Database – RMAN Backups and Reporting
Now, you can register a target database with the recovery catalog. Log in to the target database server. Ensure that you can establish connectivity to the recovery catalog database. For instance, one approach is to populate the TNS_ADMIN/tnsnames.ora file with an entry that points to the remote database. On the target database server, register the…
-
Creating a Recovery Catalog – RMAN Backups and Reporting
When I use a recovery catalog, I prefer to have a dedicated database that is used only for the recovery catalog. This ensures that the recovery catalog is not affected by any maintenance or downtime required by another application (and vice versa). Listed next are the steps for creating a recovery catalog: 1. Create a…