Home » RDBMS Server » Backup & Recovery » problem in rename datafiles after migration from ASM to non-ASM (oracle 10.2.0.4)
problem in rename datafiles after migration from ASM to non-ASM [message #317717] Fri, 02 May 2008 14:40 Go to next message
Nick_01
Messages: 36
Registered: March 2008
Member
Hi,

I recently migrated the database from ASM to non-ASM, I performed the following steps using RMAN after editing the pfile to have control file location to the filesystem.
1.RESTORE CONTROLFILE FROM '+DATA/current.256.602861507';
2.backup as copy database format '/u01/data/%U'
3.switch database to copy;
4.dropped and recreated redolog members

After starting the database I could find that all ctrl files , log files and datafiles are in the filesystem. But the datafiles have the names of the RMAN backup piece as given below..

/u01/oradata/mso/data/data_D-MSO_I-536036538_TS-SYSTEM_FNO-1_0ajf9h5i

how do I rename the above datafile to have a /u01/oradata/mso/data/system01.dbf..

When I tried 'ALTER DATABASE rename file '/u01/oradata/mso/data/data_D-MSO_I-536036538_TS-SYSTEM_FNO-1_0ajf9h5i' to '/u01/oradata/mso/data/system01.dbf'

I could not succeed..

Can any one guide me how to go about,,

Re: problem in rename datafiles after migration from ASM to non-ASM [message #317745 is a reply to message #317717] Sat, 03 May 2008 00:10 Go to previous message
NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad
Member
Copy and paste the exact message that you are getting.

Alter database rename file...command works only when the database is in mount state.
Previous Topic: Unable to connect to the Target from catalog
Next Topic: how to recover tablespace non system tablespace (merged)
Goto Forum:
  


Current Time: Mon Dec 05 14:40:24 CST 2016

Total time taken to generate the page: 0.20683 seconds