Which archivelog contains your SCN ?

Cyrille Modiano

OCP Oracle DBA in Montreal at DBSoft

Latest posts by Cyrille Modiano (see all)

Description

This query returns the archivelog sequence containing a scn. This could be usefull in case you want to manually recover a standby database until a scn or just want to know which arvhivelog you should copy to recover the standby.

Archivelog containing your SCN

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE AND comment_parent IN (12704) ORDER BY comment_date_gmt ASC, comment_ID ' at line 1]
SELECT rkq_comments.comment_ID, rkq_comments.comment_parent WHERE AND comment_parent IN (12704) ORDER BY comment_date_gmt ASC, comment_ID ASC

2 thoughts on “Which archivelog contains your SCN ?

Leave a Reply