You have a standby DB out of sync and all logs on primary are gone. At this stage you have 2 options: 1:- rebuild standby 2:- Rollforward standby What about a “one line” command that does automatically all the steps you usually do on a rollforward? Here is the magic: After this, you just need... » read more
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
This is an easy one. This is the error/warning you might while connecting to RMAN: The way to fix it is running this: And error gone!
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
On this post we are going to review possible errors we can face while creating a Standby DB with RMAN using an active DB. These are just errors I faced. For some I skipped steps on purpose so we can see the error we would face. You might face these, or others ( or none…)... » read more
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
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
Here an easy script to run a backup an in this case with a 30 day retention: