Migrate pluggable database from filesystem to ASM
Posted by raiq1 on Mar 28, 2022; 2:26pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Migrate-pluggable-database-from-filesystem-to-ASM-tp10815.html
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