ITPub博客

首页 > 数据库 > Oracle > RMAN tsm 备份错误

RMAN tsm 备份错误

原创 Oracle 作者:huzhichengforce 时间:2015-02-06 15:54:44 0 删除 编辑
1、错误1
RAC 环境
ORA-00245: control file backup failed;target is likely on a local file system

From 11gR2onwards, the controlfile backup happens without holding the controlfileenqueue. For non-RAC database, this doesn't change anything. But for RACdatabase, due to the changes made to the controlfile backup mechanism in 11gR2,any instance in the cluster may write to the snapshot controlfile. Due to thissnapshot controlfile need to be visible to all instances. In RACenvironment any form of controlfile backup may fail with ORA-0245 if thelocation of the Snapshot Controlfile is not a shared location.

The snapshotcontrolfile MUST be accessible by all nodes of a RAC database, if the snapshotcontrolfile does not reside on a shared device error will be raised at the timeof RMAN backup while taking snapshot of controlfile. 

--快照控制文件必须能被所有节点访问,如果快照控制不是存放在共享设备上,那么在RMAN 进行控制文件的快照备份时就会报错

检查快照控制文件位置

RMAN> show snapshot controlfile name;

 配置snapshot controlfile 到共享位置

RMAN> CONFIGURE SNAPSHOT CONTROLFILENAME TO '/snapcf_.f';

如果使用了ASM,就指定到对应的ASM disk group:

RMAN> CONFIGURE SNAPSHOT CONTROLFILENAME TO '+/snapcf_.f';



2、
RMAN-06207: WARNING: 14 objects could not be deleted for SBT_TAPE channel(s) due
RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix status
RMAN-06210: List of Mismatched objects
RMAN-06211: ==========================
RMAN-06212:   Object Type   Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Backup Piece    db_HZWSJ_1985_1_02_15
RMAN-06214: Backup Piece    db_HZWSJ_1986_1_02_15
RMAN-06214: Backup Piece    db_HZWSJ_1987_1_02_15
RMAN-06214: Backup Piece    db_HZWSJ_1988_1_02_15
RMAN-06214: Backup Piece    db_HZWSJ_1989_1_02_15
RMAN-06214: Backup Piece    db_HZWSJ_1990_1_02_15
RMAN-06214: Backup Piece    arch_HZWSJ_1993_1_02_15
RMAN-06214: Backup Piece    c-2252250540-20140215-01
RMAN-06214: Backup Piece    cntrl_HZWSJ_1995_1_02_15
RMAN-06214: Backup Piece    c-2252250540-20140215-02
RMAN-06214: Backup Piece    db_HZWSJ_2112_1_09_24
RMAN-06214: Backup Piece    db_HZWSJ_2113_1_09_24
RMAN-06214: Backup Piece    db_HZWSJ_2114_1_10_17
RMAN-06214: Backup Piece    db_HZWSJ_2115_1_10_17
select *from v$backup_piece where handle='xxxxx' 找出tag
RMAN> allocate channel for maintenance type sbt;-----这里是磁带库和本地备份有别!
RMAN>delete force BACKUPSET TAG XXXXX;

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/26764973/viewspace-1428782/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: 我日!
请登录后发表评论 登录
全部评论

注册时间:2012-08-19

  • 博文量
    202
  • 访问量
    518265