oracle11gr2 standby switchover后，v$archived_log中显示in-memory

itsky_vane

查看主库和从库的alter.log。也没发现什么问题。
从库的日志：
ARC4: Becoming the 'no FAL' ARCH
Tue Dec 06 11:33:55 2011
ARCt started with pid=48, OS id=6399
ARCn: Becoming the heartbeat ARCH
Tue Dec 06 11:33:55 2011
Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST
RFS[1]: Assigned to RFS process 6405
RFS[1]: Identified database type as 'physical standby': Client is ARCH pid 5824
Tue Dec 06 11:33:55 2011
RFS[2]: Assigned to RFS process 6407
RFS[2]: Identified database type as 'physical standby': Client is ARCH pid 5828
Tue Dec 06 11:33:55 2011
RFS[3]: Assigned to RFS process 6409
RFS[3]: Identified database type as 'physical standby': Client is ARCH pid 5826
RFS[2]: Opened log for thread 1 sequence 86 dbid 622049834 branch 768747306
Archived Log entry 91 added for thread 1 sequence 86 rlc 768747306 ID 0x25191256 dest 2:
RFS[3]: Selected log 4 for thread 1 sequence 85 dbid 622049834 branch 768747306
Archived Log entry 92 added for thread 1 sequence 85 ID 0x25191256 dest 1:
Tue Dec 06 11:33:56 2011
Spfile /opt/app/oracle/product/11.2.0/dbhome_1/dbs/spfilewind.ora is in old pre-11 format and compatible >= 11.0.0; converting to new H.A.R.D. compliant format.
ARCt: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Tue Dec 06 11:33:57 2011
RFS[4]: Assigned to RFS process 6413
RFS[4]: Identified database type as 'physical standby': Client is LGWR ASYNC pid 5866
Primary database is in MAXIMUM PERFORMANCE mode
RFS[4]: Selected log 4 for thread 1 sequence 87 dbid 622049834 branch 768747306
RFS[4]: Selected log 5 for thread 1 sequence 88 dbid 622049834 branch 768747306
Archived Log entry 93 added for thread 1 sequence 87 ID 0x25191256 dest 1:
Tue Dec 06 11:34:12 2011
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT
Attempt to start background Managed Standby Recovery process (wind)
Tue Dec 06 11:34:12 2011
MRP0 started with pid=53, OS id=6422
MRP0: Background Managed Standby Recovery process started (wind)
Tue Dec 06 11:34:14 2011
RFS[5]: Assigned to RFS process 6424
RFS[5]: Identified database type as 'physical standby': Client is ARCH pid 5824
started logmerger process
Tue Dec 06 11:34:17 2011
Managed Standby Recovery starting Real Time Apply
Parallel Media Recovery started with 2 slaves
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Media Recovery Log /opt/app/oracle/flash_recovery_area/DB1/archivelog/2011_12_06/o1_mf_1_85_7fv393qy_.arc
Media Recovery Log /opt/app/oracle/flash_recovery_area/DB1/archivelog/2011_12_06/o1_mf_1_86_7fv393jv_.arc
Media Recovery Log /opt/app/oracle/flash_recovery_area/DB1/archivelog/2011_12_06/o1_mf_1_87_7fv395c5_.arc
Media Recovery Waiting for thread 1 sequence 88 (in transit)
Recovery of Online Redo Log: Thread 1 Group 5 Seq 88 Reading mem 0
  Mem# 0: /opt/app/oracle/oradata/wind/standbyredolog02.log
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT
Tue Dec 06 11:35:15 2011
RFS[4]: Selected log 4 for thread 1 sequence 89 dbid 622049834 branch 768747306
Tue Dec 06 11:35:15 2011
Archived Log entry 94 added for thread 1 sequence 88 ID 0x25191256 dest 1:
Tue Dec 06 11:35:15 2011
Media Recovery Waiting for thread 1 sequence 89 (in transit)
Recovery of Online Redo Log: Thread 1 Group 4 Seq 89 Reading mem 0
  Mem# 0: /opt/app/oracle/oradata/wind/standbyredolog01.log
