Oracle Backup, Restore, and Recovery
Version 12.1.0.2

General Information
Library Note Morgan's Library Page Header
Are you prepared for the release of Oracle Database 18c ... the first autonomous database? We are here at the Library. It is time for DBAs to stop fighting robots with their fingers and losing ... time to start using our intelligence and winning.
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 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 12cR1
What's New In 12cR2

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