ORA-01503: CREATE CONTROLFILE failed
753926May 4 2010 — edited May 5 2010I use Window XP with Oracle 10g 10.2.0.1.0.
Please help.......
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "ORCL" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 SIZE 1500 M ,
GROUP 2 SIZE 1500 M ,
GROUP 3 SIZE 1500 M
DATAFILE
'C:\ORACLE\ORADATA\DATAFILE\O1_MF_SYSTEM_2KC457M8_.DBF'
CHARACTER SET WE8MSWIN1255
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 05/04/2010 12:25:10
RMAN-06136: ORACLE error from auxiliary database: ORA-01503: CREATE CONTROLFILE failed
*ORA-01276: Cannot add file +DG1/orcl/controlfile/current.509.649687193. File has an Oracle Managed Files file name.*
On auxiliary, I run a sql as below, but it returns no rows.
SQL> select name from v$controlfile;
no rows selected
Edited by: Kee Kee on May 4, 2010 12:10 PM