启动数据库的时候出错:
SQL> startup; ORACLE instance started. Total System Global Area 771751936 bytes Fixed Size 2929160 bytes Variable Size 633343480 bytes Database Buffers 130023424 bytes Redo Buffers 5455872 bytes Database mounted. ORA-03113: end-of-file on communication channel Process ID: 28259 Session ID: 243 Serial number: 50427
在alert log里面有下面的提示:
ORA-19815: WARNING: db_recovery_file_dest_size of 4781506560 bytes is 100.00% used, and has 0 remaining bytes available. Thu Sep 03 10:45:19 2020 ************************************************************************ You have following choices to free up space from recovery area: 1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard, Thu Sep 03 10:45:19 2020 Errors in file /u01/app/oracle/diag/rdbms/orcl/cdr1/trace/cdr1_arc2_28717.trc: ORA-19815: WARNING: db_recovery_file_dest_size of 4781506560 bytes is 100.00% used, and has 0 remaining bytes available. then consider changing RMAN ARCHIVELOG DELETION POLICY. 2. Back up files to tertiary device such as tape using RMAN Thu Sep 03 10:45:19 2020 ************************************************************************ BACKUP RECOVERY AREA command. 3. Add disk space and increase db_recovery_file_dest_size parameter to You have following choices to free up space from recovery area: reflect the new space. 1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard, 4. Delete unnecessary files using RMAN DELETE command. If an operating system command was used to delete files, then use RMAN CROSSCHECK and then consider changing RMAN ARCHIVELOG DELETION POLICY. DELETE EXPIRED commands. ************************************************************************
将数据库启动到mount状态,进入rman删除归档日志。
RMAN> delete archivelog all; .... Deleted 103 objects
再打开数据库
SQL> alter database open; Database altered.