Re: Migrate pluggable database from filesystem to ASM

Posted by raiq1 on Apr 13, 2022; 8:18am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Migrate-pluggable-database-from-filesystem-to-ASM-tp10815p10836.html

Dear Erman sir,

I have successfully migrate pluggable database from file system to ASM followed by the below link.

https://www.funoracleapps.com/2022/03/how-to-move-pdb-datafiles-to-asm-disk.html

Using this link, steps are very clear and easily complete the migration process.

After migration process I have realized that pluggable database temp files are still in the filesytem and not migrated to ASM Disk Group.


--------------------------------------------------------------------------------
/u02/oracle/TEST/db/apps_st/data/temp08.dbf
/u02/oracle/TEST/db/apps_st/data/temp09.dbf
/u02/oracle/TEST/db/apps_st/data/temp01.dbf
/u02/oracle/TEST/db/apps_st/data/temp02.dbf
/u02/oracle/TEST/db/apps_st/data/temp03.dbf
/u02/oracle/TEST/db/apps_st/data/temp05.dbf
/u02/oracle/TEST/db/apps_st/data/temp06.dbf
/u02/oracle/TEST/db/apps_st/data/temp07.dbf


Now need a steps to move all tempfiles from filesystem to ASM disk group.

Kindly advice.

Regards,
Raiq