DBA GENESIS

  • Courses

  • Certification

  • Contact

  • Members

  • More

    Use tab to navigate through the menu items.

    Book a mock interview and get instant feedback - Learn More

    To see this working, head to your live site.
    • Categories
    • All Posts
    • My Posts
    poojan Das
    Jan 20

    Data Guard without Backup

    in Oracle Data Guard

    We have a gap in our Data guard setup because we dont have backup in primary and some archive log files has been removed in primary Database. How to recover those archivelogs? Flashback is disabled.

    5 answers0 replies
    0
    5 Comments

    Share Your ThoughtsSign up to leave a comment.

    Piyush Ranjan
    Jan 20
    •

    REFRESH STANDBY USING INCREMENTAL(SCN BASED) BACKUP


    1. Get SCN of both PRIMARY and STANDBY

    2. Take a note of this SCN

    3. Stop the managed STANDBY apply process

    4. Shutdown the STANDBY database

    5. Take an incremental backup in PRIMARY from the SCN number

    6. Create a new STANDBY controlfile in PRIMARY

    7. Copy the RMAN backup file and new STANDBY controlfile to STANDBY database

    8. Start STANDBY in startup nomount

    9. Find the location of controlfile in STANDBY

    10. Replace the controlfile in STANDBY side with the one you just created in PRIMARY

    11. Mount STANDBY database

    12. Catloging rman files as RMAN does not know about these files yet; so you must let it know – by a process called cataloging.

    13. Cancel MRP

    14. Recover the STANDBY database

    15. Start MRP

    16. Now check the archive status in both the databases

    17. Check the processes running on STANDBY

    18. On PRIMARY switch logfiles to confirm whether new archives are getting applied or not


    Further for more information on Data Gaurd, visit our support website:


    www.support.dbagenesis.com
    Oracle Data Guard Articles
    Keep standby always in-sync with primary. Build, manage, convert standby databases for a production database with data guard broker. Find and resolve gap in data guard and me sure Log shipping and apply services are working fine.

    2
    Б
    Барзу Парпишоев
    Jan 21
    •
    Replying to

    5. Take an incremental backup in PRIMARY from the SCN number


    From the SCN of Primary or Standby?

    Like

    Piyush Ranjan
    Jan 21
    •
    Replying to

    @Барзу Парпишоев Create an incremental backup from the SCN we got in the standby.


    backup incremental from scn <current_Standby SCN> database;
    Like

    Б
    Барзу Парпишоев
    Jan 31
    •
    Replying to

    @Piyush Ranjan Now everything is clear. Thanks!

    Like

    P
    poojan Das
    Jan 25
    •

    Thank you guys !! Issue got cleared.

    1
    5 comments
    Similar Posts
    • What is the difference between Oracle Data Guard and Dbvisit Standby?
    • ORA-12514 error on Data Guard setup.
    • Data Guard

    support@dbagenesis.com

    • Facebook
    • Instagram
    • Twitter
    • YouTube

    © 2023 Biggest Database Forum by DBA Genesis