Shulou(Shulou.com)06/01 Report--

The solution to creating local data files in the RAC environment:

The ideas are as follows:

1. Data file offline

two。 Copy data files to storage via RMAN

3.alter database rename file modifies the local file path to the storage path

4. Data file online

Do the following:

SQL > select file_name,file_id,ONLINE_STATUS from dba_data_files;-query data file information is 27

SQL > alter database datafile 27 offline;-data files offline

RMAN > copy datafile 27 to'+ DATADG';-- rman copies files

Starting backup at 18-JUN-14

Using target database control file instead of recovery catalog

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: SID=6446 instance=orcl1 device type=DISK

Allocated channel: ORA_DISK_2

Channel ORA_DISK_2: SID=6672 instance=orcl1 device type=DISK

Allocated channel: ORA_DISK_3

Channel ORA_DISK_3: SID=6783 instance=orcl1 device type=DISK

Allocated channel: ORA_DISK_4

Channel ORA_DISK_4: SID=7125 instance=orcl1 device type=DISK

Channel ORA_DISK_1: starting datafile copy

Input datafile file number=00027 name=/app/oracle/product/11.2.0/dbhome_1/dbs/11111.ora

Output file name=+DATADG/orcl/datafile/mcc.291.850576959 tag=TAG20140618T152238 RECID=1 STAMP=850577020

Channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:05

Finished backup at 18-JUN-14

SQL > alter database rename file'/ app/oracle/product/11.2.0/dbhome_1/dbs/11111.ora' to'+ DATADG/orcl/datafile/mcc.291.850576959';-rename the file

RMAN > switch datafile 27 to copy;-- rman update control file

SQL > recover datafile 27;-- recover data file

SQL > alter database datafile 27 online;-data files online

SQL > select file_name,file_id,ONLINE_STATUS from dba_data_files;-- query status

SQL > select file_name,file_id,ONLINE_STATUS from dba_data_files

Reference: http://blog.itpub.net/501889/viewspace-1083311/

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.