11g rac dg 不应用日志

vincent

11g rac --->11g single

11g rac 11.2.0.4.0 asm
11g single 11.2.0.4.0 system datafile

1. SQL> select OPEN_MODE,database_role,PROTECTION_MODE,PROTECTION_LEVEL,SWITCHOVER_STATUS from v$database;
   
2. 
   
3. OPEN_MODE             DATABASE_ROLE    PROTECTION_MODE           PROTECTION_LEVEL        SWITCHOVER_STATUS
   
4. -------------------- ---------------- -------------------- -------------------- --------------------
   
5. READ ONLY WITH APPLY PHYSICAL STANDBY MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE        NOT ALLOWED

复制代码

rac
alter system switch logfile;

standby
可以收到归档日志。但是不会应用。

standby alert

1. Completed: alter database recover managed standby database using current logfile disconnect from session
   
2. Thu Apr 24 20:30:43 2014
   
3. Archived Log entry 9 added for thread 1 sequence 126 ID 0x9ae64f40 dest 1:
   
4. Thu Apr 24 20:30:43 2014
   
5. RFS[1]: Selected log 11 for thread 1 sequence 127 dbid -1696192445 branch 845510086

复制代码

vincent

standby

1. SQL> select process,status,sequence# from v$managed_standby;
   
2. 
   
3. PROCESS   STATUS        SEQUENCE#
   
4. --------- ------------ ----------
   
5. ARCH          CONNECTED                0
   
6. ARCH          CONNECTED                0
   
7. ARCH          CONNECTED                0
   
8. ARCH          CLOSING              126
   
9. ARCH          CONNECTED                0
   
10. RFS          IDLE                        0
    
11. RFS          IDLE                      127
    
12. RFS          IDLE                        0
    
13. MRP0          WAIT_FOR_LOG               76

复制代码

rac

1. SQL> select max(sequence#) from v$archived_log where thread#=1
   
2. union all
   
3. select max(sequence#) from v$archived_log where thread#=2;  2    3
   
4. 
   
5. MAX(SEQUENCE#)
   
6. --------------
   
7.            126
   
8.             75

复制代码

vincent

**********************************************************
WARNING: Files may exists in db_recovery_file_dest
that are not known to the database. Use the RMAN command
CATALOG RECOVERY AREA to re-catalog any such files.
If files cannot be cataloged, then manually delete them
using OS command.
One of the following events caused this:
1. A backup controlfile was restored.
2. A standby controlfile was restored.
3. The controlfile was re-created.
4. db_recovery_file_dest had previously been enabled and
   then disabled.
**********************************************************
replication_dependency_tracking turned off (no async multimaster replication found)
Physical standby database opened for read only access.
Completed: ALTER DATABASE OPEN
Thu Apr 24 20:26:34 2014
db_recovery_file_dest_size of 4407 MB is 0.08% 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.
ARC4: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Thu Apr 24 20:26:35 2014
Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST
Thu Apr 24 20:26:36 2014
Primary database is in MAXIMUM PERFORMANCE mode
RFS[1]: Assigned to RFS process 14941
RFS[1]: Selected log 12 for thread 1 sequence 126 dbid -1696192445 branch 845510086
Thu Apr 24 20:26:36 2014
RFS[2]: Assigned to RFS process 14943
RFS[2]: Selected log 11 for thread 1 sequence 125 dbid -1696192445 branch 845510086
Archived Log entry 8 added for thread 1 sequence 125 ID 0x9ae64f40 dest 1:
Thu Apr 24 20:28:07 2014
alter database recover managed standby database using current logfile disconnect from session
Attempt to start background Managed Standby Recovery process (standby)
Thu Apr 24 20:28:07 2014
MRP0 started with pid=28, OS id=14949
MRP0: Background Managed Standby Recovery process started (standby)
started logmerger process
Thu Apr 24 20:28:13 2014
Managed Standby Recovery starting Real Time Apply
Parallel Media Recovery started with 4 slaves
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Media Recovery Waiting for thread 2 sequence 76
Completed: alter database recover managed standby database using current logfile disconnect from session
Thu Apr 24 20:30:43 2014
Archived Log entry 9 added for thread 1 sequence 126 ID 0x9ae64f40 dest 1:
Thu Apr 24 20:30:43 2014
RFS[1]: Selected log 11 for thread 1 sequence 127 dbid -1696192445 branch 845510086

uj12best

v$archive_dest_status视图是怎么显示的