Skip to Main Content
  • Questions
  • Does Oracle 9i Data Guard have real time sync?

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, shi.

Asked: July 06, 2018 - 2:12 am UTC

Last updated: July 12, 2018 - 10:22 am UTC

Version: 9i

Viewed 1000+ times

You Asked

Hi

We have a Oracle 9i database ,When I set up the data guard

I want to use real time sync

I got a error .So I want to confirm whether Oracle 9i have this future

and Connor said...

For 9i, you need to setup the log destination as

MANDATORY
LGWR,
SYNC,
AFFIRM

and then choose between protection and availability modes

ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE {PROTECTION | AVAILABILITY};

You also want to make sure you have configured standby redo logs.

But seriously... 9i? It's time to upgrade :-)

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

standby redo log number is invalid

shi ezio, July 11, 2018 - 12:58 am UTC

thanks for the answer

So you mean that oracle 9i can use real time sync?

When I create standby redo log ,it failed ,the error message is:

the log gorup number is invailid

I query the v$controlfile_record_section, on redo log entry

records_used is equal to records_total

Is that will be the root cause?

how can I handle it
Connor McDonald
July 12, 2018 - 10:22 am UTC

From MOS Note 219344.1

How Do I create Standby Redo Logs ??
------------------------------------------------------------

Standby Redo Logs are additional Redo Log Groups. If you were to query the V$LOGFILE view on the Standby Database, 
the output would typically look something like this:

   SQL> select * from v$logfile;

   GROUP# STATUS  TYPE    MEMBER
   ------ ------- ------- ------------------------------------
        1          ONLINE C:\ORACLE\ORADATA\STANDBY\REDO01.LOG
        2          ONLINE C:\ORACLE\ORADATA\STANDBY\REDO02.LOG
        3          ONLINE C:\ORACLE\ORADATA\STANDBY\REDO03.LOG

Before you add the Standby Redo Logs to your Standby Database, verify the number of maximum Logfile Groups and Logfile Members.

If you don't remember these values, you can look at the CREATE CONTROLFILE script. 

To get such a script, run the following command:

SQL> alter database backup controlfile to trace;

This will create a *.TRC-file in your UDUMP Directory. When you edit or view this newly created file, you will find a script to recreate the Controlfile.

Notice the following relevant entries:

    MAXLOGFILES   8
    MAXLOGMEMBERS 3

In this example you can create a maximum of eight (8) Logfile groups.  Each group can contain a maximum of three (3) Members.

Now we can add Standby Redo Log files to the Standby Database (of course, the Standby Database must be in the MOUNT State):

   SQL> alter database add standby logfile group 4 ('C:\ORACLE\ORADATA\STANDBY\STBY04.LOG') SIZE 5M;

You can also add any further members to each group:

   SQL> alter database add standby logfile member 'C:\ORACLE\ORADATA\STANDBY\STBY14.LOG' to group 4;

Please keep in mind that if the RFS process is able to write into a Standby Redo Log, the filesize of the Standby Redo Log MUST be equal to the 
current Online Redo Log of the Primary Database!!


More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database