Saturday, October 25, 2008

Rename datafile (file system to raw device AIX) ,database archivelog mode

1) Take the data file offline
ALTER DATABASE DATAFILE '/oracle/pindb/arch/data/rpindb1_pinx112.dbf' OFFLINE;
2) Copy the data file to new raw device
dd if=/oracle/pindb/arch/data/rpindb1_pinx112.dbf of=/dev/rpindb1_pinx113 bs=4096 seek=1
3) rename file
ALTER DATABASE RENAME FILE '/oracle/pindb/arch/data/rpindb1_pinx112.dbf' TO '/dev/rpindb1_pinx113';
4) RECOVER DATAFILE '/dev/rpindb1_pinx113';
5) ALTER DATABASE DATAFILE '/dev/rpindb1_pinx113' online;

No comments: