Tuesday Dec 04, 2012

'rman' cheat-sheet and rlwrap completion

I started using 'rlwrap' some monthes ago like one of my colleague does.

bash-like features in sqlplus, rman and other Oracle command line tools (Oracle Luxembourg Core Tech' Blog by Gilles Haro)

One can find specific Oracle extension for databases 9i, 10g and 11g (keyword textfile) over here.
This will avoid you the need to create this .oracle_keywords file.

There is 'rman' keyword file in the link above.
I experimented a little and found some missing keywords which are:

MAXCORRUPTION PRIMARY NOCFAU VIRTUAL COMPRESSION FOREIGN

With these words added, 'rman' works like this:

$ rlwrap -f ~/rman $ORACLE_HOME/bin/rman
Recovery Manager: Release 11.2.0.3.0 - Production on Mon Dec 3 02:56:04 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
RMAN>  <-- Hit TAB
Display all 211 possibilities? (y or n)

As you can guess, this completion is not context aware.

I found these missing words by creating a kind of 'cheat sheet' for rman with the script like below.
This sheet contains list of verbs and 1st operands.
I uploaded to here so one can create a coffee cup with a lot of esoteric words printed on :)

validWords() {
  sed -n 's/^RMAN-01009: syntax error: found "identifier": expecting one of: //p' \
  | sed -r 's/double-quoted-string, single-quoted-string/Some String/;s/, /" "/g;s/""//'
}
echo "Bogus" | rman | validWords > /tmp/rman.$$
for i in $(cat /tmp/rman.$$)
do
  i=$(echo $i | tr -d '"')
  echo "#### $i ####"
  echo "$i Bogus" | rman | validWords
done

One can find more keywords in the document here.

About

The views expressed on this blog are my own and do not necessarily reflect the views of Oracle.

Search

Archives
« December 2012 »
SunMonTueWedThuFriSat
      
1
2
5
6
7
8
9
10
11
12
13
14
15
16
18
19
22
23
24
28
29
30
31
     
Today