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.
Example

SQL> set pages 100
SQL> set lines 120
SQL> select * from v$flash_recovery_area_usage;
//FRA is 100%used by the archive logs.
FILE_TYPE            PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
-------------------- ------------------ ------------------------- ---------------
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 11.2.0.3.0 - 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

0 comments:

Post a Comment

 

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