How to Rename or Move Datafiles and Logfiles in 11g

How to Rename or Move Datafiles and Logfiles

Step1:
——-
shutdown the database

Step 2:
——–
cp /Oracle/app/sample/oradata/orcl/*.dbf /NAS_Disk3/app/sample/oradata/orcl/

Step 3:
——–
startup nomount;

Step 4:
——–
Alter database mount;

Step 5:
———

ALTER DATABASE RENAME FILE ‘/Oracle/app/sample/oradata/orcl/users01.dbf’ to ‘/NAS_Disk3/app/sample/oradata/orcl/users01.dbf’;

Step 6:
——–
Alter database open;

  • July 10, 2018 | 16 views
  • Comments