10-19-2012 12:23 PM
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.
11-08-2012 10:56 PM
Hello,
Request you to please work with Technical Support to get this resolved.
Thanks & Regards,
Swati Pathak
11-09-2012 03:23 AM
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
11-09-2012 03:56 AM
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...
11-21-2012 01:22 AM
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
11-21-2012 08:36 AM
Yes it is a cross platform between windows and linux.
If I try to do the restore through a linux it works?
Thanks!