i used oracle 10G,when I want to recreate controfile,i get error,
oracle 10G is OMF,it looks like some problem with Oracle 10G OMF,i search in metalink,but i can not get any userful message about oracle 10G.I only can solve by myself,share my experience with others。
process as follows:
D:\>sqlplus / as sysdba
SQL*Plus: Release 10.1.0.2.0 - Production on 星期一 4月 19 09:52:38 2004
Copyright (c) 1982, 2004, Oracle. All rights reserved.
已连接到空闲例程。
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 134217728 bytes
Fixed Size 787808 bytes
Variable Size 49281696 bytes
Database Buffers 83886080 bytes
Redo Buffers 262144 bytes
数据库装载完毕。
数据库已经打开。
SQL> alter database backup controlfile to trace;
数据库已更改。
SQL> shutdown immediate
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup nomount
ORACLE 例程已经启动。
Total System Global Area 134217728 bytes
Fixed Size 787808 bytes
Variable Size 49281696 bytes
Database Buffers 83886080 bytes
Redo Buffers 262144 bytes
SQL> @d:\a.sql
CREATE CONTROLFILE REUSE DATABASE "ORCL10" NORESETLOGS NOARCHIVELOG
*
第 1 行出现错误:
ORA-01503: CREATE CONTROLFILE ??
ORA-01276: ??????
D:\ORACLE10G\PRODUCT\10.1.0\ORADATA\ORCL10\CONTROLFILE\O1_MF_0647DNPG_.CTL??????
??? Oracle Managed Files ????
then i comment the line in init file,recreate spfile
#control_files=("D:\ORACLE10G\PRODUCT\10.1.0\ORADATA\ORCL10\CONTROLFILE\O1_MF_0647DNPG_.CTL", "D:\ORACLE10G\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\ORCL10\CONTROLFILE\O1_MF_0647DO7S_.CTL"
SQL> create spfile from pfile;
文件已创建。
SQL> @d:\a.sql
ORACLE 例程已经启动。
Total System Global Area 134217728 bytes
Fixed Size 787808 bytes
Variable Size 49281696 bytes
Database Buffers 83886080 bytes
Redo Buffers 262144 bytes
控制文件已创建
it is ok la !
hope this will be helpful to all。