Re: ORACLE 11G data guard "real time apply " not work?
- From: Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 19 Aug 2011 11:16:25 +0200
I second to check V$ARCHIVE_DEST_STATUS - in the status recovery mode
there should be MANAGED REAL TIME APPLY value.
Another thing is how do You check that real time apply does not work?
There are probably some differences in comparison to let's say 10g - for
example it seems there is no more LNS processes - they are replaced with
NSA/NSS.
Regards
Remigiusz
W dniu 17.08.2011 09:46, saurabh manroy pisze:
> Hi,
>
> Can you check the output of v$archived_dest_status ?
>
> select
> INST_ID,DEST_NAME,STATUS,RECOVERY_MODE,ARCHIVED_THREAD#,ARCHIVED_SEQ#,APPLIED_THREAD#,APPLIED_SEQ#,DB_UNIQUE_NAME
> from GV$ARCHIVE_DEST_STATUS
> where DEST_NAME in ('LOG_ARCHIVE_DEST_2');
>
> Also monitor the alert log when you issue the following command:
>
> SQL> recover managed standby database using current logfile disconnect;
>
> If real-time apply is not possible in your setup, it would give messages
> in the alert log saying the same.
>
> Regards,
> Saurabh Manroy
> http://smanroy.wordpress.com
>
>
> On Tue, Aug 16, 2011 at 8:15 PM, dba1 mcc <mccdba1@xxxxxxxxx
> <mailto:mccdba1@xxxxxxxxx>> wrote:
>
> we have a database original on ORACLE 10.2.0.4 and we upgrade it to
> 11.1.0.7.
> after that we create standby database and tried to use "real time
> apply" feature.
>
> Primary database can transfer log files to standby database and
> standby database also can apply logs. The problem is it can NOT
> work on "real time apply".
>
> Ant ideal what wrong?
>
> === procedures ====== (standby database)
>
> SQL> startup mount;
> ORACLE instance started.
>
> Total System Global Area 2087780352 <tel:2087780352> bytes
> Fixed Size 2161272 bytes
> Variable Size 1795163528 bytes
> Database Buffers 251658240 bytes
> Redo Buffers 38797312 bytes
> Database mounted.
>
> SQL> alter database open read only;
>
> Database altered.
>
> SQL> alter database recover managed standby database using current
> logfile disconnect;
>
> Database altered.
>
> SQL> select PROTECTION_MODE, PROTECTION_LEVEL, DATABASE_ROLE,
> SWITCHOVER_STATUS, OPEN_MODE, GUARD_STATUS from v$database;
>
> PROTECTION_MODE PROTECTION_LEVEL DATABASE_ROLE
> SWITCHOVER_STATUS
> -------------------- -------------------- ----------------
> --------------------
> OPEN_MODE GUARD_S
> ---------- -------
> MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE PHYSICAL STANDBY NOT ALLOWED
> MOUNTED NONE
>
> SQL> select process, status from v$managed_standby;
>
> PROCESS STATUS
> --------- ------------
> ARCH CONNECTED
> ARCH CONNECTED
> ARCH CONNECTED
> ARCH CONNECTED
> RFS IDLE
> MRP0 APPLYING_LOG
>
> 6 rows selected.
>
>
> ========== Primary database init.ora file setup =====
>
> ### for DG use
> db_unique_name = DBPMY
> log_archive_config='dg_config=(DBPMY,DBSBY)'
> log_archive_dest_1='LOCATION=/Archive/DBPMY/arch/arch MANDATORY'
> log_archive_dest_2='service=DBSBY
> valid_for=(online_logfiles,primary_role) db_unique_name=DBSBY LGWR
> ASYNC=20480 OPTIONAL REOPEN=15 NET_TIMEOUT=30'
> *.log_archive_format='DBPMY_%r_%t_%s.arc'
> log_archive_dest_state_1 = enable
> log_archive_dest_state_2 = enable
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Pole nakazi
----------------------------------------------------------------------
Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx>
pos : DBA at DIiUSI
addr : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland
phone : +48 58 667 17 43
mobile: +48 602 42 42 77
Nordea Bank Polska S.A. z siedziba w Gdyni, ul. Kielecka 2, 81-303 Gdynia,
wpisana do Rejestru Przedsiebiorców Krajowego Rejestru Sadowego pod numerem:
0000021828,
dla której dokumentacje przechowuje Sad Rejonowy Gdansk - Pólnoc w Gdansku,
VIII Wydzial Gospodarczy Krajowego Rejestru Sadowego,
o kapitale zakladowym i wplaconym w wysokosci: 277.493.500,00 zlotych,
NIP: 586-000-78-20, REGON: 190024711--
//www.freelists.org/webpage/oracle-l
Other related posts:
