Database Backup and Recovery (MOSC)

MOSC Banner

Issued "alter database open resetlogs" prior to restore of testdb causing update to DR dbfiles

Oracle Database Enterprise Edition - version 12c

configuration:

PD server: pdserver

DR server: drserver

ASM is used


PD database: PDDB

DR database: DRDB

test database: TESTDB1

Backups are taken from DR database

Scenario: Restore from DR backup to test db.


Issue: inadvertently issued "alter database open resetlogs" prior to restore and oracle updated the datafile headers on the DR database causing redo-apply to fail and shutdown


general steps:

1. start nomount pfile='./inittestdb1.ora'

  - includes the following in init.ora file:

    *.db_name='PDDB'
    *.db_unique_name='testdb1'
    *.db_file_name_convert=('DRDB','testdb1','drdb','testdb1')
    *.log_file_name_convert=('DRDB','testdb1','DRDB','testdb1')

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