记录一个rman恢复目录所在表空间不足导致备份失败的故障:
1.
GXdbC% df -k
Filesystem kbytes used avail capacity Mounted on
/dev/md/dsk/d8 8065025 6222832 1761543 78% /
/proc 0 0 0 0% /proc
fd 0 0 0 0% /dev/fd
mnttab 0 0 0 0% /etc/mnttab
swap 5856920 16 5856904 1% /var/run
dmpfs 5856904 0 5856904 0% /dev/vx/dmp
dmpfs 5856904 0 5856904 0% /dev/vx/rdmp
swap 5863616 6712 5856904 1% /tmp
/dev/dsk/c0t0d0s4 13736409 7854468 5744577 58% /opt
/dev/md/dsk/d0 5040814 2569342 2421064 52% /export/home
/dev/vx/dsk/datadg/vol173
103218991 100124076 2062726 98% /usr5
/dev/vx/dsk/datadg/vol182
82575189 81749438 0 100% /arch_log
2.bpadm执行报错(191)
3.手工执行,报错信息如附录1
rman target / catalog rman/rman@rman
RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
BACKUP
filesperset 20
FORMAT 'al_%s_%p_%t'
ARCHIVELOG ALL DELETE INPUT;
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
}
4.查看恢复目录的空间信息,并增加rman的表空间rmants 200M
SQL> set lines 200
SQL> SELECT tablespace_name, sum ( blocks ) as free_blk ,
2 trunc ( sum ( bytes ) /(1024*1024) ) as free_m,
max ( bytes ) / (1024) as big_chunk_k, count (*) as num_chunks
FROM dba_free_space GROUP BY tablespace_name; 3 4
TABLESPACE_NAME FREE_BLK FREE_M BIG_CHUNK_K NUM_CHUNKS
------------------------------------------------------------ ---------- ---------- ----------- ----------
INDX 3192 24 25536 1
RMANTS 3032 23 22464 3
SYSTEM 1016 7 8128 1
TOOLS 1272 9 10176 1
UNDOTBS1 18776 146 149440 4
USERS 3192 24 25536 1
6 rows selected.
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/oracle92/app/oracle/oradata/rman/system01.dbf
/oracle92/app/oracle/oradata/rman/undotbs01.dbf
/oracle92/app/oracle/oradata/rman/indx01.dbf
/oracle92/app/oracle/oradata/rman/tools01.dbf
/oracle92/app/oracle/oradata/rman/users01.dbf
/oracle92/app/oracle/oradata/rman/rmants.dbf
/oracle92/app/oracle/oradata/rman/rmants02.dbf
5.删除归档目录文件
6.bpadm启动备份,策略为oracle_bak(累积增量备份),输出文件参见/opt/openv/netbackup/rman/gx_hot_database_backup.sh.out.20070628
7.调整archive_log策略,有原来的每7天备份1次修改为每天备份1次
8.检查各省RMAN
1)空间使用情况
2)rman维护(清除过期备份,目录同步,校验备份)
附录1)手工备份报错信息
恢复管理器: 版本9.2.0.6.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
连接到目标数据库: GXDBC (DBID=232768739)
连接到恢复目录数据库
RMAN> RUN {
2> ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
BACKUP
filesperset 20
FORMAT 'al_%s_%p_%t'
ARCHIVELOG ALL DELETE INPUT;
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
3> 4> 5> 6> 7> 8> 9> 10> }
分配的通道: ch00
通道 ch00: sid=111 devtype=SBT_TAPE
通道ch00: VERITAS NetBackup for Oracle - Release 5.0GA (2003103006)
分配的通道: ch01
通道 ch01: sid=40 devtype=SBT_TAPE
通道ch01: VERITAS NetBackup for Oracle - Release 5.0GA (2003103006)
启动 backup 于 2007-06-27 23:45:03
当前日志已存档
通道 ch00: 正在启动存档日志备份集
通道 ch00: 正在指定备份集中的存档日志
输入存档日志线程 =1 序列 =251943 记录 ID=245404 时间戳=626320006
输入存档日志线程 =1 序列 =251944 记录 ID=245405 时间戳=626320481
输入存档日志线程 =1 序列 =251945 记录 ID=245406 时间戳=626320709
输入存档日志线程 =1 序列 =251946 记录 ID=245407 时间戳=626320757
输入存档日志线程 =1 序列 =251947 记录 ID=245408 时间戳=626320800
输入存档日志线程 =1 序列 =251948 记录 ID=245409 时间戳=626320840
输入存档日志线程 =1 序列 =251949 记录 ID=245410 时间戳=626320888
输入存档日志线程 =1 序列 =251950 记录 ID=245411 时间戳=626320918
输入存档日志线程 =1 序列 =251951 记录 ID=245412 时间戳=626321203
输入存档日志线程 =1 序列 =251952 记录 ID=245413 时间戳=626321745
输入存档日志线程 =1 序列 =251953 记录 ID=245414 时间戳=626322363
输入存档日志线程 =1 序列 =251954 记录 ID=245415 时间戳=626322604
输入存档日志线程 =1 序列 =251955 记录 ID=245416 时间戳=626323547
输入存档日志线程 =1 序列 =251956 记录 ID=245417 时间戳=626323768
输入存档日志线程 =1 序列 =251957 记录 ID=245418 时间戳=626324437
输入存档日志线程 =1 序列 =251958 记录 ID=245419 时间戳=626324768
输入存档日志线程 =1 序列 =251959 记录 ID=245420 时间戳=626325653
输入存档日志线程 =1 序列 =251960 记录 ID=245421 时间戳=626325965
输入存档日志线程 =1 序列 =251961 记录 ID=245422 时间戳=626326489
输入存档日志线程 =1 序列 =251962 记录 ID=245423 时间戳=626327151
通道 ch00: 正在启动段 1 于 2007-06-27 23:45:51
通道 ch01: 正在启动存档日志备份集
通道 ch01: 正在指定备份集中的存档日志
输入存档日志线程 =1 序列 =251963 记录 ID=245424 时间戳=626327485
输入存档日志线程 =1 序列 =251964 记录 ID=245425 时间戳=626328098
输入存档日志线程 =1 序列 =251965 记录 ID=245426 时间戳=626328399
输入存档日志线程 =1 序列 =251966 记录 ID=245427 时间戳=626329243
输入存档日志线程 =1 序列 =251967 记录 ID=245428 时间戳=626329642
输入存档日志线程 =1 序列 =251968 记录 ID=245429 时间戳=626329912
输入存档日志线程 =1 序列 =251969 记录 ID=245430 时间戳=626330062
输入存档日志线程 =1 序列 =251970 记录 ID=245431 时间戳=626330818
输入存档日志线程 =1 序列 =251971 记录 ID=245432 时间戳=626331089
输入存档日志线程 =1 序列 =251972 记录 ID=245433 时间戳=626331509
输入存档日志线程 =1 序列 =251973 记录 ID=245434 时间戳=626331981
输入存档日志线程 =1 序列 =251974 记录 ID=245435 时间戳=626332544
输入存档日志线程 =1 序列 =251975 记录 ID=245436 时间戳=626333101
输入存档日志线程 =1 序列 =251976 记录 ID=245437 时间戳=626333219
输入存档日志线程 =1 序列 =251977 记录 ID=245438 时间戳=626334180
输入存档日志线程 =1 序列 =251978 记录 ID=245439 时间戳=626334381
输入存档日志线程 =1 序列 =251979 记录 ID=245440 时间戳=626334935
输入存档日志线程 =1 序列 =251980 记录 ID=245441 时间戳=626335557
输入存档日志线程 =1 序列 =251981 记录 ID=245442 时间戳=626335911
输入存档日志线程 =1 序列 =251982 记录 ID=245443 时间戳=626336627
通道 ch01: 正在启动段 1 于 2007-06-27 23:45:52
释放的通道: ch00
释放的通道: ch01
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch00 channel at 06/27/2007 23:45:59
ORA-19506: 无法创建顺序文件, 名称 = "al_45191_1_626399149", 参数 = ""
ORA-27028: skgfqcre: sbtbackup 返回错误
ORA-19511: 从介质管理器层接收到错误, 错误文本为:
VxBSACreateObject: Failed with error:
Server Status: operation not allowed during this time period
RMAN> oerr ora 19056
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "identifier": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, spool, startup, shutdown, send, show, test, upgrade, validate"
RMAN-01008: the bad identifier was: oerr
RMAN-01007: at line 1 column 1 file: standard input
1.
GXdbC% df -k
Filesystem kbytes used avail capacity Mounted on
/dev/md/dsk/d8 8065025 6222832 1761543 78% /
/proc 0 0 0 0% /proc
fd 0 0 0 0% /dev/fd
mnttab 0 0 0 0% /etc/mnttab
swap 5856920 16 5856904 1% /var/run
dmpfs 5856904 0 5856904 0% /dev/vx/dmp
dmpfs 5856904 0 5856904 0% /dev/vx/rdmp
swap 5863616 6712 5856904 1% /tmp
/dev/dsk/c0t0d0s4 13736409 7854468 5744577 58% /opt
/dev/md/dsk/d0 5040814 2569342 2421064 52% /export/home
/dev/vx/dsk/datadg/vol173
103218991 100124076 2062726 98% /usr5
/dev/vx/dsk/datadg/vol182
82575189 81749438 0 100% /arch_log
2.bpadm执行报错(191)
3.手工执行,报错信息如附录1
rman target / catalog rman/rman@rman
RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
BACKUP
filesperset 20
FORMAT 'al_%s_%p_%t'
ARCHIVELOG ALL DELETE INPUT;
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
}
4.查看恢复目录的空间信息,并增加rman的表空间rmants 200M
SQL> set lines 200
SQL> SELECT tablespace_name, sum ( blocks ) as free_blk ,
2 trunc ( sum ( bytes ) /(1024*1024) ) as free_m,
max ( bytes ) / (1024) as big_chunk_k, count (*) as num_chunks
FROM dba_free_space GROUP BY tablespace_name; 3 4
TABLESPACE_NAME FREE_BLK FREE_M BIG_CHUNK_K NUM_CHUNKS
------------------------------------------------------------ ---------- ---------- ----------- ----------
INDX 3192 24 25536 1
RMANTS 3032 23 22464 3
SYSTEM 1016 7 8128 1
TOOLS 1272 9 10176 1
UNDOTBS1 18776 146 149440 4
USERS 3192 24 25536 1
6 rows selected.
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/oracle92/app/oracle/oradata/rman/system01.dbf
/oracle92/app/oracle/oradata/rman/undotbs01.dbf
/oracle92/app/oracle/oradata/rman/indx01.dbf
/oracle92/app/oracle/oradata/rman/tools01.dbf
/oracle92/app/oracle/oradata/rman/users01.dbf
/oracle92/app/oracle/oradata/rman/rmants.dbf
/oracle92/app/oracle/oradata/rman/rmants02.dbf
5.删除归档目录文件
6.bpadm启动备份,策略为oracle_bak(累积增量备份),输出文件参见/opt/openv/netbackup/rman/gx_hot_database_backup.sh.out.20070628
7.调整archive_log策略,有原来的每7天备份1次修改为每天备份1次
8.检查各省RMAN
1)空间使用情况
2)rman维护(清除过期备份,目录同步,校验备份)
附录1)手工备份报错信息
恢复管理器: 版本9.2.0.6.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
连接到目标数据库: GXDBC (DBID=232768739)
连接到恢复目录数据库
RMAN> RUN {
2> ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
BACKUP
filesperset 20
FORMAT 'al_%s_%p_%t'
ARCHIVELOG ALL DELETE INPUT;
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
3> 4> 5> 6> 7> 8> 9> 10> }
分配的通道: ch00
通道 ch00: sid=111 devtype=SBT_TAPE
通道ch00: VERITAS NetBackup for Oracle - Release 5.0GA (2003103006)
分配的通道: ch01
通道 ch01: sid=40 devtype=SBT_TAPE
通道ch01: VERITAS NetBackup for Oracle - Release 5.0GA (2003103006)
启动 backup 于 2007-06-27 23:45:03
当前日志已存档
通道 ch00: 正在启动存档日志备份集
通道 ch00: 正在指定备份集中的存档日志
输入存档日志线程 =1 序列 =251943 记录 ID=245404 时间戳=626320006
输入存档日志线程 =1 序列 =251944 记录 ID=245405 时间戳=626320481
输入存档日志线程 =1 序列 =251945 记录 ID=245406 时间戳=626320709
输入存档日志线程 =1 序列 =251946 记录 ID=245407 时间戳=626320757
输入存档日志线程 =1 序列 =251947 记录 ID=245408 时间戳=626320800
输入存档日志线程 =1 序列 =251948 记录 ID=245409 时间戳=626320840
输入存档日志线程 =1 序列 =251949 记录 ID=245410 时间戳=626320888
输入存档日志线程 =1 序列 =251950 记录 ID=245411 时间戳=626320918
输入存档日志线程 =1 序列 =251951 记录 ID=245412 时间戳=626321203
输入存档日志线程 =1 序列 =251952 记录 ID=245413 时间戳=626321745
输入存档日志线程 =1 序列 =251953 记录 ID=245414 时间戳=626322363
输入存档日志线程 =1 序列 =251954 记录 ID=245415 时间戳=626322604
输入存档日志线程 =1 序列 =251955 记录 ID=245416 时间戳=626323547
输入存档日志线程 =1 序列 =251956 记录 ID=245417 时间戳=626323768
输入存档日志线程 =1 序列 =251957 记录 ID=245418 时间戳=626324437
输入存档日志线程 =1 序列 =251958 记录 ID=245419 时间戳=626324768
输入存档日志线程 =1 序列 =251959 记录 ID=245420 时间戳=626325653
输入存档日志线程 =1 序列 =251960 记录 ID=245421 时间戳=626325965
输入存档日志线程 =1 序列 =251961 记录 ID=245422 时间戳=626326489
输入存档日志线程 =1 序列 =251962 记录 ID=245423 时间戳=626327151
通道 ch00: 正在启动段 1 于 2007-06-27 23:45:51
通道 ch01: 正在启动存档日志备份集
通道 ch01: 正在指定备份集中的存档日志
输入存档日志线程 =1 序列 =251963 记录 ID=245424 时间戳=626327485
输入存档日志线程 =1 序列 =251964 记录 ID=245425 时间戳=626328098
输入存档日志线程 =1 序列 =251965 记录 ID=245426 时间戳=626328399
输入存档日志线程 =1 序列 =251966 记录 ID=245427 时间戳=626329243
输入存档日志线程 =1 序列 =251967 记录 ID=245428 时间戳=626329642
输入存档日志线程 =1 序列 =251968 记录 ID=245429 时间戳=626329912
输入存档日志线程 =1 序列 =251969 记录 ID=245430 时间戳=626330062
输入存档日志线程 =1 序列 =251970 记录 ID=245431 时间戳=626330818
输入存档日志线程 =1 序列 =251971 记录 ID=245432 时间戳=626331089
输入存档日志线程 =1 序列 =251972 记录 ID=245433 时间戳=626331509
输入存档日志线程 =1 序列 =251973 记录 ID=245434 时间戳=626331981
输入存档日志线程 =1 序列 =251974 记录 ID=245435 时间戳=626332544
输入存档日志线程 =1 序列 =251975 记录 ID=245436 时间戳=626333101
输入存档日志线程 =1 序列 =251976 记录 ID=245437 时间戳=626333219
输入存档日志线程 =1 序列 =251977 记录 ID=245438 时间戳=626334180
输入存档日志线程 =1 序列 =251978 记录 ID=245439 时间戳=626334381
输入存档日志线程 =1 序列 =251979 记录 ID=245440 时间戳=626334935
输入存档日志线程 =1 序列 =251980 记录 ID=245441 时间戳=626335557
输入存档日志线程 =1 序列 =251981 记录 ID=245442 时间戳=626335911
输入存档日志线程 =1 序列 =251982 记录 ID=245443 时间戳=626336627
通道 ch01: 正在启动段 1 于 2007-06-27 23:45:52
释放的通道: ch00
释放的通道: ch01
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch00 channel at 06/27/2007 23:45:59
ORA-19506: 无法创建顺序文件, 名称 = "al_45191_1_626399149", 参数 = ""
ORA-27028: skgfqcre: sbtbackup 返回错误
ORA-19511: 从介质管理器层接收到错误, 错误文本为:
VxBSACreateObject: Failed with error:
Server Status: operation not allowed during this time period
RMAN> oerr ora 19056
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "identifier": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, spool, startup, shutdown, send, show, test, upgrade, validate"
RMAN-01008: the bad identifier was: oerr
RMAN-01007: at line 1 column 1 file: standard input
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13086288/viewspace-201876/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/13086288/viewspace-201876/