Shulou(Shulou.com)05/31 Report--

This article focuses on "oracle rac error creation of data files to the local directory how to deal with", interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn "oracle rac error creation of data files to the local directory how to deal with it"!

Change the data file in question to 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/gc_test1.dbf 25

SQL > alter database datafile 25 offline

Database altered.

SQL > select file_name, file_id, online_status from dba_data_files where file_id=25

FILE_NAME FILE_ID ONLINE_STATUS

--

/ u01/oracle/oradata/gc_test1.dbf 25 RECOVER

Use the asmcmd command to copy files from the local directory to a shared disk group

ASMCMD > cp / u01/oracle/oradata/gc_test1.dbf + DATADG/PROD/DATAFILE/gc_test1.dbf

Copying / u01/oracle/oradata/gc_test1.dbf-> + DATADG/PROD/DATAFILE/gc_test1.dbf

Rename every data file that has been copied

SQL > alter database rename file'/ u01 apprentice oracle.oradata. Dbf'to'+ DATA/PROD/DATAFILE/gc_test1.dbf'; Database altered.

Recover data file and online it

SQL > alter database recover datafile 25

Database altered.

SQL > alter database datafile 25 online

Database altered.

Confirm that the modification is successful

SQL > select file_name, file_id, online_status from dba_data_files where file_id=6

FILE_NAME FILE_ID ONLINE_STATUS

--

+ DATA/prod/datafile/gc_test1.dbf 25 ONLINE

At this point, I believe that everyone on the "oracle rac error creation of data files to the local directory how to handle" have a deeper understanding, might as well to the actual operation of it! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.