ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle重新使用spfile后无法mount数据库

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

原创 Linux操作系统 作者:@oracle@_cu 时间:2009-03-07 16:53:29 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: SPFILE 和 PFILE
请登录后发表评论 登录
全部评论

注册时间:2009-03-03

  • 博文量
    10
  • 访问量
    16804