Read Oracle RMAN 11g Backup and Recovery Online
Authors: Robert Freeman
cmdfile
command
comment
compatible
completed
compressed
compression
configure
connect
consistent
controlfilecopy
controlfile
Convert
copies
copy
corruption
create
critical
crosscheck
cumulative
current
database
datafile
datafilecopy
datapump
Days
dba
dbid
Db_file_name_convert
db_name
Db_recovery_file_dest
Db_unique_name
debug
decryption
default
Define
delete
deletion
destination
Detail
device
directory
diskratio
disk
Display
dorecover
drop
dump
Duplex
duplicate
duration
Appendix A: RMAN Syntax Reference Guide
561
echo
encryption
exclude
execute
exit
expired
export
failover
failure
filesperset
Files
final
flashback
force
foreign
forever
format
for
from
full
get
global
grant
group
guarantee
g
header
high
host
Identified
identifier
id
immediate
import
inaccessible
incarnation
include
Including
incremental
input
instance
io
Job
kbytes
keep
krb
k
Level
libparm
library
like
limit
list
load
logfile
logical
logseq
logs
log
logscn
Low
logseq
maintenance
mask
maxcorrupt
maxdays
maxopenfiles
maxpiecesize
maxseq
maxsetsize
maxsize
method
minimize
misc
mount
msglog
Msgno
M
names
name
need
New-line
Newname
new
nocatalog
nofau
nochecksum
nodevals
noduplicates
noexclude
nofilenamecheck
nofileupdate
nokeep
nologs
nomount
none
noparallel
noprompt
noredo
normal
not
no
null
obsolete
offline
off
of
only
on
open
optimization
option
orphan
or
packages
parallelism
parallelmediarestore
parallel
parameter
Parameter_value_conversion
parms
partial
password
pfile
pipe
platform
plsql
plus
point
policy
pool
preview
primary
print
priority
privileges
proxy
put
562
Part V: Appendixes
Quit
rate
rcvcat
rcvman
readonly
readrate
recall
recoverable
recovery
recover
redundancy
register
release
reload
remove
renormalize
repairid
repair
replace
replicate
report
resetlogs
reset
restart
restore
restricted
resync
retention
reuse
revoke
rpctest
rpc
run
save
schema
scn
script
section
send
sequence
setlimit
setsize
set
shipped
show
shutdown
since
size
skip
slaxdebug
snapshot
spfile
spool
sql
standby
startup
start
step
summary
switch
tablespaces
tablespace
tag
target
tdes168
tempfile
test
thread
timeout
times
time
to
trace
transactional
transport
type
uncatalog
undo
unlimited
unrecoverable
unregister
until
upgrade
up
using
validate
verbose
virtual
window
with
RMAN Command List
The following table documents each RMAN command. Details on each command are provided in the upcoming section “RMAN Command List Syntax Details.”
@
@@
ADVISE FAILURE
ALLOCATE
CHANNEL
ALLOCATE CHANNEL FOR
BACKUP
CATALOG
CHANGE
MAINTENANCE
CONFIGURE
CONNECT
CONVERT
CREATE CATALOG
CREATE SCRIPT
CROSSCHECK
DELETE
DELETE SCRIPT
DROP CATALOG
DROP DATABASE
DUPLICATE
EXECUTE SCRIPT
EXIT
FLASHBACK DATABASE
GRANT
HOST
IMPORT CATALOG
LIST
PRINT SCRIPT
QUIT
Appendix A: RMAN Syntax Reference Guide
563
RECOVER
REGISTER DATABASE
RELEASE CHANNEL
REPAIR FAILURE
REPLACE SCRIPT
REPORT
RESET DATABASE
RESTORE
RESYNC_CATALOG
REVOKE
RMAN
RUN
SEND
SET
SHOW
SHUTDOWN
SPOOL
SQL
STARTUP
SWITCH
TRANSPORT TABLESPACE
UNREGISTER
UPGRADE CATALOG
VALIDATE
RMAN Specifier and Operands Lists
The following table provides the names of the various RMAN specifiers and operands.
allocOperandList
archivelogRecordSpecifier
completedTimeSpec
connectStringSpec
datafileSpec
deviceSpecifier
fileNameConversionSpec
forDbUniqueNameOption
foreignLogRecordSpecifier
formatSpec
keepOption
listObjList
maintQualifier
maintSpec
obsOperandList
recordSpec
tempfileSpec
untilClause
RMAN Command List Syntax Details
This section provides detailed information on each of the RMAN commands. For each command you will find
■ A summary description of the command
■ The syntax diagram for the command
■ The relevant chapter in the book in which you can find more details on the command
■ Examples of the use of the command
@ Command
The
@
command executes a command file (RMAN script) from within RMAN or from within another RMAN command file.
Syntax Diagram
@
filename
Chapter Reference
Chapter 16 provides more information on this command.
Example
@/usr/oracle/rman/script/rmanbackup.scr
564
Part V: Appendixes
@@ Command
The
@@
command executes a command file (RMAN script) from within RMAN or from within another RMAN command file. When the
@@
command is used, the script called will be executed from the same location as the calling script.
Syntax Diagram
@@
filename
Chapter Reference
Chapter 16 provides more information on this command.
Example
@@rmanbackup2.scr
advise failure Command
The
advise failure
command is used to display different repair options for the specified failures. The
advise failure
command displays a summary of the failures identified by the Data Recovery Advisor.
Syntax Diagram
ALL
CRITICAL
HIGH
LOW
,
,
failureNumber
EXCLUDE FAILURE
failureNumber
ADVISE FAILURE
;
Chapter Reference
Chapter 12 provides more information on this command.
Example
advise failure;
allocate channel Command
The
allocate channel
command establishes a channel, which is a connection between RMAN and a database instance. At least one channel must be allocated for any backup, recovery, or maintenance operation, though channels are often preconfigured.
Appendix A: RMAN Syntax Reference Guide
565