Database startup failing ORA-19815: WARNING: db_recovery_file_dest_size of bytes is 100.00% used,

Your database db_recovery_file_dest is full and it does not have any room for any more files. So you have to clean up your db_recovery_file_dest location

1. Find out your db_recovery_file_dest location from the init file and clean up some unwanted files from the location

2. Connect to sqlplus “/ as sysdba” and mount the database. Delete the backedup archivelogs using RMAN.

3. try to change your RMAN retention policy to avoid certain conditions in future.

4. Also consider to change the RMAN archive log deletion policy.

SQL> set pages 100
SQL> set lines 120
SQL> select * from v$flash_recovery_area_usage;
//FRA is 100%used by the archive logs.
-------------------- ------------------ ------------------------- ---------------
CONTROL FILE                          0                         0               0
REDO LOG                              0                         0               0
ARCHIVED LOG                      99.64                         0             107
BACKUP PIECE                          0                         0               0
IMAGE COPY                            0                         0               0
FLASHBACK LOG                         0                         0               0
FOREIGN ARCHIVED LOG                  0                         0               0
7 rows selected.
// connect to the RMAN and run following commands
crosscheck archivelog all;
delete expired archivelog all;
$ rman target /
Recovery Manager: Release - Production on Wed Jun 11 13:40:29 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: PRDTEST (DBID=2247411731)
RMAN> crosscheck archivelog all;
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=178 device type=DISK
validation failed for archived log
archived log file name=/u01/FRA/PRDTEST/archivelog/2014_06_11/o1_mf_1_3052_9shy5q8v_.arc ECID=2680 STAMP=849947735
Crosschecked 107 objects
RMAN> delete expired archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=178 device type=DISK
List of Archived Log Copies for database with db_unique_name PRDTEST
Key     Thrd Seq     S Low Time
------- ---- ------- - ---------
2680    1    3052    X 11-JUN-14
        Name: /u01/FRA/PRDTEST/archivelog/2014_06_11/o1_mf_1_3052_9shy5q8v_.arc
2681    1    3053    X 11-JUN-14
        Name: /u01/FRA/PRDTEST/archivelog/2014_06_11/o1_mf_1_3053_9shyg8g9_.arc
2786    1    3158    X 11-JUN-14
        Name: /u01/FRA/PRDTEST/archivelog/2014_06_11/o1_mf_1_3158_9sjdtwsx_.arc
Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=/u01/FRA/PRDTEST/archivelog/2014_06_11/o1_mf_1_3052_9shy5q8v_.arc RECID=2680 STAMP=849947735
Deleted 107 EXPIRED objects
RMAN> exit
Recovery Manager complete.

DBA Tips Data Pump Reference


Post a Comment


dba topics. Copyright 2011-17 All Rights Reserved | Site Map | Contact | Disclaimer | Google