Oracle | Backup Restore and Recover

Oracle Backup, Restore, and Recovery Version 19c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Page Note This page is intended to provide non-specific examples for backup, restore, and recovery as well as provide links to related technologies

Data Dictionary Objects

CDB_HIST_INSTANCE_RECOVERY	GV$BACKUP_SYNC_IO	V$BACKUP_SET
CDB_HIST_RECOVERY_PROGRESS	GV$INSTANCE_RECOVERY	V$BACKUP_SET_DETAILS
CDB_RECOVERABLE_SCRIPT	GV$RECOVERY_FILE_STATUS	V$BACKUP_SET_SUMMARY
CDB_RECOVERABLE_SCRIPT_BLOCKS	GV$RECOVERY_LOG	V$BACKUP_SPFILE
CDB_RECOVERABLE_SCRIPT_ERRORS	GV$RECOVERY_PROGRESS	V$BACKUP_SPFILE_DETAILS
CDB_RECOVERABLE_SCRIPT_HIST	GV$RECOVERY_SLAVE	V$BACKUP_SPFILE_SUMMARY
CDB_RECOVERABLE_SCRIPT_PARAMS	GV$RECOVERY_STATUS	V$BACKUP_SYNC_IO
CDB_SSCR_RESTORE	GV$RECOVER_FILE	V$DISK_RESTORE_RANGE
DBA_HIST_INSTANCE_RECOVERY	V$BACKUP	V$FLASH_RECOVERY_AREA_USAGE
DBA_HIST_RECOVERY_PROGRESS	V$BACKUP_ARCHIVELOG_DETAILS	V$INSTANCE_RECOVERY
DBA_RECOVERABLE_SCRIPT	V$BACKUP_ARCHIVELOG_SUMMARY	V$RECOVERY_AREA_USAGE
DBA_RECOVERABLE_SCRIPT_BLOCKS	V$BACKUP_ASYNC_IO	V$RECOVERY_FILE_DEST
DBA_RECOVERABLE_SCRIPT_ERRORS	V$BACKUP_CONTROLFILE_DETAILS	V$RECOVERY_FILE_STATUS
DBA_RECOVERABLE_SCRIPT_HIST	V$BACKUP_CONTROLFILE_SUMMARY	V$RECOVERY_LOG
DBA_RECOVERABLE_SCRIPT_PARAMS	V$BACKUP_COPY_DETAILS	V$RECOVERY_PROGRESS
DBA_SSCR_RESTORE	V$BACKUP_COPY_SUMMARY	V_$RECOVERY_SLAVE
GV$BACKUP	V$BACKUP_CORRUPTION	V$RECOVERY_STATUS
GV$BACKUP_ASYNC_IO	V$BACKUP_DATAFILE	V$RECOVER_FILE
GV$BACKUP_CORRUPTION	V$BACKUP_DATAFILE_DETAILS	V$RESTORE_RANGE
GV$BACKUP_DATAFILE	V$BACKUP_DATAFILE_SUMMARY	V$RMAN_BACKUP_JOB_DETAILS
GV$BACKUP_DEVICE	V$BACKUP_DEVICE	V$RMAN_BACKUP_SUBJOB_DETAILS
GV$BACKUP_NONLOGGED	V$BACKUP_FILES	V$RMAN_BACKUP_TYPE
GV$BACKUP_PIECE	V$BACKUP_NONLOGGED	V$SBT_RESTORE_RANGE
GV$BACKUP_REDOLOG	V$BACKUP_PIECE	V$UNUSABLE_BACKUPFILE_DETAILS
GV$BACKUP_SET	V$BACKUP_PIECE_DETAILS	WRH$_INSTANCE_RECOVERY
GV$BACKUP_SPFILE	V$BACKUP_REDOLOG	WRH$_RECOVERY_PROGRESS

Command-line recovery and restore conn / as sysdba STARTUP MOUNT; RESTORE DATABASE UNTIL SCN 81429340; RECOVER DATABASE UNTIL SCN 81429340; ALTER DATABASE OPEN RESETLOGS;