Skip to Main Content
  • Questions

  • Backup ORA-19806: cannot make duplex backups in recovery area

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Gyan Bahadur.

Asked: May 03, 2017 - 5:02 am UTC

Last updated: May 03, 2017 - 9:51 am UTC

Version: 11.2.0.4

Viewed 1000+ times

You Asked

Hi Tom,

I have try to copy the two copies of backup as with default format as:

backup as backupset
copies 2
database;

error :ORA-19806: cannot make duplex backups in recovery area

I have check the space in recovery_area, all right.

Please help me to solve the issue.


and Chris said...

So where exactly are you backing up to? As the docs say:

It is not possible to duplex backup sets to the fast recovery area

http://docs.oracle.com/database/121/BRADV/rcmbckad.htm#BRADV145

So it doesn't matter how much space you have in the recovery area. It isn't possible!

You also can't duplex to disk and tape at the same time:

RMAN can duplex backups to either disk or tape, but cannot duplex backups to tape and disk simultaneously

http://docs.oracle.com/database/121/BRADV/rcmconfa.htm#BRADV139

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Backup/Recovery

Check out the complete guide to all of the Backup & Recovery techniques in the Oracle Database.