达梦数据库linux启动脚本,达梦数据库怎么写shell脚本，怎么通过shell脚本调用sql脚本...

满意答案

xuli1969

推荐于 2018.05.10

采纳率：46%    等级：9

已帮助：113人

通过shell脚本调用sql脚本：

1、shell脚本调用sql脚本

#首先编辑sql文件

oracle@SZDB:~> more dept.sql

connect scott/tiger

spool /tmp/dept.lst

set linesize 100 pagesize 80

select * from dept;

spool off;

exit;

#编辑shell脚本文件，在shell脚本内调用sql脚本

oracle@SZDB:~> more get_dept.sh

#!/bin/bash

# set environment variable

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

export ORACLE_SID=CNMMBO

sqlplus -S /nolog @/users/oracle/dept.sql #注意此处执行sql脚本的方法 -S 表示以静默方式执行

exit

#授予脚本执行权限

oracle@SZDB:~> chmod 775 get_dept.sh

-->执行shell脚本

oracle@SZDB:~> ./get_dept.sh

DEPTNO DNAME LOC

---------- -------------- -------------

10 ACCOUNTING NEW YORK

20 RESEARCH DALLAS

30 SALES CHICAGO

40 OPERATIONS BOSTON

2、shell脚本调用rman脚本

#首先编辑RMAN脚本

oracle@SZDB:~> more rman.rcv

RUN {

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

CONFIGURE BACKUP OPTIMIZATION ON;

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/users/oracle/bak/%d_%F';

ALLOCATE CHANNEL CH1 TYPE DISK MAXPIECESIZE=4G;

ALLOCATE CHANNEL CH2 TYPE DISK MAXPIECESIZE=4G;

SET LIMIT CHANNEL CH1 READRATE=10240;

SET LIMIT CHANNEL CH1 KBYTES=4096000;

SET LIMIT CHANNEL CH2 READRATE=10240;

SET LIMIT CHANNEL CH2 KBYTES=4096000;

CROSSCHECK ARCHIVELOG ALL;

DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;

BACKUP

DATABASE FORMAT '/users/oracle/bak/%d_FULL__%U';

SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';

BACKUP ARCHIVELOG ALL FORMAT '/users/oracle/bak/%d_LF_%U' DELETE INPUT;

DELETE NOPROMPT OBSOLETE;

RELEASE CHANNEL CH1;

RELEASE CHANNEL CH2;

}

#编辑shell脚本文件，在shell脚本内调用rman脚本

oracle@SZDB:~> more rman_bak.sh

#!/bin/bash

# set environment variable

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

export ORACLE_SID=CNMMBO

$ORACLE_HOME/bin/rman target / cmdfile=/users/oracle/rman.rcv log=/users/oracle/bak/rman.log

exit

#授予脚本执行权限

oracle@SZDB:~> chmod 775 rman_bak.sh

#执行shell脚本

00分享举报