Database Backup and Recovery (MOSC)

MOSC Banner

Point in time restore from RMAN backups taken from physical standby database

edited Jan 24, 2019 12:25PM in Database Backup and Recovery (MOSC) 6 commentsAnswered

Oracle 11.2.0.4

I'm taking full and incremental backups of the standby databases.  While testing a point in time recovery to a time in the past I'm having trouble opening the database.  (I'm testing a recovery scenario where I'm restoring to a point in time in the past to recover from a logical corruption).

On the standby databases I'm taking full (inc 0) backups on Friday and incremental backups (inc 1) on Sun - Thu.  

These are my backup steps.

    crosscheck backup;

    crosscheck archivelog all;

    backup archivelog all not backed up 1 times tag='20190119_arch';

    delete force noprompt obsolete;

    delete force noprompt archivelog all completed before 'sysdate-${ARCHIVE_RETENTION}';

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