RE: RMAN rant
- From: "Aragon, Gabriel (GE, Corporate, consultant)" <gabriel.aragon@xxxxxx>
- To: <sfaroult@xxxxxxxxxxxx>, <cicciuxdba@xxxxxxxxx>
- Date: Wed, 3 Nov 2010 15:53:28 -0400
I think oracle doc has some not included in this list:
10.2:
http://supportcentral.ge.com/caseforms/sup_myforms.asp?form_doc_id=45555081
<http://supportcentral.ge.com/caseforms/sup_myforms.asp?form_doc_id=45555081>
11.1:
http://download.oracle.com/docs/cd/B28359_01/backup.111/b28273/rcmcomma004.htm#RCMRF909
11.2:
http://download.oracle.com/docs/cd/E11882_01/backup.112/e10643/rcmcomma004.htm#RCMRF909
BTW ist there any rman command that can give info on this, just as
v$reserved_words ?
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Stephane Faroult
Sent: Miércoles, 27 de Octubre de 2010 03:56 p.m.
To: cicciuxdba@xxxxxxxxx
Cc: ORACLE-L
Subject: Re: RMAN rant
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@xxxxxxxxxxxx> 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>
Other related posts:
