Dataguard · Oracle · RMAN

Restore Corrupt Datafile using Another Standby

If there is a corruption on one of the datafiles on a dataguard you can restore the corruption using another dataguard. I will explain how to do the restore operation in rman using oracle 11.2. ON THE WORKING DATAGUARD Backup the datafile as image copy. RMAN> BACKUP AS COPY DATAFILE 178 FORMAT “+data/test2/datafile/test_datafile178”; Uncatalog the… Continue reading Restore Corrupt Datafile using Another Standby

Dataguard · RAC · RMAN

Copy Datafile from Physical Standby to Primary – RMAN

If you have a corrupt datafile on production system you can perform the recovery using the dataguard sysem. You can backup the datafile from dataguard system to the primary system using rman. It is like copying the datafile over the network and registering that copy on the primary database and switching the corrupt datafile with… Continue reading Copy Datafile from Physical Standby to Primary – RMAN