ORA-19815: WARNING: db_recovery_file_dest_size
delete rman archivelog
delete archivelog
rman delete
DELETE EXPIRED commands.
************************************************************************
Errors in file /opt/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_arc1_435.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 43941376 bytes disk space from 4070572032 limit
ARC1: Error 19809 Creating archive log file to '/opt/app/oracle/flash_recovery_area/ORCL/archivelog/2011_06_14/o1_mf_1_465_%u_.arc'
Tue Jun 14 13:52:29 2011
Errors in file /opt/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_arc3_439.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 4070572032 bytes is 100.00% used, and has 0 remaining bytes available.
************************************************************************
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
Errors in file /opt/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_arc3_439.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 43941376 bytes disk space from 4070572032 limit
ARC3: Error 19809 Creating archive log file to '/opt/app/oracle/flash_recovery_area/ORCL/archivelog/2011_06_14/o1_mf_1_465_%u_.arc'
oracle@apt-amd-02:/opt/app/oracle/diag/rdbms/orcl/orcl/trace> rman
Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 14 13:56:08 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target /
connected to target database: ORCL (DBID=1267852645)
RMAN> delete archivelog all completed before 'sysdate -1';
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=56 device type=DISK
Search This Blog
Total Pageviews
Tuesday, 14 June 2011
Subscribe to:
Post Comments (Atom)
Oracle DBA
anuj blog Archive
- ▼ 2011 (362)
No comments:
Post a Comment