Oracle RMAN 11g Backup and Recovery (174 page)

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