oracle redo损坏的处理(二)
7046: file size is not a multiple of logical block size
Additional information: 1
SQL> CREATE CONTROLFILE REUSE DATABASE "SKYREAD" RESETLOGS FORCE LOGGING ARCHIVELOG
2 MAXLOGFILES 20
3 MAXLOGMEMBERS 5
4 MAXDATAFILES 1000
5 MAXINSTANCES 8
6 MAXLOGHISTORY 2337
7 LOGFILE
8 GROUP 1 '/database/oradata/skyread/redo01.log' SIZE 512M,
9 GROUP 2 '/database/oradata/skyread/redo02.log' SIZE 512M,
10 GROUP 3 '/database/oradata/skyread/redo03.log' SIZE 512M,
11 GROUP 4 '/database/oradata/skyread/redo04.log' SIZE 512M,
12 GROUP 5 '/database/oradata/skyread/redo05.log' SIZE 512M
13 DATAFILE
14 '/database/oradata/skyread/system01.dbf',
15 '/database/oradata/skyread/tbs_test.dbf',
16 '/database/oradata/skyread/sysaux01.dbf',
17 '/database/oradata/skyread/users01.dbf',
18 '/database/oradata/skyread/system02.dbf',
19 '/database2/oradata/skyread/undotbs02.dbf',
20 '/database2/oradata/skyread/TBS_MRPMUSIC01.dbf',
21 '/database/oradata/skyread/sf01.dbf'
22 CHARACTER SET UTF8;
Control file created.
下面是一系列的打开过程，由于redo04.log是活动的，所以需要恢复
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
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: '/database/oradata/skyread/system01.dbf'
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SQL> recover database using backup controlfile;
ORA-00279: change 122695861946 generated at 06/04/2013 13:48:31 needed for thread 1
ORA-00289: suggestion : /database/oradata/arch/1_34_815416841.dbf
ORA-00280: change 122695861946 for thread 1 is in sequence #34
Specify log: {=suggested | filename | AUTO | CANCEL}
/database/oradata/arch/1_34_815416841.dbf
ORA-00308: cannot open archived log '/database/oradata/arch/1_34_815416841.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
应用日志并打开
数据库：
Specify log: {=suggested | filename | AUTO | CANCEL}
/database/oradata/skyread/redo05.log
Log applied.
Media recovery complete.
SQL> alter database open resetlogs;
Database altered.
如果是未归档的活动在线日志文件损坏，那么需要有数据文件的备份才能恢复，这里不再详细介绍。