Category: Relocating a PDB
-
Network Connections- Containers and Pluggables
Read More: Network Connections- Containers and PluggablesIf you are initiating a remote connection through the network, then you need to first set up a listener on the target database server and create a password file (see Chapter 2 for details). Once the listener and password files are established, you can connect remotely over the network, as shown here: $ sqlplus user/password@connection_string…
-
Administrating the Root Container (CDB)- Containers and Pluggables
Read More: Administrating the Root Container (CDB)- Containers and PluggablesWhen you manage a CDB, for the most part you are connecting to the root container as SYS and performing tasks as you would with a non-CDB database. I would recommend different users for different tasks, such as backing up, creating new PDBs, and cloning. Even though these are SYSDBA-level tasks, it still makes sense…
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…