Skip to Content
avatar image
Former Member

Use stand-by database as report server

Hi Experts,

We have primary database and at our DR site stand-by database. In DR site, we apply archive log on regular interval manually. Our database version is Oracle 10.2.0.2. We want to use our stand-by database server as report server. How to make it possible?

Thanks in advance.

Regards,

Debiprasad

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 12, 2009 at 09:47 AM

    Hello Debiprasad,

    please check my reply in this thread .. it is the same what you are searching for:

    oracle-data-guard-for-sap-ep70

    Regards

    Stefan

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 12, 2009 at 12:05 PM

    > We have primary database and at our DR site stand-by database. In DR site, we apply archive log on regular interval manually. Our database version is Oracle 10.2.0.2. We want to use our stand-by database server as report server. How to make it possible?

    Simple answer: it's not possible.

    A stand-by database runs permanently in recovery mode. In that mode you can't start a SAP system. If you switch to online it's no more possible to apply the redo logs from the original system.

    Markus

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Markus and Stefan,

      Can we make that database in read-only mode? We only want to view some reports from that database, not necessarily from SAP, may be we will use any other third party tool or any customised program which extract the data from that read-only database.

      Because, the DR server also having good H/W configuration and lie idle except taking archive log. If we utilise this resource as report server then it will be best utilisation of resources.

      Could you please throw some light on this?

      Regards,

      Debiprasad

  • avatar image
    Former Member
    Nov 13, 2009 at 04:54 AM

    Hi Experts,

    I found one link may be it is usefull :

    http://blogs.oracle.com/AlejandroVargas/gems/PhysicalStandbyActivatedRead.pdf

    Regards,

    Debiprasad

    Add comment
    10|10000 characters needed characters exceeded