Backup Exec 2012 Oracle Database 11g R2 on linux

[tanyshka]

Hello.

Ihave two servers, production server and test server with Oracle Database 11.2

I Have a successful backup of the production server.

The test server is the same as the production server, hostname differs only.

I have taken the database to a nomount state, and used the SET DBID <originalDBID> on test server.

Create a restore job from Backup exec 2012 and choose Oracle Redirection to test server.

When i try to restore my ORACLE database to test server i get the following error

  RUN {

 ALLOCATE CHANNEL ch0

     TYPE 'SBT_TAPE';

 SEND 'BSA_SERVICE_HOST=xx.xxx.xx.xxx,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={3AC95E5F-855F-4131-B2F2-871990276ACF},NBBSA_DB_DEVICE_NAME=Oracle-Linux::\\test\PRD,NBBSA_SOURCE_MACHINE_NAME=prod';

 RESTORE CONTROLFILE FROM 'BE_5kn6tc3o_1_1';

 RELEASE CHANNEL ch0;

 }

using target database control file instead of recovery catalog

allocated channel: ch0

channel ch0: SID=768 device type=SBT_TAPE

channel ch0: Symantec/BackupExec/1.1.0

sent command to channel: ch0

Starting restore at 27-MAR-12

released channel: ch0

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

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

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

RMAN-03002: failure of restore command at 03/27/2012 08:56:34

RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

 EXIT

Recovery Manager complete.

I've done many times successful Recover Oracle Database 10g with BE 2010R3.

Anybody knows what's the problem?

[Backup_Exec1]

Hi

Please check this

http://www.symantec.com/docs/TECH160623

Thanks

[pkh]

This document is for BE 2010 and below, so what relevance has it got for the user who is using BE 2012.

[Backup_Exec1]

Hi there I don't see any relation with BE 2010 or BE 2012 for the above document given by me as the document suggest to run DBA intiated job here so I don't think having BE 2012 here will make difference

Thanks

[tanyshka]

It did not help.

RMAN> set dbid=xxxxxxxx

executing command: SET DBID

RMAN> RUN {

2>  ALLOCATE CHANNEL ch0

3>      TYPE 'SBT_TAPE';

4>  SEND 'BSA_SERVICE_HOST=xx.xxx.xx.xx,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={AC92E5F-855F-4131-B2F2-871990276ACF},NBBSA_DB_DEVICE_NAME=Oracle-Linux::\\test\PRD,NBBSA_SOURCE_MACHINE_NAME=prod';

RESTORE CONTROLFILE FROM autobackup;

5> 6> 7>

8>  RELEASE CHANNEL ch0;

9> }

using target database control file instead of recovery catalog

allocated channel: ch0

channel ch0: SID=615 device type=SBT_TAPE

channel ch0: Symantec/BackupExec/1.1.0

sent command to channel: ch0

Starting restore at 27-MAR-12

channel ch0: looking for AUTOBACKUP on day: 20120327

channel ch0: looking for AUTOBACKUP on day: 20120326

channel ch0: looking for AUTOBACKUP on day: 20120325

channel ch0: looking for AUTOBACKUP on day: 20120324

channel ch0: looking for AUTOBACKUP on day: 20120323

channel ch0: looking for AUTOBACKUP on day: 20120322

channel ch0: looking for AUTOBACKUP on day: 20120321

channel ch0: no AUTOBACKUP in 7 days found

released channel: ch0

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

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

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

RMAN-03002: failure of restore command at 03/27/2012 13:13:48

RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece