Re: RMAN rant

From: Stephane Faroult <sfaroult_at_roughsea.com>
Date: Wed, 27 Oct 2010 22:55:40 +0200
Message-ID: <4CC891CC.2060301_at_roughsea.com>

50 words would have looked better to me. I admit that some of them are in the "obvious" or "unavoidable" category, but they are still too many:

abort
advise
after
algorithm
all
allocate
allow
alter
and
append
applied
archivelog
area
as
autobackup
auxiliary
auxname
available
backed
backup
backuppience
backups
backupset
before
between
block
by
catalog
change
channel
check
clear
closed
command
comment
completed
compressed
compression
configure
connect
controlfile
controlfilecopy
convert
copies
copy
corruption
create
critical
crosscheck
cumulative
current
database
datafile
datafilecopy
datapump
days
dba
dbid

db_name
db_recovery_file_dest
db_unique_name

decryption
delete
deletion
destination
detail
device
directory
disk
diskratio
dorecover
drop
dump
duplicate
duration
echo
encryption
exclude
exit
failure
false
file
filesperset
flashback
for
force
foreign
forever
format
from
full
G
global
grant
group
header
high
host
ID
identified
identifier
immediate
import
inaccessible
incarnation
include
including
incremental
input
instance
K
keep
level
like
list
load
location
log
logfile
logical
low
M
maintenance
maxcorrupt
maxdays
maxopenfiles
maxpiecesize
maxseq
maxsetsize
maxsize
minimize
mount
name
need
new
newname
no
nochecksum
noduplicates
noexclude
nofilenamecheck
nokeep
none
noparallel
noprompt
noredo
noresume
normal
not
obsolete
off
offline
on
only
open
option
parallelism
parameter
parameter_value_convert
parms
partial
password
pfile
platform
plus
point
policy
pool
preview
print
priority
privileges
proxy
quit
rate
readonly
recall
recover
recoverable
recovery
redundancy
register
release
repair
replace
report
reset
resetlogs
resricted
restore
resync
retention
reuse
revoke
run
scn
script
section
send
sequence
set
shipped
show
shutdown
since
size
skip
snapshot
spool
sql
standby
start
startup
summary
switch
tablespace
tag
target
tempfile
test
thread
time
times
to
transactional
transport
true
type
unavailable
uncatalog
undo
unlimited
unnecessary
unregister
until
up
upgrade
using
validate
virtual
window
with

Stephane Faroult
RoughSea Ltd <http://www.roughsea.com>
Konagora <http://www.konagora.com>
RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd>

On 10/27/2010 10:50 PM, Guillermo Alan Bort wrote:
> Both RMAN and PL/SQL, as well as most high level programming languages
> hace way too many keywords, which is aimed to let the high level
> languages be as close as natural language as possible. As you pointed
> out, people usually know very few words, but the dictionary has an
> awful lot of words...
>
> I can't speak to autotools, but I reckon that the number of keywords
> in RMAN is related to its flexibility, which I think is one of its key
> features (it's very hard to create a tool to cover all the possible
> backup and recovery needs).
>
> That being said, If I'd wrote down all the RAMN keywords I know, I
> doubt I'll get to 50... so I guess I'll have to revise both my belief
> that I know RMAN very well and the RMAN documentation as well as set
> up a sandbox to test out all those new keywords... Can you provide
> your list?
>
>
> cheers
> Alan.-
>
>
> On Wed, Oct 27, 2010 at 5:08 PM, Stephane Faroult
> <sfaroult_at_roughsea.com <mailto:sfaroult_at_roughsea.com>> wrote:
>
> I have just tried to compile all the RMAN keywords (by "keyword" I
> mean any terminal term without space that you find in all those
> wonderful syntactical diagrams that brighten up our reading of
> Oracle reference docs).
> Having used RMAN, I had some apprehension, and I wasn't
> disappointed. If anyone is interested, my tally is 242 different
> terms (I have excluded the RMAN command itself and what can be
> passed to it on the command line). Jesus. Posters on most forums
> don't seem to have that much vocabulary. Compared to RMAN, the GNU
> autotools (I was in them shortly before) are a piece of cake.
> Whatever the opinion someone I'm thinking of has of Don Chamberlin
> and of his understanding of the relational model, at least Don and
> Ray Boyce managed to do an awful lot with very few keywords.
>
> I like to quote to developers the "Art Poétique" of Boileau, in
> particular things such as:
> “What is conceived well is expressed clearly.”
> or
> “No one who cannot limit himself has ever been able to write.”
> (uh, perhaps time I stop my rant).
>
> I dream that Oracle products get a stamp of approval from Steve
> Jobs before being released.
>
> --
> Stephane Faroult
> RoughSea Ltd <http://www.roughsea.com>
> Konagora <http://www.konagora.com>
> RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Oct 27 2010 - 15:55:40 CDT