Home » RDBMS Server » Backup & Recovery » Restore stuck affer the control files (Oracle 9i)
Restore stuck affer the control files [message #351894] Fri, 03 October 2008 11:53 Go to next message
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
Re: Restore stuck affer the control files [message #351897 is a reply to message #351894] Fri, 03 October 2008 12:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is "Backup Exec"?

Regards
Michel
Re: Restore stuck affer the control files [message #351902 is a reply to message #351897] Fri, 03 October 2008 12:18 Go to previous messageGo to next message
shekharnegi12
Messages: 52
Registered: October 2008
Member
I'm sorry, it's Symantec Backup Exec 12
Re: Restore stuck affer the control files [message #351904 is a reply to message #351902] Fri, 03 October 2008 12:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So maybe you should ask on a Symantec forum?

Regards
Michel
Re: Restore stuck affer the control files [message #351912 is a reply to message #351894] Fri, 03 October 2008 12:56 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
How are you performing the restore? Are you using RMAN or Backup Exec ?
Re: Restore stuck affer the control files [message #351920 is a reply to message #351894] Fri, 03 October 2008 13:23 Go to previous messageGo to next message
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.
Re: Restore stuck affer the control files [message #351923 is a reply to message #351920] Fri, 03 October 2008 13:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
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
Re: Restore stuck affer the control files [message #351925 is a reply to message #351920] Fri, 03 October 2008 13:39 Go to previous messageGo to next message
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?
Re: Restore stuck affer the control files [message #351933 is a reply to message #351894] Fri, 03 October 2008 14:44 Go to previous messageGo to next message
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?
Re: Restore stuck affer the control files [message #351934 is a reply to message #351933] Fri, 03 October 2008 14:57 Go to previous message
Michel Cadot
Messages: 64140
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
Previous Topic: Specify different name for backup
Next Topic: Recover database when windows Crash
Goto Forum:
  


Current Time: Fri Dec 09 09:27:23 CST 2016

Total time taken to generate the page: 0.09888 seconds