? ? ? ? 2 /u01/app/oracle/oradata/test3/sysaux01.dbf? ? ? ? ? ? ? ? ? ? 333365
? ? ? ? 3 /u01/app/oracle/oradata/test3/undotbs01.dbf? ? ? ? ? ? ? ? ? ? 333365
? ? ? ? 4 /u01/app/oracle/oradata/test3/users01.dbf? ? ? ? ? ? ? ? ? ? ? 333365
4、打开数据库
11:00:54 SYS@ test3 >alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/app/oracle/oradata/test3/system01.dbf'
?
---打开数据库报错，需要做“media recovery”
?
执行介质恢复：
由于本库为非归档模式，只能通过current redolog来恢复
?
查看当前日志组：
[oracle@rh6 ~]$ sqlplus '/as sysdba'
SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 7 11:02:12 2015
Copyright (c) 1982, 2009, Oracle.? All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
?
11:02:12 SYS@ test3 >select member from v$logfile;
?
MEMBER
------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/test3/redo01a.log
/u01/app/oracle/oradata/test3/redo02a.log
?
11:02:22 SYS@ test3 >select group#,sequence#,status from v$log;
?
? ? GROUP#? SEQUENCE# STATUS
---------- ---------- ----------------
? ? ? ? 2? ? ? ? 12 INACTIVE
? ? ? ? 1? ? ? ? 13 CURRENT
?
?
11:00:59 SYS@ test3 >recover database until cancel;
ORA-00279: change 333365 generated at 01/07/2015 10:30:26 needed for thread 1
ORA-00289: suggestion : /u01/app/oracle/product/11.2.0/db_1/dbs/arch1_13_868275293.dbf
ORA-00280: change 333365 for thread 1 is in sequence #13
11:01:42 Specify log: {
/u01/app/oracle/oradata/test3/redo01a.log
Log applied.
Media recovery complete.
---恢复完成！
?
11:02:46 SYS@ test3 >alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
Elapsed: 00:00:00.01
?
11:02:52 SYS@ test3 >alter database open resetlogs;
Database altered.
?
---Database open成功！
查看告警日志：
alter database open
Errors in file /u01/app/oracle/diag/rdbms/test3/test3/trace/test3_ora_3294.trc:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/app/oracle/oradata/test3/system01.dbf'
ORA-1113 signalled during: alter database open...
Wed Jan 07 11:01:40 2015
ALTER DATABASE RECOVER? database until cancel?
Media Recovery Start
Serial Media Recovery started
ORA-279 signalled during: ALTER DATABASE RECOVER? database until cancel? ...
Wed Jan 07 11:02:44 2015
ALTER DATABASE RECOVER? ? LOGFILE '/u01/app/oracle/oradata/test3/redo01a.log'?
Media Recovery Log /u01/app/oracle/oradata/test3/redo01a.log
Incomplete recovery applied all redo ever generated.
Recovery completed through change 334001 time 01/07/2015 10:51:13
Media Recovery Complete (test3)
Completed: ALTER DATABASE RECOVER? ? LOGFILE '/u01/app/oracle/oradata/test3/redo01a.log'?
alter database open
Errors in file /u01/app/oracle/diag/rdbms/test3/test3/trace/test3_ora_3294.trc:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
ORA-1589 signalled during: alter database open...
Wed Jan 07 11:03:04 2015
alter database open resetlogs
RESETLOGS after complete recovery through change 334001
Resetting resetlogs activation ID 990996637 (0x3b11689d)
Errors in file /u01/app/oracle/diag/rdbms/test3/test3/trace/test3_ora_3294.trc:
ORA-00367: checksum