有个测试环境,没开归档,每天做一个expdp全备份,周末现场反馈备份失败,发出来的报错如下
orcl:/backup/orcl@db> tail -f /tmp/orcl.log
Export: Release 12.2.0.1.0 - Production on Mon Apr 21 10:58:28 2024
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
ORA-31626: job does not exist
ORA-31633: unable to create master table "USR_EXP.SYS_EXPORT_FULL_01"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1161
ORA-01658: unable to create INITIAL extent for segment in tablespace USERS
ORA-06512: at "SYS.KUPV$FT", line 1054
ORA-06512: at "SYS.KUPV$FT", line 1042
看报错是备份用户USR_EXP的默认表空间是USERS,现USERS表空间使用率100%导致,让现场检查USERS的使用率,确实100%,新增数据文件后全库备份恢复正常
TABLESPACE_NAME MAXSIZE_MB ACTUALSIZE_MB USED_MB FREESPACE_MB USAGE
--------------------- ---------- ------------- ---------- ------------ --------------------
USERS 32767 32767 32767 0 100%