ALTER DATABASE DATAFILE OFFLINE

How to Resolve ORA-45909: restore, recover or block media recovery may be in progress

by Ed Chen
June 15, 2023June 24, 2023

ORA-45909 Tried to restore a data file by RMAN, it failed with ORA-45909, ORA-19890 and ORA-19573. RMAN> restore datafile 13; ... ORA-19870: error while restoring… Read More »

Switch Datafile To Copy

by Ed Chen
May 16, 2016October 16, 2022

Move Data File by RMAN As usual, we use RMAN to change the location of a data file. Check the file number. SQL> select file#… Read More »

Alter Database Rename File

by Ed Chen
May 16, 2016October 15, 2022

Move Data File Offline Not like the new released statement ALTER DATABASE MOVE DATAFILE which can move data files online, the old-fashioned file renaming procedure… Read More »

JavaScript is not enabled. Please enable it and reload the page.