β08-14-2007 12:12 AM
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