Oracle Backup, Restore, and Recovery
Version 12.1.0.2

General Information
Library Note Morgan's Library Page Header
Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't make it this year, check out TidalScale at www.tidalscale.com. Be sure to click on the Solutions link and look through the Oracle resources.
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