OCP Oracle DBA in Montreal at DBSoft
Latest posts by Cyrille Modiano (see all)
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
select sequence# from v$archived_log where &scn between FIRST_CHANGE# and NEXT_CHANGE#-1;
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