控制文件备份无法运行,但是这个可以在oracle用户下运行。内容如下:
系统环境是hpux。gzyy_2#[/oracle/linzl_workarea/bak]ll
total 4
-rwxrwxrwx   1 root       sys            283 Mar 28 11:46 bakctrlfile.sh
-rwxrwxrwx   1 oracle     dba            111 Mar 27 23:40 bakctrlfile.sql
drwxrwxrwx   2 oracle     dba             96 Mar 28 14:16 bakfile
gzyy_2#[/oracle/linzl_workarea/bak]ls
bakctrlfile.sh   bakctrlfile.sql  bakfile
gzyy_2#[/oracle/linzl_workarea/bak]cat bakctrlfile.sh
#!/usr/bin/ksh
export ORACLE_HOME=/oracle/app/oracle/product/9.2.0
touch /oracle/linzl_workarea/bak/bakfile/controlfile.bak
rm /oracle/linzl_workarea/bak/bakfile/controlfile.bak
/oracle/app/oracle/product/9.2.0/bin/sqlplus -s dbalin/yydnlin851 < <!
@/oracle/linzl_workarea/bak/bakctrlfile.sql
exit
!
gzyy_2#[/oracle/linzl_workarea/bak]cat bakctrlfile.sql
connect / as sysdba
alter database backup controlfile to '/oracle/linzl_workarea/bak/bakfile/control
file.bak';
gzyy_2#[/oracle/linzl_workarea/bak]./*.sh
ERROR:
ORA-07217: sltln: environment variable cannot be evaluated.ERROR:
ORA-01031: insufficient privileges
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon>  ::= <username>[/<password>][@<connect_string>] | /
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus 
***********************************************************************************************************
环境变量输出:
gzyy_2#[/oracle/linzl_workarea/bak]env
_=/usr/bin/env
MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/u
sr/local/man/%L:/usr/local/man:/opt/upgrade/share/man/%L:/opt/upgrade/share/man:
/opt/pd/share/man/%L:/opt/pd/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/o
pt/pd/share/man/%L:/opt/pd/share/man:/opt/ignite/share/man/%L:/opt/ignite/share/
man:/opt/mx/share/man:/opt/resmon/share/man:/usr/dt/share/man:/opt/samba/man:/op
t/gnome/man:/opt/perf/man/%L:/opt/perf/man:/opt/openssl/man:/opt/openssl/prngd/m
an:/opt/wbem/share/man:/opt/perl/man:/opt/hparray/share/man/%L:/opt/hparray/shar
e/man:/opt/graphics/common/man:/opt/aCC/share/man/%L:/opt/aCC/share/man:/opt/lan
gtools/share/man/%L:/opt/langtools/share/man:/opt/omni/lib/man:/opt/hpsmc/shc/ma
n
PATH=/usr/sbin:/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/opt/hparray/bin:/opt/nett
ladm/bin:/opt/upgrade/bin:/opt/fcms/bin:/opt/pd/bin:/usr/bin/X11:/usr/contrib/bi
n/X11:/opt/resmon/bin:/opt/ignite/bin:/opt/gnome/bin:/opt/perf/bin:/opt/mozilla:
/opt/wbem/bin:/opt/wbem/sbin:/opt/mx/bin:/opt/perl/bin:/usr/sbin/diag/contrib:/o
pt/graphics/common/bin:/opt/aCC/bin:/opt/langtools/bin:/opt/omni/bin:/sbin:/home
/root
COLUMNS=80
EDITOR=vi
HISTFILE=/.sh_history
LOGNAME=root
ERASE=^H
PS1=gzyy_2#[$PWD]
SHELL=/sbin/sh
HISTSIZE=100
HOME=/
TERM=ansi
PWD=/oracle/linzl_workarea/bak
TZ=EAT-8
LINES=26
gzyy_2#[/oracle/linzl_workarea/bak]