Re: Logical Standby Database Oracle 9.2 LGWR redo shipping

From: <parag9i_at_gmail.com>
Date: 30 Aug 2005 00:18:28 -0700
Message-ID: <1125386308.800324.170980@g47g2000cwa.googlegroups.com>

Hi,

Thanks for your help.

More details to your questions are

1. Oracle DB : 9.2 OS : AIX 5
2. My goal is to setup logical standby database on two different servers. Before that I want to setup standby db in test server to understand how it works, configure and test different scenarios. Of, course when we talk about data guard it is for disaster recover only.
3. I want to setup redo shipping thru LGWR not by ARCH process and for maximum availability
4. resource_manager plan parameter can be ignored.
5. I have not understood what you are talking about ls -alt ? On which directory you want to run this command ? I have already listed files by ls -ltr from bdump directory
6. 1 select dataguard_broker, protection_mode, protection_level 2* from v$database 12:37:25 SQL> /

DATAGUAR PROTECTION_MODE PROTECTION_LEVEL

-------- -------------------- --------------------

DISABLED MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY Intresting thing to note that on a priamry database when I put LGWR sync ( changed from async )

12:38:57 SQL> show parameter log_archive_dest_2

NAME                                 TYPE        VALUE


------------------------------------ -----------

------------------------------

log_archive_dest_2                   string      SERVICE=standby LGWR

SYNC still I am able to commiting to standby database.

My logical standby is working fine, when there is switch in logfile. which I do not want this. I want LGWR to apply changes immediately if network is available. Kindly help me regarding this as I am doing this kind of data guard logical standby setup first time.

regards & thanks
pjp Received on Tue Aug 30 2005 - 02:18:28 CDT