Rmanbackup

[Arsalan]

Hello Erman Arslan,

Oracle 11g,windows 2012


While taking full backup i face below error

-----------------------------------------------------------------------------
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 09/17/2019 08:39:16
ORA-19599: block number 19592 is corrupt in archived log E:\RECOVERY_AREA\AFGPROD\AFGPROD\ARCHIVELOG\2019_09_15\O1_MF_1_4940_GQVMTHNF_.ARC

Recovery Manager complete.
----------------------------------------------------------

after this error i runed

RMAN>crosscheck archivelog all;

RMAN> delete expired archivelog all;


And again taking backup

BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;

I face same error

Please guide me  

Thanks

[ErmanArslansOracleBlog]

It seems one of your archivelog files is corrupted.

Please follow -> ORA-19599 When backing up an archivelog that is corrupt (Doc ID 461239.1)

However; with this move, you actually make your corrupt archivelog expired. This means rman will skip it. That is, rman will not attempt to back up an archived redo log file with an EXPIRED status.
So it is not a solution actually, it is a workaround.

I recommend you to find the cause of this corruption.
Work with your system admin.. It is maybe the filesystem , or OS that made this archivelog to be corrupted..

check Oracle side as well..

[Arsalan]

Here multi time  power cute issue occurred , db server abnormally down,


after this archive log have been corrupted.

we don;t have oracle support,

Please guide  me ,

RMAN does not allow my to take backup,, still we don;t have backup ,,

Just have expdp dump file backup


 

[Arsalan]

The mention problem have been solved,



Thanks Arslan,

[ErmanArslansOracleBlog]

You just had to move the problematic archivelog to another place in the filesystem, and then crosscheck your archive logs to make rman mark that problematic archive log as expired.
As the rman will not try to backup an expired archivelog, your issue will be solved.

But I guess you already did that and solved your issue. Good.