Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Name column is null after querying ' SELECT * FROM V$ARCHIVED_LOG WHERE SEQUENCE#....'

User_OPD8ROct 12 2021

Hello

I am trying to fix a gap in Oracle RAC db-s .
I have found that the the missing archive logs are in the sequence between 40665 and 40668 in my db
DB is Oracle 11g.

But when i run the query SELECT * FROM V$ARCHIVED_LOG WHERE SEQUENCE# between '40665' and '40668'; i got null for the name column and i can't identify the archive log name so i can copy it to the standy by database.
Can you please give me any hint on this , how can i find the missing archive logs names?

Thanks in advance!

Dario.

Added on Oct 12 2021

#general-database-discussions

4 comments

530 views