我是个初学者,对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'
收起