Oracle 12c

ORA-10873: file 1 needs to be either taken out of backup mode or media recovered

Leave a Comment / ORA Error, Oracle 12c, Oracle Database /

This article is about ORA-10873: file 1 needs to be either taken out of backup mode or media recovered. Cause This is may be due to database went down while database is in backup mode. Error in the alert log Errors in file F:ORACLEPRODUCTDIAGdiagrdbmsbwdbbwdbtracebwdb_ora_1268.trc: ORA-10873: file 1 needs to be either taken out of backup […]

ORA-10873: file 1 needs to be either taken out of backup mode or media recovered Read More »

Data File Relocation Steps

Leave a Comment / Oracle Database, Oracle 12c /

The list of files are – /vch27/VCHP/vchdata/wntitel01.dbf and /vch27/VCHP/vchdata/wntitel02.dbf of table space WNTITEL (File No-6 & 13). /vch27/VCHP/rpdata/riepatables03.dbf of table space RIEPATABLES (File No-21). Control File Location- /vch8/VCHP/oradata/control01.ctl, /vch8/VCHP/oradata/control02.ctl, /vch8/VCHP/oradata/control03.ctl The steps are as follows- Shut immediate; Copy the files to /vch32/VCHP/vchdata, /vch32/VCHP/rpdata and rename them if required. Startup mount ALTER DATABASE BACKUP CONTROLFILE TO ‘/vch32/VCHP/control.bkp’;

Data File Relocation Steps Read More »