【Oracle技术文章】startup 出现ora-03113

RMAN TARGET 账户/密码
RMAN> startup mount
复制

RMAN> delete obsolete;
复制

RMAN> delete archivelog all;
复制

SQL> alter database open;
复制

RMAN> show retention policy;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
复制

configure retention policy to recovery window of 1 days
复制

configure retenton policy to none;
复制

alter database flashback off;
复制

alter system set DB_RECOVERY_FILE_DEST='';
复制

--查询历史警报
select * from dba_alert_history;
复制

--查询阈值
select * from  dba_thresholds;
--查询当前警报
select * from dba_outstanding_alerts;
Tablespace [APPS_DATA_TABLESPACE] is [90 percent] full
复制

select d.file_name, d.MAXBYTES/1024/1024/1024 from dba_data_files d
where d.TABLESPACE_NAME='APPS_DATA_TABLESPACE';
复制

alter database datafile
'/usr/local/oracle19c/oradata/ORCL/APPS_DATA_TABLESPACE.dbf'
autoextend on next 8m maxsize 20g;
复制