Re: ORACLE 11G data guard "real time apply " not work?
- From: saurabh manroy <saurabhmanroy@xxxxxxxxx>
- To: mccdba1@xxxxxxxxx
- Date: Wed, 17 Aug 2011 09:46:48 +0200
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> 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 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
>
>
>
Other related posts:
