今天客户配置RMAN 备份发现错误。
报RMAN-6186 错误,发现是RMAN 版本之间的错误。解决后顺便将RMAN 多版本的兼容性列表发出来,希望大家有所帮助。
Target/Auxiliary Database | RMAN Executable | Catalog Database | Catalog Schema |
8.1.7.4 | 8.1.7.4 | >=8.1.7 | 8.1.7.4 |
8.1.7.4 | 8.1.7.4 | >=8.1.7 | >=9.0.1.4 |
9.0.1 | 9.0.1 | >=8.1.7 | >= RMAN executable |
9.2.0 | >=9.0.1.3 and <= Target database | >=8.1.7 | >= RMAN executable |
>=10.1.0 | >=9.0.1.3 and <= Target database | >=9.0.1 | >= RMAN executable |
在有Catalog db 的RMAN 备份中,有三个点要注意:
RMAN 执行的数据库版本
RMAN Catalog 数据库版本
RMAN 备份的Target 数据库版本
但一般需要遵循如下:
RMAN 执行的数据库版本和Target 数据库版本一致。
RMAN catalog schema 版本必须大于等于RMAN 执行版本。
RMAN target DB 版本必须大于等于RMAN catalog 数据库版本。
最好的情况就是这三个大小版本相同,一般没有任何问题。
如果遇到下面两个错误号码就要注意了:
$ oerr rman 6184
6184, 1, "duplicate object in backup specifier: %s %s"
// *Cause: A backup command specifies the same datafile or copy of a datafile
// multiple times.
// *Action: Eliminate the duplicates.
$ oerr rman 6186
6186, 1, "PL/SQL package %s.%s version %s in %s database is too old"
// *Cause: The specified PL/SQL package is a version that is too old to work
// with this version of the Recovery Manager (RMAN).
// *Action: If the database indicated is RCVCAT, then you can use the
// UPGRADE CATALOG command to upgrade the recovery catalog to the
// most current version. If the database is TARGET or AUXILIARY,
// then you must either upgrade the specified database or use
// an older version of RMAN.
$ oerr rman 6429
6429, 1, "%s database is not compatible with this version of RMAN"
// *Cause: The indicated database is not compatible with this version of
// the Recovery Manager (RMAN). Other messages have also
// been issued which detail the cause of the error.
// *Action: See the other messages. If the database is RCVCAT, then you may
// be able to use the CREATE CATALOG or UPGRADE CATALOG commands
// to correct the problem. If the database is TARGET or AUXILIARY,
// then you must either upgrade the target database or use a
// newer version of the RMAN executable.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/34596/viewspace-611849/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/34596/viewspace-611849/