Thursday 15 May 2014

Datafile movement in EBS Database

shutdown db,and listener
check datafile with size with command

SQL>select name,bytes from v$datafile;


old oldname:

/u01/oracle/VIS/db/apps_st/data/undotbs_04.dbf
/u01/oracle/VIS/db/apps_st/data/summary14.dbf
/u01/oracle/VIS/db/apps_st/data/demantra02.dbf
/u01/oracle/VIS/db/apps_st/data/demantra01.dbf

new name:

/NEW1/oracle/VIS/db/apps_st/data/undotbs_04.dbf
/NEW1/oracle/VIS/db/apps_st/data/summary14.dbf
/NEW1/oracle/VIS/db/apps_st/data/demantra02.dbf
/NEW1/oracle/VIS/db/apps_st/data/demantra01.dbf

cp "oldlocation" to "new location"

SQL>startup mount
SQL>alter database  rename file 'old name' to 'new name';
SQL>alter database open;

database altered
now check name of datafile again with command

SQL>select name,bytes from v$datafile;

No comments:

Post a Comment