Video Screencast Help

Restore Oracle Archive Logs

Created: 19 Oct 2012 | 5 comments

I need help to Restore Oracle11g Archive Logs.

Running this command bellow i get errors:

 

Connected to my target database and recovery catalog

 

RMAN> RUN {

2> ALLOCATE CHANNEL ch0

3>      TYPE 'SBT_TAPE';

4> SEND 'BSA_SERVICE_HOST=192.168.63.189,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={87234189-7F27-466A-999A-814EA2F311EB},NBBSA_DB_DEVICE_NAME=Oracle-Linux::\\RAC-SW02-2861684627\SW02';

5>    allocate channel t1 type disk;

6>    set archivelog destination to 'c:\';

7>    restore archivelog scn between 10756452257563 and 10756477117583;

8>    release channel ch0;

9> }

 

starting full resync of recovery catalog

full resync complete

allocated channel: ch0

channel ch0: SID=117 instance=SW022 device type=SBT_TAPE

channel ch0: Symantec/BackupExec/1.1.0

 

sent command to channel: ch0

 

allocated channel: t1

channel t1: SID=1155 instance=SW021 device type=DISK

 

executing command: SET ARCHIVELOG DESTINATION

 

Starting restore at 18/10/12

 

channel ch0: starting archived log restore to user-specified destination

archived log destination=c:\

channel ch0: restoring archived log

archived log thread=2 sequence=3984

channel ch0: restoring archived log

archived log thread=1 sequence=8039

channel ch0: restoring archived log

archived log thread=2 sequence=3985

channel ch0: restoring archived log

archived log thread=1 sequence=8040

channel ch0: reading from backup piece BE_9bnljhdc_1_1

channel CH0: ORA-19870: error while restoring backup component BE_9bnljhdc_1_1
ORA-19507: failed to retrieve sequential file, handle = "BE_9bnljhdc_1_1", parms = ""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from manager mÝdia layer, error text:
    BEError (0xe000fe30) A communications failure has occurred.

Comments 5 CommentsJump to latest comment

swati's picture

Hello,

Request you to please work with Technical Support to get this resolved.

Thanks & Regards,

Swati Pathak

swati's picture

Before logging a support case, I would like to know the setup. From the script, it looks like a RAC setup . Is it a Linux RAC or Windows? As script mentions to direct the logs to c:\ and device name Oracle-Linux::\\RAC-SW02-2861684627\SW02, tells us that its a Linux RAC.

Is it a DBA initiated job meaning did you log on to RMAN console and fired the script mentioned above? If yes, then you need not specify NBSA variables except for some particular scenarios. Please reply with your setup details and how you ran the restore job.

 

Thanks & Regards,

Swati

andre_banzai's picture

Hi swati,

Ok, i understand what did you means.

The DB is in a "Linux RAC" but the script is running on the Windows system.

 

I use this commands before in Windows System:

rman target sys/*MyPass*@sw02 catalog rman/*MyRMANPass*@rman

 

And this is the msg result:

 

Recovery Manager: Release 11.2.0.3.0 - Production on Qui Out 18 11:16:23 2012

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: SW02 (DBID=2861684627)

connected to recovery catalog database

 

And now i run the script trying to restore...

swati's picture

Hello,

From the above reply it seems that we are trying to restore archived logs on Windows system from a Linux RAC DB backup. Such a cross platform restores of Oracle are not supported in BE.

Thanks & Regards,

Swati

andre_banzai's picture

Yes it is a cross platform between windows and linux.

If I try to do the restore through a linux it works?

 

Thanks!