Migrate pluggable database from filesystem to ASM

[raiq1]

Dear Erman sir,

As you know, I am in the stage of upgrading a database from 11g to 19c with ebs 12.1.3 environment.

My empty CDB is in ASM and the pluggable database is in filesytem.

I have done a successfully upgrade from 11g to 19c. Now next step is to migrate all pluggable database(including datafiles,controlfile,redolog files) in ASM.

If I check below.

SQL> show pdbs

    CON_ID CON_NAME                  OPEN MODE   RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY      NO
         3 TEST                               READ WRITE     NO


SQL > select name from v$datafile;


Below query results show CDB is in +DATA but pluggable database is in filesytem.

Kindly advice or share with me high level steps to complete this task.


NAME
--------------------------------------------------------------------------------
+DATA/TESTCDB/DATAFILE/system.264.1099530769
+DATA/TESTCDB/DATAFILE/sysaux.276.1099530805
+DATA/TESTCDB/DATAFILE/undotbs1.277.1099530829
+DATA/TESTCDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/system.285.1099532081
+DATA/TESTCDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/sysaux.286.1099532081
+DATA/TESTCDB/DATAFILE/users.278.1099530831
+DATA/TESTCDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/undotbs1.287.1099532081
/u02/oracle/TEST/db/apps_st/data/system11.dbf
/u02/oracle/TEST/db/apps_st/data/system08.dbf
/u02/oracle/TEST/db/apps_st/data/system09.dbf
/u02/oracle/TEST/db/apps_st/data/system07.dbf


Regards,
Raiq

[ErmanArslansOracleBlog]

Hi

Check the following MOS note ;

Migrate 12c Pluggable Single Tenant Database from non-ASM to ASM Online With Less Downtime (Doc ID 2083226.1)

Also check the following ->  (I didn't test it bytheway)

--Move PDB to a Different ASM Disk Group
https://asanga-pradeep.blogspot.com/2021/06/move-pdb-to-different-asm-disk-group.html

[raiq1]

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

[ErmanArslansOracleBlog]

just create the new tempfiles in the desired location and then get rid of the old ones Raiq.

Some refs:

Rename a Pluggable Database In Oracle 12c (Doc ID 2439885.1)
Moving A Tempfile Online giving error ORA-01516: Nonexistent Log File, Data File, (Doc ID 2506456.1)