Tags

11g (5) 12c (6) 18c (3) 19c (4) ASM (1) Critical Patch (11) Data Pump (1) Dataguard (9) Diverse (3) GRID (7) GitLab (2) Linux (8) OEM (2) ORA Errors (13) Oracle (12) RMAN (4)

Tuesday, December 3, 2019

RMAN-06025: no backup of archived log for thread 1


RMAN-06025: no backup of archived log for thread 1 


If you see such type of errors:
RMAN-06025: no backup of archived log for thread 1 with sequence 148635 and starting SCN of 57325629377 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 148634 and starting SCN of 57325618994 found to restore
--
PURPOSE: All documents are provided on this Blog just for educational purposes only.  Please make sure that you run it in your test environment before to move on to production environment.  


--

SOLUTION:
Create a backup of the missing Sequence.

RMAN> run
{
ALLOCATE CHANNEL disk07 DEVICE TYPE DISK MAXPIECESIZE 500M FORMAT '/oracledb/backup/ARC_%d.%p.%s.%T.%t';
BACKUP ARCHIVELOG FROM SEQUENCE 148506 UNTIL SEQUENCE 148635;
}

Restore it as follow:

RMAN> run
{
RESTORE ARCHIVELOG FROM SEQUENCE 148506 UNTIL SEQUENCE 148635;
}


No comments:

Post a Comment

Oracle JDBC Connection Test

How to test Oracle connection via JDBC Thin driver. Oracle JDBC Connection Test SCOPE: Oracle JDBC Connection Test PURPOSE:   All do...