This post is about re-synchronized a duplicated database: the source database is PROD@vsi08 server and the target database will have the same SID, but located @vsi10 server. All the steps to set up a duplicated database are already explained in this previous post. Let’s duplicate for the first time our target database PROD located on […]
Monthly Archives: September 2017
Upgrade OEM 12cR5 to 13cR2
Let’s have a quick introduction of Upgrade in Oracle. As we go in depth of this article we have mentioned about the steps of an upgrade OEM from 12cR5 to 13cR2. Thanks to my fellow DBA Kellyn Pot’Vin-Gorman who gave me idea to write on OEM 13c. Day by day technologies get change and advanced technology […]
Migrating Databases to Oracle Cloud Using RMAN Backup
This article was written by Skant Gupta and Joel Perez in Oracle OTN. This method is based on the traditional backup/restore/recover database. It has been one of the methods most effective to migrate/move an Oracle Database from one host to another host or even in the same host. The advantages of this method are several, one of them is that […]
Oracle Cloud (DBaaS): Move PDB with exporting the TDE master Key in Oracle 12.2
This article was written by Skant Gupta and Joel Perez in Oracle OTN. Security is one of the main issues that customers think at the time of moving or having the databases, applications and more into the Cloud. Security has many layers, areas, sections and more. When we work with databases “On-Prem”, security in many […]
Categories of Failures in Oracle Database
Today we are going to have look on Categories of Failures in Oracle Database. This information helps to DBA solve the issue as soon as possible. Statement Failure Statement failure transpires when there is a logical failure in the handling of a statement in an Oracle program. If a statement failure occurs, then the Oracle software or operating […]
Install Oracle Enterprise Manager(OEM) Cloud Control 12c
Today we are going to learn about OEM. We are going to have look on Install Oracle Enterprise Manager Cloud Control 12c. Let’s have look on the technical definition of OEM. Oracle Enterprise Manager (OEM or EM) is a set of web-based tools aimed at managing software and hardware produced by Oracle Corporation as well as by […]
Restore from a loss of all current control files to a non default location using a backup piece
This post is about the steps which use restore from a loss of all current control files to a non-default location using a backup piece. First of all just create a location outside the flash recovery area where to save the backup piece containing the current control file: [oracle@localhost oracle]$ pwd /home/oracle/app/oracle/ [oracle@localhost oracle]$ […]
Perform a time-based incomplete recovery
Every incomplete recovery is followed by a resetlogs command before opening the database: each time you use a resetlogs command, a new incarnation of the database is created. While performing incomplete recovery it should be known the target point at which the recovery process needs to terminate: there are several ways to establish and set […]
Recover duplicate a production database on a different server
In the following scenario, We are going to learn about those steps which use to recover duplicate a production database on a different server maintaining the same SID and directory structures with ‘duplicate‘ RMAN command I simply want to have a copy of my production database to a different server preserving the same database directory structures and […]
Duplicate a database on the same host
This post explains the steps which are used for RMAN: how to duplicate a database on the same host. We need to duplicate a database. There are many possibilities to complete this task and I choose to use RMAN and its commands: in particular, I decided (to be honest it was just a poor notebook configuration […]