Snippet Name: RMAN: Command Summary
Description: Summary of RMAN commands that you can execute at the RMAN prompt, within a RUN command, or both.
Also see: » RMAN: List the most recent Level 0 bac...
» RMAN: Format Directives
» RMAN: Data Dictionary Objects
» RMAN (Oracle Recovery Manager)
Comment: (none)
Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 10th, 2009
|
@
Run a command file.
@@
Run a command file IN the same directory AS another command
file that IS currently running. The @@ command differs FROM
the @ command only WHEN run FROM within a command file.
ALLOCATE CHANNEL
Establish a channel, which IS a connection BETWEEN RMAN AND a
database instance.
ALLOCATE CHANNEL FOR MAINTENANCE
Allocate a channel IN preparation FOR issuing maintenance commands
such AS DELETE.
allocOperandList
A subclause that specifies channel control options such AS PARMS
AND FORMAT.
ALTER DATABASE
Mount OR OPEN a database.
archivelogRecordSpecifier
Specify a RANGE OF archived redo logs files.
BACKUP
Back up database files, copies OF database files, archived logs,
OR backup sets.
BLOCKRECOVER
Recover an individual data block OR SET OF data blocks within
one OR more datafiles.
CATALOG
Add information about a datafile copy, archived redo LOG, OR control
file copy TO the repository.
CHANGE
Mark a backup piece, image copy, OR archived redo LOG AS HAVING the
status UNAVAILABLE OR AVAILABLE; remove the repository RECORD FOR a
backup OR copy; override the retention policy FOR a backup OR copy.
completedTimeSpec
Specify a TIME RANGE during which the backup OR copy completed.
CONFIGURE
Configure persistent RMAN settings. These settings apply TO ALL RMAN
sessions until explicitly changed OR disabled.
CONNECT
Establish a connection BETWEEN RMAN AND a target, auxiliary, OR
recovery catalog database.
connectStringSpec
Specify the username, password, AND net service name FOR connecting TO
a target, recovery catalog, OR auxiliary database. The connection IS
necessary TO authenticate the USER AND identify the database.
CONVERT
Converts datafile formats FOR transporting tablespaces across platforms.
CREATE CATALOG
CREATE the schema FOR the recovery catalog.
CREATE SCRIPT
CREATE a stored script AND store it IN the recovery catalog.
CROSSCHECK
Determine whether files managed BY RMAN, such AS archived logs, datafile
copies, AND backup pieces, still exist ON disk OR tape.
datafileSpec
Specify a datafile BY filename OR absolute file NUMBER.
DELETE
DELETE backups AND copies, remove REFERENCES TO them FROM the recovery
catalog, AND UPDATE their control file records TO status DELETED.
DELETE SCRIPT
DELETE a stored script FROM the recovery catalog.
deviceSpecifier
Specify the TYPE OF storage device FOR a backup OR copy.
DROP CATALOG
Remove the schema FROM the recovery catalog.
DROP DATABASE
Deletes the target database FROM disk AND unregisters it.
DUPLICATE
USE backups OF the target database TO CREATE a duplicate database
that you can USE FOR testing purposes OR TO CREATE a standby database.
EXECUTE SCRIPT
Run an RMAN stored script.
EXIT
Quit the RMAN executable.
fileNameConversionSpec
Specify patterns TO transform source TO target filenames during
BACKUP AS COPY, CONVERT AND DUPLICATE.
FLASHBACK
Returns the database TO its state AT a previous TIME OR SCN.
formatSpec
Specify a filename format FOR a backup OR copy.
HOST
Invoke an operating system command-line subshell FROM within
RMAN OR run a specific
operating system command.
keepOption
Specify that a backup OR copy should OR should NOT be exempt FROM
the CURRENT retention policy.
LIST
Produce a detailed listing OF backup sets OR copies.
listObjList
A subclause used TO specify which items will be displayed BY the
LIST command.
maintQualifier
A subclause used TO specify additional options FOR maintenance
commands such AS DELETE AND CHANGE.
maintSpec
A subclause used TO specify the files operated ON BY maintenance
commands such AS CHANGE, CROSSCHECK, AND DELETE.
obsOperandList
A subclause used TO determine which backups AND copies are obsolete.
PRINT SCRIPT
Display a stored script.
QUIT
EXIT the RMAN executable.
recordSpec
A subclause used TO specify which objects the maintenance commands
should operate ON.
RECOVER
Apply redo logs AND incremental backups TO datafiles restored FROM
backup OR datafile copies, IN ORDER TO UPDATE them TO a specified TIME.
REGISTER
Register the target database IN the recovery catalog.
RELEASE CHANNEL
RELEASE a channel that was allocated WITH an ALLOCATE CHANNEL command.
releaseForMaint
RELEASE a channel allocated WITH an ALLOCATE CHANNEL FOR MAINTENANCE
command.
REPLACE SCRIPT
REPLACE an existing script stored IN the recovery catalog. IF the
script does NOT exist, THEN REPLACE SCRIPT creates it.
REPORT
Perform detailed analyses OF the content OF the recovery catalog.
RESET DATABASE
Inform RMAN that the SQL statement ALTER DATABASE OPEN RESETLOGS
has been executed AND that a NEW incarnation OF the target database
has been created, OR reset the target database TO a PRIOR incarnation.
RESTORE
Restore files FROM backup sets OR FROM disk copies TO the DEFAULT
OR a NEW location.
RESYNC
Perform a full resynchronization, which creates a snapshot control
file AND THEN copies ANY NEW OR changed information FROM that snapshot
control file TO the recovery catalog.
RUN
EXECUTE a sequence OF one OR more RMAN commands, which are one OR more
statements executed within the braces OF RUN.
SEND
Send a vendor-specific quoted string TO one OR more specific channels.
SET
Sets the VALUE OF various attributes that affect RMAN behavior FOR
the duration OF a RUN block OR a session.
SHOW
Displays the CURRENT CONFIGURE settings.
SHUTDOWN
Shut down the target database. This command IS equivalent TO the
SQL*Plus SHUTDOWN command.
SPOOL
WRITE RMAN output TO a LOG file.
SQL
EXECUTE a SQL statement FROM within Recovery Manager.
STARTUP
START up the target database. This command IS equivalent TO the
SQL*Plus STARTUP command.
SWITCH
Specify that a datafile copy IS now the CURRENT datafile, that IS,
the datafile pointed TO BY the control file. This command IS equivalent
TO the SQL statement ALTER DATABASE RENAME FILE AS it applies TO datafiles.
UNREGISTER DATABASE
Unregisters a database FROM the recovery catalog.
untilClause
A subclause specifying an UPPER limit BY TIME, SCN, OR LOG sequence
NUMBER. This clause IS usually used TO specify the desired point IN
TIME FOR an incomplete recovery.
UPGRADE CATALOG
Upgrade the recovery catalog schema FROM an older version TO the version
required BY the RMAN executable.
VALIDATE
Examine a backup SET AND report whether its data IS intact. RMAN scans
ALL OF the backup pieces IN the specified backup sets AND looks AT the
checksums TO verify that the contents can be successfully restored.
|