Sample Header Ad - 728x90

rename datafile when file does not exists

0 votes
3 answers
10594 views
I am trying to clone our production database in test virtual machine. Our production database works with ASM. I would like to use plain file system in test database. I created database, services, pfile etc. I gave production database control files to test database. Right now I am trying to rename datafiles in test database. I get following error. SQL> startup mount; ..... SQL> alter database rename file '+NEWDATA/XX/XX01.dbf' to 'M:\oracle\datafiles\XX\XX01.dbf'; alter database rename file '+NEWDATA/XX/XX01.dbf' to 'M:\oracle\datafiles\XX\XX01.dbf'; * ERROR at line 1: ORA-01511: error in renaming log/data files ORA-01141: error renaming data file 162 - new file 'M:\oracle\datafiles\XX\XX01.dbf' not found ORA-01110: data file 162: '+NEWDATA/XX/XX01.dbf' ORA-27046: file size is not a multiple of logical block size OSD-04012: file size mismatch O/S-Error: (OS 4) The system cannot open the file. My backup is normal rman backup pieces not backup as copy. I am trying to rename nonexistent files. After this rename process , I will try to restore database from rman backup. But this backup is not piece by piece copy.
Asked by Atilla Ozgur (1466 rep)
Dec 30, 2013, 12:31 PM
Last activity: Dec 31, 2013, 01:31 PM