Move Oracle Datafiles in NOARCHIVE MODE
Stop the database:
SQL> shutdown immediate;
Copy the datafile to the new directory or disk:
$ cp /u01/data/datafile.dbf /u02/data/datafilenew.dbf
Mount database
SQL> startup mount;
Rename the datafile:
SQL> ALTER DATABASE RENAME FILE ‘/u01/data/datafile.dbf’ TO ‘/u02/data/datafilenew.dbf’;
Open the database:
SQL> ALTER DATABASE OPEN;
Move Oracle Datafiles in ARCHIVE MODE
Set the datafile offline:
SQL> ALTER DATABASE DATAFILE ‘/u01/data/datafile.dbf’ OFFLINE;
Copy the datafile to another directory or disk:
$ cp /u01/data/datafile.dbf /u02/data/datafilenew.dbf
Connect to the database and rename the datafile:
SQL> ALTER DATABASE RENAME FILE ‘/u01/data/datafile.dbf’ TO ‘/u02/data/datafilenew.dbf’;
Recover the datafile:
SQL> RECOVER DATAFILE ‘/u02/data/datafilenew.dbf’;
Set the datafile online :
SQL> ALTER DATABASE DATAFILE ‘/u02/data/datafilenew.dbf’ ONLINE;