This discussion is archived
6 Replies Latest reply: Aug 16, 2013 6:25 AM by FelipheL RSS

Create an RMAN job that backs up the USERS tablespace using two disk  channels

03260412-4856-48e9-a54f-d627d3f34aab Newbie
Currently Being Moderated

RMAN> run {

2>          allocate channel ch1 type disk;

3>          allocate channel ch2 type disk;

4>          backup as compressed backupset tablespace users;

5> }



using target database control file instead of recovery catalog

allocated channel: ch1

channel ch1: SID=12 device type=DISK



allocated channel: ch2

channel ch2: SID=200 device type=DISK



Starting backup at 10-AUG-13

channel ch1: starting compressed full datafile backup set

channel ch1: specifying datafile(s) in backup set

input datafile file number=00004 name=+DATA/asmdb/datafile/users.259.822666927

channel ch1: starting piece 1 at 10-AUG-13

released channel: ch1

released channel: ch2

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ch1 channel at 08/10/2013 21:16:50

ORA-19806: cannot make duplex backups in recovery area





Hi everyone

Can you help with this backup failure?


  • Correct Answers - 10 points
  • Helpful Answers - 5 points