"Translated from MoS article" use the Asmcmd CP command to move the datafile from the file system (move) to the ASM Disk group-for 11GR2

Source: Internet
Author: User


Use the Asmcmd CP command to move the datafile from the file system (move) to the ASM Disk group-for 11GR2

Reference text:
How to Move a datafile from Filesystem to ASM Using asmcmd CP Command. (Doc ID 1610615.1)

Suitable for:
Oracle database-enterprise edition-version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.


Symptoms:
The datafile was incorrectly added to the file system and should be placed in the ASM Disk group.

Reason:
This is not a datafile of the system table space

Solution:

1 Let the datafile offline
sql> alter system switch logfile;
System altered.
Sql> Select file_name, file_id from Dba_data_files;
file_name file_id
---------------------
/U01/ORACLE/ORADATA/TEST1.DBF 6

Sql> ALTER DATABASE datafile 6 offline;
Database altered.
Sql> select file_name, file_id, online_status from Dba_data_files where file_id=6;
file_name file_id Online_status
---------- -------
/U01/ORACLE/ORADATA/TEST1.DBF 6 RECOVER


2. Use the Asmcmd command to copy this file from the file system to the ASM Disk group.
Asmcmd> cp/u01/oracle/oradata/test1.dbf +data/london/datafile/test.dbf
COPYING/U01/ORACLE/ORADATA/TEST1.DBF-+DATA/LONDON/DATAFILE/TEST.DBF

Asmcmd> Ls-lt
Type redund striped Time Sys Name
N test.dbf = +data/asm/datafile/test.dbf.286.833718815
asmcmd> pwd
+data/asm/datafile

3. Once the datafile is copied, rename the datafile
sql> ALTER DATABASE rename file '/u01/oracle/oradata/test1.dbf ' to ' +data/london/datafile/test.dbf ';
Database altered.

4. Recover the datafile, and onlime the datafile
sql> ALTER DATABASE recover datafile 6;
Database altered.

Sql> ALTER DATABASE datafile 6 online;
Database altered.


5. Confirm the correct file name and path

Sql> select file_name, file_id, online_status from Dba_data_files where file_id=6;
file_name file_id Online_status
---------- -------
+DATA/LONDON/DATAFILE/TEST.DBF 6 ONLINE

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.