How To Move a Datafile in the File System to the ASM Disk Group

 

Files that are created accidentally or deliberately in the file system in a database that uses ASM often cause problems.

In particular, a file created in the file system on a node in RAC databases will not be seen by the other node, so there will be problems with the operations associated with this datafile.

In this case, a file in the file system can be moved into the ASM disk group by following the steps below.

Step1:

The relevant tablespace must be offline.

Step2:

Find the exact path of the datafile in the file system.

Steps3:

We copy the corresponding file into the ASM disk group (+ DATA) with rman.

Steps4:

We’re changing the name of the relavent file with sqlplus.

Steps5:

We set the relevant tablespace online.

Steps6:

Finally, we delete the file in the file system.

When we check all datafiles again, there should be no datafile in the file system.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *