Oracle – Page 3

By - rgonzalezpinto
Posted in Oracle

Recovering Database on the same Host with Rman

Although it is generally less common to restore a database on the same machine than on a different host, in this post outline the steps required to restore a database on the same host; in this case, we are not using ASM storage. The source database

By - rgonzalezpinto
Posted in Oracle

Hide / obfuscate PL/SQL code (WRAP)

Sometimes it is necessary to hide (obfuscate) our PL/SQL source code. This utility should be used judiciously, it is not about hiding all the available code, but only that which for security reasons, should not be shared with third parties. The method used has been traditionally performed with the WRAP tool, which we detail below

By - rgonzalezpinto
Posted in Oracle

Add disks to ASM

With the Grid environment variables set, run the following command: ./u01/app/oracle/21.0.0/grid/bin/asmca The ASM graphical configuration screen will appear; click on the "Disk Groups" option. Select the disks that will belong to the disk group you are creating. These are the disks listed as "candidates" in the second column. Select disks of the same size.

By - rgonzalezpinto
Posted in Oracle

Restore a table with RMAN

En la versión 12c, se introdujeron muchas y muy útiles nuevas funcionalidades. Entre ellas, la posibilidad de recuperar una tabla con RMAN. Esta característica se aplica tanto a arquitecturas Multitenant como no Multitenant, permitiéndote recuperar una tabla de una PDB si ese fuera el caso. En el siguiente enlace podemos encontrar la nota oficial: RMAN

By - rgonzalezpinto
Posted in Oracle

Installing Oracle Restart 21c (Oracle Grid Infrastructure) on Oracle Linux 8

On this page, we will explain how to install a Grid infrastructure, specifically Oracle Restart 21c on Oracle Linux 8 with ASM udev). The installation is performed on a single server. In this case, we are starting with the following configuration: Memory: 9 GB Operating system: Linux 8.1 software disk: software GB 2 disks

By - rgonzalezpinto
Posted in Oracle

How to Create a PDB

CREATE AN APPLICATION PDB "Application containers" are a feature of Oracle Database version 12.2. An "application container" is an optional CDB component used to store data and metadata for an application. A CDB can have zero or more application containers. Each application consists of a configuration, metadata, and shared objects.