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')