Symantec Backup Exec2012恢复oracle10g报错
本帖最后由 fengyuhao16 于 2012-05-18 20:31 编辑1、架构
windows server 2003 x86(BE2012备份服务器) + Centos4.8 x86-oracle10g(客户端)+虚拟磁带库
2、备份信息
备份服务器主机名:db-oracle192.168.1.65
客户端:db192.168.1.168
3、BE2012完全备份RMAN日志
Recovery Manager: Release 10.2.0.1.0 - Production on Fri May 18 16:13:38 2012
Copyright (c) 1982, 2005, Oracle.All rights reserved.
connected to target database: ORCL (DBID=1311307188 )
# -----------------------------------------------------------------
# RMAN command section
# -----------------------------------------------------------------
RUN {
ALLOCATE CHANNEL ch0
TYPE 'SBT_TAPE';
SEND 'BSA_SERVICE_HOST=192.168.1.65,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={C616D8E2-A9B8-409B-B27A-B6D70284B68A},NBBSA_DB_DEVICE_NAME=Oracle-Linux::\\db\orcl';
BACKUP
INCREMENTAL LEVEL=0
FORMAT 'BE_U'
DATABASE FORCE;
BACKUP
FORMAT 'BE_U'
ARCHIVELOG ALL FORCE NOT BACKED UP;
RELEASE CHANNEL ch0;
}
using target database control file instead of recovery catalog
allocated channel: ch0
channel ch0: sid=139 devtype=SBT_TAPE
channel ch0: Symantec/BackupExec/1.1.0
sent command to channel: ch0
Starting backup at 18-MAY-12
channel ch0: starting incremental level 0 datafile backupset
channel ch0: specifying datafile(s) in backupset
input datafile fno=00001 name=/database/oracle/oradata/orcl/system01.dbf
input datafile fno=00003 name=/database/oracle/oradata/orcl/sysaux01.dbf
input datafile fno=00002 name=/database/oracle/oradata/orcl/undotbs01.dbf
input datafile fno=00004 name=/database/oracle/oradata/orcl/users01.dbf
channel ch0: starting piece 1 at 18-MAY-12
channel ch0: finished piece 1 at 18-MAY-12
piece handle=BE_1anba5tl_1_1 tag=TAG20120518T161341 comment=API Version 2.0,MMS Version 1.1.0.0
channel ch0: backup set complete, elapsed time: 00:00:55
Finished backup at 18-MAY-12
Starting backup at 18-MAY-12
current log archived
skipping archive log file /database/oracle/flash_recovery_area/ORCL/archivelog/2012_05_18/o1_mf_1_18_7vcdv376_.arc; already backed on 18-MAY-12
skipping archive log file /database/oracle/flash_recovery_area/ORCL/archivelog/2012_05_18/o1_mf_1_19_7vcsbtdq_.arc; already backed on 18-MAY-12
skipping archive log file /database/oracle/flash_recovery_area/ORCL/archivelog/2012_05_18/o1_mf_1_20_7vcslbqw_.arc; already backed on 18-MAY-12
skipping archive log file /database/oracle/flash_recovery_area/ORCL/archivelog/2012_05_18/o1_mf_1_21_7vctksq8_.arc; already backed on 18-MAY-12
skipping archive log file /database/oracle/flash_recovery_area/ORCL/archivelog/2012_05_18/o1_mf_1_22_7vcykrxk_.arc; already backed on 18-MAY-12
channel ch0: starting archive log backupset
channel ch0: specifying archive log(s) in backup set
input archive log thread=1 sequence=23 recid=22 stamp=783618434
input archive log thread=1 sequence=24 recid=23 stamp=783620077
channel ch0: starting piece 1 at 18-MAY-12
channel ch0: finished piece 1 at 18-MAY-12
piece handle=BE_1bnba5vd_1_1 tag=TAG20120518T161437 comment=API Version 2.0,MMS Version 1.1.0.0
channel ch0: backup set complete, elapsed time: 00:00:02
Finished backup at 18-MAY-12
Starting Control File and SPFILE Autobackup at 18-MAY-12
piece handle=c-1311307188-20120518-05 comment=API Version 2.0,MMS Version 1.1.0.0
Finished Control File and SPFILE Autobackup at 18-MAY-12
released channel: ch0
EXIT
Recovery Manager complete.
4、数据库备份信息
RMAN> list backup of database;
List of Backup Sets
===================
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27 Incr 0522.75M SBT_TAPE 00:00:52 18-MAY-12
BP Key: 27 Status: AVAILABLECompressed: NOTag: TAG20120518T102547
Handle: BE_0tnb9hhb_1_1 Media:
List of Datafiles in backup set 27
File LV Type Ckp SCN Ckp TimeName
---- -- ---- ---------- --------- ----
1 0Incr 494890 18-MAY-12 /database/oracle/oradata/orcl/system01.dbf
2 0Incr 494890 18-MAY-12 /database/oracle/oradata/orcl/undotbs01.dbf
3 0Incr 494890 18-MAY-12 /database/oracle/oradata/orcl/sysaux01.dbf
4 0Incr 494890 18-MAY-12 /database/oracle/oradata/orcl/users01.dbf
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
30 Incr 0523.25M SBT_TAPE 00:00:45 18-MAY-12
BP Key: 30 Status: AVAILABLECompressed: NOTag: TAG20120518T140256
Handle: BE_11nb9u8g_1_1 Media:
List of Datafiles in backup set 30
File LV Type Ckp SCN Ckp TimeName
---- -- ---- ---------- --------- ----
1 0Incr 497179 18-MAY-12 /database/oracle/oradata/orcl/system01.dbf
2 0Incr 497179 18-MAY-12 /database/oracle/oradata/orcl/undotbs01.dbf
3 0Incr 497179 18-MAY-12 /database/oracle/oradata/orcl/sysaux01.dbf
4 0Incr 497179 18-MAY-12 /database/oracle/oradata/orcl/users01.dbf
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
33 Incr 0523.25M SBT_TAPE 00:00:45 18-MAY-12
BP Key: 33 Status: AVAILABLECompressed: NOTag: TAG20120518T141945
Handle: BE_14nb9v81_1_1 Media:
List of Datafiles in backup set 33
File LV Type Ckp SCN Ckp TimeName
---- -- ---- ---------- --------- ----
1 0Incr 498098 18-MAY-12 /database/oracle/oradata/orcl/system01.dbf
2 0Incr 498098 18-MAY-12 /database/oracle/oradata/orcl/undotbs01.dbf
3 0Incr 498098 18-MAY-12 /database/oracle/oradata/orcl/sysaux01.dbf
4 0Incr 498098 18-MAY-12 /database/oracle/oradata/orcl/users01.dbf
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
36 Incr 0523.25M SBT_TAPE 00:01:11 18-MAY-12
BP Key: 36 Status: AVAILABLECompressed: NOTag: TAG20120518T152738
Handle: BE_17nba37a_1_1 Media:
List of Datafiles in backup set 36
File LV Type Ckp SCN Ckp TimeName
---- -- ---- ---------- --------- ----
1 0Incr 498838 18-MAY-12 /database/oracle/oradata/orcl/system01.dbf
2 0Incr 498838 18-MAY-12 /database/oracle/oradata/orcl/undotbs01.dbf
3 0Incr 498838 18-MAY-12 /database/oracle/oradata/orcl/sysaux01.dbf
4 0Incr 498838 18-MAY-12 /database/oracle/oradata/orcl/users01.dbf
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
39 Incr 0523.25M SBT_TAPE 00:00:46 18-MAY-12
BP Key: 39 Status: AVAILABLECompressed: NOTag: TAG20120518T161341
Handle: BE_1anba5tl_1_1 Media:
List of Datafiles in backup set 39
File LV Type Ckp SCN Ckp TimeName
---- -- ---- ---------- --------- ----
1 0Incr 520828 18-MAY-12 /database/oracle/oradata/orcl/system01.dbf
2 0Incr 520828 18-MAY-12 /database/oracle/oradata/orcl/undotbs01.dbf
3 0Incr 520828 18-MAY-12 /database/oracle/oradata/orcl/sysaux01.dbf
4 0Incr 520828 18-MAY-12 /database/oracle/oradata/orcl/users01.dbf
5、完全备份oracle后,shutdown immediate,把数据文件移动另外1个路径,数据库启动到mount状态下
6、利用BE进行恢复
恢复日志报错
Recovery Manager: Release 10.2.0.1.0 - Production on Fri May 18 16:20:19 2012
Copyright (c) 1982, 2005, Oracle.All rights reserved.
connected to target database: ORCL (DBID=1311307188, not open)
# -----------------------------------------------------------------
# RMAN command section
# -----------------------------------------------------------------
RUN {
ALLOCATE CHANNEL ch0
TYPE 'SBT_TAPE';
SEND 'BSA_SERVICE_HOST=192.168.1.65,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={AACA64E9-54D2-4A03-B40B-3EAFA7CA215D},NBBSA_DB_DEVICE_NAME=Oracle-Linux::\\db\orcl';
RESTORE
DATABASE;
RECOVER
DATABASE;
RELEASE CHANNEL ch0;
}
using target database control file instead of recovery catalog
allocated channel: ch0
channel ch0: sid=154 devtype=SBT_TAPE
channel ch0: Symantec/BackupExec/1.1.0
sent command to channel: ch0
Starting restore at 18-MAY-12
channel ch0: starting datafile backupset restore
channel ch0: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /database/oracle/oradata/orcl/system01.dbf
restoring datafile 00002 to /database/oracle/oradata/orcl/undotbs01.dbf
restoring datafile 00003 to /database/oracle/oradata/orcl/sysaux01.dbf
restoring datafile 00004 to /database/oracle/oradata/orcl/users01.dbf
channel ch0: reading from backup piece BE_1anba5tl_1_1
ORA-19870: error reading backup piece BE_1anba5tl_1_1
ORA-19507: failed to retrieve sequential file, handle="BE_1anba5tl_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
BEError(0xe0001501) The specified backup object was not found in Backup Exec catalogs.
failover to previous backup
channel ch0: starting datafile backupset restore
channel ch0: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /database/oracle/oradata/orcl/system01.dbf
restoring datafile 00002 to /database/oracle/oradata/orcl/undotbs01.dbf
restoring datafile 00003 to /database/oracle/oradata/orcl/sysaux01.dbf
restoring datafile 00004 to /database/oracle/oradata/orcl/users01.dbf
channel ch0: reading from backup piece BE_17nba37a_1_1
ORA-19870: error reading backup piece BE_17nba37a_1_1
ORA-19507: failed to retrieve sequential file, handle="BE_17nba37a_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
BEError(0xe0001501) The specified backup object was not found in Backup Exec catalogs.
failover to previous backup
channel ch0: starting datafile backupset restore
channel ch0: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /database/oracle/oradata/orcl/system01.dbf
restoring datafile 00002 to /database/oracle/oradata/orcl/undotbs01.dbf
restoring datafile 00003 to /database/oracle/oradata/orcl/sysaux01.dbf
restoring datafile 00004 to /database/oracle/oradata/orcl/users01.dbf
channel ch0: reading from backup piece BE_14nb9v81_1_1
ORA-19870: error reading backup piece BE_14nb9v81_1_1
ORA-19507: failed to retrieve sequential file, handle="BE_14nb9v81_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
BEError(0xe0001501) The specified backup object was not found in Backup Exec catalogs.
failover to previous backup
channel ch0: starting datafile backupset restore
channel ch0: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /database/oracle/oradata/orcl/system01.dbf
restoring datafile 00002 to /database/oracle/oradata/orcl/undotbs01.dbf
restoring datafile 00003 to /database/oracle/oradata/orcl/sysaux01.dbf
restoring datafile 00004 to /database/oracle/oradata/orcl/users01.dbf
channel ch0: reading from backup piece BE_11nb9u8g_1_1
ORA-19870: error reading backup piece BE_11nb9u8g_1_1
ORA-19507: failed to retrieve sequential file, handle="BE_11nb9u8g_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
BEError(0xe0001501) The specified backup object was not found in Backup Exec catalogs.
failover to previous backup
channel ch0: starting datafile backupset restore
channel ch0: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /database/oracle/oradata/orcl/system01.dbf
restoring datafile 00002 to /database/oracle/oradata/orcl/undotbs01.dbf
restoring datafile 00003 to /database/oracle/oradata/orcl/sysaux01.dbf
restoring datafile 00004 to /database/oracle/oradata/orcl/users01.dbf
channel ch0: reading from backup piece BE_0tnb9hhb_1_1
ORA-19870: error reading backup piece BE_0tnb9hhb_1_1
ORA-19507: failed to retrieve sequential file, handle="BE_0tnb9hhb_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
BEError(0xe0001501) The specified backup object was not found in Backup Exec catalogs.
failover to previous backup
channel ch0: starting datafile backupset restore
channel ch0: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /database/oracle/oradata/orcl/system01.dbf
restoring datafile 00002 to /database/oracle/oradata/orcl/undotbs01.dbf
restoring datafile 00003 to /database/oracle/oradata/orcl/sysaux01.dbf
restoring datafile 00004 to /database/oracle/oradata/orcl/users01.dbf
channel ch0: reading from backup piece BE_0pnb9hac_1_1
ORA-19870: error reading backup piece BE_0pnb9hac_1_1
ORA-19507: failed to retrieve sequential file, handle="BE_0pnb9hac_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
BEError(0xe0001501) The specified backup object was not found in Backup Exec catalogs.
failover to previous backup
channel ch0: starting datafile backupset restore
channel ch0: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /database/oracle/oradata/orcl/system01.dbf
restoring datafile 00002 to /database/oracle/oradata/orcl/undotbs01.dbf
restoring datafile 00003 to /database/oracle/oradata/orcl/sysaux01.dbf
restoring datafile 00004 to /database/oracle/oradata/orcl/users01.dbf
channel ch0: reading from backup piece BE_0knb7mvn_1_1
ORA-19870: error reading backup piece BE_0knb7mvn_1_1
ORA-19507: failed to retrieve sequential file, handle="BE_0knb7mvn_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
BEError(0xe0001501) The specified backup object was not found in Backup Exec catalogs.
failover to previous backup
channel ch0: starting datafile backupset restore
channel ch0: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /database/oracle/oradata/orcl/system01.dbf
restoring datafile 00002 to /database/oracle/oradata/orcl/undotbs01.dbf
restoring datafile 00003 to /database/oracle/oradata/orcl/sysaux01.dbf
restoring datafile 00004 to /database/oracle/oradata/orcl/users01.dbf
channel ch0: reading from backup piece BE_0gnb7klj_1_1
ORA-19870: error reading backup piece BE_0gnb7klj_1_1
ORA-19507: failed to retrieve sequential file, handle="BE_0gnb7klj_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
BEError(0xe0001501) The specified backup object was not found in Backup Exec catalogs.
failover to previous backup
channel ch0: starting datafile backupset restore
channel ch0: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /database/oracle/oradata/orcl/system01.dbf
restoring datafile 00002 to /database/oracle/oradata/orcl/undotbs01.dbf
restoring datafile 00003 to /database/oracle/oradata/orcl/sysaux01.dbf
restoring datafile 00004 to /database/oracle/oradata/orcl/users01.dbf
channel ch0: reading from backup piece BE_0bnb7fv2_1_1
ORA-19870: error reading backup piece BE_0bnb7fv2_1_1
ORA-19507: failed to retrieve sequential file, handle="BE_0bnb7fv2_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
BEError(0xe0001501) The specified backup object was not found in Backup Exec catalogs.
failover to previous backup
channel ch0: starting datafile backupset restore
channel ch0: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /database/oracle/oradata/orcl/system01.dbf
restoring datafile 00002 to /database/oracle/oradata/orcl/undotbs01.dbf
restoring datafile 00003 to /database/oracle/oradata/orcl/sysaux01.dbf
restoring datafile 00004 to /database/oracle/oradata/orcl/users01.dbf
channel ch0: reading from backup piece BE_07nb7eo1_1_1
ORA-19870: error reading backup piece BE_07nb7eo1_1_1
ORA-19507: failed to retrieve sequential file, handle="BE_07nb7eo1_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
BEError(0xe0001501) The specified backup object was not found in Backup Exec catalogs.
failover to previous backup
channel ch0: starting datafile backupset restore
channel ch0: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /database/oracle/oradata/orcl/system01.dbf
restoring datafile 00002 to /database/oracle/oradata/orcl/undotbs01.dbf
restoring datafile 00003 to /database/oracle/oradata/orcl/sysaux01.dbf
restoring datafile 00004 to /database/oracle/oradata/orcl/users01.dbf
channel ch0: reading from backup piece BE_02nb7b32_1_1
ORA-19870: error reading backup piece BE_02nb7b32_1_1
ORA-19507: failed to retrieve sequential file, handle="BE_02nb7b32_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
BEError(0xe0001501) The specified backup object was not found in Backup Exec catalogs.
failover to previous backup
released channel: ch0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/18/2012 16:21:04
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
EXIT
Recovery Manager complete.
7、BE报错信息
作业结束于: 2012年5月18日,16:20:51
完成状态: 失败
最终错误: 0xe0001501 - 在 Backup Exec 编录中没有找到指定的备份对象。
最终出错类别: 资源出错
有关此错误的其它信息,请参考相应的链接 V-79-57344-5377
8、从客户端恢复文件都正常,说明虚拟磁带库是没有问题的,恢复oracle就有问题,问题出在哪啦?
9、windows server 2003 x86(BE2010备份服务器) + Centos4.8 x86-oracle10g(客户端)+虚拟磁带库
恢复oracle都是正常的。
今天重装了 Oracle Release 10.2.0.1.0 for linux,恢复还是报一样的错。
Symantec Backup Exec2012错误提示:
最终错误: 0xe0001501 - 在 Backup Exec 编录中没有找到指定的备份对象。
最终出错类别: 资源出错
有关此错误的其它信息,请参考相应的链接 V-79-57344-5377
我查了一下参数parameter db_create_file_dest
SQL> show parameter db_create_file_dest;
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
db_create_file_dest string
郁闷,今天利用Oracle Release 9.2.0.4.0 for linux,恢复都是正常的。
数据库是不是设置了DB_CREATE_FILE_DEST,如果有先去掉再试一试。
页:
[1]