oracle重新使用spfile后无法mount数据库

http://www.powersite.cn/?q=node/104

今天在解决一个oracle数据库问题时，需要通过pfile生成spfile，create后，先是报memory pool设置的太小，改完后，再次启动oracle，结果报控制文件找不到，从原来的pfile文件中找到control_file一行，将内容拷贝过去，再次重新启动，虽然数据库可以启动，但是无法挂载，报ora-00201,ora-01103错误，在网上搜索了一圈，在itpub上找到了解决办法，报的错误都是一模一样，只要根据以下步骤操作即可。

[oracle@rdas3 log]$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.1.0.3.0 - Production on Tue Dec 6 10:37:26 2005

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> alter system set control_files='/opt/app/oracle/oradata/orcl/control01.ctl' scope=spfile;
alter system set control_files='/opt/app/oracle/oradata/orcl/control01.ctl' scope=spfile
*
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE specified at startup

SQL> create spfile from pfile;

File created.

SQL> shutdown immediate
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 88080384 bytes
Fixed Size 777812 bytes
Variable Size 87040428 bytes
Database Buffers 0 bytes
Redo Buffers 262144 bytes
ORA-00205: error in identifying controlfile, check alert log for more info

SQL> alter system set control_files='/opt/app/oracle/oradata/orcl/control01.ctl' scope=spfile;

System altered.

SQL> shutdown immediate
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 88080384 bytes
Fixed Size 777812 bytes
Variable Size 87040428 bytes
Database Buffers 0 bytes
Redo Buffers 262144 bytes
ORA-00201: controlfile version 10.1.0.2.0 incompatible with ORACLE version
10.0.0.0.0
ORA-00202: controlfile: '/opt/app/oracle/oradata/orcl/control01.ctl'

SQL> show parameter com

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
commit_point_strength integer 1
compatible string 10.0.0
max_commit_propagation_delay integer 700
nls_comp string
plsql_compiler_flags string INTERPRETED, NON_DEBUG
plsql_v2_compatibility boolean FALSE
SQL> alter system set compatible='10.1.0.3.0' scope=spfile;

System altered.

SQL> shutdown immediate
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 88080384 bytes
Fixed Size 777812 bytes
Variable Size 87040428 bytes
Database Buffers 0 bytes
Redo Buffers 262144 bytes
ORA-01103: database name 'ORCL' in controlfile is not 'DEFAULT'

SQL> oerr ora 1103
SP2-0734: unknown command beginning "oerr ora 1..." - rest of line ignored.
SQL> host oerr ora 1103
01103, 00000, "database name '%s' in controlfile is not '%s'"
// *Cause: The database name in the controlfile does not match your
// database name.
// *Action: Either find the correct controlfile or change your database name.

SQL> show parameter db_name

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string DEFAULT
SQL> alter system set db_name=ORCL scope=spfile;

System altered.

SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-01103: database name 'ORCL' in controlfile is not 'DEFAULT'

SQL> shutdown immediate
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 88080384 bytes
Fixed Size 777812 bytes
Variable Size 87040428 bytes
Database Buffers 0 bytes
Redo Buffers 262144 bytes
Database mounted.
Database opened.
SQL> exit

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/20570073/viewspace-563187/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/20570073/viewspace-563187/