- 论坛徽章:
- 2
|
最近遇到一个很有趣的问题,是这样的。生产系统里有主备两个数据库,主库里的数据每天在下午进行备份,然后ftp到备库,备库load,然后主备库进行数据比对都一致,但是最近从备库上下载数据到测试系统里load的时候经常load到一半的时候报错,load了多次,主要有下面三种报错。
从网上找了一些答案,大都是说是dump文件有问题,但是我奇怪的是,既然备库能load,那么说明备库上这份文件肯定没有问题,而且我也从主库下载过,结果一样,每次下载完我都会比对数据大小,也没有错,还有个奇怪的现象就是好比日期越往后,能load的数据越少,比如在6月1号的数据还能load到三十多G,但是到7月1号就是十几二十G,而且似乎6月前的数据没有这个问题。
(1)
Jul 5 16:25:45 2016: Backup Server: 3.29.2.1: No virtual mapping for logical page 914030842.
Jul 5 16:25:45 2016: Backup Server: 3.29.2.1: No virtual mapping for logical page -1856962061.
Jul 5 16:25:45 2016: Backup Server: 3.14.2.4: Logical page 1281557 is not in the given database map.
Jul 5 16:25:45 2016: Backup Server: 6.32.2.3: compress::6::/backup/20160701/ksqhdb_20160701_part4.c6dmp::03: volume not valid or not requested (server: , session id: 28.)
Jul 5 16:25:45 2016: Backup Server: 1.14.2.4: Unrecoverable I/O or volume error. This DUMP or LOAD session must exit.
(2)
Jul 6 11:18:33 2016: Backup Server: 3.29.2.1: No virtual mapping for logical page 2097953072.
Jul 6 11:18:33 2016: Backup Server: 3.29.2.1: No virtual mapping for logical page -310530138.
Jul 6 11:18:33 2016: Backup Server: 3.29.2.1: No virtual mapping for logical page -1.
(3)
Jul 6 08:17:44 2016: Backup Server: 4.58.1.1: Database ksqhdb: 19476092 kilobytes LOADed.
Jul 6 08:18:07 2016: Backup Server: 4.58.1.1: Database ksqhdb: 19975656 kilobytes LOADed.
Jul 6 08:18:37 2016: Backup Server: 4.58.1.1: Database ksqhdb: 20501150 kilobytes LOADed.
Jul 6 08:18:52 2016: Backup Server: 4.124.2.1: Archive API error for device='compress::6::/backup/20160701/ksqhdb_20160701_part4.c6dmp::03': Vendor application name=Compress API
, Library version=1, API routine=syb_read(), Message=
Jul 6 08:18:53 2016: Backup Server: 6.32.2.3: compress::6::/backup/20160701/ksqhdb_20160701_part3.c6dmp::02: volume not valid or not requested (server: , session id: 40.)
Jul 6 08:18:53 2016: Backup Server: 1.14.2.4: Unrecoverable I/O or volume error. This DUMP or LOAD session must exit.
Jul 6 08:18:53 2016: Backup Server: 6.32.2.3: compress::6::/backup/20160701/ksqhdb_20160701_part1.c6dmp::00: volume not valid or not requested (server: , session id: 40.)
Jul 6 08:18:53 2016: Backup Server: 1.14.2.4: Unrecoverable I/O or volume error. This DUMP or LOAD session must exit.
Jul 6 08:18:54 2016: Backup Server: 6.32.2.3: compress::6::/backup/20160701/ksqhdb_20160701_part2.c6dmp::01: volume not valid or not requested (server: , session id: 40.)
Jul 6 08:18:54 2016: Backup Server: 1.14.2.4: Unrecoverable I/O or volume error. This DUMP or LOAD session must exit.
Jul 6 08:18:54 2016: Backup Server: 6.32.2.3: compress::6::/backup/20160701/ksqhdb_20160701_part4.c6dmp::03: volume not valid or not requested (server: , session id: 40.)
Jul 6 08:18:54 2016: Backup Server: 1.14.2.4: Unrecoverable I/O or volume error. This DUMP or LOAD session must exit.
Jul 6 09:07:51 2016: Backup Server: 4.132.1.1: Attempting to open byte stream device: 'compress::6::/backup/20160602/ksqhdb_20160602_part1.c6dmp::00'
Jul 6 09:07:51 2016: Backup Server: 4.132.1.1: Attempting to open byte stream device: 'compress::6::/backup/20160602/ksqhdb_20160602_part2.c6dmp::01'
Jul 6 09:07:51 2016: Backup Server: 4.132.1.1: Attempting to open byte stream device: 'compress::6::/backup/20160602/ksqhdb_20160602_part3.c6dmp::02'
Jul 6 09:07:51 2016: Backup Server: 4.132.1.1: Attempting to open byte stream device: 'compress::6::/backup/20160602/ksqhdb_20160602_part4.c6dmp::03'
Jul 6 09:07:51 2016: Backup Server: 6.28.1.1: Dumpfile name 'ksqhdb161540F362 ' section number 1 mounted on byte stream 'compress::6::/backup/20160602/ksqhdb_20160602_part3.c6dm
p::02'
Jul 6 09:07:51 2016: Backup Server: 6.28.1.1: Dumpfile name 'ksqhdb161540F362 ' section number 1 mounted on byte stream 'compress::6::/backup/20160602/ksqhdb_20160602_part2.c6dm
p::01'
Jul 6 09:07:51 2016: Backup Server: 6.28.1.1: Dumpfile name 'ksqhdb161540F362 ' section number 1 mounted on byte stream 'compress::6::/backup/20160602/ksqhdb_20160602_part1.c6dm
p::00'
Jul 6 09:07:51 2016: Backup Server: 6.28.1.1: Dumpfile name 'ksqhdb161540F362 ' section number 1 mounted on byte stream 'compress::6::/backup/20160602/ksqhdb_20160602_part4.c6dm
p::03'
|
|