Oracle Backup, Restore, and Recovery
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to 12.1.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
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
DBA_HIST_INSTANCE_RECOVERY GV_$RECOVERY_LOG V$RECOVER_FILE
DBA_RECOVERABLE_SCRIPT GV_$RECOVERY_PROGRESS V$RECOVERY_FILE_DEST
DBA_RECOVERABLE_SCRIPT_BLOCKS GV$RECOVERY_STATUS V$RECOVERY_FILE_STATUS
DBA_RECOVERABLE_SCRIPT_ERRORS V$BACKUP_ASYNC_IO V$RECOVERY_LOG
DBA_RECOVERABLE_SCRIPT_PARAMS V$BACKUP_SYNC_IO V$RECOVERY_PROGRESS
GV_$INSTANCE_RECOVERY V$FLASH_RECOVERY_AREA_USAGE V$RECOVERY_STATUS
GV_$RECOVER_FILE V$INSTANCE_RECOVERY V$RMAN_BACKUP_JOB_DETAILS
GV_$RECOVERY_FILE_STATUS    
Command-line recovery and restore 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

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-2014 Daniel A. Morgan All Rights Reserved