RMAN

Recovery Manager commands.

  BACKUP     Back up database files, archive logs, backups, or copies.
  CHANGE     Update the status of a backup in the RMAN repository.
  CONFIGURE  Persistent RMAN settings.
  CROSSCHECK Check whether backup items still exist.
  DELETE     Delete backups from disk or tape
  EXIT       Exit the RMAN console
  LIST       List backups and copies
  RECOVER    Apply redo logs or incremental backups to a restored backup set
              (or copy) in order to update it to a specified time. 
  REPORT     Report backup status: database, files, backups
  RESTORE    Restore files from an RMAN backup (or copy)
  RUN        Some RMAN commands are only valid inside a RUN block.
  SET        Settings for the current RMAN session.
  SHOW       Display the current configuration
  SHUTDOWN   Shutdown the database
  SQL        Execute a PL/SQL procedure or SQL statement(not SELECT)
  STARTUP    Startup the database

Syntax:
   Start RMAN without connecting to a database
         % rman
		 
   Start RMAN with a command file to run
         % rman @/my_dir/my_commands.txt  

   Connect to a target database without using a recovery catalog:
         % rman TARGET SYS/pwd@target_str 

   Connect to a target database and export to a log file
         % rman TARGET SYS/pwd@target_str LOG $ORACLE_HOME/dbs/log/my_log.log APPEND

   Connect to a target database and a recovery catalog:
         % rman TARGET SYS/pwd@target_str CATALOG cat_usr/pwd@cat_str

Run a command file from the RMAN prompt
RMAN> @/my_dir/my_command_file.txt

In interactive mode, RMAN displays an "RMAN>" prompt
The commands above may be entered directly at the RMAN> prompt or used within a command file. To quit, type EXIT
RMAN records it's backup activity in the database control file.

Syntax on this page is based on Oracle 10g Release 1 (10.1)

Optional Components of RMAN:

The recovery catalog database, a separate database used to record RMAN activity against one or more target databases. RMAN's LIST, REPORT, and SHOW commands display information from this repository. It is also possible for one database to store both the RMAN repository and other data. Typically this would be a Test or Train instance (with the repository data in a separate RMAN schema.)

The flash recovery area, a disk location in which the database can store and manage files related to backup and recovery.

Media management software, for interface with tape drives/libraries.

Initialization Parameters

Set the flash recovery area size and location, using DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE.

CONTROL_FILE_RECORD_KEEP_TIME controls how long backup records are kept in the control file before those records are re-used to hold information about more recent backups.

"We don't want to go back to tomorrow, we want to go forward" - Dan Quale

Related Views:

    RC_DATABASE               V$DATABASE
    RC_DATABASE_INCARNATION   V$DATABASE_INCARNATION