俺顶一下加个错误信息:
=================================SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.Total System Global Area 608174080 bytes
Fixed Size 1220820 bytes
Variable Size 205524780 bytes
Database Buffers 394264576 bytes
Redo Buffers 7163904 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database openSQL> 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: '/home/oracle/oradata/orcl/system01.dbf'
=================================SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.Total System Global Area 608174080 bytes
Fixed Size 1220820 bytes
Variable Size 205524780 bytes
Database Buffers 394264576 bytes
Redo Buffers 7163904 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database openSQL> 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: '/home/oracle/oradata/orcl/system01.dbf'
解决方案 »
- sql 不等於跟null為什麼不能同時抓出?
- 不显示删除回复显示所有回复显示星级回复显示得分回复 import org.apache.commons.lang.StringUtils;这样的包是放在文件夹
- oracle存储过程中类似@@IDENTITY
- oracle允许在sys方案中创建数据表,为什么不允许在创建的数据表上写触发器?
- 如何在oracle存储过程中使用partiton 啊,想用for循环实现
- 请教:用哪个字符集比较好?
- 一個表中反復查詢的問題!!!!急急急(解決驪上結貼)
- 如何获取update所操作的条数
- 为什么我用sql server 导出表到oracle 中后,在oracle 中select 这些表的话,表名要加引号且要区分大小写
- 简单的Oracle问题,散分了!
- 数据库恢复问题?
- 如何按依赖关系获得视图名称
recover database untill time|change_no;
alter database open resetlogs;
SQL> STARTUP NOMOUNT
SQL> CREATE CONTROLFILE REUSE DATABASE "TEST" RESETLOGS ARCHIVELOG
SQL> ALTER DATABASE OPEN RESETLOGS;
马上备份如果不是非安全关闭:
非当前日志就
SQL>alter database clear unarchived logfile group n;
当前日志:
在initsid>.ora中加入如下参数 _allow_resetlogs_corruption=TRUE
SQL>recover database until cancel;
Cancel
如果出错,不再理会,发出
SQL>alter database open resetlogs;
打开后也是马上备份
SQL> alter system set "_allow_resetlogs_corruption"=true scope=spfile;System altered.SQL> shutdown immediate;
ORA-01109: database not openDatabase dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.Total System Global Area 97588504 bytes
Fixed Size 451864 bytes
Variable Size 33554432 bytes
Database Buffers 62914560 bytes
Redo Buffers 667648 bytes
Database mounted.
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 897612315 generated at 10/19/2005 16:54:18 needed for thread 1
ORA-00289: suggestion : /opt/oracle/oradata/conner/archive/1_160.dbf
ORA-00280: change 897612315 for thread 1 is in sequence #160
Specify log: {=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/opt/oracle/oradata/conner/system01.dbf'
ORA-01112: media recovery not started
SQL> alter database open resetlogs;执行到这个地方的时候,就出了问题
连接被强行中断SQL>recover database until cancel;
SQL>alter database open resetlogs;
死了,半天没反应
...数据库版本是 oracle10g linux版