Announcements

Oracle training based on real-time expertise as per industry standards. Upcoming batch details are here.

View batch schedule

Free Oracle mock interview. Register using the link.

Register

#DBAchallenge: submit your questions.

Ask questions
Swipe for more →
Browse by Topic
Latest Posts

    Friday, August 29, 2025

    Easy/Different steps build lower environment or build your DR setup

    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

    🌟 Proud to be an Oracle ACE Pro! 🚀

    🌟 Proud to be an Oracle ACE Pro! 🚀 I’m excited to share my official Oracle ACE Profile with the Oracle community. 👨‍💻 Mallikarjun ...