在Linux下使用script命令记录数据库操作

在Linux下使用Oracle时，很多时候我们想记录操作信息，有很多方法可以实现，如：spool之类的。但本文介绍的是Linux下带的script工具。

Linux下有一个script工具可以讲当前终端会话中的所有输入输出结果捕获到一个指定的文件中。下面我们就看看script的介绍和用法。

[oracle@HZCC-SRV-NEW1 newccs]$ which script

/usr/bin/script

[oracle@HZCC-SRV-NEW1 newccs]$ man script

SCRIPT(1)                BSD General Commands Manual                SCRIPT(1)

NAME

     script - make typescript of terminal session

SYNOPSIS

     script [-a] [-c COMMAND] [-f] [-q] [-t] [file]

DESCRIPTION

     Script makes a typescript of everything printed on your terminal.  It is

     useful for students who need a hardcopy record of an interactive session

     as proof of an assignment, as the typescript file can be printed out

     later with lpr(1).

     If the argument file is given, script saves all dialogue in file.  If no

     file name is given, the typescript is saved in the file typescript.

     Options:

     -a      Append the output to file or typescript, retaining the prior

             contents.

     -c COMMAND

             Run the COMMAND rather than an interactive shell.  This makes it

             easy for a script to capture the output of a program that

             behaves differently when its stdout is not a tty.

     -f      Flush output after each write. This is nice for telecooperation:

             One person does 鈥榤kfifo foo; script -f foo鈥?and another can

             supervise real-time what is being done using 鈥榗at foo鈥?

     -q      Be quiet.

     -t      Output timeing data to standard error. This data contains two

             fields, separated by a space. The first field indicates how much

             time elapsed since the previous output. The second field indi-

             cates how many characters were output this time.

     The script ends when the forked shell exits (a control-D to exit the

     Bourne shell (sh(1)), and exit, logout or control-d (if ignoreeof is not

     set) for the C-shell, csh(1)).

     Certain interactive commands, such as vi(1), create garbage in the type-

     script file.  Script works best with commands that do not manipulate the

     screen, the results are meant to emulate a hardcopy terminal.

ENVIRONMENT

     The following environment variable is utilized by script:

     SHELL  If the variable SHELL exists, the shell forked by script will be

            that shell. If SHELL is not set, the Bourne shell is assumed.

            (Most shells set this variable automatically).

SEE ALSO

     csh(1) (for the history mechanism).

HISTORY

     The script command appeared in 3.0BSD.

BUGS

     Script places everything in the log file, including linefeeds and

     backspaces.  This is not what the naive user expects.

Linux                           July 30, 2000                           Linux

 [oracle@HZCC-SRV-NEW1 newccs]$ script

Script started, file is typescript

省略中间操作部分。

[oracle@HZCC-SRV-NEW1 newccs]$ exit

exit

Script done, file is typescript

[oracle@HZCC-SRV-NEW1 newccs]$ cat typescript

Script started on Wed 14 Jul 2010 01:16:20 PM CST

[oracle@HZCC-SRV-NEW1 newccs]$ sqlplus "/ as sysdba"

 

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jul 14 13:16:34 2010

 

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

 

 

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

 

SQL> select dbid from v$database;

 

      DBID

----------

3728795045

 

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@HZCC-SRV-NEW1 newccs]$ exit

exit

 

Script done on Wed 14 Jul 2010 01:17:05 PM CST

通过上述方法我们可以很方面的记录在用户的操作。当然还有功能更强大的scriptreplay工具，可以replay script。不过这里就不做过多的介绍了。