DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Wednesday, September 30, 2015

ORA 00270 : ERROR CREATING ARCHIVE LOG IN STANDBY DATABASE

I faced the below error

ORA 00270 : ERROR CREATING ARCHIVE LOG IN DATA GUARD

Solution: Please check the primary and standby alert log
and I can see the below error in standby alert log,
ORA-19815: WARNING: db_recovery_file_dest_size of 32212254720 bytes is 100.00% used, and has 0 remaining bytes available

So,I checked the FRA  free size in database and i can see 99% got full

col name for a45

SELECT NAME,TO_CHAR(SPACE_LIMIT, '999,999,999,999') AS SPACE_LIMIT,
TO_CHAR(SPACE_LIMIT - SPACE_USED + SPACE_RECLAIMABLE,
'999,999,999,999') AS SPACE_AVAILABLE,
ROUND((SPACE_USED - SPACE_RECLAIMABLE)/SPACE_LIMIT * 100, 1)
AS PERCENT_FULL FROM V$RECOVERY_FILE_DEST;

Sample output:

NAME                                          SPACE_LIMIT          SPACE_AVAILABLE    PERCENT_FULL      
--------------------------------------------- ----------------------------------------------------------------
/v10/oracle/archive/db_name                   32,212,254,720        341,460,480                  99


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

 and then I have choosen crosschecked archivelog all and deleted the expired archives

 rman > crosscheck archivelog all;

 rman > delete expired archivelog all;

After crosschecking and deleting expired archives, we got flash recover area size to 50%
and then the archives are creating in standby, and also started applying and the alert got cleared.


No comments: