Login  Register

Migrate pluggable database from filesystem to ASM

classic Classic list List threaded Threaded
4 messages Options Options
Embed post
Permalink
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

Migrate pluggable database from filesystem to ASM

raiq1
157 posts
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
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

Re: Migrate pluggable database from filesystem to ASM

ErmanArslansOracleBlog
Administrator
5727 posts
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
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

Re: Migrate pluggable database from filesystem to ASM

raiq1
157 posts
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

Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

Re: Migrate pluggable database from filesystem to ASM

ErmanArslansOracleBlog
Administrator
5727 posts
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)