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:
Post a Comment