This discussion is archived
6 Replies Latest reply: Nov 22, 2013 2:06 AM by MahirM.Quluzade RSS

DG physical standby 1

petra-K Expert
Currently Being Moderated

Hi

 

11.2.0.1

 

We have a DEV database which is also as critical as PROD db since there are lots of critical projects running on it.

This DEV database was configured with dataguard physical standby at the DR server.

 

Well this is what I read in the documents only, as I am newly taking over as dba. The setup was done outsourced

by 3rd party, and I can not talk to the implentors as they have been long gone.

 

When I check the DR server only the PROD is running and the DEV was shutdown for the last 12 months.

My question is if the physical standby is shutdown for almost a year, can it still be activated? or will it still be valid?

Will it affect performance of the Primary database? since it might still checking heartbeat to it? or holding up some processes like archivers?

How do you disable physical standby from the primary db?

 

Thanks

petra k.

  • 1. Re: DG physical standby 1
    mseberg Guru
    Currently Being Moderated

    Hello;

     

    "if the physical standby is shutdown for almost a year, can it still be activated? or will it still be valid?"

     

    No and no. Even a tiny production database would have generated and remove too much archive in a years time for the old standby to have ANY value. Rebuild it.

     

    How do you disable physical standby from the primary db?

     

    You could just do this: ( On the primary side )

     

    alter system set log_archive_dest_state_2=defer;

     

    And you could clean up all the parameters for DG too.

     

    How to remove a Data Guard Configuration from Primary Database (Doc ID 733794.1)

     

    Best Regards

     

    mseberg

  • 2. Re: DG physical standby 1
    petra-K Expert
    Currently Being Moderated

    Excellent answer!

     

    Thanks mseberg

  • 3. Re: DG physical standby 1
    petra-K Expert
    Currently Being Moderated

    Hi,

     

    If I backup my db using RMAN.

     

    BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;

     

    can I be able to restore it using the generic RESTORE DATABASE command? Or do I need to UNCOMPRESS it , or specify RESTORE COMPRESSED BACKUP?

  • 4. Re: DG physical standby 1
    mseberg Guru
    Currently Being Moderated

    Hello again;

     

    RMAN will handle so just RESTORE DATABASE, no special compress command needed.

     

    Hopefully you really need to to perform a restore or you are doing a test.

     

    Best Regards

     

    mseberg

  • 5. Re: DG physical standby 1
    petra-K Expert
    Currently Being Moderated

    Thanks,

     

    One last, Do I need to RMAN backup the  Standby db? Even if I have daily RMAN backup of the Primary DB, which is sent also to the standby server?

  • 6. Re: DG physical standby 1
    MahirM.Quluzade Guru
    Currently Being Moderated

    Hi,

     

    You can use RMAN backups, which is backed up from standby database.

    If you have problem with size, then you can  tale backups from standby database (as my case).

     

    In your case, I  think, every thing normal.

     

    Regards

    Mahir M. Quluzade

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points