Re: ORACLE 11G data guard "real time apply " not work?
- From: Robert Hanuschke <robert.hanuschke@xxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 16 Aug 2011 20:39:20 +0200
Hi,
haven't set up an active data guard myself until now, but what I can
see from the documentation is that there, the "alter database open" is
specified without the read only. might give that a try.
reference:
http://download.oracle.com/docs/cd/E11882_01/server.112/e17022/manage_ps.htm#CHDGJEFF
Best regards,
Robert
http://robertvsoracle.blogspot.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
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
