Forum Discussion

Petermtn's avatar
Petermtn
Level 3
12 years ago

Database rman backup failed with file does not exist

I have a database of 20TB which is backed up using RMAN. The backup runs but most times failed after the channels have been downed due to the error below released channel: ch05 released channel:...
7.1.x and Earlier
Backup and Recovery
Error messages
NetBackup
Solaris
Troubleshooting
  • Marianne's avatar
    Marianne
    12 years ago

    ORA-01157: cannot identify/lock data file 84 - see DBWR trace file
    ORA-01110: data file 84: 'No file with this number, file does not exist'

    Oracle error telling you that data file number 84 does not exist.

    You need to troubleshoot Oracle....

Petermtn's avatar
Petermtn
Level 3
12 years ago

Thanks Marianne and wr. I comunicated back to the database admin based on ur advise though they refused intially that its a database issue. See response from the admin

 

This is part of the normal data lifecycle management: we drop obsolete partitions and empty tablespaces and create new tablespaces/partitions for future data every night at around 11pm.

I suggest that you schedule your backups to run at least after 11:30pm to avoid conflicts with this activity. Obviously, this doesn’t apply to archivelog backups.

 

I will communicate back the outcome after i reschedule and run the backup

 

Thanks,

 

Peter