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)
Showing posts with label RMAN-06025: no backup of archived log for thread 1. Show all posts
Showing posts with label RMAN-06025: no backup of archived log for thread 1. Show all posts

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;
}


physical standby without duplicate command

physical standby without duplicate command create a physical standby database using RMAN without using duplicate command PURPOSE:   All docu...