Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database Restore

JhilMar 17 2020 — edited Mar 21 2020

Dear Experts,

I am trying to restore database on test server (for test activity).

Full Database has done on 11th March and we have 30 days retention for full db backup.

When i am trying to restore the database, i am getting below error.

>> Restoring the DB by using EMC Avamar

RMAN> run {
2> allocate channel c1 type sbt PARMS="SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so";
3> allocate channel c2 type sbt PARMS="SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so";
4> allocate channel c3 type sbt PARMS="SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so";
5> allocate channel c4 type sbt PARMS="SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so";
6> allocate channel c5 type sbt PARMS="SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so";
7> send '"--prefix=12/*******/" "--flagfile=/home/oracle/my-avtar-flags.txt" "--bindir=/usr/local/avamar/bin" "--logfile=/home/oracle/restore.log"';
8> restore database;
9> release channel c1;
10> release channel c2;
11> release channel c3;
12> release channel c4;
13> release channel c5;
14> }
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=646 instance=*****1 device type=SBT_TAPE
channel c1: EMC|Avamar (avtar backup)
allocated channel: c2
channel c2: SID=1129 instance=*****1 device type=SBT_TAPE
channel c2: EMC|Avamar (avtar backup)
allocated channel: c3
channel c3: SID=1290 instance=*****1 device type=SBT_TAPE
channel c3: EMC|Avamar (avtar backup)
allocated channel: c4
channel c4: SID=6442 instance=*****1 device type=SBT_TAPE
channel c4: EMC|Avamar (avtar backup)
allocated channel: c5
channel c5: SID=6603 instance=*****1 device type=SBT_TAPE
channel c5: EMC|Avamar (avtar backup)
sent command to channel: c1
sent command to channel: c2
sent command to channel: c3
sent command to channel: c4
sent command to channel: c5
Starting restore at 17-MAR-20
released channel: c1
released channel: c2
released channel: c3
released channel: c4
released channel: c5
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/17/2020 06:09:51
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of datafile 21
RMAN-06100: no channel to restore a backup or copy of datafile 20
RMAN-06100: no channel to restore a backup or copy of datafile 19
RMAN-06100: no channel to restore a backup or copy of datafile 18
RMAN-06100: no channel to restore a backup or copy of datafile 17
RMAN-06100: no channel to restore a backup or copy of datafile 16
RMAN-06100: no channel to restore a backup or copy of datafile 15
RMAN-06100: no channel to restore a backup or copy of datafile 14
RMAN-06100: no channel to restore a backup or copy of datafile 13
RMAN-06100: no channel to restore a backup or copy of datafile 12
RMAN-06100: no channel to restore a backup or copy of datafile 11
RMAN-06100: no channel to restore a backup or copy of datafile 10
RMAN-06100: no channel to restore a backup or copy of datafile 9
RMAN-06100: no channel to restore a backup or copy of datafile 8
RMAN-06100: no channel to restore a backup or copy of datafile 7
RMAN-06100: no channel to restore a backup or copy of datafile 5
RMAN-06100: no channel to restore a backup or copy of datafile 4
RMAN-06100: no channel to restore a backup or copy of datafile 3
RMAN-06100: no channel to restore a backup or copy of datafile 2
RMAN-06100: no channel to restore a backup or copy of datafile 1

>> I tried to crosscheck all backup but it is running more than 8 hrs.

>> Crosscheck command output

...

backup piece handle=XXXXX_6uuog6oa_1_1 RECID=297172 STAMP=1032329994