cancel
Showing results for 
Search instead for 
Did you mean: 

Archive file missing : Data Guard.

former_member216914
Participant
0 Kudos

Dear Expert,

Archive file are not exist in both side primary and secondary. Please help.

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> recover automatic standby database until cancel;

ORA-00279: change 1537608710 generated at 10/19/2020 12:19:07 needed for thread 1 ORA-00289: suggestion : H:\ORACLE\PR8\ORAARCH\PR8ARCH1_7319_967683946.DBF ORA-00280: change 1537608710 for thread 1 is in sequence #7319 ORA-00278: log file 'H:\ORACLE\PR8\ORAARCH\PR8ARCH1_7319_967683946.DBF' no longer needed for this recovery ORA-00308: cannot open archived log 'H:\ORACLE\PR8\ORAARCH\PR8ARCH1_7319_967683946.DBF' ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 2) The system cannot find the file specified.

View Entire Topic
0 Kudos

Ahmed have you check on SAP Archive Wizard Platform. Run Same it may help you.