So your first writing session on the rewritable optical media has the password protected archive with your wallet file in it.

Do you remember that your second non-finalized writing session that wrote the Photoshop archive extended the first session, i.e. both archives should've been visible after your wrote the second session? You did verify that your written backups were initially readable, didn't you?

Have you checked that your DVD-RW reading device is working properly?

Have you tried with another optical reading device?

Which software specifically did write the sessions to the optical media?

What kind of archives have you used specifically (zip, rar, ...)?