ORA-01274: cannot add data file

PROBLEM: After adding a datafile in primary database, recovery process in standby stopped with below error. — Primary database:

— Error in alert log of standby database File #5 added to control file as ‘UNNAMED00005’ because the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL The file should be manually created to continue. MRP0: Background Media Recovery terminated […]

Read More

Roll Forward Physical Standby Database using RMAN incremental backup

There would be scenarios where the standby database lags far behind from the primary database leading to Archive Gap. It could be due to one of the following reasons 1.  Might be due to the network outage between the primary and the standby database leading to the archive gaps. Data guard would be able to detect […]

Read More