IT分销/经销 Oracleaix 5.3

AIX 5.3系统ORACLE 11数据库报错,请高手指教!非常感谢!

我是个初学者,对ORACLE不是很了解,还请各位大虾帮忙看看。。最好能有详细的操作步骤!多谢啦。。:P% sqlplus "/ as sysdba"SQL*Plus: Release 11.1.0.6.0 - Production on Fri Feb 4 05:22:01 2011Copyright (c) 1982, 2007, Oracle.  All rights reserved.Connec... 显示全部
我是个初学者,对ORACLE不是很了解,还请各位大虾帮忙看看。。最好能有详细的操作步骤!多谢啦。。:P


% sqlplus "/ as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on Fri Feb 4 05:22:01 2011

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

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


启动时报错:
SQL> startup;
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 1.3429E+10 bytes
Fixed Size                  2142840 bytes
Variable Size            7516196232 bytes
Database Buffers         5905580032 bytes
Redo Buffers                4734976 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


SQL> shutdown immediate;
ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.



看网上说要查看:$ORACLE_BASE/admin/.../bdump/alter_TEST.log文件,但是我的那个目录下都没有这个bdump目录,不知道什么时候没有了。


% pwd
/opt/oracle/admin/ORA103
% ls -a
.       ..      adump   dpdump  pfile


----------------------------------------------------------------------------------
补充:
现在的问题是这样啦,还请各位大神出手相助啊。。。

SQL> startup mount;
ORACLE instance started.
Total System Global Area 1.3429E+10 bytes
Fixed Size                  2142840 bytes
Variable Size            7516196232 bytes
Database Buffers         5905580032 bytes
Redo Buffers                4734976 bytes
Database mounted.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/opt/oracle/oradata/ORA103/system01.dbf'
收起
参与25

查看其它 23 个回答296308389 的回答

296308389 296308389 系统管理员 epro
回复 15# steven_zw
您好!
按照你的步骤,执行到第六步的时候报错了!还麻烦您才看一下!多谢。。

已经注释掉了:
#*.remote_os_authent=TRUE

SQL> startup nomount pfile='/opt/oracle/product/11.1.0/db_1/dbs/initORA103.ora';
ORACLE instance started.

Total System Global Area 1.3429E+10 bytes
Fixed Size                  2142840 bytes
Variable Size            7516196232 bytes
Database Buffers         5905580032 bytes
Redo Buffers                4734976 bytes
SQL> create spfile from pfile;

File created.

SQL> shutdown immediate;
ORA-01507: database not mounted


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

Total System Global Area 1.3429E+10 bytes
Fixed Size                  2142840 bytes
Variable Size            7516196232 bytes
Database Buffers         5905580032 bytes
Redo Buffers                4734976 bytes
Database mounted.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/opt/oracle/oradata/ORA103/system01.dbf'
IT分销/经销 · 2012-09-06
浏览2125

回答者

296308389
系统管理员 epro
评论16

296308389 最近回答过的问题

回答状态

  • 发布时间:2012-09-06
  • 关注会员:1 人
  • 回答浏览:2125
  • X社区推广