Category: Oracle Certifications and Exams
-
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…
-
Understanding RMAN- RMAN Backups and Reporting
Read More: Understanding RMAN- RMAN Backups and ReportingThe 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:…
-
Dropping a PDB- Large Objects
Read More: Dropping a PDB- Large ObjectsOccasionally, 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…
-
Restricting Changes to SYSTEM at PDB- Large Objects
Read More: Restricting Changes to SYSTEM at PDB- Large ObjectsIn administering the PDB, the parameters can be changed as described at the PDB level. You can also change these parameters for a PDB at the CDB level. The changes can be restricted so that only CDB administrators can modify these settings for the PDB. This will allow the CDB DBAs to know how many…
-
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…
-
Managing a Listener in a PDB Environment- Large Objects
Read More: Managing a Listener in a PDB Environment- Large ObjectsRecall from Chapter 2 that a listener is the process that enables remote network connections to a database. Most database environments require a listener to operate. When a client attempts to connect to a remote database, the client provides three key pieces of information: the host the listener is on, the host port the listener…
-
Administrating Pluggable Databases- Large Objects
Read More: Administrating Pluggable Databases- Large ObjectsWe 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.…
-
Relocating a PDB- Large Objects
Read More: Relocating a PDB- Large ObjectsRelocating a PDB is an online action instead of unplugging and plugging a database. The source can be open for read and write, and there is minimal or no downtime. The files that are associated with the PDB are moved to a new location, and the PDB is added in the target CDB and then…
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…