OraFAQ Forum: Backup & Recovery » Restore stuck affer the control files

Home » RDBMS Server » Backup & Recovery » Restore stuck affer the control files (Oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Restore stuck affer the control files [message #351894]

Fri, 03 October 2008 11:53

shekharnegi12
Messages: 52
Registered: October 2008

Member

Hello Everyone,

I have a question about restore the Oracle9i database. When I try to restore the database from the tape using Backup Exec, it just restores the control files (I say control files because the size of the control file is that. Also during restore, the control files get copied first). The restore was stuck without giving any errors. Any suggestions or responses are welcome.

Thanks,
Shekhar

Report message to a moderator

Re: Restore stuck affer the control files [message #351897 is a reply to message #351894]

Fri, 03 October 2008 12:09

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What is "Backup Exec"?

Regards
Michel

Report message to a moderator

Re: Restore stuck affer the control files [message #351902 is a reply to message #351897]

Fri, 03 October 2008 12:18

shekharnegi12
Messages: 52
Registered: October 2008

Member

I'm sorry, it's Symantec Backup Exec 12

Report message to a moderator

Re: Restore stuck affer the control files [message #351904 is a reply to message #351902]

Fri, 03 October 2008 12:27

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So maybe you should ask on a Symantec forum?

Regards
Michel

Report message to a moderator

Re: Restore stuck affer the control files [message #351912 is a reply to message #351894]

Fri, 03 October 2008 12:56

ebrian
Messages: 2794
Registered: April 2006

Senior Member

How are you performing the restore? Are you using RMAN or Backup Exec ?

Report message to a moderator

Re: Restore stuck affer the control files [message #351920 is a reply to message #351894]

Fri, 03 October 2008 13:23

shekharnegi12
Messages: 52
Registered: October 2008

Member

Thanks for your response. Symantec eventually uses RMAN to restore.

Following is the error message

RMAN Output Recovery Manager: Release 9i - Production

Copyright (c) Oracle Corporation. All rights reserved.

# -----------------------------------------------------------------
# RMAN command section
# -----------------------------------------------------------------

RUN {
ALLOCATE CHANNEL ch0
TYPE 'SBT_TAPE';
SEND 'BSA_SERVICE_HOST=mediaservername,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={86EB22C6-E110-4B20-9F73-FC3BAA5E0FEE},NBBSA_DB_DEVICE_NAME= Oracle-Win::\\destinationserver\databaseinstance,NBBSA_SOURCE_MACHINE_NAME=Sourcemachinename';

RESTORE CONTROLFILE FROM 'tapename';

ALTER DATABASE MOUNT;

RESTORE
DATABASE;

RECOVER
DATABASE;

RELEASE CHANNEL ch0;
alter database open resetlogs;
}

connected to target database: ngs1 (not mounted)

using target database controlfile instead of recovery catalog
allocated channel: ch0
channel ch0: sid=12 devtype=SBT_TAPE
channel ch0: Symantec/BackupExec/1.1.0

sent command to channel: ch0

Starting restore at 03-OCT-08

released channel: ch0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/03/2008 14:04:19
ORA-27191: sbtinfo2 returned error

Recovery Manager complete.

Report message to a moderator

Re: Restore stuck affer the control files [message #351923 is a reply to message #351920]

Fri, 03 October 2008 13:38

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You should FIRST say that you use RMAN and post your session.

ORA-27191: sbtinfo2 returned error
 *Cause:  sbtinfo2 returned an error.  This happens while retrieving
          backup file information from the media manager's catalog.
 *Action: This error is returned from the media management software which is
          linked with Oracle.  There should be additional messages which
          explain the cause of the error.  This error usually requires
          contacting the media management vendor.

Next time, please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Indent the code.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Regards
Michel

Report message to a moderator

Re: Restore stuck affer the control files [message #351925 is a reply to message #351920]

Fri, 03 October 2008 13:39

ebrian
Messages: 2794
Registered: April 2006

Senior Member

This is a MML error. Have you performed a restore with Backup Exec before? Have you linked BackupExec in with RMAN?

Report message to a moderator

Re: Restore stuck affer the control files [message #351933 is a reply to message #351894]

Fri, 03 October 2008 14:44

shekharnegi12
Messages: 52
Registered: October 2008

Member

Ebrian,

Have you performed a restore with Backup Exec before?
Yes, I have performed restore before many times and it worked then.

Have you linked BackupExec in with RMAN?
I have linked the Backupexec with RMAN.

Are you familiar with the error?

Michel,

I appologize for not reading the FAQ before posting. Do you suggest anything on the error I got?

Report message to a moderator

Re: Restore stuck affer the control files [message #351934 is a reply to message #351933]

Fri, 03 October 2008 14:57

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

There should be additional messages which
explain the cause of the error. This error usually requires
contacting the media management vendor.

Regards
Michel

Report message to a moderator

Previous Topic:	Specify different name for backup
Next Topic:	Recover database when windows Crash

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 28 01:03:04 CDT 2024