OraFAQ Forum: Backup & Recovery » problem in rename datafiles after migration from ASM to non-ASM

Home » RDBMS Server » Backup & Recovery » problem in rename datafiles after migration from ASM to non-ASM (oracle 10.2.0.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

problem in rename datafiles after migration from ASM to non-ASM [message #317717]

Fri, 02 May 2008 14:40

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,,

Report message to a moderator

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

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.

Report message to a moderator

Previous Topic:	Unable to connect to the Target from catalog
Next Topic:	how to recover tablespace non system tablespace (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 10 12:57:23 CDT 2024