《非归档模式system表空间损坏数据库恢复》由会员分享,可在线阅读,更多相关《非归档模式system表空间损坏数据库恢复(10页珍藏版)》请在金锄头文库上搜索。
1、-bash-3.00$ sqlplus /as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on 星期三 10 月 20 16:39:27 2010Copyright (c) 1982, 2009, Oracle. All rights reserved.连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testi
2、ng optionsSQL SQL SQL Select version FROM Product_component_version 2 Where SUBSTR(PRODUCT,1,6)=Oracle;Select version FROM Product_component_version*第 1 行出现错误:ORA-01219: 数据库未打开: 仅允许在固定表/ 视图中查询SQL select status from v$instance;STATUS-MOUNTEDSQL alter database open;alter database open*第 1 行出现错误:ORA-01
3、589: 要打开数据库则必须使用 RESETLOGS 或 NORESETLOGS 选项SQL alter database open resetlogsl2 SQL SQL SQL alter database open resetlogs;alter database open resetlogs*第 1 行出现错误:ORA-01113: 文件 1 需要介质恢复ORA-01110: 数据文件 1: /usr2/ORADATA/syssystem01.dbfSQL recover datafile 1;ORA-00283: 恢复会话因错误而取消ORA-01610: 使用 BACKUP CONT
4、ROLFILE 选项的恢复必须已完成SQL recover datafile 1 using backup CONTROLFILE;ORA-00274: 非法恢复选项 USINGSQL recover datafile 1 backup CONTROLFILE;ORA-00905: 缺失关键字SQL recover datafile 1 using backup CONTROLFILE until cancel;ORA-00274: 非法恢复选项 USINGSQL recover datafile 1 until cancel;ORA-00274: 非法恢复选项 UNTILSQL recove
5、r datafile 1;ORA-00283: 恢复会话因错误而取消ORA-01610: 使用 BACKUP CONTROLFILE 选项的恢复必须已完成SQL recover database until cancel;ORA-00283: 恢复会话因错误而取消ORA-01610: 使用 BACKUP CONTROLFILE 选项的恢复必须已完成SQL recover database using backup controlfile;ORA-00279: 更改 4599655 (在 10/14/2010 11:38:38 生成) 对于线程 1 是必需的ORA-00289: 建议:/usr2
6、/ORADATA/redo_log/SI11G/archivelog/2010_10_20/o1_mf_1_80_%u_.arcORA-00280: 更改 4599655 (用于线程 1) 在序列 #80 中指定日志: =suggested | filename | AUTO | CANCELautoORA-00308: 无法打开归档日志/usr2/ORADATA/redo_log/SI11G/archivelog/2010_10_20/o1_mf_1_80_%u_.arcORA-27037: 无法获得文件状态SVR4 Error: 2: No such file or directoryAd
7、ditional information: 3ORA-00308: 无法打开归档日志/usr2/ORADATA/redo_log/SI11G/archivelog/2010_10_20/o1_mf_1_80_%u_.arcORA-27037: 无法获得文件状态SVR4 Error: 2: No such file or directoryAdditional information: 3SQL recover database using backup controlfile;ORA-00279: 更改 4599655 (在 10/14/2010 11:38:38 生成) 对于线程 1 是必需
8、的ORA-00289: 建议:/usr2/ORADATA/redo_log/SI11G/archivelog/2010_10_20/o1_mf_1_80_%u_.arcORA-00280: 更改 4599655 (用于线程 1) 在序列 #80 中指定日志: =suggested | filename | AUTO | CANCELcancel介质恢复已取消。SQL alter database open resetlogs;alter database open resetlogs*第 1 行出现错误:ORA-01113: 文件 1 需要介质恢复ORA-01110: 数据文件 1: /usr
9、2/ORADATA/syssystem01.dbfSQL recover datafile 1 using backup controlfile;ORA-00274: 非法恢复选项 USINGSQL recover datafile 1 ; ORA-00283: 恢复会话因错误而取消ORA-01610: 使用 BACKUP CONTROLFILE 选项的恢复必须已完成SQL recover database using backup controlfile;ORA-00279: 更改 4599655 (在 10/14/2010 11:38:38 生成) 对于线程 1 是必需的ORA-00289
10、: 建议:/usr2/ORADATA/redo_log/SI11G/archivelog/2010_10_20/o1_mf_1_80_%u_.arcORA-00280: 更改 4599655 (用于线程 1) 在序列 #80 中指定日志: =suggested | filename | AUTO | CANCELORA-00308: 无法打开归档日志/usr2/ORADATA/redo_log/SI11G/archivelog/2010_10_20/o1_mf_1_80_%u_.arcORA-27037: 无法获得文件状态SVR4 Error: 2: No such file or direc
11、toryAdditional information: 3SQL recover database using backup controlfile;ORA-00279: 更改 4599655 (在 10/14/2010 11:38:38 生成) 对于线程 1 是必需的ORA-00289: 建议:/usr2/ORADATA/redo_log/SI11G/archivelog/2010_10_20/o1_mf_1_80_%u_.arcORA-00280: 更改 4599655 (用于线程 1) 在序列 #80 中指定日志: =suggested | filename | AUTO | CANCE
12、LORA-00308: 无法打开归档日志/usr2/ORADATA/redo_log/SI11G/archivelog/2010_10_20/o1_mf_1_80_%u_.arcORA-27037: 无法获得文件状态SVR4 Error: 2: No such file or directoryAdditional information: 3SQL recover database using backup controlfile;ORA-00279: 更改 4599655 (在 10/14/2010 11:38:38 生成) 对于线程 1 是必需的ORA-00289: 建议:/usr2/O
13、RADATA/redo_log/SI11G/archivelog/2010_10_20/o1_mf_1_80_%u_.arcORA-00280: 更改 4599655 (用于线程 1) 在序列 #80 中指定日志: =suggested | filename | AUTO | CANCELautoORA-00308: 无法打开归档日志/usr2/ORADATA/redo_log/SI11G/archivelog/2010_10_20/o1_mf_1_80_%u_.arcORA-27037: 无法获得文件状态SVR4 Error: 2: No such file or directoryAddi
14、tional information: 3ORA-00308: 无法打开归档日志/usr2/ORADATA/redo_log/SI11G/archivelog/2010_10_20/o1_mf_1_80_%u_.arcORA-27037: 无法获得文件状态SVR4 Error: 2: No such file or directoryAdditional information: 3SQL recover database using backup controlfile;ORA-00279: 更改 4599655 (在 10/14/2010 11:38:38 生成) 对于线程 1 是必需的O
15、RA-00289: 建议:/usr2/ORADATA/redo_log/SI11G/archivelog/2010_10_20/o1_mf_1_80_%u_.arcORA-00280: 更改 4599655 (用于线程 1) 在序列 #80 中指定日志: =suggested | filename | AUTO | CANCELautoORA-00308: 无法打开归档日志/usr2/ORADATA/redo_log/SI11G/archivelog/2010_10_20/o1_mf_1_80_%u_.arcORA-27037: 无法获得文件状态SVR4 Error: 2: No such f
16、ile or directoryAdditional information: 3ORA-00308: 无法打开归档日志/usr2/ORADATA/redo_log/SI11G/archivelog/2010_10_20/o1_mf_1_80_%u_.arcORA-27037: 无法获得文件状态SVR4 Error: 2: No such file or directoryAdditional information: 3SQL recover database using backup controlfile;ORA-00279: 更改 4599655 (在 10/14/2010 11:38:38 生成) 对于线程 1 是必需的ORA-00289: 建议:/usr2/ORADATA/redo_log/SI11G/archivelog/2010_