Oracle Backup, Restore, and Recovery
Version 12.1.0.2

General Information
Library Note Morgan's Library Page Header
"We don't live in a dictatorship or a monarchy. I swore an oath in the military and in the Senate to preserve, protect and defend the Constitution of the United States, not to mindlessly cater to the whims of Cadet Bone Spurs and clap when he demands I clap,"
~ Sen. Tammy Duckworth
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