Oracle 19c - RMAN Recovery Scenarios Overview - Oracle Database Backup and Recovery - Session 4!
RMAN recovery scenarios:
In this video, we are going to see various RMAN recovery scenarios as below. Complete database restore and recovery Loss of System Datafile Non-System datafile Restore Restoring a tablespace Restoring a datafile if no backups Restoring a datafile to different location Restoring controlfile Restoring spfile Restoring online redologs Restoring temporary datafiles Incomplete Recovery Scenarios (Time based , Change based and SCN based) Recovering archived logs Lab Setup for RMAN Recovery Scenarios: Let me explain you the environment used for this practice. I am using a multi-tenant architecture (CDB+PDB) database with srlab in this Container have one pluggable database for testing all the different scenarios mentioned above. I am using a recovery catalog database for my rman configuration and its details are rmancat and schema used for rman catalog data is rcat and the tns alias to connect to catalog database is rmancat. I have both my databases srlab and rmancat in archive log mode and i also have backup for my database srlab. For all my restore and recover operations I am using the following syntax to connect to target database and catalog database.
Post a Comment: