Oracle Backup, Restore, and Recovery
Version 18.3.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
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;

Related Topics
Block Change Tracking
DBMS_BACKUP_RESTORE
DBMS_RCVCAT
DBMS_RCVMAN
Dynamic Performance Views
RMAN
RMAN Demos
What's New In 12cR2
What's New In 18cR3

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved