RMAN – Recovery Manager

Oracle Recovery Manager

RMAN command line options.

@[pathname]filename[.ext]
@@filename[.ext]
ALLOCATE CHANNEL
ALLOCATE CHANNEL FOR MAINTENANCE
ALTER DATABASE
BACKUP
BLOCKRECOVER
CATALOG
CHANGE
CONFIGURE
CONNECT
COPY
CREATE CATALOG
CREATE SCRIPT
CROSSCHECK
DELETE
DELETE SCRIPT
DROP CATALOG
DUPLICATE
EXECUTE SCRIPT
EXIT
HOST
LIST
PRINT SCRIPT
QUIT
RECOVER
REGISTER
RELEASE CHANNEL
REPLACE SCRIPT
REPORT
RESET DATABASE
RESTORE
RESYNC CATALOG
RUN
SEND
SET
SHOW
SHUTDOWN
SPOOL
SQL
STARTUP
SWITCH
UPGRADE CATALOG
VALIDATE

ALLOCATE [AUXILIARY] CHANNEL [']
channel_id ['] DEVICE TYPE [=]
devicespecifier [allocOperandList]
Manually establish a channel. Can only be executed within the braces of a RUN command.
ALLOCATE CHANNEL FOR MAINTENANCE TYPE ['] devicespecifier
[allocOperandList]
Used to manually allocate a channel in preparation for issuing a
CHANGE, DELETE,or
CROSSCHECK command. Can only be executed from RMAN prompt.
ALTER DATABASE { MOUNT | OPEN [RESETLOGS] }
Mount or open a database.
COPY
Create an image copy of a datafile, control file, or archived redo log.
DUPLICATE
Use backups of the target database to create a duplicate or auxiliary database
which can be used for testing purposes or creating a standby database.
Must exist in order to perform tablespace point-in-time recovery.
EXIT
Quit the RMAN executable.
HOST ['command']
Invoke an operating system command-line subshell from within RMAN or run a specific
operating system command.
QUIT
Exit the RMAN executable.
REGISTER DATABASE
Register the target database in the
recovery catalog.
RELEASE CHANNEL ['] channel_id
[']
Release a channel that was allocated with an ALLOCATE CHANNEL command.
REPORT
Perform detailed analyses of the content of the
recovery catalog.
RESET DATABASE [TO INCARNATION primary_key]
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.
SEND
Send a vendor-specific quoted string to one or more specific channels
SPOOL LOG { OFF | TO filename } [APPEND] [;]
Write RMAN output to a log file.
SQL 'command'
Execute a SQL statement from within Recovery Manager.

Related Parameters:
control_file_record_keep_time Specifies the minimum number of days before a reusable record in the
control file can be reused.

Related Commands:
ALTER DATABASE
ARCHIVE LOG
RECOVER
SHUTDOWN
STARTUP

Related Views:
V$BACKUP This view displays the backup status of all online datafiles.
V$BACKUP_ASYNC_IO Displays performance information about ongoing and recently completed RMAN backups and restores.
V$BACKUP_CORRUPTION Displays information about corrupt block ranges in datafile backups from the control file.
V$BACKUP_DATAFILE Displays backup datafile and backup control file information from the control file.
V$BACKUP_DEVICE Displays information about supported backup devices.
V$BACKUP_PIECE Displays information about backup pieces from the control file.
V$BACKUP_REDOLOG Displays information about archived logs in backup sets from the control file.
V$BACKUP_SET Displays backup set information from the control file.
V$BACKUP_SPFILE Displays information about server parameter files in backup sets.
V$BACKUP_SYNC_IO This view displays performance information about ongoing and recently completed
RMAN backups and restores.
RC_DATABASE_INCARNATION
V$DATABASE_INCARNATION
V$DATABASE_BLOCK_CORRUPTION
V$DATAFILE_COPY
V$RMAN_CONFIGURATION

Related Packages:
DBMS_RCVMAN Used for querying the recovery catalog or the control file.
DBMS_RCVCAT responsible for maintaining information in the recovery catalog.
DBMS_BACKUP_RESTORE Is used to interface with the O/S for creating, restoring and recovering
backups of datafiles and archive redo log files.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: