Oracle technology: How to migrate ASM to the file system

--Create Pfile file

sql> Create pfile = '/tmp/pfile ' from SPFile;

File created.

Sql> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0-production

With the partitioning, OLAP and Data Mining options

--Modify the content in Pfile about ASM

Control_files

Db_recovery_file_dest

Log_archive_dest_1

Specify to File system

--Login Rman

[Oracle@localhost tmp]$ Rman Target/

Recovery manager:release 10.2.0.3.0-production on Mon June 27 12:48:26 2011

Copyright (c) 1982, +, Oracle. All rights reserved.

Connected to target Database:tos (dbid=1569606545)

--Perform backup as copy datafile

rman> Backup as Copy datafile ' +data/tos/datafile/users.276.754906035 ' format '/u01/oradata/tos/users01.dbf ';

Starting backup at 27-jun-11

Using target database control file instead of recovery catalog

Allocated Channel:ora_disk_1

Channel ora_disk_1:sid=141 Devtype=disk

Channel ora_disk_1:starting datafile Copy

Input datafile fno=00004 name=+data/tos/datafile/users.276.754906035

Output filename=/u01/oradata/tos/users01.dbf tag=tag20110627t124853 recid=17 stamp=754922939

Channel ora_disk_1:datafile copy complete, elapsed time:00:00:07

Finished backup at 27-jun-11

rman> Backup as Copy datafile ' +data/tos/datafile/sysaux.271.754905929 ' format '/u01/oradata/tos/sysaux01.dbf ';

Starting backup at 27-jun-11

Using channel Ora_disk_1

Channel ora_disk_1:starting datafile Copy

Input datafile fno=00003 name=+data/tos/datafile/sysaux.271.754905929

More Wonderful content: http://www.bianceng.cn/database/Oracle/

Output filename=/u01/oradata/tos/sysaux01.dbf tag=tag20110627t124929 recid=18 stamp=754923029

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

Finished backup at 27-jun-11

rman> Backup as Copy datafile ' +data/tos/datafile/undotbs1.273.754906021 ' format '/u01/oradata/tos/undotbs101.dbf ' ;

Starting backup at 27-jun-11

Using channel Ora_disk_1

Channel ora_disk_1:starting datafile Copy

Input datafile fno=00002 name=+data/tos/datafile/undotbs1.273.754906021

Output filename=/u01/oradata/tos/undotbs101.dbf tag=tag20110627t125049 recid=19 stamp=754923057

Channel ora_disk_1:datafile copy complete, elapsed time:00:00:15

Finished backup at 27-jun-11

rman> Backup as Copy datafile ' +data/tos/datafile/system.270.754905833 ' format '/u01/oradata/tos/system01.dbf ';

Starting backup at 27-jun-11

Using channel Ora_disk_1

Channel ora_disk_1:starting datafile Copy

Input datafile fno=00001 name=+data/tos/datafile/system.270.754905833

Output filename=/u01/oradata/tos/system01.dbf tag=tag20110627t125112 recid=20 stamp=754923150

Channel ora_disk_1:datafile copy complete, elapsed time:00:01:25

Channel ora_disk_1:starting datafile Copy

Copying control file

Rman-03009:failure of Backup command on Ora_disk_1 channel at 06/27/2011 12:52:39

Ora-01580:error Creating control Backup FILE/U01/ORADATA/TOS/SYSTEM01.DBF

ora-27038:created file already exists

Additional Information:1

Continuing other job steps, job failed won't be re-run

Channel ora_disk_1:starting full datafile backupset

Channel ora_disk_1:specifying DataFile (s) in Backupset

Including current SPFILE in Backupset

Channel ora_disk_1:starting piece 1 at 27-jun-11

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR message STACK follows ===============

RMAN-00571: ===========================================================

Rman-03009:failure of Backup command on Ora_disk_1 channel at 06/27/2011 12:52:42

ora-19504:failed to create file "/U01/ORADATA/TOS/SYSTEM01.DBF"

ora-27038:created file already exists

Additional Information:1

Note: Because the backup system data file is, by default, the control file is automatically backed up, because the SYSTEM01.DBF has been backed up, and the control file is backed up to that name, it fails

rman> Backup as Copy datafile ' +data/tos/datafile/example.272.754905995 ' format '/u01/oradata/tos/example01.dbf ';

Starting backup at 27-jun-11

Using channel Ora_disk_1

Channel ora_disk_1:starting datafile Copy

Input datafile fno=00005 name=+data/tos/datafile/example.272.754905995

Output filename=/u01/oradata/tos/example01.dbf tag=tag20110627t125341 recid=21 stamp=754923244

Channel ora_disk_1:datafile copy complete, elapsed time:00:00:25

Finished backup at 27-jun-11

rman> Backup as Copy datafile ' +data/tos/datafile/xff.274.754906027 ' format '/u01/oradata/tos/xff01.dbf ';