2025年sqlldr 多字节字符错误（oracle 多字节字符错误）

科技前沿 • 2025-05-30 23:37 • 阅读 39

大家好，我是讯享网，很高兴认识大家。

参考以下脚本：
–-作业环境初始化
SP_INIT_JOB_SYS(1);
–-定时每周六运行，进行全量备份
call SP_CREATE_JOB(‘JOB_FULL_BAK_TIMELY’,1,0,“,0,0,”,0,“);
call SP_JOB_CONFIG_START(‘JOB_FULL_BAK_TIMELY’);
call SP_ADD_JOB_STEP(‘JOB_FULL_BAK_TIMELY’, ‘定时全量备份’, 6,‘0/dmdata/dmbak’, 1, 2, 0, 0, NULL, 0);
call SP_ADD_JOB_SCHEDULE(‘JOB_FULL_BAK_TIMELY’, ‘JOB_FULL_BAK_TIMELY’, 1, 2, 1, 64, 0, ‘00:06:08’, NULL, ‘2020-07-07 12:06:08’, NULL, “);
call SP_JOB_CONFIG_COMMIT(‘JOB_FULL_BAK_TIMELY’);
–-定时每天运行，进行增量备份(晚上,周六除外)
call SP_CREATE_JOB(‘JOB_INCREMENT_BAK_TIMELY_NIGHT’,1,0,”,0,0,“,0,”);
call SP_JOB_CONFIG_START(‘JOB_INCREMENT_BAK_TIMELY_NIGHT’);
call SP_ADD_JOB_STEP(‘JOB_INCREMENT_BAK_TIMELY_NIGHT’, ‘定时增量备份’, 6, ‘/dmdata/dmbak|/dmdata/dmbak’, 1, 2, 0, 0, NULL, 0);
call SP_ADD_JOB_SCHEDULE(‘JOB_INCREMENT_BAK_TIMELY_NIGHT’, ‘JOB_INCREMENT_BAK_TIMELY_NIGHT’, 1, 2, 1, 63, 0, ‘00:08:07’, NULL, ‘2020-07-07 12:08:07’, NULL, “);
call SP_JOB_CONFIG_COMMIT(‘JOB_INCREMENT_BAK_TIMELY_NIGHT’);
–-定时每周日运行，删除前30天的备份，包括全量和增量
call SP_CREATE_JOB(‘JOB_DEL_BAK_TIMELY’,1,0,”,0,0,“,0,”);
call SP_JOB_CONFIG_START(‘JOB_DEL_BAK_TIMELY’);
call SP_ADD_JOB_STEP(‘JOB_DEL_BAK_TIMELY’, ‘定时删除备份’, 0, ‘SF_BAKSET_BACKUP_DIR_ADD(“DISK”,“/dmdata/dmbak”);
CALL SP_DB_BAKSET_REMOVE_BATCH(“DISK”,SYSDATE - 30);’, 1, 2, 0, 0, NULL, 0);
call SP_ADD_JOB_SCHEDULE(‘JOB_DEL_BAK_TIMELY’, ‘JOB_DEL_BAK_TIMELY’, 1, 1, 1, 0, 0, ‘00:10:10’, NULL, ‘2020-07-07 12:13:10’, NULL, “);
call SP_JOB_CONFIG_COMMIT(‘JOB_DEL_BAK_TIMELY’);

讯享网

2025年sqlldr 多字节字符错误（oracle 多字节字符错误）

相关推荐