Move Datafiles on an Oracle Standby Database when you run out of space

alter database move datafile 25 to '/dba0A/oradata/ORAP/system10.dbf;

SELECT file#, name FROM v$datafile where name like '%system10.dbf%';

system07.dbf  system08.dbf  system09.dbf  system10.dbf
APPS_TS_SUMMARY05 APPS_TS_SUMMARY06

% cp <Source> <Destination>
SQL> alter database rename file '<Path of Source datafilename or File#>' to ‘<Destination path and name>’;

SQL> alter database database open; # If Active Data Guard is used


alter database rename file '/dba0B/oradata/ORAP/system10.dbf' to '/dba0A/oradata/ORAP/system10.dbf';
alter database rename file '/dba0B/oradata/ORAP/system09.dbf' to '/dba0A/oradata/ORAP/system09.dbf';
alter database rename file '/dba0B/oradata/ORAP/system08.dbf' to '/dba0A/oradata/ORAP/system08.dbf';
alter database rename file '/dba0B/oradata/ORAP/system07.dbf' to '/dba0A/oradata/ORAP/system07.dbf';

alter system set standby_file_management=manual
alter database rename file '/dba0B/oradata/ORAP/APPS_TS_SUMMARY05.dbf' to '/dba0A/oradata/ORAP/APPS_TS_SUMMARY05.dbf';
alter database rename file '/dba0B/oradata/ORAP/APPS_TS_SUMMARY06.dbf' to '/dba0A/oradata/ORAP/APPS_TS_SUMMARY06.dbf';

shutdown immediate;
startup nomount;
alter database mount standby database;
alter database recover managed standby database disconnect from session;


The increased responsibility will supplement my passion for leading and helping people to be a better version of themselves.
Simultaneously motivating and challenging the people will produce better output and results for the organization.
Sometimes the best people to lead are the one's who has been there and have deeper connection with people and role.