求助：catalog backup一直处于active状态！

alanhust

任务的Job details：
validating NBDB backup in /usr/openv/db/staging
在这里就一直没有再继续了。
在/usr/openv/netbackup/logs下创建bpdbm，获取日志，其中也没有报错，截取部分如下。这个问题从哪方面来定位呢？
......
11:28:57.572 [3237] <2> LOCAL CLASS_ATT_DEFS: Product ID = 7
11:28:57.573 [3237] <2> CatImg_FilesFileSize: Size of /usr/openv/netbackup/db/images/nbumaster/1321000000/tmp/backup_catalog_1321846056_FULL.f 4790
11:28:57.587 [3237] <2> Orb::init: initializing ORB EMMlib_Orb with: connect_bpdbm_to_emm -ORBSvcConfDirective "-ORBDottedDecimalAddresses 0" -ORBSvcConfDirective "static PBXIOP_Factory '-enable_keepalive'" -ORBSvcConfDirective "static EndpointSelectorFactory ''" -ORBSvcConfDirective "static Resource_Factory '-ORBProtocolFactory PBXIOP_Factory'" -ORBSvcConfDirective "static Resource_Factory '-ORBProtocolFactory IIOP_Factory'" -ORBSvcConfDirective "static PBXIOP_Evaluator_Factory '-orb EMMlib_Orb'" -ORBSvcConfDirective "static Resource_Factory '-ORBConnectionCacheMax 1024 '" -ORBSvcConf /dev/null -ORBSvcConfDirective "static Server_Strategy_Factory '-ORBMaxRecvGIOPPayloadSize 268435456'"(Orb.cpp:741)
11:28:57.593 [3237] <2> EndpointSelector::select_endpoint: performing call with the only endpt available!(Endpoint_Selector.cpp:437)
11:28:57.597 [3237] <4> connect_bpdbm_to_emm: succesfully initialized EMM interface
11:28:57.597 [3237] <2> db_get_image_info: Job in progress, found image file /usr/openv/netbackup/db/images/nbumaster/1321000000/tmp/backup_catalog_1321846037_FULL
11:28:57.626 [3237] <4> update_DBM_ImageChangeLog_Timestamp: SQL_NO_DATA_FOUND when executing UPDATE DBM_MAIN.DBM_ImageChangeLog SET CreatedDateTime = current utc timestamp WHERE (MasterServerKey = 1000002) AND (BackupID = 'nbumaster_1321846056') AND (ClientType = 7) AND (OperationID = 1) (rc=100) ErrMsg , ErrCode 0, SqlState
11:28:57.635 [3237] <2> process_request: request complete: exit status 0  ; query type: 74
11:28:58.826 [3008] <4> ASA_XBSA_file_backup: All backup jobs have completed.
11:28:58.826 [3008] <4> do_online_nbdb_backup: Succesfully completed backing up files in /usr/openv/db/staging.  backup_id = nbumaster_1321846056
11:28:58.827 [3008] <4> do_online_nbdb_backup: validating NBDB backup in /usr/openv/db/staging
11:28:58.827 [3008] <4> validate_database: Entering.
11:28:58.827 [3008] <4> validate_database: Validating database: NBDB
11:28:58.827 [3008] <4> build_dbvalid_command: Entering.
11:28:58.827 [3008] <4> build_dbvalid_command: Building dbvalid command for database: NBDB
11:28:58.827 [3008] <4> build_dbvalid_command: Exiting. rc = 0
11:28:58.827 [3008] <4> validate_database: Executing . /usr/openv/db/vxdbms_env.sh &&/usr/openv/db/bin/dbvalid -q -fx -c "UID=dbaWD=******;ENG=validation_eng;LINKS=shmem;START=/usr/openv/db/bin/dbeng11 \"/usr/openv/db/staging/NBDB.db\" -ds \"/usr/openv/db/staging\""
11:32:26.032 [3563] <2> process_request: request complete: exit status 0  ; query type: 98
11:33:19.847 [3644] <2> process_request: request complete: exit status 0  ; query type: 91

alanhust

尝试将catalog备份到disk上，仍然报同样的错误。
其它的备份任务都可以成功执行。

无牙

什么平台？

alanhust

回复 3# 无牙

    nbu master 7.0.1 在linux suse 上
    使用的昆腾i2000物理带库。

无牙

ls -l /usr/openv/db/staging

这个输出贴上来

C字裤男爵

# /usr/openv/db/bin/nbdb_admin -validate NBDB
报错么？

牙兄的意思是有脏东西在staging目录？

无牙

