尴尬笑脸.jpg
测试库 /u01 使用率100%，闪回区占了很大，rm -fr /u01/flash_area/* 然后数据库打不开，提示找不到redo日志文件。
SYS @orcl > ALTER SYSTEM SET "_ALLOW_READ_ONLY_CORRUPTION"=TRUE SCOPE=SPFILE;
System altered.
Elapsed: 00:00:00.14
SYS @orcl > STARTUP MOUNT force;
ORACLE instance started.
Total System Global Area 838858176 bytes
Fixed Size 8902080 bytes
Variable Size 427819008 bytes
Database Buffers 398458880 bytes
Redo Buffers 3678208 bytes
Database mounted.
SYS @orcl > RECOVER DATABASE UNTIL CANCEL;
ORA-00279: change 8182501 generated at 04/11/2020 07:27:19 needed for thread 1
ORA-00289: suggestion : /arch/1_98_1034935196.arc
ORA-00280: change 8182501 for thread 1 is in sequence #98
Specify log: {
回车吧
ORA-00308: cannot open archived log '/arch/1_98_1034935196.arc'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
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: '/u01/app/oracle/oradata/ORCL/system01.dbf'
SYS @orcl > ALTER DATABASE OPEN RESETLOGS;
ERROR:
ORA-03114: not connected to ORACLE
ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
ORA-00600: internal error code, arguments: [kcbzib_kcrsds_1], [], [], [], [], [], [], [], [], [], [], []
Process ID: 3951
Session ID: 390 Serial number: 22787
Elapsed: 00:00:06.53
SYS @orcl > exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.6.0.0.0
[oracle@dbserver1 ~]$ s
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Apr 17 19:56:36 2020
Version 19.6.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
SYS @orcl > startup
ORACLE instance started.
Total System Global Area 838858176 bytes
Fixed Size 8902080 bytes
Variable Size 427819008 bytes
Database Buffers 398458880 bytes
Redo Buffers 3678208 bytes
Database mounted.
Database opened.
SYS @orcl >
open成功，又可以开心的玩耍了。