Syntax parsing error

 Hi All,

I am getting RMAN-01005: syntax error: found "and": expecting one of:.

Please let me know the correct syntax if possible.It is listed below:-

List Archivelog backups for a Specific Database Instance ‘&&DB_NAME’

 

select a.db_name “Database”,db.dbid “DBID”,a.end_time “Latest Backup”,

round(a.output_bytes/1000000) “MBytes Processed”,

round((end_time – start_time) * 60 * 24) “Minutes Taken”

from v$rman_status a, v$database db

where

 object_type =’ARCHIVELOG’

and status = ‘COMPLETED’

and operation = ‘BACKUP’

and a.db_name=’&&DB_NAME’

and end_time in (select end_time from v$rman_status b

where