Sorry to hear this, but the DBA is on leave, for sure you can Phone him. Pleae study the recovery procedure and look for the deleted archive log file in the backup some where, I am sure you can find it. Else painfull but the Production is still good, take a new back up as a base. the delay , God forbid can put real issue on your hand. Take a Fresh Cold Base Backup soon, do not waite for your DBA or the solution. run man. run...... But the best solution is use inhouse scripts. Nisar tareen ----- Original Message ---- From: drumil narayan <drumilnarayan@xxxxxxxxx> To: askdba@xxxxxxxxxxxxx Sent: Tuesday, November 13, 2007 9:17:53 AM Subject: [askdba] Stby DB Backup failed Dear All, am facing a problem on standby database. On November 9 a file was supposed to ship from the actual database to standby db that archive file may not be shipped or might have been deleted/archived, how do i know what exactly has happened. Now if am executing manual backup script its poinitng to the archive file of November 9, which am not able to find. Now, how should i proceed my admin is saying if stby backup is not done, there will not be a backup of primay datbase also. how should i validate this statement. We are using RMAN, we do not have complete documentation, our usual DBA is on leave. Kindly help. Drumil Get the freedom to save as many mails as you wish. Click here to know how. ____________________________________________________________________________________ Be a better pen pal. Text or chat with friends inside Yahoo! Mail. See how. http://overview.mail.yahoo.com/