cancel
Showing results forΒ 
Search instead forΒ 
Did you mean:Β 

Problem doing an Oracle 10.2 restore

Darryl_Eason
Level 3

All tests have been successful except for the restore of an Oracle database. I am able to backup the database though.

My system information is as follows:

Backup Server-Windows 2003 SP2, BExec 11d

Client Server-Suse Linux ES v9

Oracle-On the Linux server, v10.2

Below are some of the error logs:

Recovery Manager: Release 10.2.0.2.0 - Production on Wed Aug 8 11:47:17 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

 # -----------------------------------------------------------------

 # RMAN command section

 # -----------------------------------------------------------------

 RUN {

 ALLOCATE CHANNEL ch0

    TYPE 'SBT_TAPE';

 SEND 'BSA_SERVICE_HOST=163.197.230.97,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={96F2D41E-5C08-49CC-A4AC-CB39CF3597F4},NBBSA_DB_DEVICE_NAME=Oracle-Linux::\\demo.caretech.co.za\genpoc,NBBSA_SOURCE_MACHINE_NAME=mxgendb.caretech.co.za';

 SET NEWNAME FOR DATAFILE '/oradata/genpoc/genpoc/system01.dbf' TO '/oradata/genpoc/system01.dbf';

 SET NEWNAME FOR DATAFILE '/oradata/genpoc/genpoc/undotbs01.dbf' TO '/oradata/genpoc/undotbs01.dbf';

 SET NEWNAME FOR DATAFILE '/oradata/genpoc/genpoc/sysaux01.dbf' TO '/oradata/genpoc/sysaux01.dbf';

 SET NEWNAME FOR DATAFILE '/oradata/genpoc/genpoc/users01.dbf' TO '/oradata/genpoc/users01.dbf';

 RESTORE

    DATABASE;

  SWITCH DATAFILE ALL;

 SET ARCHIVELOG DESTINATION TO "/oradata/archivelogs";

 RECOVER

    DATABASE;

  RELEASE CHANNEL ch0;

 alter database open;

 }

 connected to target database: GENPOC (DBID=678697059, not open)

using target database control file instead of recovery catalog

allocated channel: ch0

channel ch0: sid=159 devtype=SBT_TAPE

channel ch0: Symantec/BackupExec/1.1.0

sent command to channel: ch0

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 08-AUG-07

starting up daemon

starting up daemon

released channel: ch0

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

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

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

RMAN-03002: failure of restore command at 08/08/2007 11:47:20

ORA-27191: sbtinfo2 returned error

Additional information: 2

Recovery Manager complete.

 

Completed status: Failed

Final error: 0xe0000340 - The Database script returned an error.  Refer to the Database script output section in job logs for more details.

Final error category: Resource Errors

For additional information regarding this error refer to link V-79-57344-832

0 REPLIES 0