有可能里面有一些之前备份失败留下的东西，可以先删除。再试一试。

alanhust

回复 7# 无牙

oracle@nbumaster:~> ls -l /usr/openv/db/staging
total 168976
-rw-rw-rw- 1 root root 26218496 2011-12-06 14:39 DARS_DATA.db
-rw-rw-rw- 1 root root 26218496 2011-12-06 14:39 DARS_INDEX.db
-rw------- 1 root root       37 2011-12-06 14:39 databases.conf
-rw-rw-rw- 1 root root 26218496 2011-12-06 14:39 DBM_DATA.db
-rw-rw-rw- 1 root root 26218496 2011-12-06 14:39 DBM_INDEX.db
-rw-rw-rw- 1 root root 26218496 2011-12-06 14:39 EMM_DATA.db
-rw-rw-rw- 1 root root 26218496 2011-12-06 14:39 EMM_INDEX.db
-rw-rw-rw- 1 root root  2617344 2011-12-06 14:39 NBDB.db
-rw-rw-rw- 1 root root 12869632 2011-12-06 14:39 NBDB.log
-rw------- 1 root root      178 2011-12-06 14:39 server.conf
-rw------- 1 root root      456 2011-12-06 14:39 vxdbms.conf

这里面似乎都是catalog数据库的配置文件和数据库文件，有什么需要删除的么？

alanhust

回复 6# C字裤男爵


nbumaster:/usr/openv/db/bin # ./nbdb_admin -validate NBDB  
......
........
VALIDATE TABLE "dbo"."sync_passthrough_progress" WITH EXPRESS CHECK
VALIDATE TABLE "dbo"."sync_passthrough_script" WITH EXPRESS CHECK
VALIDATE TABLE "dbo"."sync_passthrough_status" WITH EXPRESS CHECK
VALIDATE TABLE "rs_systabgroup"."rs_lastcommit" WITH EXPRESS CHECK
VALIDATE TABLE "rs_systabgroup"."rs_threads" WITH EXPRESS CHECK
No errors reported
Database [NBDB] validation successful.

这个没有报错。

alanhust

catalog pool 中是有空白的磁带的
策略是保留1周的备份。
执行bpverify -policy backup_catalog -s 11/13/2011 00:00:01 -e 12/06/2011 12:00:00的结果如下：
nbumaster:/usr/openv/netbackup/bin/admincmd # ./bpverify -policy backup_catalog -s 11/13/2011 00:00:01 -e 12/06/2011 12:00:00
Verify started Tue Dec  6 16:29:18 2011
INF - Verifying policy backup_catalog, schedule Full (nbumaster_1322619280), media id 000012, created 11/30/2011 10:14:40.
INF - Verify of policy backup_catalog, schedule Full (nbumaster_1322619280) was successful.
INF - Verifying policy backup_catalog, schedule Full (nbumaster_132266313, media id 000012, created 11/30/2011 22:25:38.
INF - Verify of policy backup_catalog, schedule Full (nbumaster_132266313 was successful.
INF - Verifying policy backup_catalog, schedule Full (nbumaster_132269938, media id 000012, created 12/01/2011 08:29:48.
INF - Verify of policy backup_catalog, schedule Full (nbumaster_132269938 was successful.
INF - Verifying policy backup_catalog, schedule Full (nbumaster_1322786514), media id 000012, created 12/02/2011 08:41:54.
INF - Verify of policy backup_catalog, schedule Full (nbumaster_1322786514) was successful.
INF - Verifying policy backup_catalog, schedule Full (nbumaster_1323134326), media id 000012, created 12/06/2011 09:18:46.
INF - Verify of policy backup_catalog, schedule Full (nbumaster_1323134326) was successful.
INF - Verifying policy backup_catalog, schedule Full (nbumaster_1323135645), media id 000012, created 12/06/2011 09:40:45.
INF - Verify of policy backup_catalog, schedule Full (nbumaster_1323135645) was successful.
INF - Verifying policy backup_catalog, schedule Full (nbumaster_1323136811), media id 000012, created 12/06/2011 10:00:11.
INF - Verify of policy backup_catalog, schedule Full (nbumaster_1323136811) was successful.
INF - Verifying policy backup_catalog, schedule Full (nbumaster_1322820602), path "/sdu", created 12/02/2011 18:10:02.
INF - from host nbumaster, no data in archive
INF - Verify of policy backup_catalog, schedule Full (nbumaster_1322820602) failed, tar had an unexpected error.
INF - Status = successfully verified 7 of 8 images.
INF - Status = the requested operation was partially successful.