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
