RESETLOGS ORA-00392
来源:互联网 发布:养殖场记账软件 编辑:程序博客网 时间:2024/06/15 05:15
RAMN 恢复后,用resetlogs打开数据库时遇到了ORA-00392错误:
ORA-00392: log 7 of thread 1 is being cleared, operation not allowed
RMAN> alter database open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 05/25/2012 09:41:46
ORA-00392: log 7 of thread 1 is being cleared, operation not allowed
ORA-00312: online log 7 thread 1: '/opt/ora11g/oradata/acscnprd/redo/redo07.rdo'
1.获取创建控制文件的脚本
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS '/tmp/control.sql' resetlogs ;
2.修改/tmp/control.sql,在创建控制文件的位置加入RESETLOGS选项。
CREATE CONTROLFILE REUSE DATABASE "ACSCNPRD" FORCE LOGGING ARCHIVELOG
....
LOGFILE
......
RESETLOGS
DATAFILE
3.关闭数据库
SQL>SHUTDOWN IMMEDIATE
4.把数据库启动到mount状态
SQL>STARTUP FORCE NOMOUNT
5.执行生成的control.sql
SQL> @/tmp/control.sql
ORA-01081: cannot start already-running ORACLE - shut it down first
Control file created.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
ORA-00279: change 733410844 generated at 05/24/2012 05:15:53 needed for thread1
ORA-00289: suggestion :
/opt/ora11g/fast_recovery_area/ACSCNPRD/archivelog/2012_05_25/o1_mf_1_7293_%u_.arc
ORA-00280: change 733410844 for thread 1 is in sequence #7293
ORA-00308: cannot open archived log
'/opt/ora11g/fast_recovery_area/ACSCNPRD/archivelog/2012_05_25/o1_mf_1_7293_%u_.arc'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/opt/ora11g/oradata/acscnprd/system01.dbf'
ALTER TABLESPACE TEMP ADD TEMPFILE '/opt/ora11g/oradata/acscnprd/temp01.dbf' REUSE
*
ERROR at line 1:
ORA-01109: database not open
Database altered.
6.进行恢复
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
ORA-00279: change 733410844 generated at 05/24/2012 05:15:53 needed for thread1
ORA-00289: suggestion :
/opt/ora11g/fast_recovery_area/ACSCNPRD/archivelog/2012_05_25/o1_mf_1_7293_%u_.arc
ORA-00280: change 733410844 for thread 1 is in sequence #7293
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
CANCEL
Media recovery cancelled.
7.以RESETLOGS方式打开数据库.
SQL> ALTER DATABASE OPEN RESETLOGS ;
Database altered.
8.查看数据库状态
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE
- RESETLOGS ORA-00392
- OPEN RESETLOGS 启动,报ORA-00392 ORA-00312错误
- resetlogs
- ora 10g 跨越resetlogs 进行恢复 (test 成功)
- ORA-01589错误 要打开数据库则必须使用 RESETLOGS 或 NORESETLOGS 选项
- ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
- ORA-19909:当进行不完全恢复之后使用open database resetlogs
- “ORA-01589:must use RESETLOGS or NORESETLOGS option for database open”
- ORA-01190: 控制文件或数据文件 6 来自最后一个 RESETLOGS 之前
- ORA-01589: 要打开数据库则必须使用 RESETLOGS 或 NORESETLOGS 选项
- 重建控制文件时提示ORA-01189: file is from a different RESETLOGS than previous files
- ora-01033:oracle initialization or shutdown in progress(ORA-01589: 要打开数据库则必须使用 RESETLOGS 或 NORESETL)
- resetlogs选项
- resetlogs noresetlogs
- 关于resetlogs
- RESETLOGS,NORESETLOGS
- recover through resetlogs
- 完全恢复与Resetlogs
- Android中使用语音引擎入门七步曲
- css---心得
- 搭建cocos2d-x工程
- ROW_NUMBER() OVER 函数使用方法
- Python之全局变量
- RESETLOGS ORA-00392
- Java学习第八天
- jquery label的值用$("#id").text() ,类似html()的用法,可赋值可取值
- 排序算法(2)-冒泡排序
- java.1 java初识
- ASP.NET 指令语法大全
- Linux删除文件夹命令
- 一位工科硕士毕业14年所分享他的经验教训
- 图学PowerBuilder----Datawindow数据列表分组小计功能