Skip to main content
Version: 1.0.16

RMAN Commands

1-1 RMAN Manager Commands

CommandPurpose
backupBack up database files, database file copies, archived logs, or backup sets
validateCheck backup sets and report whether their data is intact. RMAN scans all backup pieces in the specified backup set and examines checksums to verify that the contents can be successfully restored.
show detailAfter a backup is complete, view the backup information
initInitialize the backup catalog
restoreFull database recovery
showDisplay backup history. The detail option shows additional information about backups
deleteDelete backup files
purgeRemove deleted backups from the backup catalog
pgdata=PATHLocation of the database storage area
arclog-path=PATHWAL storage path
srvlog-path=PATHPath to the server log storage area
backup-path=PATHPath to the backup storage area
checkCheck
verboseDisplay detailed information
progressShow progress of processed files
backup-mode=MODEfull, incremental, or archive mode
with-serverlogAlso back up server log files
compress-dataCompress backup data using zlib
smooth-checkpointPerform a smooth checkpoint before backup
full-backup-on-errorSwitch to full backup mode
validate-backupValidate the backup immediately after the backup is complete
validate-buffer-sizeValidate buffer size, default is 1 (KB)
validate-modeValidation mode, size|crc. size only validates backup size so it is faster; crc checks data integrity and is slower. Default is size
keep-data-generations=NUMKeep NUM generations of full data backups
keep-data-days=NUMKeep enough data backups to restore to N days ago
keep-arclog-files=NUMKeep NUM WAL archives
keep-arclog-days=DAYKeep archived WAL modified within DAY days
keep-srvlog-files=NUMKeep NUM server logs
keep-srvlog-days=DAYKeep server logs modified within DAY days
standby-host=HOSTNAMEWhen backing up from a standby host, select the standby host
standby-port=PORTStandby port when backing up from a standby
recovery-target-timeTimestamp for recovery
recovery-target-xidTransaction ID for recovery
recovery-target-inclusiveWhether to stop after the recovery target
recovery-target-timelineRecover to a specific timeline
recovery-target-actionAction the server should take after the recovery target
hard-copyCopy archivelog instead of creating symbolic links
-a, --show-allShow deleted backups
-f, --forceForce deletion of backups older than the given date
-d, --dbname=DBNAMEDatabase name to connect to
-h, --host=HOSTNAMEDatabase server host or socket directory
-p, --port=PORTDatabase server port
-U, --username=USERNAMEUsername for connection
-w, --no-passwordNever prompt for password
-W, --passwordForce password prompt
-q, --quietDo not display any INFO or DEBUG messages
--debugDisplay debug messages
--helpShow this help, then exit
--versionOutput version information, then exit