This discussion is archived
7 Replies Latest reply: Feb 22, 2013 8:44 AM by Meenakshy singh RSS

DataGuard Configuration

Meenakshy singh Newbie
Currently Being Moderated
Hi All,

Oracle Version :- 9.2.0.5 on AIX machine

I have a scenario where I need to enable AUDITING . For doing so I need to change the spfile parameter AUDIT_TRAIL and restart the database.

My query is :-
1) I have database managed by DG BROKER(DGMGRL). So when I do change in spfile parameter how is it propagated to dataguard configuration file.
2) Do I need to DISABLE DG_BROKER before enabling the AUDIT as i am going to restart my database for the AUDIT_TRAIL parameter to come in effect.And enable again the DG BROKER after the DB restarted.

Thanks
Meena

Edited by: Meenakshy singh on Feb 23, 2013 12:08 AM
  • 1. Re: DataGuard Configuration
    mseberg Guru
    Currently Being Moderated
    Hello;

    1) I have database managed by DG BROKER(DGMGRL). So when I do change in spfile parameter how is it propagated to dataguard configuration file.

    It should.

    2) Do I need to DISABLE DG_BROKER before enabling the AUDIT as i am going to restart my database for the AUDIT_TRAIL parameter to come in effect.And enable again the DG BROKER after the DB restarted.

    You have a larger issue. Audit is a Read Only oracle 9 database ( the standby ). If you audit to the database this will error.

    Can you audit to the OS?

    audit trail parameter should be in OS or NONE when standby database configured.

    Best Regards

    mseberg
  • 2. Re: DataGuard Configuration
    CKPT Guru
    Currently Being Moderated
    I have a scenario where I need to enable AUDITING . For doing so I need to change the spfile parameter AUDIT_TRAIL and restart the database.

    My query is :-
    1) I have database managed by DG BROKER(DGMGRL). So when I do change in spfile parameter how is it propagated to dataguard configuration file.
    2) Do I need to DISABLE DG_BROKER before enabling the AUDIT as i am going to restart my database for the AUDIT_TRAIL parameter to come in effect.And enable again the DG BROKER after the DB restarted.
    When you are disturbing parameters related to Data Guard then only you have to use Broker, Data Guard broker wont manage whole database activities.
    AUDIT_TRIAL is more of database and not related to Broker configuration. So you can safely go ahead and enable it.
  • 3. Re: DataGuard Configuration
    Meenakshy singh Newbie
    Currently Being Moderated
    Hi Msberg ,

    Thanks for your prompt reply as always.

    Yes, I am enabling auditing at OS level only by setting the parameter AUDIT_TRAIL=OS SCOPE=BOTH.
    so, Do I need to DISABLE DG_BROKER before enabling the AUDIT as i am going to restart my database for the AUDIT_TRAIL parameter to come in effect.And enable again the DG BROKER after the DB restarted.

    If so then which command do i need to give
    DGMGRL>disable configuration;
    SQL>alter system set dg_broker_start=false scope=both;

    OR

    DGMGRL>disable configuration;
    DGMGRL>enable configuration; will do the work.

    Thanks
    Meena.
  • 4. Re: DataGuard Configuration
    Meenakshy singh Newbie
    Currently Being Moderated
    Hi CKPT,

    So i don't need to disturb the broker. Let it be running while I bring down my database and change parameter and bring it back up again.

    Thanks
    Meena
  • 5. Re: DataGuard Configuration
    mseberg Guru
    Currently Being Moderated
    OK.

    Thanks. I think you are good then.

    Best Regards

    mseberg
  • 6. Re: DataGuard Configuration
    CKPT Guru
    Currently Being Moderated
    Meenakshy singh wrote:
    Hi CKPT,

    So i don't need to disturb the broker. Let it be running while I bring down my database and change parameter and bring it back up again.

    Thanks
    Meena
    Wish, You can check the log here tested
    DGMGRL> show configuration;
    
    Configuration - DG_BR
    
      Protection Mode: MaxPerformance
      Databases:
        prim_un - Primary database
        standby_un  - Physical standby database
    
    Fast-Start Failover: DISABLED
    
    Configuration Status:
    SUCCESS
    
    DGMGRL> 
    
    
    
    SQL> show parameter audit_trail
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    audit_trail                          string      DB
    
    SQL> alter system set audit_trail='OS' scope=spfile;
    
    System altered.
    
    SQL> shut immediate
    Database closed.
    Database dismounted.
    ORACLE instance shut down.
    SQL> startup
    ORACLE instance started.
    
    Total System Global Area 2238099456 bytes
    Fixed Size                  2230312 bytes
    Variable Size            1275070424 bytes
    Database Buffers          956301312 bytes
    Redo Buffers                4497408 bytes
    Database mounted.
    Database opened.
    SQL> show parameter audit_trail
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    audit_trail                          string      OS
    SQL> 
    
    
    DGMGRL> show configuration;
    
    Configuration - DG_BR
    
      Protection Mode: MaxPerformance
      Databases:
        prim_un - Primary database
        standby_un  - Physical standby database
    
    Fast-Start Failover: DISABLED
    
    Configuration Status:
    SUCCESS
    
    DGMGRL> 
  • 7. Re: DataGuard Configuration
    Meenakshy singh Newbie
    Currently Being Moderated
    Hi CKPT,

    Thanks a lot.The example given by you cleared my fears and doubts.

    Thanks,
    Meena

Legend

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