厦门网站到首页排名,网页设计尺寸用怎么量,网站菜单代码,长春seo建站Oracle的备份一般都是在操作系统上完成#xff0c;因此定时备份Oracle的功能一般都是由操作系统功能完成#xff0c;比如crontab。但是Oracle的PIPE接口使得在Oracle数据库中通过JOB来备份Oracle变得可能。 这篇文章给出一个简单的例子#xff0c;说明如何在JOB中定期备份数…Oracle的备份一般都是在操作系统上完成因此定时备份Oracle的功能一般都是由操作系统功能完成比如crontab。但是Oracle的PIPE接口使得在Oracle数据库中通过JOB来备份Oracle变得可能。 这篇文章给出一个简单的例子说明如何在JOB中定期备份数据库。 首先需要保证RMAN已PIPE方式一直在后台运行 [oraclemember member]$ rman pipe PJOB target / nocatalog[oraclemember member]$ Recovery Manager: Release 9.2.0.4.0 - Production Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved. [oraclemember member]$ 下面构建一个日志表和备份使用的过程 SQL CREATE TABLE BACKUP_LOG (END_DATE DATE, OUTPUT_LOG VARCHAR2(4000)); Table created. SQL CREATE OR REPLACE PROCEDURE P_BACKUP_SQL AS2 V_INPUT VARCHAR2(32767);3 V_OUTPUT VARCHAR2(32767);4 V_OUT NUMBER;5 BEGIN6 V_INPUT : RUN 7 {8 ALLOCATE CHANNEL C1 DEVICE TYPE DISK FORMAT /data/backup/member/%U;9 ALLOCATE CHANNEL C2 DEVICE TYPE DISK FORMAT /data/backup/member/%U;10 ALLOCATE CHANNEL C3 DEVICE TYPE DISK FORMAT /data/backup/member/%U;11 BACKUP DATABASE;12 };13 DBMS_PIPE.PACK_MESSAGE(V_INPUT);14 V_OUT : DBMS_PIPE.SEND_MESSAGE(ORA$RMAN_PJOB_IN);15 COMMIT;16 17 V_OUT : 0;18 WHILE (V_OUT 0) LOOP19 V_OUT : DBMS_PIPE.RECEIVE_MESSAGE(ORA$RMAN_PJOB_OUT, 3600);20 IF V_OUT 0 THEN21 DBMS_PIPE.UNPACK_MESSAGE(V_OUTPUT);22 INSERT INTO BACKUP_LOG (END_DATE, OUTPUT_LOG) VALUES (SYSDATE, SUBSTRB(V_OUTPUT, 1, 4000));23 END IF;24 END LOOP;25 COMMIT;26 END;27 / Procedure created. 下面就可以通过job来定时备份了 SQL DECLARE2 V_JOB NUMBER;3 BEGIN4 DBMS_JOB.SUBMIT(V_JOB, P_BACKUP_SQL;, TRUNC(SYSDATE) 17.25/24, TRUNC(SYSDATE) 41/24);5 COMMIT;6 END;7 / PL/SQL procedure successfully completed. 等待备份结束后检查备份结果 SQL SELECT * FROM BACKUP_LOG; END_DATE OUTPUT_LOG------------------- --------------------------------------------------------------------------------2007-06-04 17:40:09 channel C3: finished piece 1 at 04-6月 -072007-06-04 17:40:09 piece handle/data/backup/member/07ijeqcm_1_1 commentNONE2007-06-04 17:15:01 using target database controlfile instead of recovery catalog2007-06-04 17:40:09 channel C3: backup set complete, elapsed time: 00:25:072007-06-04 17:40:12 channel C3: starting full datafile backupset2007-06-04 17:40:12 channel C3: specifying datafile(s) in backupset2007-06-04 17:40:12 including current SPFILE in backupset2007-06-04 17:40:13 including current controlfile in backupset2007-06-04 17:40:13 input datafile fno00001 name/data/oradata/member/system01.dbf2007-06-04 17:40:13 input datafile fno00003 name/data/oradata/member/cwmlite01.dbf2007-06-04 17:40:13 input datafile fno00009 name/data/oradata/member/users01.dbf2007-06-04 17:40:13 input datafile fno00004 name/data/oradata/member/drsys01.dbf2007-06-04 17:40:13 channel C3: starting piece 1 at 04-6 转载于:https://www.cnblogs.com/zndavid/archive/2009/08/24/1552838.html
