PROD database to Lower environment (PROD -> DEV/TEST/UAT)
==========================================================
With PROD backup (RMAN-backups):
Option 1: Restore recover from backup
- restore
- recover
- open database with reset logs
Option 2: RMAN clone / RMAN duplicate from backup
- duplicate target database to TESTDB backup location '/u01/backup' nofilenamecheck;
Without PROD backup (without RMAN-backups):
Option 3: RMAN active database duplicate
$rman target sys/password@PROD
RMAN> connect auxiliary sys/password@TESTDB
RMAN> duplicate target database to TESTDB from active database;
PROD database to DR environment (PROD -> DR)
==========================================================
With PROD backup (RMAN-backup):
Option 1: Restore recover from backup
- restore
- recover
- start MRP
Option 2: RMAN clone / RMAN duplicate from backup
- duplicate target database for standby database backup location '/u01/backup' filenamecheck/nofilenamecheck;
- start MRP
Without PROD backup (without RMAN-backup):
Option 3: RMAN active database duplicate
$rman target sys/password@PROD
RMAN> connect auxiliary sys/password@DR
RMAN> duplicate target database for standby database from active database;
- start MRP
https://mallik034.blogspot.com/2021/05/19c-dataguard-build-document.html
Option 4: Service based standby build (from 12c onwards) (Without PROD backup)
rman target / (on Standby Side)
RMAN> restore standby controlfile from PROD service;
RMAN> restore standby database from PROD service;
RMAN> recover standby database from PROD service;
No comments:
Post a Comment