Database Backup and Recovery (MOSC)

MOSC Banner

RMAN backup retention period, and how to do a test backup and restore

edited Oct 1, 2015 9:20AM in Database Backup and Recovery (MOSC) 5 commentsAnswered ✓

Oracle Installed:

On RAC

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

PL/SQL Release 11.2.0.3.0 - Production

"CORE 11.2.0.3.0 Production"

TNS for Linux: Version 11.2.0.3.0 - Production

NLSRTL Version 11.2.0.3.0 - Production

Linux: Red Hat 64 bit

Question:

    1-  RMAN backups are running on my oracle system every day.  How do I find out the retention period of those backup files?

     2-  I need to do a test of backup and restore. For example,

                                                       a:  Create a File

                                                       b:  Add it to the RMAN backup

                                                       c: Save it

                                                       d: Delete it

                                                       f: Restore it from RMAN

      How do I do this?

Thanks for your help.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center