RMAN duplicate for standby fails with ORA-19845

While recreating an standby DB from an active primary RAC DB, rman might fail with these errors: This is not an actual issue on the standby side, but instead a RMAN config on primary. Since primary is a RAC DB, snapshot control file needs to be located on a shared location, so lets change to:... » read more

Oracle 19c: Step by Step Physical Standby CDB Database Setup

On this activity we are going to create a Physical Standby from a 19c in CDB configuration: These are the details for the primary DB: Our plan is to create a Standby DB with these details: STEPS: 1:- Prepare Primary database Enable force logging and archivelog mode: Create Standby Redo Log (SRL) files: **We are... » read more

How To Recover Tables to a Specified Point in Time

Starting from 12c, RMAN allows to perform a Table Point In Time Recovery (PITR).On earlier releases, this was only possible by manually creating a point in time clone of the database and extracting the data via datapump.With this “new” feature, life gets easier. SETUP:For this task we are assuming you have your DB/ARCHIVE log backups... » read more

RMAN: HOW TO REFRESH a DB from backup

Lets suppose you have been requested to refresh a TEST/DEV Database and you don’t have access to the source DB, just access to the backups someone created. In this case, this is a Windows environment and we are going to assume the following information: DB and Archive log backups located under: “D:\RMAN\Backup\”Control file backup to... » read more