2858 rows deleted.
#session 2
sys@ORCL>select group#,status from v$log;
GROUP# STATUS
---------- ------------------------------------------------
1 INACTIVE
2 ACTIVE
3 CURRENT
sys@ORCL>shutdown abort;
ORACLE instance shut down.
#删除redo log文件
[oracle@rhel6 ~]$ cd /u02/app/oracle/oradata/orcl/
[oracle@rhel6 orcl]$ ls -l
total 1944992
-rw-r----- 1 oracle oinstall 9748480 Feb 24 23:56 control01.ctl
-rw-r----- 1 oracle oinstall 9748480 Feb 24 23:56 control02.ctl
-rw-r----- 1 oracle oinstall 328343552 Feb 24 23:54 example01.dbf
-rw-r----- 1 oracle oinstall 52429312 Feb 24 23:54 redo01.log
-rw-r----- 1 oracle oinstall 52429312 Feb 24 23:55 redo02.log
-rw-r----- 1 oracle oinstall 52429312 Feb 24 23:55 redo03.log
-rw-r----- 1 oracle oinstall 545267712 Feb 24 23:54 sysaux01.dbf
-rw-r----- 1 oracle oinstall 796925952 Feb 24 23:54 system01.dbf
-rw-r----- 1 oracle oinstall 30416896 Feb 24 13:58 temp01.dbf
-rw-r----- 1 oracle oinstall 110108672 Feb 24 23:54 undotbs01.dbf
-rw-r----- 1 oracle oinstall 5251072 Feb 24 23:54 users01.dbf
[oracle@rhel6 orcl]$ rm redo*log
l[oracle@rhel6 orcl]$ ls -l
total 1791212
-rw-r----- 1 oracle oinstall 9748480 Feb 24 23:56 control01.ctl
-rw-r----- 1 oracle oinstall 9748480 Feb 24 23:56 control02.ctl
-rw-r----- 1 oracle oinstall 328343552 Feb 24 23:54 example01.dbf
-rw-r----- 1 oracle oinstall 545267712 Feb 24 23:54 sysaux01.dbf
-rw-r----- 1 oracle oinstall 796925952 Feb 24 23:54 system01.dbf
-rw-r----- 1 oracle oinstall 30416896 Feb 24 13:58 temp01.dbf
-rw-r----- 1 oracle oinstall 110108672 Feb 24 23:54 undotbs01.dbf
-rw-r----- 1 oracle oinstall 5251072 Feb 24 23:54 users01.dbf
2、启动数据库出现报错
1
2
3
4
5
6
7
8
9
10
11
12
13
14
idle>startup
ORACLE instance started.
Total System Global Area 1603411968 bytes
Fixed Size 2253664 bytes
Variable Size 1476398240 bytes
Database Buffers 117440512 bytes
Redo Buffers 7319552 bytes
Database mounted.
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u02/app/oracle/oradata/orcl/redo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
3、尝试使用clear方式重建日志组出现报错
1
2
3
4
5
6
7
8
9
10
11
12
13
14
idle>alter database clear logfile group 2;
alter database clear logfile group 2
*
ERROR at line 1:
ORA-01624: log 2 needed for crash recovery of instance orcl (thread 1)
ORA-00312: online log 2 thread 1: '/u02/app/oracle/oradata/orcl/redo02.log'
idle>alter database clear unarchived logfile group 2;
alter database clear unarchived logfile group 2
*
ERROR at line 1:
ORA-01624: log 2 needed for crash recovery of instance orcl (thread 1)
ORA-00312: online log 2 thread 1: '/u02/app/oracle/oradata/orcl/redo02.log'
Total System Global Area 1603411968 bytes
Fixed Size 2253664 bytes
Variable Size 1476398240 bytes
Database Buffers 117440512 bytes
Redo Buffers 7319552 bytes
Database mounted.
idle>show parameter _allow_
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
_allow_resetlogs_corruption boolean TRUE
idle>recover database until cancel;
ORA-00279: change 1023441 generated at 02/24/2017 23:54:54 needed for thread 1
ORA-00289: suggestion : /u02/app/oracle/product/11.2.4/db1/dbs/arch1_2_936817668.dbf
ORA-00280: change 1023441 for thread 1 is in sequence #2
Specify log: {<RET>=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: '/u02/app/oracle/oradata/orcl/system01.dbf'
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01248: file 5 was created in the future of incomplete recovery
于是先把这个文件offline drop
1
SQL> alter database datafile 5 offline drop;
再次open resetlogs时又遇到了ORA-00704和ORA-01555
1
2
3
4
5
6
7
8
9
10
11
12
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-01555: snapshot too old: rollback segment number 5 with name
"_SYSSMU5_4116806824$" too small
Process ID: 3396
Session ID: 573 Serial number: 51