Tue Dec 06 11:48:44 2011
db_recovery_file_dest_size of 4977 MB is 1.89% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.

itsky_vane

在线等呀。请高人指点。。。

novamc

Spfile /opt/app/oracle/product/11.2.0/dbhome_1/dbs/spfilewind.ora is in old pre-11 format and compatible >= 11.0.0; converting to new H.A.R.D. compliant format.
在pfile里面写上compatible

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT
这个是实时应用,你这个配置打不开的
贴一下你的online redo log和standby redo log

itsky_vane

novamc 发表于 2011-12-13 15:55
Spfile /opt/app/oracle/product/11.2.0/dbhome_1/dbs/spfilewind.ora is in old pre-11 format and compat ...

请问，为什么我的这个配置打不开呢？11g不是已经支持实时应用了吗？
如果要进行实时应用，需要加哪些配置项呢？
另外你说的online redo log是贴online redo log的什么信息呢？

novamc

itsky_vane 发表于 2011-12-14 10:13
请问，为什么我的这个配置打不开呢？11g不是已经支持实时应用了吗？
如果要进行实时应用，需要加哪些配置 ...

你确定11g在备库不用standby redo log也能real time redo apply么

itsky_vane

novamc 发表于 2011-12-13 15:55
Spfile /opt/app/oracle/product/11.2.0/dbhome_1/dbs/spfilewind.ora is in old pre-11 format and compat ...

今天我把主库重装了，然后再重新配置了下。发现如果使用的是实时应用日志模式。那么查询到的v$archived_log就是In-memory。但是不使用实时应用日志，查询到的v$archived_log就是yes。
另外在查询时，因为应用日志需要时间，需要等一会儿再来查看。。

itsky_vane

但是我的备库有使用standby redo log呀：
SQL> select * from v$standby_log;

    GROUP# DBID                                        THREAD#  SEQUENCE#      BYTES  BLOCKSIZE       USED ARC STATUS      FIRST_CHANGE# FIRST_TIME     NEXT_CHANGE# NEXT_TIME      LAST_CHANGE# LAST_TIME
---------- ---------------------------------------- ---------- ---------- ---------- ---------- ---------- --- ---------- ------------- -------------- ------------ -------------- ------------ --------------
         4 623172129                                         1         48   52428800        512      35328 YES ACTIVE            314967 15-12月-11           315032 15-12月-11           315032 15-12月-11
         5 UNASSIGNED                                        1          0   52428800        512        512 NO  UNASSIGNED              0                           0                           0
         6 UNASSIGNED                                        0          0   52428800        512        512 YES UNASSIGNED              0                           0                           0
         7 UNASSIGNED                                        0          0   52428800        512        512 YES UNASSIGNED              0                           0                           0

SQL>

itsky_vane

SQL> select * from v$logfile;

    GROUP# STATUS  TYPE    MEMBER                                                                                                    IS_
---------- ------- ------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---
         1         ONLINE  /opt/app/oracle/oradata/wind/redo01.log                                                                   NO
         2         ONLINE  /opt/app/oracle/oradata/wind/redo02.log                                                                   NO
         3         ONLINE  /opt/app/oracle/oradata/wind/redo03.log                                                                   NO
         4         STANDBY /opt/app/oracle/oradata/wind/standbyredolog01.log                                                         NO
         5         STANDBY /opt/app/oracle/oradata/wind/standbyredolog02.log                                                         NO
         6         STANDBY /opt/app/oracle/oradata/wind/standbyredolog03.log                                                         NO
         7         STANDBY /opt/app/oracle/oradata/wind/standbyredolog04.log                                                         NO

已选择7行。
这是我的standby的日志文件。

itsky_vane

所以我猜，这种情况应该是正常的。所以现在需要专家来个确认下。